> ## 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 Data

> Public pool account, position, order, and share data.

The `lighter_robinhood.raw.public_pool_data` table contains public pool account, position, order, and share data.

## Table Columns

**Unique key:** `_ingested_at`, `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_data`.            |
| `_ingested_at`      | `TIMESTAMP_NTZ(9)` | Timestamp associated with the row's availability.  |
| `orders`            | `VARIANT`          | Order information for this pool account.           |
| `positions`         | `VARIANT`          | Position information for this pool account.        |
| `trades`            | `VARIANT`          | Trade information for this pool account.           |
| `shares`            | `VARIANT`          | Share records for this pool account.               |
| `funding_histories` | `VARIANT`          | Funding history information for this pool account. |
| `_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
    _ingested_at,
    account,
    orders,
    positions,
    shares
FROM lighter_robinhood.raw.public_pool_data
WHERE _ingested_at >= CURRENT_DATE - 7
LIMIT 100;
```