platform,

SUM(blocks.block_header_json:baseFeePerGas / 1e18 * tx.gas_used) AS eth_burnt,

FROM ethereum.defi.ez_dex_swaps s

JOIN ethereum.core.fact_transactions tx ON s.tx_hash = tx.tx_hash

JOIN ethereum.core.fact_blocks blocks ON tx.block_number = blocks.block_number

WHERE s.block_timestamp >= '2021-08-01'

GROUP BY month, platform