DEX Trades

Thecrosschain.dex.trades table aggregates DEX trades indexed by Allium across multiple blockchains (EVM and non-EVM) into a single table. The crosschain.dex.trades_evm table aggregates DEX trades for EVM-compatible blockchain. This model includes EVM-specific fee details (e.g. priority fees) that are not found on non-EVM chains.

Blockchain Coverage

Overview
EVM DEX Coverage
Sui DEX Coverage
Solana DEX Coverage

This table currently does not contain aggregator swaps to avoid double-counting volume. The dex trades table only contains swap events/instructions from DEXs with liquidity pools/vaults.

For example, suppose a DEX swap was executed by an aggregator (e.g. Openocean or 0x) and routed to liquidity pools on Uniswap and Balancer, only the volume on Uniswap and Balancer is included dex.trades. For trades routed by aggregators, they are found in the dex.aggregator_trades models on the respective blockchain.

Coverage of DEX Protocols Across various EVM Blockchains. Note that for a single protocol (e.g. uniswap_v2) there can be multiple dex projects (e.g. uniswap, sushiswap).

Chain	Protocol Version	Protocols
arbitrum	algebra	zyberswap
arbitrum	balancer_v2	balancer
arbitrum	balancer_v3	balancer
arbitrum	camelot_v3	camelot
arbitrum	curve_v1	curve
arbitrum	curve_v2	curve
arbitrum	dodo_v2	dodo
arbitrum	fluid_dex	fluid
arbitrum	gmx_v1	gmx
arbitrum	kyberswap_elastic	kyberswap
arbitrum	pancakeswap_v3	pancakeswap
arbitrum	solidly	auragi_finance, chronos, hamburger, magicfox, perfectswap, ramses, solidlizard, solunea, sterling_finance, x3calibur
arbitrum	trader_joe_v2	trader_joe
arbitrum	trader_joe_v2_1	trader_joe
arbitrum	uniswap_v2	alienfi, apeswap, arbiswap, arbitrum_exchange, arbswap, camelot, dxswap, elkfinance, integralsize, lfgswap, mmfinance, oreoswap, pancakeswap, sharkyswap, sushiswap, swapfish, swaprum, trader_joe, uniswap, wtfdex, zyberswap
arbitrum	uniswap_v3	arbitrum_exchange, chronos, cresentswap, horiza, ramses, solidly, summaswap, sushiswap, thick, uniswap
arbitrum	uniswap_v4	uniswap
avalanche	balancer_v2	balancer
avalanche	balancer_v3	balancer
avalanche	curve_v1	curve
avalanche	curve_v2	curve
avalanche	dexalot_v1	dexalot
avalanche	dodo_v2	dodo
avalanche	gmx_v1	gmx
avalanche	hashflow_v3	hashflow
avalanche	kyberswap_elastic	kyberswap
avalanche	trader_joe_v2	trader_joe
avalanche	trader_joe_v2_1	trader_joe
avalanche	uniswap_v2	alligator, baguette, canary, complusswap, elkfinance, hakuswap, hurricaneswap, lydiafinance, olive, onavax, pandaswap, pangolin, partyswap, pyreswap, radioshackswap, sushiswap, swapsicle, thorus, trader_joe, uniswap, vapordex, vavalon, yetiswap, zeroswap
avalanche	uniswap_v3	pangolin, pharaoh, sushiswap, uniswap, vapordex
avalanche	uniswap_v4	uniswap
base	aerodrome_v2	aerodrome
base	algebra	swapbased, synthswap
base	balancer_v2	balancer
base	balancer_v3	balancer
base	curve_v1	curve
base	curve_v2	curve
base	dodo_v2	dodo
base	fluid_dex	fluid
base	kyberswap_elastic	kyberswap
base	maverick	maverick
base	maverick_v2	maverick
base	pancakeswap_v3	pancakeswap
base	solidly	archly, baso, infusion, leetswap, scale, velocimeter
base	uniswap_v2	9mm, alienbase, alienbase_area51, baseswap, cbswap, cloudbase, dackieswap, elkfinance, icecreamswap, leetswap, melegaswap, oasisswap, pancakeswap, rocketswap, sharkswap, soswap, sushiswap, swapbased, synthswap, uniswap, virtuals_protocol
base	uniswap_v3	aerodrome, alienbase, baseswap, basexfi, candyswap, cresentswap, derpdex, horizondex, kinetix, nftx, realwagmi, solidly, sushiswap, thick, uniswap, yumyumswap
base	uniswap_v4	uniswap
base	woofi_v2	woofi
blast	algebra	bladeswap, fenix
blast	uniswap_v2	akitaswap, bitconnect, blaspace, blastdex, blasterswap, dyorswap, hyperblast, icecreamswap, monoswap, ring_dex, sushiswap, swapblast, thruster, uniswap
blast	uniswap_v3	blaster, blasterswap, monoswap, sushiswap, thruster, uniswap
blast	uniswap_v4	uniswap
bsc	dodo_v2	dodo
bsc	kyberswap_elastic	kyberswap
bsc	maverick	maverick
bsc	pancakeswap_stableswap	pancakeswap
bsc	pancakeswap_v3	pancakeswap
bsc	thena_fusion	thena
bsc	thena_v1	thena
bsc	trader_joe_v2	trader_joe
bsc	trader_joe_v2_1	trader_joe
bsc	uniswap_v2	apeswap, babydogeswap, babyswap, bakeryswap, biswap, bscswap, demaxswap, fstswap, hyperswap, jswap, julswap, mdex, melegaswap, nomiswap, pancakeswap, sushiswap, uniswap, youswap
bsc	uniswap_v3	apeswap, sheepdex, sushiswap, uniswap
bsc	uniswap_v4	uniswap
celo	algebra	ubeswap
celo	curve_v1	curve
celo	uniswap_v2	padi, sushiswap, ubeswap
celo	uniswap_v3	ubeswap, uniswap
ethereum	balancer_v1	balancer
ethereum	balancer_v2	balancer
ethereum	balancer_v3	balancer
ethereum	bancor_v1	bancor
ethereum	bancor_v3	bancor
ethereum	clipper_fmm_v1	clipper
ethereum	clipper_fmm_v2	clipper
ethereum	clipper_fmm_v3	clipper
ethereum	curve_v1	curve
ethereum	curve_v2	curve
ethereum	dodo_v1	dodo
ethereum	dodo_v2	dodo
ethereum	fluid_dex	fluid
ethereum	hashflow_v3	hashflow
ethereum	kyberswap_elastic	kyberswap
ethereum	maverick	maverick
ethereum	maverick_v2	maverick
ethereum	native_v1	native
ethereum	pancakeswap_v3	pancakeswap
ethereum	solidly	archly_finance, solidly
ethereum	trader_joe_v2_1	trader_joe
ethereum	uniswap_v2	bitberryswap, cityswap, convergence, defiswap, dooar, equalizerfinance, ethervista, fraxswap, gemswap, integralsize, linkswap, luaswap, mintyswap, nineinch, nomiswap, orionprotocol, pancakeswap, plasmafinance, radioshackswap, safeswap, saitaswap, sakeswap, sashimiswap, shibaswap, sumswap, sushiswap, swapr, swipeswap, unicly, uniswap, verse, vulcandex, wallstreetbetsdex, whiteswap, x7_finance
ethereum	uniswap_v3	blueprint, mauve, nftx, realwagmi, solidly, sushiswap, uniswap
ethereum	uniswap_v4	uniswap
fantom	algebra	skullswap, spiritswap
fantom	balancer_v2	beethoven_x
fantom	curve_v1	curve
fantom	curve_v2	curve
fantom	kyberswap_elastic	kyberswap
fantom	uniswap_v2	alium_finance, bombfinance, defyswap, degenhaus, elkfinance, excalibur, farmtom, hyperjump, jetswap, knightswap, liquidbolt, mageswap, magik_finance, makiswap, morpheusswap, paintswap, protofi, pyreswap, radioshackswap, redemption, runic, shibaswap, skullswap, soulswap, spiritswap, spookyswap, sushiswap, tombswap, wigoswap, wingswap, yoshiexchange, zoodex
fantom	uniswap_v3	lif3, solidly, spookyswap, sushiswap, thick, wagmi
fraxtal	balancer_v2	balancer
fraxtal	curve_v1	curve
fraxtal	curve_v2	curve
fraxtal	uniswap_v2	fraxswap
fraxtal	uniswap_v3	pharaoh
gnosis	balancer_v2	balancer
gnosis	curve_v1	curve
gnosis	curve_v2	curve
gnosis	uniswap_v2	dxswap, honeyswap, sushiswap
gnosis	uniswap_v3	sushiswap, uniswap
hyperevm	algebra	hypercat
hyperevm	uniswap_v3	hx_finance, hybra_finance, hyperswap, laminar, noxa_fi, project_x, ramses
hyperevm	balancer_v3	balancer
hyperevm	curve_v1	curve
hyperevm	curve_v2	curve
hyperevm	uniswap_v2	dyorswap, hyperswap
hyperevm	solidly	hybra, kittenswap
ink	uniswap_v2	dyorswap, inkswap, inkyswap, squidswap, uniswap
ink	uniswap_v3	uniswap, velodrome
ink	uniswap_v4	uniswap
ink	velodrome_v2	velodrome
mode	algebra	kim_exchange
mode	iziswap_v1	iziswap
mode	uniswap_v2	dyorswap, kim_exchange, supswap, swapmode
mode	uniswap_v3	poolshark, swapmode
mode	velodrome_v2	velodrome
optimism	balancer_v2	balancer
optimism	balancer_v3	balancer
optimism	curve_v1	curve
optimism	curve_v2	curve
optimism	dodo_v2	dodo
optimism	kyberswap_elastic	kyberswap
optimism	uniswap_v2	elkfinance, openxswap, sushiswap, uniswap, zipswap
optimism	uniswap_v3	solidly, sushiswap, uniswap, velodrome
optimism	uniswap_v4	uniswap
optimism	velodrome_v1	velodrome
optimism	velodrome_v2	velodrome
polygon	alegeba	quickswap
polygon	algebra	quickswap
polygon	balancer_v2	balancer
polygon	curve_v1	curve
polygon	curve_v2	curve
polygon	dodo_v1	dodo
polygon	dodo_v2	dodo
polygon	hashflow_v3	hashflow
polygon	kyberswap_elastic	kyberswap
polygon	quickswap_v3	quickswap
polygon	uniswap_v2	apeswap-amm, dfyn-network, elkfinance, fraxswap, gravityfinance, jetswap, mmfinance, polycat, quickswap, sushiswap, uniswap
polygon	uniswap_v3	retro, sushiswap, uniswap
polygon	uniswap_v4	uniswap
polygon	woofi_v2	woofi
polygon_zkevm	algebra	quickswap
polygon_zkevm	balancer_v2	balancer
polygon_zkevm	kyberswap_elastic	kyberswap
polygon_zkevm	pancakeswap_v3	pancakeswap
polygon_zkevm	uniswap_v2	doveswap, flashliquidity, leetswap, pancakeswap, potato, zkevmswap, zkmoonswap
polygon_zkevm	uniswap_v3	doveswap, quickswap, sushiswap, uniswap
scroll	algebra	scribe
scroll	iziswap_v1	iziswap
scroll	maverick_v2	maverick
scroll	solidly	keller, nuri_exchange, skydrome, tokan_exchange
scroll	uniswap_v2	canary, chiliswap, icecreamswap, issuaa, ivyswap, luigiswap, metavault, papyrusswap, punkswap, quillswap, sanctuary, scrollswap, spacefi, stoneswap, sushiswap, voltageswap, zebra, zerodex, zprotocol
scroll	uniswap_v3	chadfinance, keller, kyberswap, metavault, nuri_exchange, poolshark, sushiswap, uniswap, zebra
soneium	solidly	velodrome
soneium	uniswap_v2	dyorswap, kyo_fi, sonefi, sonus_exchange, uniswap
soneium	uniswap_v3	kyo_fi, sonex, uniswap, velodrome
soneium	uniswap_v4	uniswap
tron	uniswap_v2	intercroneswap, justmoney, sunswap, tofuswap, uswap
tron	uniswap_v3	sunswap
unichain	solidly	unknown
unichain	uniswap_v2	dyorswap, unichainswap, uniswap, unknown
unichain	uniswap_v3	uniswap, velodrome
unichain	uniswap_v4	uniswap
unichain	velodrome_v2	velodrome
worldchain	uniswap_v2	dyorswap, multex, uniswap
worldchain	uniswap_v3	uniswap
worldchain	uniswap_v4	uniswap
zksync	maverick	maverick
zksync	maverick_v2	maverick
zksync	pancakeswap_v3	pancakeswap
zksync	solidly	dracula, solunea, starmaker, velocore, vesync
zksync	uniswap_v2	ezkalibur, gemswap, megalon, pancakeswap, spacefi, zkswap, zkswap2
zksync	uniswap_v3	derpdex, mute, uniswap, wagmi, zkswapdex
zora	uniswap_v2	uniswap
zora	uniswap_v3	uniswap
zora	uniswap_v4	uniswap

