Public Pool Data

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

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

SELECT *
FROM lighter.raw.public_pool_data
WHERE _ingested_at >= CURRENT_DATE - 7
LIMIT 100

⌘I