SELECT BLOCK_TIMESTAMP_HOUR AS "Hour"
,BLOCK_COUNT AS "Blocks_Hourly"
,TRANSACTION_COUNT AS "Transactions_Hourly"
,UNIQUE_ADDRESS_COUNT AS "Unique_Addresses"
,UNIQUE_TO_COUNT AS "Unique_Recipients"
,TOTAL_FEES_NATIVE AS "Fees_Hourly"
,TOTAL_FEES_USD AS "Fees_Hourly_USD"
FROM bitcoin.stats.ez_core_metrics_hourly
WHERE 1 = 1
AND BLOCK_TIMESTAMP_HOUR > current_timestamp - interval '24 hours'
ORDER BY BLOCK_TIMESTAMP_HOUR DESC