peteer1optimism
Updated 2023-04-14
9
1
2
3
4
5
6
7
›
⌄
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