Query editor
1select2 date_trunc('day',block_time) as day,3 Count (*) as tx_count,4 count(distinct "from") as active_addresses5from ethereum.transactions6where block_time > now() - interval '90' 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 '90' day
group by 1
order by 1