SUM(GAS_USED) AS total_gas_used

FROM

ethereum.core.fact_transactions

WHERE

BLOCK_TIMESTAMP >= CURRENT_DATE - INTERVAL '30 DAY'

AND STATUS = 'SUCCESS';