date_trunc ('day', block_timestamp) as date,

event_name as Status,

count(distinct tx_hash) as "# TXs",

count(distinct origin_from_address) as "# Users",

sum(event_inputs:value/pow(10,6)) as Volume,

avg(event_inputs:value/pow(10,6)) as "Avg Volume"

from avalanche.core.fact_event_logs

where 1=1

block_timestamp >= '2022-07-01'

and

EVENT_NAME in ('Burn', 'Mint')

and

TX_STATUS = 'SUCCESS'

and

contract_address = '0xb97ef9ef8734c71904d8002f8b6bc66dd9c48a6e'

group by 1,2