Overview

The lighter.metrics.overview table contains daily volume, fee, open-interest, user, and liquidation metrics.

Table Columns

Unique key: activity_date

Column Name	Data Type	Description
`activity_date`	`TIMESTAMP_NTZ(9)`	The date of activity.
`total_volume_usd`	`FLOAT`	Daily total volume in USD (all trade types).
`perpetual_volume_usd`	`FLOAT`	Daily perpetual volume in USD.
`spot_volume_usd`	`FLOAT`	Daily spot volume in USD.
`trading_volume_usd`	`FLOAT`	Daily voluntary trading volume only.
`liquidations_volume_usd`	`FLOAT`	Daily liquidation volume in USD.
`deleverages_volume_usd`	`FLOAT`	Daily deleverage volume in USD.
`total_trade_count`	`NUMBER(38,0)`	Daily total number of trades.
`median_volume_usd`	`FLOAT`	Daily median trade size in USD.
`avg_volume_usd`	`FLOAT`	Daily average trade size in USD.
`perpetual_trade_count`	`NUMBER(38,0)`	Daily number of perpetual trades.
`spot_trade_count`	`NUMBER(38,0)`	Daily number of spot trades.
`active_users`	`NUMBER(38,0)`	Daily unique users.
`active_buyers`	`NUMBER(38,0)`	Daily unique buyers.
`active_sellers`	`NUMBER(38,0)`	Daily unique sellers.
`unique_perp_markets_traded`	`NUMBER(38,0)`	Daily unique perpetual markets with activity.
`unique_spot_markets_traded`	`NUMBER(38,0)`	Daily unique spot markets with activity.
`total_trading_fees_usd`	`FLOAT`	Daily total trading fees in USD.
`perpetual_trading_fees_usd`	`FLOAT`	Daily perpetual trading fees.
`spot_trading_fees_usd`	`FLOAT`	Daily spot trading fees.
`total_maker_fees_usd`	`FLOAT`	Daily total maker fees in USD.
`total_taker_fees_usd`	`FLOAT`	Daily total taker fees in USD.
`total_liquidation_fees_usd`	`FLOAT`	Daily liquidation fees in USD.
`total_transfer_fees_usd`	`FLOAT`	Daily transfer fees in USD.
`total_withdraw_fees_usd`	`FLOAT`	Daily withdrawal fees in USD.
`total_fees_usd`	`FLOAT`	Daily total fees (all types).
`total_revenue_usd`	`FLOAT`	Daily protocol revenue in USD.
`perpetual_revenue_usd`	`FLOAT`	Daily perpetual protocol revenue.
`spot_revenue_usd`	`FLOAT`	Daily spot protocol revenue.
`daily_holders_revenue_usd`	`FLOAT`	Daily LIT buyback value (returned to holders).
`avg_maker_fee_rate`	`FLOAT`	Daily average maker fee rate.
`avg_taker_fee_rate`	`FLOAT`	Daily average taker fee rate.
`high_leverage_volume_usd`	`FLOAT`	Daily volume on markets with 20x+ leverage.
`medium_leverage_volume_usd`	`FLOAT`	Daily volume on markets with 10-19x leverage.
`low_leverage_volume_usd`	`FLOAT`	Daily volume on markets with less than 10x leverage.
`liquidations_count`	`NUMBER(38,0)`	Daily number of liquidation events.
`liquidated_users_count`	`NUMBER(38,0)`	Daily unique liquidated accounts.
`unique_markets_liquidated`	`NUMBER(38,0)`	Daily unique markets with liquidations.
`total_open_interest_usd`	`FLOAT`	Daily total open interest in USD.
`btc_open_interest_usd`	`FLOAT`	Daily BTC open interest in USD.
`eth_open_interest_usd`	`FLOAT`	Daily ETH open interest in USD.
`avg_funding_rate`	`FLOAT`	Daily average funding rate across all markets.
`avg_basis_bps`	`FLOAT`	Daily average mark-index spread in basis points.
`buyback_volume_usd`	`FLOAT`	Daily LIT buyback volume in USD.
`buyback_lit_amount`	`FLOAT`	Daily LIT tokens bought back.
`buyback_trade_count`	`NUMBER(38,0)`	Daily number of LIT buyback trades.
`cumulative_volume_usd`	`FLOAT`	Cumulative total volume since inception.
`cumulative_trading_fees_usd`	`FLOAT`	Cumulative trading fees since inception.
`cumulative_fees_usd`	`FLOAT`	Cumulative total fees since inception.
`_created_at`	`TIMESTAMP_NTZ(9)`	Timestamp when the row was first recorded.
`_updated_at`	`TIMESTAMP_NTZ(9)`	Timestamp when the row was last updated.
`_changed_since_full_refresh`	`BOOLEAN`	Indicates whether the row has changed.

Sample Query

SELECT
    activity_date,
    total_volume_usd,
    total_trading_fees_usd,
    total_open_interest_usd,
    active_users,
    liquidations_count
FROM lighter.metrics.overview
WHERE activity_date >= CURRENT_DATE - 30
ORDER BY activity_date DESC
LIMIT 100;

Data Verticals

Solana

Hyperliquid

Lighter

Bitcoin Ecosystem

EVM

Cosmos Ecosystem

Move Ecosystem

Other Ecosystems

Overview

Table Columns

Sample Query

​Table Columns

​Sample Query

Table Columns

Sample Query