binhachonSeasonality - Days and timezone
    Updated 2022-11-28
    with swap_transaction as (
    select
    tx_id,
    count(*) as frequency
    from ethereum.dex_swaps
    where platform like '%sushi%'
    group by tx_id
    ),
    swap_gas as (
    select
    block_timestamp,
    tx_fee
    from ethereum.transactions
    where tx_id in (select tx_id from swap_transaction where frequency = 2)
    )
    select
    date_part('hour', block_timestamp) as timezonehour,
    -- date_part('weekday', block_timestamp) as dayofweek,
    dayname(block_timestamp) as dayofweek,
    avg(tx_fee) as average_fee
    from swap_gas group by timezonehour, dayofweek

    Run a query to Download Data