theericstoneAverage hourly fees
    Updated 2023-03-09
    select * from (
    select
    date_trunc('hour',block_timestamp) as hour,
    function_name,
    count(*) as n_txns,
    avg(fee_usd) as mean_fee
    from
    ethereum.transactions
    where
    block_timestamp >= getdate() - interval '8 hours'
    and (
    LOWER(function_name) like 'swap%'
    OR LOWER(function_name) like '%liquidity%'
    OR LOWER(function_name) like '%claim%'
    OR LOWER(function_name) like '%deposit%'
    )
    group by 1,2
    order by 1 desc)
    allofit where n_txns >= 100 and mean_fee > 0;
    Run a query to Download Data