Public Pool Info

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

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

SELECT *
FROM lighter.raw.public_pool_info
WHERE timestamp >= CURRENT_DATE - 7
ORDER BY timestamp DESC
LIMIT 100

⌘I