aptos.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 | FLOAT | The minimum block number in the hour. |
| BLOCK_NUMBER_MAX | FLOAT | 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_SENDER_COUNT | NUMBER | The number of unique sender address in the hour. |
| UNIQUE_PAYLOAD_FUNCTION_COUNT | NUMBER | The number of unique payload functions in the hour. |
| TOTAL_FEES_NATIVE | NUMBER | The sum of all fees in the hour, in the native fee currency. |
| TOTAL_FEES_USD | FLOAT | The sum of all fees in the hour, in USD. |
| EZ_CORE_METRICS_HOURLY_ID | TEXT | The unique primary key identifier for each row in the table, ensuring data integrity and uniqueness. |
- 0x1234567890abcdef1234567890abcdef1234567890abcdef1234567890abcdef
- Essential for data integrity and unique row identification.
- Critical for join operations and data relationship management.
- Enables precise data retrieval and referential integrity maintenance. | | INSERTED_TIMESTAMP | TIMESTAMP_NTZ | The UTC timestamp when the row was inserted into the table, representing when the data was first recorded.
- 2024-01-15 14:30:25.123456
- Essential for data lineage tracking and insertion timing analysis.
- Critical for understanding data freshness and processing delays.
- Enables data quality analysis and processing performance monitoring. | | MODIFIED_TIMESTAMP | TIMESTAMP_NTZ | The UTC timestamp when the row was last modified, representing when the data was most recently updated.
- 2024-01-15 14:30:25.123456
- Essential for data freshness analysis and update tracking.
- Critical for understanding data modification patterns and change frequency.
- Enables data quality monitoring and update performance analysis. |