Query editor
1select2date_trunc('day',block_time) as day,3Count (*) as tx_count,4count(distinct "from") as active_addresses5from ethereum.transactions6where block_time > now() - interval '365' day7group by 18order by 19
select
date_trunc('day',block_time) as day,
Count (*) as tx_count,
count(distinct "from") as active_addresses
from ethereum.transactions
where block_time > now() - interval '365' day
group by 1
order by 1