blast.stats Table: ez_core_metrics_hourly Type: View
A convenience table that aggregates block and transaction related metrics using various aggregate
functions such as SUM, COUNT, MIN and MAX from the fact_transactions table, on an hourly basis.
Columns
| Column Name | Data Type | Description |
|---|---|---|
| BLOCK_TIMESTAMP_HOUR | TIMESTAMP_NTZ | The hour of the timestamp of the block. |
| BLOCK_NUMBER_MIN | NUMBER | The minimum block number in the hour. |
| BLOCK_NUMBER_MAX | NUMBER | The maximum block number in the hour. |
| BLOCK_COUNT | NUMBER | The number of blocks in the hour. |
| TRANSACTION_COUNT | NUMBER | The number of transactions in the hour. |
| TRANSACTION_COUNT_SUCCESS | NUMBER | The number of successful transactions in the hour. |
| TRANSACTION_COUNT_FAILED | NUMBER | The number of failed transactions in the hour. |
| UNIQUE_FROM_COUNT | NUMBER | The number of unique origin from addresses in the hour. |
| UNIQUE_TO_COUNT | NUMBER | The number of unique origin to addresses in the hour. |
| TOTAL_FEES_NATIVE | FLOAT | The sum of all fees in the hour, in the native fee currency. Note, Snowflake’s native SUM() function may limit decimal precision. To view precise transaction fee values, please use the tx_fee_precise column in core.fact_transactions. |
| TOTAL_FEES_USD | FLOAT | The sum of all fees in the hour, in USD, rounded to 2 decimal places. |
| EZ_CORE_METRICS_HOURLY_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. |