General

For protocols that do not fall into any of the protocol types listed here, they are captured under the Generic Protocol type. Our tables capture key metrics on liquidity, tokens, and user activity.

Key Tables:

• Pool Snapshot: Insights into pools, including total value locked and APRs.

• Protocol Snapshot: Aggregated data on the protocol’s fees, transactions, and user count.

• Token Balance Snapshot: User-level token balance snapshots.

• General Transactions: Transactions on the protocol, capturing details about token transfers, fees, and associated addresses.

• User Transaction Fee Snapshot: Gas and transaction snapshot data at the user level.

Pool 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 chain id.	number
protocol_type	The type of protocol (ie, Lending, CDP, DEX, Gaming, etc).	string
pool_address	The smart contract address of the pool.	string
pool_name	The name of the pool (ie, pool() in the smart contract, if it exists).	string
total_value_locked_usd	The total value locked within this pool in USD.	number
supply_apr	The annual percentage rate of this pool at the snapshot.	number
supply_apy	The annual percentage yield of the pool.	number

Protocol 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
daily_active_users	The number of unique daily active users on this protocol.	number
transaction_count	The number of transactions in this time period.	number
fees_usd	The amount of fees in this given period, decimal normalized.	number

Token Balance 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
user_address	The address of the user this snapshot activity is based on.	string
token_address	The smart contract address of the token.	string
token_symbol	The symbol of the token we are getting the balance of.	string
token_amount	The amount of the token at the given snapshot timestamp (decimal normalized).	number
token_amount_usd	The amount of the token in USD.	number

General Transactions

Property	Description	Type
timestamp	The timestamp of the transaction.	timestamp
block_date	A date representation of the timestamp (ie, YYYY-MM-DD HH:MM:SS)	date
chain_id	The standard chain id.	number
block_number	The ordinal block number.	number
signer_address	The transaction signer's address.	varbinary
transaction_hash	The unique identifier for this transaction.	varbinary
log_index	The unique identifier for this transaction.	number
event_name	The string name for the event associated with log_index, corresponds to the action taken by the user (ie, deposit, withdrawal, borrow, repay, liquidation, flashloan).	string
transaction_fee	The total amount of gas used in the transactions occurring in the given snapshot (in the native gas amount).	number
transaction_fee_usd	The total amount of gas used in USD terms in the given snapshot.	number

User Transaction Fee 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
user_address	The address of the user this snapshot activity is based on.	string
transaction_count	The number of transactions this user has signed in the given snapshot.	number
transaction_fees	The total amount of gas used in the transactions occurring in the given snapshot (in the native gas amount).	number
transaction_fees_usd	(Optional, if possible) The total amount of gas used in USD terms in the given snapshot.	vnumber