Yield Aggregator
Our data tables capture key metrics on vault pools, withdrawals, deposits, and user activity.
Key Tables:
Pools: Information about vault pools, including underlying tokens, pool address, and receipt tokens.
Position Snapshot: Snapshot of user positions, detailing underlying tokens and their value.
Pool Snapshot: Snapshot of individuals pools, tracking TVL, fees, and other high-level metrics.
Events: Tracks user interactions such as deposits, withdrawals, and changes to positions.Pools
chain_id
The standard chain id.
number
timestamp
The timestamp this pool was created.
number
creation_block_number
The block number that this pool was created.
number
underlying_token_address
The contract address of the underlying token or deposited token.
string
underlying_token_index
The index of the underlying token in the smart contract, default 0.
number
underlying_token_symbol
The symbol of the underlying token token.
string
underlying_token_decimals
The decimal amount of the underlying token.
number
receipt_token_address
The contract address of the output or receipt token of this pool, if available.
string
receipt_token_symbol
The symbol of the receipt token.
string
receipt_token_decimals
The symbol decimal amount for the receipt token.
number
pool_address
The smart contract address of the pool.
string
pool_symbol
The symbol of the pool.
string
timestamp
The timestamp of the snapshot.
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 chain id.
number
pool_address
The address of the pool this user has a position in.
string
user_address
The address of the user who has a position in the pool.
string
underlying_token_address
The address of the supplied underlying token.
string
underlying_token_index
The index in the smart contract of this underlying token, default 0.
number
underlying_token_amount
The amount of the underlying token that the user deposited, decimal normalized.
number
underlying_token_amount_usd
The amount of underlying tokens supplied, in USD.
number
total_fees_usd
The total amount of revenue and fees paid in this pool in the given snapshot, in USD.
number
timestamp
The timestamp of the snapshot.
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 chain id.
number
underlying_token_address
The contract address of the underlying token or deposited token.
string
underlying_token_index
The index of the underlying token in the smart contract, default 0.
number
pool_address
The address of the pool.
string
underlying_token_amount
The amount of underlying token supplied in this pool, decimal normalized.
number
underlying_token_amount_usd
The amount of underlying tokens supplied in this pool, in USD.
number
total_fees_usd
The total amount of revenue and fees paid in this pool in the given snapshot, in USD.
number
timestamp
The timestamp of the transaction.
number
chain_id
The standard id of the chain.
number
block_number
The block number of the trade.
number
log_index
The event log. For transactions that don't emit event, create arbitrary index starting from 0.
number
transaction_hash
The hash of the transaction.
string
user_address
The address that initiates the transaction (ie, the transaction signer).
string
taker_address
The address that owns the position (ie, most of the time, it is the same as the user_address).
string
pool_address
The smart contract address of the pool.
string
underlying_token_address
The contract address of the underlying token or deposited token.
string
amount
The amount of token transacted, decimal normalized.
number
amount_usd
The amount of token transacted, in USD.
number
event_type
The type of event, corresponds to the action taken by the user (ie, deposit, withdrawal).
string
Last updated