with

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 origin_from_address) as users,

sum(case when token_in = lower('0xb97ef9ef8734c71904d8002f8b6bc66dd9c48a6e') then amount_in else amount_out end) as volume,

avg(case when token_in = lower('0xb97ef9ef8734c71904d8002f8b6bc66dd9c48a6e') then amount_in else amount_out end) 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.defi.ez_dex_swaps

where (token_in = lower('0xb97ef9ef8734c71904d8002f8b6bc66dd9c48a6e') or token_out = lower('0xb97ef9ef8734c71904d8002f8b6bc66dd9c48a6e'))

and block_timestamp >= '2022-01-01'

group by 1

),

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 origin_from_address) as users,

sum(case when token_in = lower('0x7F5c764cBc14f9669B88837ca1490cCa17c31607') then amount_in else amount_out end) as volume,

avg(case when token_in = lower('0x7F5c764cBc14f9669B88837ca1490cCa17c31607') then amount_in else amount_out end) 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.defi.ez_dex_swaps

where (token_in = lower('0x7F5c764cBc14f9669B88837ca1490cCa17c31607') or token_out = lower('0x7F5c764cBc14f9669B88837ca1490cCa17c31607'))

and block_timestamp >= '2022-01-01'

group by 1

),

arb 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 origin_from_address) as users,

sum(raw_amount/1e6) as volume,