select date_trunc('day', block_timestamp) as day,
event_name,
count (distinct tx_hash) as trxs,
count (distinct origin_from_address) as wallets,
sum (event_inputs:value/1e6) as volume,
avg (event_inputs:value/1e6) as avg_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, 2