SUM(f.tx_fee) AS total_gas_fees_usd

FROM

optimism.core.ez_token_transfers t

JOIN

optimism.core.fact_transactions f

ON

t.tx_hash = f.tx_hash

WHERE

t.contract_address = LOWER('0x296F55F8Fb28E498B858d0BcDA06D955B2Cb3f97');