avax as (

select

trunc (block_timestamp,'month') as date,

count (distinct tx_hash) as txs,

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

count(distinct decoded_log:to) as users,

sum(decoded_log:value/1e6) as volume,

avg(decoded_log:value/1e6) as avg_volume,

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

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

from avalanche.core.fact_decoded_event_logs

where event_name='Mint' and contract_address = '0xb97ef9ef8734c71904d8002f8b6bc66dd9c48a6e'

and block_timestamp >= '2022-01-01'

group by 1 order by 1 asc

),

opt as (

select

trunc (block_timestamp,'month') as date,

count (distinct tx_hash) as txs,

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

count(distinct to_address) as users,

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_7day,

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

from optimism.core.ez_token_transfers

where from_address = '0x0000000000000000000000000000000000000000'

and contract_address = lower('0x7F5c764cBc14f9669B88837ca1490cCa17c31607')

and block_timestamp >= '2022-01-01'

group by 1 order by 1 asc

),

arb as (

select

trunc (block_timestamp,'month') as date,