table1 AS (

SELECT

TIMESTAMP,

TX_HASH,

CONTRACT,

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'

WHEN '0x0124aeb495b947201f5fac96fd1138e326ad86195b98df6dec9009158a533b49' THEN 'LORDS'

WHEN '0x0319111a5037cbec2b3e638cc34a3474e2d2608299f3e62866e9cc683208c610' THEN 'rETH'

WHEN '0x070a76fd48ca0ef910631754d77dd822147fe98a569b826ec85e3c33fde586ac' THEN 'LUSD'

ELSE '31'

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

WHEN '0x042b8f0484674ca266ac5d08e4ac6a3fe65bd3129795def2dca5c34ecc5f96d2' THEN 18 --wstETH31DECIMALS

WHEN '0x0124aeb495b947201f5fac96fd1138e326ad86195b98df6dec9009158a533b49' THEN 18 --LORDS18DECIMALS

WHEN '0x0319111a5037cbec2b3e638cc34a3474e2d2608299f3e62866e9cc683208c610' THEN 18 --rETH18DECIMALS

WHEN '0x070a76fd48ca0ef910631754d77dd822147fe98a569b826ec85e3c33fde586ac' THEN 18 --LUSD18DECIMALS

ELSE '31'

END AS decimals,

CASE CONTRACT