lighter_robinhood.raw.public_pool_info table contains public pool performance and configuration information.
Table Columns
Unique key:timestamp, 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_info. |
timestamp | TIMESTAMP_NTZ(9) | UTC timestamp of the snapshot. |
_ingested_at | TIMESTAMP_NTZ(9) | Timestamp associated with the row’s availability. |
annual_percentage_yield | FLOAT | Annualized percentage yield of the pool. |
sharpe_ratio | FLOAT | Sharpe ratio of the pool’s historical returns (risk-adjusted performance measure). |
status | NUMBER(38,0) | Pool status code. |
total_shares | NUMBER(38,0) | Total number of shares outstanding in this pool. |
operator_fee | VARCHAR | Fee rate charged by the pool operator, as a fraction of total shares. |
operator_shares | NUMBER(38,0) | Number of shares held by the pool operator. |
min_operator_share_rate | VARCHAR | Minimum share rate the pool operator is entitled to receive. |
daily_returns | VARIANT | Array of daily return values for this pool over the historical period. |
share_prices | VARIANT | Array of historical share prices for this pool. |
strategies | VARIANT | Array of trading strategy identifiers associated with this pool. |
_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
timestamp,
account,
annual_percentage_yield,
sharpe_ratio,
total_shares
FROM lighter_robinhood.raw.public_pool_info
WHERE timestamp >= CURRENT_DATE - 7
ORDER BY timestamp DESC
LIMIT 100;