SELECT

block_timestamp AS swap_time,

tx_hash AS transaction_id

FROM optimism.defi.ez_dex_swaps

WHERE block_timestamp >= CURRENT_TIMESTAMP() - INTERVAL '1 DAY'

),

transaction AS (

SELECT

t.tx_fee_precise AS transaction_fee

FROM recent_swaps r

JOIN optimism.core.fact_transactions t

ON r.transaction_id = t.tx_hash

SUM(transaction_fee) AS total_gas_fees,

ROUND(AVG(transaction_fee), 5) AS average_gas_fees

FROM transaction;