Ez Core Metrics Hourly

stats.ez_core_metrics_hourly

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

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_FROM_COUNT	NUMBER	The number of unique origin from addresses in the hour.
UNIQUE_TO_COUNT	NUMBER	The number of unique origin to addresses in the hour.
TOTAL_FEES_NATIVE	FLOAT	The sum of all fees in the hour, in the native fee currency. Note, Snowflake’s native SUM() function may limit decimal precision. To view precise transaction fee values, please use the tx_fee_precise column in core.fact_transactions.
TOTAL_FEES_USD	FLOAT	The sum of all fees in the hour, in USD, rounded to 2 decimal places.
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.