select event_name,

date_trunc (day,block_timestamp) as date,

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,

sum(Users_Count) over (partition by event_name order by date) as cum_user,

sum (tx_count) over (partition by event_name order by date) as Cumulative_TX_Count,

sum (total_volume) over (partition by event_name order by date) as Cumulative_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