DATE(BLOCK_TIMESTAMP) AS date,

SUM(tx_fee) AS total_transaction_fees_per_day

FROM

ethereum.core.fact_transactions

WHERE

BLOCK_TIMESTAMP >= CURRENT_DATE - INTERVAL '30 DAY'

AND STATUS = 'SUCCESS'

GROUP BY

DATE(BLOCK_TIMESTAMP)

ORDER BY

date DESC;