SELECT

CORR(transaction_count, total_fees_usd) AS correlation_transaction_fees

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';