flipside

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