select SYMBOL_IN

,sum(AMOUNT_IN) as "Volume To EUROC"

,count(distinct ORIGIN_FROM_ADDRESS) as "EUROC BUYERS"

,count(distinct TX_HASH) as "EUROC Buy Count"

from avalanche.core.ez_dex_swaps

where TOKEN_OUT=lower('0xC891EB4cbdEFf6e073e859e987815Ed1505c2ACD')

and BLOCK_TIMESTAMP>'2023-05-24'

and SYMBOL_IN='WAVAX'

group by 1

),

tab2 as (

select SYMBOL_OUT

,sum(AMOUNT_OUT) as "Volume From EUROC"

,count(distinct ORIGIN_FROM_ADDRESS) as "EUROC SELLRS"

,count(distinct TX_HASH) as "EUROC Sell Count"

from avalanche.core.ez_dex_swaps

where TOKEN_IN=lower('0xC891EB4cbdEFf6e073e859e987815Ed1505c2ACD')

and BLOCK_TIMESTAMP>'2023-05-24'

and SYMBOL_OUT='WAVAX'

group by 1

),

tab3 as (

select SYMBOL_IN

,sum(AMOUNT_IN) as "Volume To EUROC"

,count(distinct ORIGIN_FROM_ADDRESS) as "EUROC BUYERS"

,count(distinct TX_HASH) as "EUROC Buy Count"

from avalanche.core.ez_dex_swaps

where TOKEN_OUT=lower('0xC891EB4cbdEFf6e073e859e987815Ed1505c2ACD')

and BLOCK_TIMESTAMP>'2023-05-24'

and SYMBOL_IN='USDC'

group by 1

),

tab4 as (

select SYMBOL_OUT

,sum(AMOUNT_OUT) as "Volume From EUROC"