hessDaily Mint and Burn
Updated 2022-12-08
99
1
2
3
4
5
6
7
8
9
10
›
⌄
with mint as ( select trunc(block_timestamp,'{{Time_Frame}}') as date,event_name, tx_hash, origin_from_address, event_inputs:value/pow(10,6) as volume
from avalanche.core.fact_event_logs
where date >= '2022-07-01' and contract_address = lower('0xb97ef9ef8734c71904d8002f8b6bc66dd9c48a6e')
and event_name in ('Mint','Burn') and tx_status = 'SUCCESS')
select date, event_name, count(DISTINCT(tx_hash)) as total_tx, count(DISTINCT(origin_from_address)) as total_user, sum(volume) as usdc_volume,
avg(volume) as avg_volume, sum(total_tx) over (partition by event_name order by date asc) as cum_tx,
sum(usdc_volume) over (partition by event_name order by date asc) as cum_volume
from mint
group by 1,2
Run a query to Download Data