EXTRACT(day, block_timestamp_hour) AS day,

SUM(total_fees_native) AS "Fees in Bitcoin",

SUM(total_fees_usd) AS "Fees in USD"

FROM

bitcoin.stats.ez_core_metrics_hourly

WHERE

block_timestamp_hour BETWEEN '2024-08-01' AND '2024-08-31'

GROUP BY

EXTRACT(day, block_timestamp_hour)

ORDER BY

day;