crosschain.stats Table: ez_dex_protocol_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 dex protocol.Columns
| Column Name | Data Type | Description |
|---|---|---|
| BLOCKCHAIN | TEXT | Blockchain, Network, or Platform the transaction or event occurs on. |
| PROTOCOL | TEXT | This field denotes which application the liquidity pool belongs to. |
| BLOCK_DATE | DATE | The date of the block timestamp of this transaction in UTC |
| SWAP_COUNT | NUMBER | SWAP_COUNT column |
| DISTINCT_SWAPPER_COUNT | NUMBER | DISTINCT_SWAPPER_COUNT column |
| GROSS_DEX_VOLUME_USD | FLOAT | GROSS_DEX_VOLUME_USD column |
| EZ_DEX_PROTOCOL_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. |