t1 as (

select trunc(block_timestamp,'week') as date,

count(distinct tx_hash) as txs,

sum(txs) over (order by date) as cum_txs,

sum(amount) as volume,

avg(amount) as avg_volume,

avg(avg_volume) over (order by date ROWS BETWEEN 6 PRECEDING AND CURRENT ROW ) as avg_volume_ma_7hour,

sum(volume) over (order by date) as cum_volume

from avalanche.core.ez_token_transfers

where contract_address = lower('0xC891EB4cbdEFf6e073e859e987815Ed1505c2ACD')

and from_address='0x0000000000000000000000000000000000000000'

and block_timestamp >= '2023-05-25'

group by 1

),

t2 as (

select trunc(block_timestamp,'week') as date,

count(distinct tx_hash) as txs,

sum(txs) over (order by date) as cum_txs,

sum(amount) as volume,

avg(amount) as avg_volume,

avg(avg_volume) over (order by date ROWS BETWEEN 6 PRECEDING AND CURRENT ROW ) as avg_volume_ma_7hour,

sum(volume) over (order by date) as cum_volume

from avalanche.core.ez_token_transfers

where contract_address = lower('0xC891EB4cbdEFf6e073e859e987815Ed1505c2ACD')

and to_address='0x0000000000000000000000000000000000000000'

and block_timestamp >= '2023-05-25'

group by 1

)

select 'Mint' as type, * from t1 where date<trunc(current_date,'week')

union select 'Burn' as type, * from t2 where date<trunc(current_date,'week') order by 2 asc ,1