-- forked from Ethereum swaps count @ https://flipsidecrypto.xyz/edit/queries/446f6210-0d7e-441a-9600-7aebb78245ae

WITH t1 AS (

SELECT

date_trunc('week', BLOCK_TIMESTAMP) AS week,

TOKEN_IN AS token,

CASE

WHEN TOKEN_IN=lower('0xFd086bC7CD5C481DCC9C85ebE478A1C0b69FCbb9') THEN 'USDT'

WHEN TOKEN_IN=lower('0xaf88d065e77c8cC2239327C5EDb3A432268e5831') THEN 'USDC'

WHEN TOKEN_IN=lower('0xDA10009cBd5D07dd0CeCc66161FC93D7c9000da1') THEN 'DAI'

-- WHEN TOKEN_IN=lower('0xc5f0f7b66764F6ec8C8Dff7BA683102295E16409') THEN 'FDUSD'

WHEN TOKEN_IN=lower('0x4D15a3A2286D883AF0AA1B3f21367843FAc63E07') THEN 'TUSD'

END AS symbol,

tx_hash

FROM

arbitrum.defi.ez_dex_swaps

WHERE

LOWER(TOKEN_IN) IN (

lower('0xFd086bC7CD5C481DCC9C85ebE478A1C0b69FCbb9'),

lower('0xaf88d065e77c8cC2239327C5EDb3A432268e5831'),

lower('0xDA10009cBd5D07dd0CeCc66161FC93D7c9000da1'),

-- lower('0xc5f0f7b66764F6ec8C8Dff7BA683102295E16409'),

lower('0x4D15a3A2286D883AF0AA1B3f21367843FAc63E07')

)

),

t2 AS (

SELECT

date_trunc('week', BLOCK_TIMESTAMP) AS week,

TOKEN_out AS token,

CASE

WHEN LOWER(TOKEN_OUT) = LOWER('0xFd086bC7CD5C481DCC9C85ebE478A1C0b69FCbb9') THEN 'USDT'

WHEN LOWER(TOKEN_OUT) = LOWER('0xaf88d065e77c8cC2239327C5EDb3A432268e5831') THEN 'USDC'

WHEN LOWER(TOKEN_OUT) = LOWER('0xDA10009cBd5D07dd0CeCc66161FC93D7c9000da1') THEN 'DAI'

-- WHEN LOWER(TOKEN_OUT) = LOWER('0xc5f0f7b66764F6ec8C8Dff7BA683102295E16409') THEN 'FDUSD'

WHEN LOWER(TOKEN_OUT) = LOWER('0x4D15a3A2286D883AF0AA1B3f21367843FAc63E07') THEN 'TUSD'