mlhUntitled Query
Updated 2022-11-30
9
1
2
3
4
5
6
7
8
›
⌄
select date_trunc('day', block_timestamp) as day,
count(distinct tx_hash),
count(distinct ORIGIN_FROM_ADDRESS) as users,
event_name
from avalanche.core.fact_event_logs
where block_timestamp >= CURRENT_DATE - 90
order by 2 desc
group by 1, 4
Run a query to Download Data