> ## Documentation Index
> Fetch the complete documentation index at: https://docs.allium.so/llms.txt
> Use this file to discover all available pages before exploring further.

# Public Pool Info

> Public pool performance and configuration information.

The `lighter_robinhood.raw.public_pool_info` table contains public pool performance and configuration information.

## Table Columns

**Unique key:** `timestamp`, `account`

| Column Name               | Data Type          | Description                                                                        |
| ------------------------- | ------------------ | ---------------------------------------------------------------------------------- |
| `account`                 | `NUMBER(38,0)`     | Account identifier for the pool.                                                   |
| `channel`                 | `VARCHAR`          | Channel identifier.                                                                |
| `type`                    | `VARCHAR`          | Event type, such as `update/pool_info`.                                            |
| `timestamp`               | `TIMESTAMP_NTZ(9)` | UTC timestamp of the snapshot.                                                     |
| `_ingested_at`            | `TIMESTAMP_NTZ(9)` | Timestamp associated with the row's availability.                                  |
| `annual_percentage_yield` | `FLOAT`            | Annualized percentage yield of the pool.                                           |
| `sharpe_ratio`            | `FLOAT`            | Sharpe ratio of the pool's historical returns (risk-adjusted performance measure). |
| `status`                  | `NUMBER(38,0)`     | Pool status code.                                                                  |
| `total_shares`            | `NUMBER(38,0)`     | Total number of shares outstanding in this pool.                                   |
| `operator_fee`            | `VARCHAR`          | Fee rate charged by the pool operator, as a fraction of total shares.              |
| `operator_shares`         | `NUMBER(38,0)`     | Number of shares held by the pool operator.                                        |
| `min_operator_share_rate` | `VARCHAR`          | Minimum share rate the pool operator is entitled to receive.                       |
| `daily_returns`           | `VARIANT`          | Array of daily return values for this pool over the historical period.             |
| `share_prices`            | `VARIANT`          | Array of historical share prices for this pool.                                    |
| `strategies`              | `VARIANT`          | Array of trading strategy identifiers associated with this pool.                   |
| `_created_at`             | `TIMESTAMP_NTZ(9)` | Timestamp when the row was first recorded.                                         |
| `_updated_at`             | `TIMESTAMP_NTZ(9)` | Timestamp when the row was last updated.                                           |

### Sample Query

```sql theme={null}
SELECT
    timestamp,
    account,
    annual_percentage_yield,
    sharpe_ratio,
    total_shares
FROM lighter_robinhood.raw.public_pool_info
WHERE timestamp >= CURRENT_DATE - 7
ORDER BY timestamp DESC
LIMIT 100;
```