EVM-Like Blockchain Chains Tron’s TVM (Tron Virtual Machine) is partially EVM-compatible, but there are specific differences, particularly in its network fee structure. Unlike the EVM, TVM uses energy instead of gas, with TRX as the ecosystem gas token. Additionally, addresses are in Base58.

Chain	Protocols
sui	bluefin, bluemove, cetus_protocol, flowx_v2, flowx_v3, turbos_finance2

Projects and Protocol Indexed on Solana.

Project	Protocols
orca	orca-v1, orca-v2, orca-whirlpool
raydium	raydium-v4, raydium-clmm, raydium-stable, raydium-cp
saber	saber-stableswap
lifinity	lifinity-v2, lifinity-v1
mercurial	mercurial
meteora	meteora, meteora-dlmm, meteora-vault
marinade	marinade
stepn	stepn
openbook	openbook, openbook-v2
crema	clmm-v2
symmetry	symmetry
invariant	invariant
phoenix	phoenix
cropper	cropper-whirlpool
pumpfun	pumpfun
goosefx	goosefx-ssl, goosefx-ssl-v2
fluxbeam	fluxbeam
dexscreener-moonshot	dexscreener-moonshot
stabble	stabble, stabble-weighted
jupiter	jupiter-perp
obric	obric-v2
solfi	solfi
zerofi	zerofi
aldrin	aldrin-v1, aldrin-v2
sanctum	sanctum
virtuals	virtuals
pumpswap	pumpswap
gamma	gamma

