peteer1optimism
    Updated 2023-04-14
    select avg(eth_value),avg(tx_fee) , count(*)/count(distinct from_address)
    , sum(eth_value) / count(distinct from_address) ,
    sum(tx_fee) / count(distinct from_address)
    ,year(block_timestamp::date) as years
    from optimism.core.fact_transactions
    where years in (2022,2023)
    group by years
    Run a query to Download Data