solana.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 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 | A unique, stable identifier for each record in this table. The primary key (PK) ensures that every row is uniquely identifiable and supports efficient joins, lookups, and data integrity across models. The PK may be a natural key (such as a blockchain transaction hash) or a surrogate key generated from one or more fields, depending on the table’s structure and requirements. |
| INSERTED_TIMESTAMP | TIMESTAMP_NTZ | The timestamp when this transaction record was first inserted into the analytics database. Used for data freshness tracking and incremental model logic. Format: YYYY-MM-DD HH:MI:SS. Not derived from the blockchain, but from the ETL process. |
| MODIFIED_TIMESTAMP | TIMESTAMP_NTZ | The timestamp when this transaction record was last updated in the analytics database. Used for tracking updates and supporting incremental model logic. Format: YYYY-MM-DD HH:MI:SS. Not derived from the blockchain, but from the ETL process. |