Definitions of funding, open interest, mark and index price, positions, and liquidations are on Concepts.
Supported Protocols
| Protocol | Type | Platform | Data Coverage |
|---|---|---|---|
| Hyperliquid | Decentralized | Hyperliquid | Trades, positions, markets, funding, liquidations (daily metrics + misc_events), metrics |
| Lighter | Decentralized | Lighter | Trades, liquidations, order books, funding, market stats, metrics |
| Lighter Robinhood | Decentralized | Lighter Robinhood | Trades, liquidations, order books, funding, market stats, metrics |
| Kalshi | Centralized | Kalshi | Trades, candlesticks, markets, orderbook, funding |
| Jupiter Perpetuals | Decentralized | Solana | Trades, liquidations, daily metrics |
| GMTrade | Decentralized | Solana | Trades, liquidations, markets, funding, open interest, positions, daily metrics |
| Phoenix | Decentralized | Solana | Trades, liquidations, position changes, markets, funding, open interest, positions, daily metrics |
| GMX | Decentralized | Arbitrum, Avalanche (v1 / v2); MegaETH (v2) | Trades, liquidations, fees, daily metrics |
| Ostium | Decentralized | Arbitrum | Trades, liquidations, fees, user actions, TVL, daily metrics |
| Variational Omni | Decentralized | Arbitrum | Settlement pools, user actions, funding, market snapshots, daily metrics |
Available Tables
Sample Queries
- Hyperliquid Trades
- Lighter Trades
- Kalshi Trades
- Jupiter Trades
- GMX Trades
- Ostium Trades
- GMTrade Trades
- Phoenix Trades
Query Hyperliquid perpetual trades in the last 30 days.
select
timestamp,
coin,
market_type,
amount,
price,
usd_amount,
buyer_address,
seller_address
from hyperliquid.dex.trades
where timestamp::date >= current_date - 30
and market_type = 'perpetuals'
order by timestamp desc
limit 100
Query Lighter trades in the last 7 days.
select
timestamp,
coin,
trade_type,
amount,
price,
usd_amount,
buyer,
seller
from lighter.dex.trades
where timestamp::date >= current_date - 7
and market_type = 'perpetuals'
order by timestamp desc
limit 100
Query Kalshi perp trades in the last 7 days.
select
trade_id,
ticker,
created_time,
num_contracts,
price,
contract_size,
underlying_price,
taker_side
from common.perpetuals.kalshi_trades
where partition_date >= current_date - 7
order by created_time desc
limit 100
Query Jupiter Perpetuals position-change events.
select
block_timestamp,
project,
protocol,
trader,
market_symbol,
side,
action,
size_usd,
price_usd,
collateral_usd,
pnl_usd,
fee_usd,
txn_id
from solana.perpetuals.trades
where block_date >= current_date - 30
order by block_timestamp desc
limit 100
Query GMX position-change events on Arbitrum.
select
block_timestamp,
project,
protocol,
version,
trader,
market_symbol,
side,
action,
size_usd,
price_usd,
collateral_usd,
pnl_usd,
fee_usd,
transaction_hash
from arbitrum.perpetuals.trades
where block_date >= current_date - 30
and project = 'gmx'
order by block_timestamp desc
limit 100
Query Ostium position-change events on Arbitrum.
select
block_timestamp,
project,
protocol,
version,
trader,
market_symbol,
side,
action,
size_usd,
price_usd,
collateral_usd,
pnl_usd,
fee_usd,
transaction_hash
from arbitrum.perpetuals.trades
where block_date >= current_date - 30
and project = 'ostium'
order by block_timestamp desc
limit 100
Query GMTrade position-change events.
select
block_timestamp,
project,
protocol,
trader,
market_symbol,
side,
action,
size_usd,
price_usd,
fee_usd,
txn_id
from solana.perpetuals.trades
where block_timestamp::date >= current_date - 7
and project = 'gmtrade'
order by block_timestamp desc
limit 100
Query Phoenix position-change events.
select
block_timestamp,
project,
protocol,
trader,
market_symbol,
side,
action,
size_usd,
price_usd,
fee_usd,
txn_id
from solana.perpetuals.trades
where block_timestamp::date >= current_date - 7
and project = 'phoenix'
order by block_timestamp desc
limit 100