DEX Aggregator
Our data tables capture key metrics related to token volumes, fees, and trades.
Key Tables:
Tokens: Details of the tokens supported by the aggregator, including token addresses, names, symbols, and decimals.
Token Snapshot: Token-level snapshots, capturing trading volume, fees, and incentives collected in USD for a given period.
Protocol Snapshot: Snapshot of aggregator-wide metrics, including total volume and fees in USD across all tokens.
Trades: Data on individual trades executed via the aggregator, including token swaps, slippage, and fees.
chain_id
The standard id of the chain.
number
token_address
The contract address of the token.
string
token_name
The full name of the token, from the eth_call name().
string
token_symbol
The symbol of the token, from the eth_call symbol().
string
decimals
The decimals name of the token, from the eth_call decimals().
number
timestamp
The timestamp of the record.
number
block_date
The timestamp truncated (ie, YYYY-MM-DD format for daily snapshots and YYYY-MM-DD HH:00:00 for hourly snapshots).
date
chain_id
The standard id of the chain.
number
token_address
The contract address of the token.
string
volume_amount
The volume amount of the token, during the snapshot period, decimal normalized.
number
volume_usd
The volume of the token in USD.
number
fees
The fees (ie, revenue generated from trading this token) from this token in native, decimal normalized terms.
number
fees_usd
The fees collected in USD.
number
incentive_amount
The amount of incentives collected from this token, during the snapshot period, decimal normalized.
number
incentive_usd
The value of incentives in USD.
number
timestamp
The timestamp of the block this snapshot was taken.
number
block_date
The timestamp truncated (ie, YYYY-MM-DD format for daily snapshots and YYYY-MM-DD HH:00:00 for hourly snapshots).
date
chain_id
The standard id of the chain.
number
volume_usd
The volume in USD, in the given snapshot period.
number
fees_usd
The fees (ie, total revenue generated in the protocol) collected in USD, during the snapshot period.
number
timestamp
The timestamp of the trade.
number
chain_id
The standard id of the chain this trade belongs to.
number
block_number
The block number in which the trade occurred.
number
transaction_hash
The transaction hash associated with this trade.
string
log_index
The event log. For transactions that don't emit event, create arbitrary index starting from 0.
number
fees
The amount of fees from this trade (ie, the revenue generated from executing this trade).
number
fees_usd
The fees for this trade in USD.
number
slippage
(Optional) The slippage of the given trade, as a percentage (ie, 1.3% slippage is 0.013).
number
user_address
The address of the user initiating the trade.
string
input_tokens
The contract address of the input token(s).
[string]
input_token_amounts
Parallel array to input_tokens, dictating the normalized native amounts of each token traded.
[number]
output_tokens
The contract address of the output token(s).
[string]
output_token_amounts
Parallel array to output_tokens, dictating the normalized native amounts of each token traded.
[number]
swap_amount_usd
The value of the swap in USD.
number
Last updated