Sample Query

DEX Volume
DEX Transaction Fees

Query DEX Volume and Users Across Blockchains indexed by Allium in the last 90 days.

select
    date(block_timestamp) as date,
    chain,
    sum(usd_amount) as usd_volume,
    count(distinct transaction_from_address) as traders
from crosschain.dex.trades
where block_timestamp >= current_timestamp - interval '90 days'
group by all

ℹ️ This is only applicable for EVM DEXs in the crosschain.dex.trades_evm model.Dividing the transaction fees by swap count is required as fees are computed at the transaction level and there are dex trades within a same transaction with multiple hops.

select
    date(block_timestamp) as date,
    chain,
    count(distinct transaction_from_address) as distinct_users,  -- Number of unique users
    avg(usd_amount) as avg_usd_volume,  -- Average swap volume in USD
    sum(usd_amount) as total_usd_volume,  -- Total trade volume in USD by chain
    sum(transaction_fees_usd / swap_count) as total_fees_usd  -- Total fees USD
from crosschain.dex.trades_evm
where block_timestamp > current_timestamp - interval '6 months'
group by all
order by 1 desc

Table Columns

crosschain.dex.trades
crosschain.dex.trades_evm

For blockchains (e.g. Solana) that are not EVM-compatible, the additional fields only relevant to these chains (e.g. Signer for Solana) are added and appended at the end of this table.

