stellar.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 successful transactions submitted and completed by the network in this ledger. |
| 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_ACCOUNTS_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 | Unique primary key for the dimension table, used as the main identifier for each record. |
| INSERTED_TIMESTAMP | TIMESTAMP_NTZ | Timestamp when this record was inserted. |
| MODIFIED_TIMESTAMP | TIMESTAMP_NTZ | Timestamp when this record was last modified. |