crosschain.stats Table: ez_activity_metrics_daily Type: Base Table
What
An aggregated daily view of cross-chain activity metrics, including transaction counts, fees, and unique initiators. 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 |
| TRANSACTION_COUNT | NUMBER | The number of transactions in the hour. |
| QUALITY_TRANSACTION_COUNT | NUMBER | The number of transactions in the hour. |
| TRANSACTION_COUNT_SUCCEEDED | NUMBER | TRANSACTION_COUNT_SUCCEEDED column |
| QUALITY_TRANSACTION_COUNT_SUCCEEDED | NUMBER | The number of successful transactions in the hour for addresses with a score of 4 or higher |
| UNIQUE_INITIATOR_COUNT | NUMBER | The number of unique initiator or origin from addresses in the hour. |
| QUALITY_UNIQUE_INITIATOR_COUNT | NUMBER | The number of unique initiator or origin from addresses in the hour for addresses with a score of 4 or higher |
| TOTAL_FEES_NATIVE | FLOAT | The sum of all fees in the hour, in the native fee currency. |
| QUALITY_TOTAL_FEES_NATIVE | FLOAT | The sum of all fees in the hour, in the native fee currency for addresses with a score of 4 or higher |
| TOTAL_FEES_USD | FLOAT | The sum of all fees in the hour, in USD. |
| QUALITY_TOTAL_FEES_USD | FLOAT | The sum of all fees in the hour, in USD for addresses with a score of 4 or higher |
| EZ_ACTIVITY_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. |
| _INVOCATION_ID | TEXT | _INVOCATION_ID column |