Table Details
| Property | Value |
|---|---|
| Table Name | dogecoin.metrics.overview |
| Table Status | Production-Ready |
Table Columns
| Column Name | Data Type | Description |
|---|---|---|
| chain | VARCHAR(8) | Slug identifying the blockchain this record belongs to. |
| activity_date | TIMESTAMP_NTZ(9) | Calendar date (UTC) for which these metrics are computed. Only includes fully completed days. |
| native_token_price_median_usd | FLOAT | Median USD price of the chain’s native token over the day, using hourly price samples. |
| total_blocks | NUMBER(18,0) | Total number of blocks produced on this date. |
| avg_block_time | NUMBER(36,6) | Average time in seconds between consecutive blocks on this date. |
| avg_transactions_per_second | NUMBER(38,12) | Average number of transactions per second, calculated as average transactions per block divided by average block time. |
| hash_rate | FLOAT | Estimated total mining hash rate securing the network on this date. |
| avg_block_size | NUMBER(38,6) | The average block size in bytes on this date. |
| total_transactions | NUMBER(18,0) | Total number of transactions processed on this date. |
| success_transactions | NUMBER(18,0) | Number of transactions that executed successfully on this date. |
| failed_transactions | NUMBER(1,0) | Number of transactions that failed on this date. |
| transaction_fees | FLOAT | Total transaction fees paid on this date, in the chain’s native token. |
| transaction_fees_usd | FLOAT | Total transaction fees paid on this date, converted to USD. |
| avg_transaction_fee | FLOAT | Average fee per transaction on this date, in the chain’s native token. |
| avg_transaction_fee_usd | FLOAT | Average fee per transaction on this date, converted to USD. |