Column Name	Description
chain	Blockchain where the dex trade was executed.
project	Name of the project e.g. uniswap, balancer, curve, sushiswap, pancakeswap, fraxswap.
protocol	Version of the protocol used e.g. uniswap_v2, uniswap_v3, balancer_v1, balancer_v2, curve_v1, curve_v2
liquidity_pool_address	Contract address of the liquidity pool holding the asset.
sender_address	Address of the sender of the swap event log, which can be the Router.
to_address	Address of the recipient of the swap event.
token_bought_address	Token address of the token bought, i.e. the asset acquired from the trade.
token_bought_name	Name of the token bought.
token_bought_symbol	Symbol of the token bought.
token_sold_address	Address of the token sold.
token_sold_name	Name of the token sold.
token_sold_symbol	Symbol of the token sold.
token_bought_amount_raw	Amount of token bought (not divided by the number of decimals).
token_bought_amount	token_bought_amount_raw divided by the number of decimals of the token.
token_sold_amount_raw	Amount of token sold (not divided by the number of decimals).
token_sold_amount	token_sold_amount_raw divided by the number of decimals of the token.
usd_amount	USD value of the swap.
transaction_from_address	The address of the sending party of this transaction (Signer on Solana).
transaction_to_address	The address of the receiving party of this transaction, which could be a contract address. (Null for Solana)
transaction_hash	Transaction hash of this trade. (txn_id For Solana)
transaction_index	Transaction index of this trade in the block.
log_index	Log index of this trade. (Null for Solana)
block_timestamp	Block timestamp of this trade.
block_number	Block number of this trade. (block_slot for Solana)
block_hash	Block hash of this trade.
unique_id	Unique ID of each trade.
aggregator	(Solana) Aggregator used for the trade. (Only applicable for Solana trades currently).
block_height	(Solana) Block height of the trade.
instruction_index	(Solana) Instruction index of the trade.
signer	(Solana) Signer of the trade.
program_id	(Solana) program_id of the trade.

