with avalanche as (with tab3 as (with tab1 as (select date_trunc('{{Time_Frame}}',block_timestamp) as date, to_address, sum(amount) as input_vol, COUNT(DISTINCT TX_HASH) AS input_tx

from avalanche.core.ez_token_transfers

where (contract_address=lower('0xB97EF9Ef8734C71904D8002F8b6Bc66Dd9c48a6E') OR

and block_timestamp::date>='{{Start_Date}}' and block_timestamp::date<='{{End_Date}}'

group by 1,2

order by 1),

tab2 as (select date_trunc('{{Time_Frame}}',block_timestamp) as date, from_address, sum(amount) as output_vol, COUNT(DISTINCT TX_HASH) AS output_tx

from avalanche.core.ez_token_transfers

where (contract_address=lower('0xB97EF9Ef8734C71904D8002F8b6Bc66Dd9c48a6E') OR

contract_address=lower('0xa7d7079b0fead91f3e65f86e8915cb59c1a4c664'))

and block_timestamp::date>='{{Start_Date}}' and block_timestamp::date<='{{End_Date}}'

group by 1,2

order by 1)

select tab1.date as date, tab1.to_address as address, input_tx, output_tx, case

when input_vol is null then 0 else input_vol end as input_volume, case

when output_vol is null then 0 else output_vol end as output_volume

from tab1 left join tab2 on tab1.to_address=tab2.from_address and tab1.date=tab2.date)

select date as "Date", count(distinct address) as "Active Holders", case

when input_volume>output_volume then 'Balance increase'

when input_volume<output_volume then 'Balance Decrease'

else 'Unchanged'

end as "Group", 'Avalanche' as "Chain"

from tab3

group by 1,3

order by 1),

arbitrum as (with tab3 as (with tab1 as (select date_trunc('{{Time_Frame}}',block_timestamp) as date, to_address, sum(amount) as input_vol, COUNT(DISTINCT TX_HASH) AS input_tx