from avalanche.core.fact_event_logs

where (event_name = 'Mint' or event_name = 'Burn')

and block_timestamp >= '2022-06-20'),

base2 as (select date_trunc('day', block_timestamp) as day,

count(distinct(origin_from_address)) as mint_wallet,

sum(event_inputs:value/1e6) as mint_size,

avg(event_inputs:value/1e6) as avg_mint_size

from avalanche.core.fact_event_logs

where contract_address = '0xb97ef9ef8734c71904d8002f8b6bc66dd9c48a6e'

and event_name = 'Transfer'

and tx_hash in (select tx_hash from base where event_name = 'Mint')

group by 1),

base3 as (select date_trunc('day', block_timestamp) as day,

count(distinct(origin_from_address)) as burn_wallet,

sum(event_inputs:value/1e6) as burn_size,

avg(event_inputs:value/1e6) as avg_burn_size

from avalanche.core.fact_event_logs

where contract_address = '0xb97ef9ef8734c71904d8002f8b6bc66dd9c48a6e'

and event_name = 'Transfer'

and block_timestamp >= '2022-06-20'

and tx_hash in (select tx_hash from base where event_name = 'Burn')

group by 1)

select a.day,

mint_wallet,

mint_size,

avg_mint_size,

burn_wallet,

burn_size,

from base2 a

join base3 b

on a.day = b.day