Trades - Allium Documentation Hub

Table Details

Property	Value
Table Name	`solana.dex.trades`
Table Status	Production-Ready
Unique Key	`block_timestamp::date`, `txn_id`, `unique_id`
Clustering Key(s)	`block_timestamp::date, project, protocol, aggregator`
Search Optimization	`block_slot`, `txn_id`, `sender_address`, `token_sold_symbol`, `token_bought_symbol`, `token_sold_mint`, `token_bought_mint`

solana.dex.trades contains instruction level swap data from major dex protocols and projects on Solana network. If you require tx-level detail for records in this table, see here for more info.

DEX Coverage

The existing project and protocol coverage includes:

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

Aggregator Coverage

Swaps routed through aggregators are also tagged. Existing aggregator coverage includes:

Aggregators	Versions
Jupiter	jupiter-aggregator-v2, jupiter-aggregator-v3, jupiter-aggregator-v4, jupiter-aggregator-v5, jupiter-aggregator-v5.1, jupiter-aggregator-v6
Others	drift, kamino, raydium-router, saber-router com

Table Columns

Column Name	Data Type	Description
project	VARCHAR(134217728)	The project (decentralized exchange) of the liquidity pool that the swap occurred from.
protocol	VARCHAR(134217728)	Version of the protocol.
aggregator	VARCHAR(134217728)	Aggregator, if available.
sender_address	VARCHAR(44)	The address of the sender emitted on the swap event logs. This can be a router or pool address.
to_address	VARCHAR(44)	Address where the token is being transferred to.
sender_token_acc	VARCHAR(44)	Address of the account sending the token.
to_token_acc	VARCHAR(44)	Address of the account receiving the token.
token_sold_mint	VARCHAR(44)	Mint address of the token sold.
token_sold_symbol	VARCHAR(134217728)	Symbol of the token sold.
token_sold_amount_raw	FLOAT	Raw amount of tokens sold (unnormalized).
token_sold_amount_raw_str	VARCHAR(134217728)	Raw amount of tokens sold (unnormalized) in string.
token_sold_amount	FLOAT	Amount of tokens sold.
token_sold_amount_str	VARCHAR(134217728)	Amount of tokens sold in string.
usd_sold_amount	FLOAT	Amount of token sold in USD value.
usd_sold_exchange_rate	FLOAT	USD exchange rate of the token sold.
token_bought_mint	VARCHAR(44)	Mint address of the token bought.
token_bought_symbol	VARCHAR(134217728)	Symbol of the token bought.
token_bought_amount_raw	FLOAT	Raw amount of tokens bought (unnormalized).
token_bought_amount_raw_str	VARCHAR(134217728)	Raw amount of tokens bought (unnormalized) in string.
token_bought_amount	FLOAT	Amount of tokens bought.
token_bought_amount_str	VARCHAR(134217728)	Amount of tokens bought in string.
usd_bought_amount	FLOAT	Amount of token bought in USD value.
usd_bought_exchange_rate	FLOAT	USD exchange rate of the token bought.
usd_amount	FLOAT	USD value of the token amount transferred.
tokens_sold_symbols	VARIANT	Array of tokens bought.
tokens_bought_symbols	VARIANT	Array of tokens sold.
token_pairs	VARIANT	Array of token pairs traded.
signer	VARCHAR(44)	Address of the transaction signer.
block_slot	NUMBER(38,0)	Block slot of the transfer.
block_height	NUMBER(38,0)	Block height of the transfer
block_timestamp	TIMESTAMP_NTZ(9)	Block timestamp of the transfer.
block_hash	VARCHAR(44)	Block hash of the transfer.
txn_id	VARCHAR(88)	Transaction ID of the transfer.
txn_index	NUMBER(38,0)	Transaction Index of the transfer.
instruction_index	NUMBER(38,0)	Transfer instruction index.
inner_instruction_index	NUMBER(38,0)	Transfer inner instruction index.
program_id	VARCHAR(44)	Program ID.
accounts	VARIANT	Array of account addresses involved in the trade.
data	VARCHAR(134217728)	Data field.
selector	VARCHAR(134217728)	Selector data.
unique_id	VARCHAR(134217728)	Unique id of the trade.
pool	VARCHAR(44)	Address of the liquidity pool associated with this position or trade.
_updated_at	TIMESTAMP_NTZ(9)	Timestamp of when the entry was last updated in the database.
_created_at	TIMESTAMP_NTZ(9)	Timestamp of when the entry was created in the database.
outer_program_id	VARCHAR(44)	Program ID of the outermost instruction that invoked this inner instruction on Solana