Overview

Perpetual futures are derivatives that track an underlying with no expiry. Allium provides perpetual futures data across on-chain and centralized venues: trades, funding, open interest, liquidations, positions, and protocol metrics.

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
GMX	Decentralized	Arbitrum, Avalanche (v1 / v2); MegaETH (v2)	Trades, liquidations, fees, daily metrics
Variational Omni	Decentralized	Arbitrum	Settlement pools, user actions, funding, market snapshots, daily metrics

Available Tables

Project	Trades	Funding	Liquidations	Order books	Markets	Daily metrics	Fees
Hyperliquid
Lighter
Lighter Robinhood
Kalshi
Jupiter
GMX
Variational

Sample Queries

Hyperliquid Trades
Lighter Trades
Kalshi Trades
Jupiter Trades
GMX 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

Data Verticals

Solana

Hyperliquid

Lighter

Bitcoin Ecosystem

EVM

Cosmos Ecosystem

Move Ecosystem

Other Ecosystems

Overview

Supported Protocols

Available Tables

Sample Queries

​Supported Protocols

​Available Tables

​Sample Queries

Supported Protocols

Available Tables

Sample Queries