table0 AS (

SELECT

PARAMETERS[0]:value AS senderAddress

, TIMESTAMP AS time

, TX_HASH AS hash

, CONTRACT AS tokenAddress

, PARAMETERS[2]:value[0]:value AS rawAmount

, CASE CONTRACT

WHEN '0x049d36570d4e46f48e99674bd3fcc84644ddd6b96f7c741b1562b82f9e004dc7' THEN 'ETH'

WHEN '0x053c91253bc9682c04929ca02ed00b3e423f6710d2ee7e0d5ebb06f3ecf368a8' THEN 'USDC'

WHEN '0x00da114221cb83fa859dbdb4c44beeaa0bb37c7537ad5ae66fe5e0efd20e6eb3' THEN 'DAI'

WHEN '0x068f5c6a61780768455de69077e07e89787839bf8166decfbf92b645209c0fb8' THEN 'USDT'

WHEN '0x03fe2b97c1fd336e750087d68b9b867997fd64a2661ff3ca5a7c771641e8e7ac' THEN 'WBTC'

ELSE 'CHECK'

END AS TOKEN_NAME

, CASE CONTRACT

WHEN '0x049d36570d4e46f48e99674bd3fcc84644ddd6b96f7c741b1562b82f9e004dc7' THEN 18 --WETH18DECIMALS

WHEN '0x053c91253bc9682c04929ca02ed00b3e423f6710d2ee7e0d5ebb06f3ecf368a8' THEN 6 --USDC6DECIMALS

WHEN '0x00da114221cb83fa859dbdb4c44beeaa0bb37c7537ad5ae66fe5e0efd20e6eb3' THEN 18 --DAI18DECIMALS

WHEN '0x068f5c6a61780768455de69077e07e89787839bf8166decfbf92b645209c0fb8' THEN 6 --USDT6DECIMALS

WHEN '0x03fe2b97c1fd336e750087d68b9b867997fd64a2661ff3ca5a7c771641e8e7ac' THEN 8 --WBTC8DECIMALS

ELSE 31

END AS decimals

, CASE CONTRACT

WHEN '0x049d36570d4e46f48e99674bd3fcc84644ddd6b96f7c741b1562b82f9e004dc7' THEN '0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2' --WETH18DECIMALS

WHEN '0x053c91253bc9682c04929ca02ed00b3e423f6710d2ee7e0d5ebb06f3ecf368a8' THEN '0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48' --USDC6DECIMALS

WHEN '0x00da114221cb83fa859dbdb4c44beeaa0bb37c7537ad5ae66fe5e0efd20e6eb3' THEN '0x6b175474e89094c44da98b954eedeac495271d0f' --DAI18DECIMALS

WHEN '0x068f5c6a61780768455de69077e07e89787839bf8166decfbf92b645209c0fb8' THEN '0xdac17f958d2ee523a2206206994597c13d831ec7' --USDT6DECIMALS

WHEN '0x03fe2b97c1fd336e750087d68b9b867997fd64a2661ff3ca5a7c771641e8e7ac' THEN '0x2260fac5e5542a773aa44fbcfedf7c193bc2c599' --WBTC8DECIMALS

ELSE 'CHECK'

END AS addressonL1

FROM external.tokenflow_starknet.decoded_events

WHERE NAME = 'Transfer'