table0 AS (

SELECT

PARAMETERS[1]:value AS userAddress

, TX_HASH AS hash

FROM external.tokenflow_starknet.decoded_events

WHERE CHAIN_ID = 'mainnet'

AND NAME = 'Transfer'

AND PARAMETERS[0]:value = '0'

AND CONTRACT IN (

'0x041f9a1e9a4d924273f5a5c0c138d52d66d2e6a8bee17412c6b0f48fe059ae04' -- MYSWAP ETH/USDT

, '0x0611e8f4f3badf1737b9e8f0ca77dd2f6b46a1d33ce4eed951c6b18ac497d505' -- MYSWAP DAI/USDC

, '0x014e644c20bd5f9888033d2093c8ba3334caa0c7d15ed142962a9bebf36cc7e0' -- MYSWAP wstETH/ETH

, '0x02699b69786cb08b4c83c1c02e943eca3eba00234d80a564ebe00c40226ea70b' -- MYSWAP LORDS/ETH

, '0x025b392609604c75d62dde3d6ae98e124a31b49123b8366d7ce0066ccb94f696' --MYSWAP WBTC/USDC

, '0x022b05f9396d2c48183f6deaf138a57522bcc8b35b67dee919f76403d1783136' --MYSWAP ETH/USDC

, '0x07c662b10f409d7a0a69c8da79b397fd91187ca5f6230ed30effef2dceddc5b3' --MYSWAP DAI/ETH

, '0x01ea237607b7d9d2e9997aa373795929807552503683e35d8739f4dc46652de1' --MYSWAP USDC/USDT

)

AND TIMESTAMP BETWEEN '2023-08-05 15:59:00' AND '2023-08-07 16:01:00'

AND TX_HASH = '0x042a75676860af1f1588cef80c33f7eeefce11773dbf3872382cd83269d86a28'

, table1 AS (

SELECT

TIMESTAMP AS date

, TX_HASH AS hash

, CASE CONTRACT

WHEN '0x049d36570d4e46f48e99674bd3fcc84644ddd6b96f7c741b1562b82f9e004dc7' THEN 'ETH'

WHEN '0x053c91253bc9682c04929ca02ed00b3e423f6710d2ee7e0d5ebb06f3ecf368a8' THEN 'USDC'

WHEN '0x00da114221cb83fa859dbdb4c44beeaa0bb37c7537ad5ae66fe5e0efd20e6eb3' THEN 'DAI'

WHEN '0x068f5c6a61780768455de69077e07e89787839bf8166decfbf92b645209c0fb8' THEN 'USDT'

WHEN '0x03fe2b97c1fd336e750087d68b9b867997fd64a2661ff3ca5a7c771641e8e7ac' THEN 'WBTC'

WHEN '0x042b8f0484674ca266ac5d08e4ac6a3fe65bd3129795def2dca5c34ecc5f96d2' THEN 'wstETH'