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.

Tokens

Property	Description	Type
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

Token Snapshot

Property	Description	Type
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

Protocol Snapshot

Property	Description	Type
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

Trades

Property	Description	Type
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