Updated 2022-12-09
99
1
2
3
4
5
6
7
8
9
10
›
⌄
select event_name, date_trunc(hour,block_timestamp) as date, count(distinct tx_hash) as txns, count(distinct origin_from_address) as Users,
sum(event_inputs:value/1e6) as Total_Vol, avg(event_inputs:value/1e6) as Avg_Vol, median(event_inputs:value/1e6) as Median_Vol,
sum(txns) over (partition by event_name order by date) as Cum_txns, sum(total_vol) over (partition by event_name order by date) as Cum_Vol
from avalanche.core.fact_event_logs
where tx_status = 'SUCCESS'
and event_name in ('Mint','Burn')
and contract_address = '0xb97ef9ef8734c71904d8002f8b6bc66dd9c48a6e'
and block_timestamp >= '2022-07-01'
group by 1,2
Run a query to Download Data