osmosis.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.
Stats for the current hour will be updated as new data arrives.
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 id in the hour. |
| BLOCK_NUMBER_MAX | NUMBER | The maximum block id 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 tx_from addresses in the hour. |
| TOTAL_FEES_NATIVE | FLOAT | The sum of all fees in the hour, in the native fee currency. |
| TOTAL_FEES_USD | FLOAT | The sum of all fees in the hour, in USD. |
| 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. |