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

Pools

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

Position Snapshot

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

Pool Snapshot

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

Events

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