Hyperliquid 🌱

Hyperliquid DEX trades data is currently in beta, with data available from 5 March 2025. Backfilled data is coming soon!

Hyperliquid is an L1 built to support an ecosystem of permisionless financial applications. The flagship native application is the Hyperliquid DEX, a fully onchain order book exchange.

Tables

Using hyperliquid.dex.trades is recommended as it enriches the raw.trades table with relevant trade & token metadata

Table Name	Description
hyperliquid.raw.trades	Raw Hyperliquid spot & perpetual trades data
hyperliquid.dex.trades	Enriched Hyperliquid spot & perpetual trades data.

Sample Queries

Get all trades of BTC in the last 24 hours

select
    *
from hyperliquid.dex.trades
where 1=1
    and token_a_symbol = 'BTC'
    and timestamp >= current_timestamp - interval '24 hours'

Get a list of tokens traded in the last 24 hours, with a breakdown of spot vs perpertuals volume, ordered by total USD volume traded

select
    token_a_symbol,
    count(distinct trader_address) as num_traders,
    sum(case when market_type = 'spot' then amount_usd else 0 end) as total_spot_amount_usd,
    sum(case when market_type = 'perpetuals' then amount_usd else 0 end) as total_perpetuals_amount_usd,
    sum(amount_usd) as total_amount_usd,
from hyperliquid.dex.trades
where 1=1
    and timestamp >= current_timestamp - interval '24 hours'
group by all
order by total_amount_usd desc

Get daily activity metrics, aggregated by token, for the last 7 days

select
    date(timestamp) as day,
    token_a_symbol,
    count(distinct trader_address) as num_traders,
    sum(amount_usd) as total_amount_usd,
from hyperliquid.dex.trades
where 1=1
    and timestamp >= current_timestamp - interval '7 days'
group by all
order by 1 asc

Table Columns

Tables are in beta, so the schemas are subject to change.

dex.trades

Column Name	Description
market_type	The type of market for the trade, e.g. spot, perpetuals
intent	The intended action of the trader e.g. short, long, sell, buy
token_a_symbol	The symbol of the first token in the trading pair
token_b_symbol	The symbol of the second token in the trading pair. At the moment, this is always USDC
trader_address	The address of the trader initiating the trade
amount	The quantity of token_a being traded (normalized)
price	The execution price of token_a for the trade, in terms of token_b (usually USDC)
amount_usd	The quantity of token_a being traded, in USD terms
buyer_address	The address of the buyer in the trade
seller_address	The address of the seller in the trade
order_type	The type of order executed. Currently, the only valid values are: twap, other. TWAP order are identified as those where the transaction_hash is 0x0000000000000000000000000000000000000000000000000000000000000000
timestamp	The UTC timestamp of when the trade was executed
transaction_hash	The transaction hash for the trade. There can be multiple trades (i.e. multiple records with different trade_id) for the same transaction_hash
trade_id	A unique identifier for the trade