The crosschain.dex.trades_evm table columns additional fields that are only applicable for EVM-compatible blockchains.

Column	Description
project	The project (decentralized exchange) of the liquidity pool that the swap occurred from.
protocol	DEX protocol (& version, if applicable) of the contract address facilitating the swap.
liquidity_pool_address	Contract address of the liquidity pool holding the asset. For protocol without the concept of LP such as airswap, this will be null.
sender_address	The address of the sender emitted on the swap event logs. This can be a router or pool address, which is different from the transaction initiator transaction_from_address that initiated the swap.
to_address	Address of the recipient emitted on the swap event logs. For example, we use the to_address from the uniswap v2 swap event log and the recipient_address from the uniswap v3 swap event log.
token_sold_address	Token address of the token sold.
token_sold_name	Name of the token sold.
token_sold_symbol	Symbol of the token sold.
token_sold_decimals	Token decimals of the token sold.
token_sold_amount_raw_str	Raw amount of tokens sold (unnormalized) in string.
token_sold_amount_raw	Raw amount of tokens sold (unnormalized).
token_sold_amount_str	Amount of tokens sold in string.
token_sold_amount	Amount of tokens sold.
usd_sold_amount	Amount of token sold in USD value.
token_bought_address	Token address of the token bought, i.e. the asset acquired from the trade.
token_bought_name	Name of the token bought.
token_bought_symbol	Symbol of the token bought.
token_bought_decimals	Token decimals of the token bought.
token_bought_amount_raw_str	Raw amount of tokens bought (unnormalized) in string.
token_bought_amount_raw	Raw amount of tokens bought (unnormalized).
token_bought_amount_str	Amount of tokens bought in string.
token_bought_amount	Amount of tokens bought.
usd_bought_amount	Amount of token bought in USD value.
usd_amount	USD value of the swap. This field preferentially selects the USD value of Native Assets and Stablecoin (USDT/USDC) tokens, as spam/meme token prices may conflate the true swap value.
extra_fields	This field contains all the extra columns emitted from the event/function call that were not part of the conventional DEX trades columns.
swap_count	Swap count within the transaction.
transaction_fees	Fees paid at the transaction level.
transaction_fees_usd	Fees paid in USD at the time of the transaction.
fee_details	Additional fee details of the transaction, including max priority fee, gas price and gas used for the transaction.
transaction_from_address	Transaction sender address. I.e. the address of the transaction initiator. (from_address in the raw.transactions field for the transaction_hash of this swap).
transaction_to_address	Transaction receiver. (to_address in the raw.transactions field for the transaction_hash of this swap).
transaction_hash	Transaction hash that this swap belongs to.
transaction_index	The position of this transaction in the block that it belongs to. The first transaction has index 0.
selector	4-byte selector of the transaction.
log_index	The position of the swap event log in the transaction.
block_timestamp	Block timestamp of the swap event.
block_number	Block number of the swap event.
block_hash	Block hash of the swap event.
unique_id	Unique ID of each trade.

Overview

Data Verticals

Solana

Hyperliquid

Lighter

Bitcoin Ecosystem

EVM

Cosmos Ecosystem

Move Ecosystem

Other Ecosystems

Blockchain Coverage

Sample Query

Table Columns

​Blockchain Coverage

​Sample Query

​Table Columns

Blockchain Coverage

Sample Query

Table Columns