select

date_trunc('month',block_timestamp) as date,

count(distinct tx_hash) as "Swap To USDC",

count(distinct sender) as "Trader To USDC",

sum(amount_out) as "Amount To USDC",

avg(amount_out) as "AVG Amount To USDC",

symbol_in as "From Token"

from avalanche.core.ez_dex_swaps

where date_trunc('month',block_timestamp) >= current_date - interval '{{Months}} month'

and symbol_out = 'USDC'

and token_out = '0xb97ef9ef8734c71904d8002f8b6bc66dd9c48a6e'

group by 1,6

),

swaps_from as (

select

date_trunc('month',block_timestamp) as days,

count(distinct tx_hash) as "Swap From USDC",

count(distinct sender) as "Trader From USDC",

sum(amount_in) as "Amount From USDC",

avg(amount_in) as "AVG Amount From USDC",

symbol_out as "To Token"

from avalanche.core.ez_dex_swaps

where date_trunc('month',block_timestamp) >= current_date - interval '{{Months}} month'

and symbol_in = 'USDC'

and token_in = '0xb97ef9ef8734c71904d8002f8b6bc66dd9c48a6e'

group by 1,6

select * from swaps_to

having "Amount To USDC" > 100000