.svg?alt=media&token=46df73ac-afb3-4b02-8db1-555488611437)
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.
dex_trades
The table below contains all the dex_trades table columns , such as signer, pool_address, base_mint, quote_mint, amount, etc.
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
Last updated