nitsAverage Fee During Festive Season 2
    Updated 2022-03-17
    SELECT date(block_timestamp) as day, avg(fee_usd) as avg_fee_paid , avg(avg_fee_paid) over (order by day) as avg_fee_paid_over_time,
    count(*) as total_txs , sum(total_txs) over (order by day)
    from ethereum.transactions where tx_id in
    (SELECT tx_id from ethereum.dex_swaps
    where platform = 'sushiswap') and date(block_timestamp) > '2021-11-20' AND DATE(BLOCK_TIMESTAMP)< '2021-12-01'

    GROUP by 1
    limit 100
    Run a query to Download Data