eclipse.stats Table: ez_core_metrics_hourly Type: Base Table
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 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_SIGNERS_COUNT | NUMBER | The count of unique first signers for transactions in the hour. |
| TOTAL_FEES_NATIVE | NUMBER | The sum of all fees in the hour, in Lamports. |
| 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 timestamp at which the record was initially created and inserted into this table. |
| MODIFIED_TIMESTAMP | TIMESTAMP_NTZ | The timestamp at which this record was last modified by an internal process. |