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.
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
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
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
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
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
Last updated