block_timestamp_hour::date as "Date",

sum(transaction_count) as "Transaction_count",

sum(unique_address_count) as "Unique_addresses",

sum(total_fees_usd) as "Total_fees_USD"

FROM bitcoin.stats.ez_core_metrics_hourly

WHERE block_timestamp_hour::date BETWEEN '2022-01-01' AND '2024-03-31'

GROUP BY "Date"

ORDER BY "Date" DESC