sum(tx_fee) as fee_eth

from optimism.core.fact_transactions

where block_timestamp >= current_date - 1