crosschain.stats Table: ez_dex_token_metrics_daily Type: Base Table
What
An aggregated daily view of cross-chain dex metrics, including volume, distinct addresses and unique transactions grouped by blockchain and token. This only includes verified tokens.Columns
| Column Name | Data Type | Description |
|---|---|---|
| BLOCKCHAIN | TEXT | Blockchain, Network, or Platform the transaction or event occurs on. |
| TOKEN_ADDRESS | TEXT | The specific address representing the asset on a specific platform. This will be NULL if referring to a native asset. |
| SYMBOL | TEXT | The symbol of asset. |
| BLOCK_DATE | DATE | The date of the block timestamp of this transaction in UTC |
| BUY_SWAP_COUNT | NUMBER | BUY_SWAP_COUNT column |
| BUY_VOLUME | FLOAT | BUY_VOLUME column |
| BUY_USD_VOLUME | FLOAT | BUY_USD_VOLUME column |
| SELL_SWAP_COUNT | NUMBER | SELL_SWAP_COUNT column |
| TOKEN_SWAPPERS | NUMBER | TOKEN_SWAPPERS column |
| SELL_VOLUME | FLOAT | SELL_VOLUME column |
| SELL_USD_VOLUME | FLOAT | SELL_USD_VOLUME column |
| NET_PURCHASED | FLOAT | NET_PURCHASED column |
| NET_PURCHASED_USD | FLOAT | NET_PURCHASED_USD column |
| EZ_DEX_TOKEN_METRICS_DAILY_ID | TEXT | The unique identifier for each row in the table. |
| INSERTED_TIMESTAMP | TIMESTAMP_NTZ | The utc timestamp at which the row was inserted into the table. |
| MODIFIED_TIMESTAMP | TIMESTAMP_NTZ | The utc timestamp at which the row was last modified. |