Ez Core Metrics Hourly

stats.ez_core_metrics_hourly

Schema: 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.