DEX Trades

The respective table contains all the dex trades on Solana since February 2021.

How we are indexing our dex_trades table?

We have written a Substreams to index this data. Substreams is a powerful blockchain indexing technology developed by StreamingFast. You can take a look at our indexing code here.

The table below contains the project names and their respective program addresses that we have included in our dex_trades table.

Platform Name	DAPP	Instructions
Pheonix	PhoeNiXZ8ByJGLkxNfZRnkUfjvmuYqLR89jjFHGqdXY	Swap
Saros	SSwapUtytfBdBn1b9NUGG6foMVPtcWgpRU32HToDUZr	Swap
Stepn	Dooar9JkhdZ7J3LHN3A7YCuoGRUggXhQaG4kijfLGU2j	Swap
Crema	CLMM9tUoggJu2wagPkkqs9eFG4BWhVBZWkP1qv3Sp7tR	SwapWithPartner
Meteora	Eo7WjKq67rjJQSZxS6z3YkapzY3eMj6Xy8X5EQVn5UaB	Swap
Openbook	srmqPvymJeFKQ4zGQed1GFppgkRHL9kaELCbyksJtPX	Serum3PlaceOrder
Openbook V2	opnb2LAfJYbRMAHHvqjCwQxanZn7ReEHp1k81EohpZb
Symmetry	2KehYt3KsEQR53jYcxjbQp2d2kCp4AkuQW68atufRwSr	SwapFundTokens
Invariant	HyaB3W9q6XdA5xwpU4XnSZV94htfmbmqJXZcEbRaJutt	Swap
Orca Liquidity Pools	whirLbMiicVdio4qvUfM5KAg6Ct8VwpYzGff3uctyCc	Swap
Lifinity v1	EewxydAPCCVuNEyrVN68PuSYdQ7wKn27V9Gjeoi8dy3S	Swap
Lifinity v2	2wT8Yq49kHgDzXuPxZSaeLaH1qbmGXtEyPy64bL7aD3c	Swap
Saber	SSwpkEEcbUqx4vtoEByFjSkhKdCT862DNVb52nZg1UZ	Swap
Raydium v4	675kPX9MHTjS2zt1qfr1NYHuzeLXfQM9H24wFSUt1Mp8	SwapBaseIn
Raydium v3	27haf8L6oxUeXrHrgEgsexjSY5hbVUWEmvv9Nyxg8vQv	SwapBaseIn
Raydium CLMM	CAMMCzo5YL8w4VFF8KVHrK22GGUsp5VTaW7grrKgrWqK	Swap
Orca legacy	9W959DqEETiGZocYWCQPaJ6sBmUzgfxXfqGeTEdp3aQP	Swap
Aldrin AMM	AMM55ShdkoGRB5jVYPjWziwk8m5MpwyDgsMWHaMSQWH6	Swap
Aldrin AMM v2	CURVGoZn8zycx6FXwwevgBTB2gVvdbGTEpvMJDbgs2t4	Swap
Cropper	CTMAxxk34HjKWxQ3QLZK1HpaLXmBveao3ESePXbiyfzh	Swap
Cykura	cysPXAjehMpVKUapzbMCCnpFxUFFryEWEaLgnb9NrR8	ExactInputSingle
GooseFX	7WduLbRfYhTJktjLw5FDEyrqoEv61aTTCuGAetgLjzN5	Swap
GooseFX V2	GFXsSL5sSaDfNFQUYsHekbWBW1TsFdjDYzACh62tEHxn	Swap
BonkSwap	BSwp6bEBihVLdqJRKGgzjcGLHkcTuzmSo1TQkHepzH8p	Swap
FluxBeam	FLUXubRmkEi2q6K3Y9kBPg9248ggaZVsoSFhtJHSrm1X	Swap
Penguin	PSwapMdSai8tjrEXcxFeQth87xC4rRsa4VA5mhGhXkP	Swap
Balansol	D3BBjqUdCYuP18fNvvMbPAZ8DpcRi4io2EsYHQawJDag	Swap
Step Finance	SSwpMgqNDsyV7mAgN9ady4bDVu5ySjmmXejXvy2vLt1	Swap
Sencha	SCHAtsf8mbjyjiv4LkhLKutTf6JnZAbdJKFkXQNMFHZ	Swap
Dradex	dp2waEWSBy5yKmq65ergoU3G6qRLmqa6K7We4rZSKph	CreateOrder
Oasis	9tKE7Mbmj4mxDjWatikzGAtkoWosiiZX9y6J4Hfm2R8H	Swap
Mercurial	MERLuDFBMmsHnsBPZw2sDQZHvXFMwp8EdjudcU2HKky	Exchange
Orca v1	DjVE6JNiYqPL2QXyCUUh8rNjHrbz9hXHNYt99MQ59qw1	Swap
Crema	6MLxLqiXaaSUpkgMnWDTuejNZEz3kE7k2woyHGVFw319	Swap

dex_trades

The table below contains all the dex_trades table columns , such as signer, pool_address, base_mint, quote_mint, amount, etc.

Column Name	Column Type	Description
block_time	timestamp	The time this block was produced
block_slot	bigint	This block’s slot index in the ledger
tx_id	string	The first signature in the transaction
signer	string	The first value from the account_keys array that initiates the transaction and pays the transaction fee
pool_address	string	The address of the pool
base_mint	string	Mint of the base token
quote_mint	string	Mint of the quote token
base_vault	string	Vault address of the base token
quote_vault	string	Vault address of the quote token
base_amount	double	Amount of the base token that is traded in the transaction
quote_amount	double	Amount of the quote token that is traded in the transaction
is_inner_instruction	boolean	Tells whether there is any inner instruction in the transaction or not
instruction_index	int	Instruction index of various instructions in a transaction
instruction_type	string	Name of the function of a Solana program invoked via an instruction
inner_instruxtion_index	int	Index of various inner instructions in a instruction
outer_program	string	The main program of an instruction
inner_program	string	The inner programs under the main/outer program
txn_fee	big_int	Fee this transaction was charged, as paid signer
signer_sol_change	bigint	Sol balance change of signer
partition_0	string	The date on which the block was produced