Public Pool Data - Allium Documentation Hub

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

SELECT
    _ingested_at,
    account,
    orders,
    positions,
    shares
FROM lighter_robinhood.raw.public_pool_data
WHERE _ingested_at >= CURRENT_DATE - 7
LIMIT 100;