flipside

    ✅ fees: Average Transaction Fees in Each weekday ($ETH)
    elsina✅ fees: Average Transaction Fees in Each weekday ($ETH)
    Updated 2022-08-04
    select
    dayname(block_timestamp) as "Day Name",
    DATE_PART(WEEKDAY, block_timestamp) as "Day Number",
    avg(tx_fee) as "Fee"
    from optimism.core.fact_transactions
    where block_timestamp::date < current_date
    group by 1,2
    order by "Day Number"
    Run a query to Download Data