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

> Lighter public pool data

The `lighter.raw.public_pool_data` table contains public pool data from Lighter.

### Table Details

| Property          | Value                     |
| ----------------- | ------------------------- |
| Clustering Key(s) | `to_date("_ingested_at")` |

## Table Columns

| Column Name    | Description                     |
| -------------- | ------------------------------- |
| \_ingested\_at | Ingestion timestamp for the row |
| account        | Account identifier for the pool |

## Sample Query

```sql theme={null}
SELECT *
FROM lighter.raw.public_pool_data
WHERE _ingested_at >= CURRENT_DATE - 7
LIMIT 100
```