crosschain.stats Table: ez_activity_protocol_metrics_daily Type: Base Table
What
An aggregated daily view of cross-chain activity metrics, including transaction counts aggregated by the protocol. This model also contains and IS_QUALITY flag that indicates whether the transaction initiator has a user score of 4 or higher.Columns
| Column Name | Data Type | Description |
|---|---|---|
| BLOCKCHAIN | TEXT | Blockchain, Network, or Platform the transaction or event occurs on. |
| BLOCK_DATE | DATE | The date of the block timestamp of this transaction in UTC |
| PROTOCOL | TEXT | PROTOCOL column |
| TRANSACTION_COUNT | NUMBER | The number of transactions in the hour. |
| QUALITY_TRANSACTION_COUNT | NUMBER | The number of transactions in the hour. |
| NUM_USERS | NUMBER | unique addresses submitting a transaction that interacts with any protocol contract (same address can be counted across two different protocols, but never more than once within a protocol) |
| NUM_QUALITY_USERS | NUMBER | quality addresses with flipside score >= 4 submitting a transaction that interacts with any protocol contract (same address can be counted across two different protocols, but never more than once within a protocol) |
| EZ_ACTIVITY_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. |