nitsEvent Type Stats
Updated 2022-12-08Copy Reference Fork
99
1
2
3
4
5
6
7
8
9
10
11
12
13
›
⌄
--credit : https://app.flipsidecrypto.com/velocity/queries/dee9ab7c-e801-4602-a1ce-3ddc296d377a
select event_name,
count (distinct tx_hash) as TX_Count,
count (distinct origin_from_address) as Users_Count,
sum (event_inputs:value/1e6) as Total_Volume,
avg (event_inputs:value/1e6) as Average_Volume,
median (event_inputs:value/1e6) as Median_Volume
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
Run a query to Download Data