Extract(day,block_timestamp_hour) AS Day,

block_count,

transaction_count,

total_fees_native

FROM

bitcoin.stats.ez_core_metrics_hourly

WHERE

block_timestamp_hour BETWEEN '2024-08-01 00:00:00' AND '2024-08-31 23:59:59'

ORDER BY

block_timestamp_hour;