date_trunc('week',BLOCK_TIMESTAMP) as week,

'Ethereum' as chain,

case

when (SYMBOL_IN = 'USDC' or symbol_out = 'USDC') then 'USDC'

when (SYMBOL_IN = 'USDT' or symbol_out = 'USDT') then 'USDT'

when (SYMBOL_IN = 'DAI' or symbol_out = 'DAI') then 'DAI'

when (SYMBOL_IN = 'BUSD' or symbol_out = 'BUSD') then 'BUSD'

when (SYMBOL_IN = 'TUSD' or symbol_out = 'TUSD') then 'TUSD'

end as symbol ,

count(distinct tx_hash) as "Trades",

round(sum(AMOUNT_IN_USD),2) as "Total volume",

round(avg(AMOUNT_IN_USD),2) as "Avg volume"

from ethereum.defi.ez_dex_swaps

where

(SYMBOL_IN in ('USDC','USDT','DAI','BUSD','TUSD')

or SYMBOL_out in ('USDC','USDT','DAI','BUSD','TUSD'))

and block_timestamp between '2022-01-01' AND '2024-03-31'

and AMOUNT_IN_USD > 0 and AMOUNT_out_USD > 0

and 100*(abs(AMOUNT_IN_USD-AMOUNT_out_USD)/AMOUNT_out_USD) <= 10

group by 1,2,3

having symbol is not null

union all

select

date_trunc('week',BLOCK_TIMESTAMP) as week,

'Polygon' as chain,

case

when (SYMBOL_IN = 'USDC' or symbol_out = 'USDC') then 'USDC'

when (SYMBOL_IN = 'USDT' or symbol_out = 'USDT') then 'USDT'

when (SYMBOL_IN = 'DAI' or symbol_out = 'DAI') then 'DAI'