Table Details
| Property | Value |
|---|---|
| Table Name | hyperevm.dex.tvl_daily |
| Table Status | Production-Ready |
Table Columns
| Column Name | Data Type | Description |
|---|---|---|
| date | TIMESTAMP_NTZ(9) | Date of the balance entry. |
| project | VARCHAR(16777216) | Name of the project e.g. uniswap, balancer, curve, sushiswap, pancakeswap, fraxswap, etc. |
| protocol | VARCHAR(16777216) | Version of the protocol used e.g. uniswap_v2, uniswap_v3, balancer_v3, curve, fluid, etc. |
| pool_name | VARCHAR(16777216) | Name of the liquidity pool. |
| liquidity_pool_address | VARCHAR(16777216) | Contract address of the liquidity pool holding the asset. For some projects, it might be the vault address. |
| token_address | VARCHAR(16777216) | Contract address of the token. |
| token_name | VARCHAR(16777216) | Name of the token. |
| token_symbol | VARCHAR(16777216) | Symbol of the token. |
| token_decimals | NUMBER(38,0) | Decimals of the token. |
| raw_balance_str | VARCHAR(16777216) | Raw balance of the token in string. |
| raw_balance | FLOAT | Raw balance of the token, normalized. |
| balance_str | VARCHAR(16777216) | Balance of the token in string. |
| balance | FLOAT | Balance of the token, normalized. |
| usd_balance | FLOAT | USD balance of the token at the date of the balance entry. |
| usd_exchange_rate | FLOAT | USD exchange rate of the token at the date of the balance entry. |
| last_block_timestamp | TIMESTAMP_NTZ(9) | Timestamp of the last block where the balance of the pool was updated. |
| last_block_number | NUMBER(38,0) | Number of the last block where the balance of the pool was updated. |
| _created_at | TIMESTAMP_NTZ(9) | Timestamp when the record was created. |
| _updated_at | TIMESTAMP_NTZ(9) | Timestamp when the record was last updated. |