DATE_TRUNC('day', block_timestamp) AS day,

COUNT(tx_id) AS transfer_count,

SUM(transfer_amount) AS total_transfer_amount_btc

bitcoin.core.fact_clustered_transfers

block_timestamp >= '2024-01-01'

GROUP BY

day

ORDER BY

day;