| date | TIMESTAMP_NTZ(9) | Calendar date (UTC) this record represents. Used in daily aggregate tables. |
| sector | VARCHAR(16777216) | Protocol sector or vertical this TVL row belongs to (e.g. dex, lending, labs, yields). Used to categorize and aggregate TVL across verticals. |
| project | VARCHAR(16777216) | Business name of the protocol being used (e.g. uniswap, aave, lido, paraswap). Consistent across verticals — every table with a project column uses this field to identify the top-level protocol brand. |
| protocol | VARCHAR(16777216) | Specific version or variant of the protocol (e.g. uniswap_v3, aave_v2, stargate_v2). Qualifies the project field with version information. |
| address | VARCHAR(16777216) | Wallet or contract address of the account. On EVM chains, a 42-character hex string (0x-prefixed). On other chains, the native address format applies. |
| token_address | VARCHAR(16777216) | Contract address of the token. For EVM chains, native currency (e.g. ETH, MATIC) is represented as the zero address (0x0000000000000000000000000000000000000000). For Solana, this is the mint address. |
| token_name | VARCHAR(16777216) | Full name of the token (e.g. “USD Coin”, “Wrapped Ether”). |
| token_symbol | VARCHAR(16777216) | Ticker symbol of the token (e.g. “USDC”, “WETH”). |
| token_decimals | NUMBER(38,0) | Number of decimal places used to represent the token’s smallest unit. Used to convert raw amounts: normalized_amount = raw_amount / 10^decimals. For example, USDC has 6 decimals, so 2500000 raw units = 2.5 USDC. |
| raw_balance_str | VARCHAR(16777216) | Token balance in the smallest unit, stored as a string for full precision. Avoids floating-point truncation for tokens with very large integer balances. |
| balance | FLOAT | Token balance normalized by the token’s decimal precision (raw_balance / 10^decimals). Human-readable value (e.g. 1.5 USDC rather than 1500000). |
| usd_balance | FLOAT | USD value of the token balance, computed using the exchange rate at the time of the balance snapshot. |
| usd_exchange_rate | FLOAT | USD price per unit of the token at the time of the event, used to compute usd_amount. Sourced from Allium’s hourly price feed. |
| is_primary | BOOLEAN | Whether this row represents the canonical (non-double-counted) TVL for this asset. When an asset is deployed into another tracked protocol, is_primary = false on the source row to avoid double-counting. Filter to is_primary = true for unique TVL. |
| adjusted_usd_balance | FLOAT | USD TVL after removing double-counted value. For assets that are deployed into another tracked protocol (e.g. lending collateral also counted in the lending sector), this is set to zero on the non-primary row; for primary rows it equals usd_balance. |
| is_rwa | BOOLEAN | Whether the token in this row is a Real World Asset (RWA) token. Derived from the RWA token registry. |
| rwa_asset_class | VARCHAR(16777216) | High-level asset class of the RWA token (e.g. treasuries, credit, commodities). Null for non-RWA tokens. |
| rwa_asset_type | VARCHAR(16777216) | Specific asset type within the RWA asset class (e.g. us_treasuries, trade_finance). Null for non-RWA tokens. |
| last_block_timestamp | TIMESTAMP_NTZ(9) | Timestamp of the last block included in the TVL calculation. |
| last_block_number | NUMBER(38,0) | Block number of the last block included in the TVL calculation. |
| _created_at | TIMESTAMP_NTZ(9) | Timestamp of when the entry was created in the database. |
| _updated_at | TIMESTAMP_NTZ(9) | Timestamp of when the entry was last updated in the database. |
