Table Details
| Property | Value |
|---|---|
| Table Name | bitcoin_cash.metrics.overview |
| Table Status | Production-Ready |
Table Columns
| Column Name | Data Type | Description |
|---|---|---|
| chain | VARCHAR(12) | Name of the blockchain network this record belongs to. |
| activity_date | TIMESTAMP_NTZ(9) | Calendar date (UTC) this daily metric aggregates. |
| native_token_price_median_usd | FLOAT | Median USD price of the native token over the day. |
| total_blocks | NUMBER(18,0) | Total number of blocks produced over the day. |
| avg_block_time | NUMBER(36,6) | Average time between blocks over the day, in seconds. |
| avg_transactions_per_second | NUMBER(38,12) | Average number of transactions per second over the day. |
| hash_rate | FLOAT | Network hash rate over the day. |
| avg_block_size | NUMBER(38,6) | Average block size over the day. |
| total_transactions | NUMBER(18,0) | Total number of transactions over the day. |
| success_transactions | NUMBER(18,0) | Number of successful transactions over the day. |
| failed_transactions | NUMBER(1,0) | Number of failed transactions over the day. |
| transaction_fees | FLOAT | Total transaction fees collected over the day, in the native token. |
| transaction_fees_usd | FLOAT | Total transaction fees collected over the day, in USD. |
| avg_transaction_fee | FLOAT | Average transaction fee over the day, in the native token. |
| avg_transaction_fee_usd | FLOAT | Average transaction fee over the day, in USD. |