blockchain

project

Version of the contract built and deployed by the DEX project

version

version_name

block_month

block_date

block_time

block_slot

Was the trade a direct call to the whirlpool or did it go through another program like Jupiter (Dex Aggregator)

trade_source

Token symbol for token bought in the trade

token_bought_symbol

token_sold_symbol

Token symbol pair for each token involved in the trade

token_pair

Value of the token bought at time of execution in the original currency

token_bought_amount

Value of the token sold at time of execution in the original currency

token_sold_amount

Raw value of the token bought at time of execution in the original currency

token_bought_amount_raw

Raw value of the token sold at time of execution in the original currency

token_sold_amount_raw

USD value of the trade at time of execution

amount_usd

fee_tier

fee_usd

token_bought_mint_address

token_sold_mint_address

token associated address for the whirlpool, of the token bought

token_bought_vault

token associated address for the whirlpool, of the token sold

token_sold_vault

project_program_id

project_main_id

id (address) of trader who purchased a token

trader_id

Unique transaction id value tied to each transaction on the DEX

tx_id

top level instruction index for a given transaction id

outer_instruction_index

inner instruction index for a given transaction id

inner_instruction_index

index of the transaction in the block slot

tx_index

Timestamp when the row was last updated by dbt

_updated_at

Detailed data on trades executed via decentralized exchanges (DEXs) on Solana, containing one or many trades per transaction with Solana-specific fields like block_slot, fee_tier, and token vaults.