Skip to main content
The lighter.metrics.overview table provides daily aggregated metrics for the Lighter network.

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

Table Columns

General

Column NameDescription
activity_dateThe date of activity

Trading Volume

Column NameDescription
total_volume_usdDaily total volume in USD (all trade types)
perpetual_volume_usdDaily perpetual volume in USD
spot_volume_usdDaily spot volume in USD
trading_volume_usdDaily voluntary trading volume only
liquidations_volume_usdDaily liquidation volume in USD
deleverages_volume_usdDaily deleverage volume in USD

Trade Counts

Column NameDescription
total_trade_countDaily total number of trades
perpetual_trade_countDaily number of perpetual trades
spot_trade_countDaily number of spot trades
median_volume_usdDaily median trade size in USD
avg_volume_usdDaily average trade size in USD

Users & Markets

Column NameDescription
active_usersDaily unique users
active_buyersDaily unique buyers
active_sellersDaily unique sellers
unique_perp_markets_tradedDaily unique perpetual markets with activity
unique_spot_markets_tradedDaily unique spot markets with activity

Trading Fees

Column NameDescription
total_trading_fees_usdDaily total trading fees in USD
perpetual_trading_fees_usdDaily perpetual trading fees
spot_trading_fees_usdDaily spot trading fees
total_maker_fees_usdDaily total maker fees in USD
total_taker_fees_usdDaily total taker fees in USD
avg_maker_fee_rateDaily average maker fee rate
avg_taker_fee_rateDaily average taker fee rate

All Fees & Revenue

Column NameDescription
total_liquidation_fees_usdDaily liquidation fees in USD
total_transfer_fees_usdDaily transfer fees in USD
total_withdraw_fees_usdDaily withdrawal fees in USD
total_fees_usdDaily total fees (all types)
total_revenue_usdDaily protocol revenue in USD
perpetual_revenue_usdDaily perpetual protocol revenue
spot_revenue_usdDaily spot protocol revenue
daily_holders_revenue_usdDaily LIT buyback value (returned to holders)

Leverage Breakdown

Column NameDescription
high_leverage_volume_usdDaily volume on markets with 20x+ leverage
medium_leverage_volume_usdDaily volume on markets with 10-19x leverage
low_leverage_volume_usdDaily volume on markets with less than 10x leverage

Liquidations

Column NameDescription
liquidations_countDaily number of liquidation events
liquidated_users_countDaily unique liquidated accounts
unique_markets_liquidatedDaily unique markets with liquidations

Open Interest

Column NameDescription
total_open_interest_usdDaily total open interest in USD
btc_open_interest_usdDaily BTC open interest in USD
eth_open_interest_usdDaily ETH open interest in USD

Funding & Basis

Column NameDescription
avg_funding_rateDaily average funding rate across all markets
avg_basis_bpsDaily average mark-index spread in basis points

LIT Buybacks

Column NameDescription
buyback_volume_usdDaily LIT buyback volume in USD
buyback_lit_amountDaily LIT tokens bought back
buyback_trade_countDaily number of LIT buyback trades

Cumulative Metrics

Column NameDescription
cumulative_volume_usdCumulative total volume since inception
cumulative_trading_fees_usdCumulative trading fees since inception
cumulative_fees_usdCumulative total fees since inception