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

> Lighter public pool info

The `lighter.raw.public_pool_info` table contains public pool information from Lighter.

### Table Details

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

## Table Columns

| Column Name | Description                     |
| ----------- | ------------------------------- |
| timestamp   | UTC timestamp of the snapshot   |
| account     | Account identifier for the pool |

## Sample Query

```sql theme={null}
SELECT *
FROM lighter.raw.public_pool_info
WHERE timestamp >= CURRENT_DATE - 7
ORDER BY timestamp DESC
LIMIT 100
```