DATE(BLOCK_TIMESTAMP) as DATE,

CASE

WHEN PLATFORM = 'fuzio' THEN 'Fuzio'

WHEN PLATFORM = 'astroport' THEN 'Astroport'

WHEN PLATFORM = 'seaswap' THEN 'SeaSwap'

END AS PLATFORMS,

TX_ID,

SWAPPER,

case

when CURRENCY_IN = 'usei' then 'SEI'

when CURRENCY_IN = 'sei1606hlfm6sxee9ha7myshcyelhqydjfaca6w37wljphkjpt53fzrqlw9y68' then 'SAY'

when CURRENCY_IN = 'sei123gd6c6je3nmtjuvesuwhxphtuxgtuu6gu5ck3h5zcn6qqzzmgaqe85df2' then 'SAILOR'

when CURRENCY_IN = 'sei16aa3whueaddmms3qw0apz7ylddg0vwtw2zugafmccdtrxrwyx0kqwxntat' then 'TURTLE'

when CURRENCY_IN = 'sei1ys77cs0qsqzx4dvtds0e077qc0sg4k7tg32lcmqemek8g0tpr57s5ckxd7' then 'MUSK'

when CURRENCY_IN = 'sei1y6t2swnwjewa07hxeuv3pvxd9x9vc8chtwtfz8awpyex0tuurp9qkdzq66' then 'sey'

when CURRENCY_IN = 'sei1smdzpfsy48kmkzmm4m9hsg4850czdvfncxyxp6d4h3j7qv3m4v0slzx8yy' then 'OIN'

when CURRENCY_IN = 'sei1nnrhfhegm072tlwwme4a0y50q80tnkjjqv2zh0pkrwrj45pqthpsrjmeqd' then 'SPEPE'

when CURRENCY_IN = 'sei1hujt4dydg2lt0yaw8qp6gs3e78fv0tsehp6temwfq28m356v6kmqt9lctc' then 'SDOGE'

when CURRENCY_IN = 'sei1ajwmaynzjuekhs2tyv7qvvsu8dnw5d5ug0suzvt3353rz0t5ltwsflty4r' then 'SEINU'

when CURRENCY_IN = 'sei108mlhpvgxgl8556lwvf3cxfcw647wch4ear25kxjmp642cn3cdys92splz' then 'SINK'

when CURRENCY_IN = 'sei132zrqrk2de8zmu64sy8j7g2hgsc9xse3jfc88py8ufpkla0pu9gsexgu09' then 'FLOAT'

when CURRENCY_IN = 'ibc/F082B65C88E4B6D5EF1DB243CDA1D331D002759E938A0F5CD3FFDC5D53B3E349' then 'axlUSDC'

when CURRENCY_IN = 'ibc/C4CFF46FD6DE35CA4CF4CE031E643C8FDC9BA4B99AE598E9B0ED98FE3A2319F9' then 'ATOM'

when CURRENCY_IN = 'ibc/ED07A3391A112B175915CD8FAF43A2DA8E4790EDE12566649D0C2F97716B8518' then 'OSMO'

when CURRENCY_IN = 'ibc/6CDD4663F2F09CD62285E2D45891FC149A3568E316CE3EBBE201A71A78A69388' then 'ATOM (Osmosis)'

when CURRENCY_IN = 'ibc/0EC78B75D318EA0AAB6160A12AEE8F3C7FEA3CFEAD001A3B103E11914709F4CE' then 'ASTRO'

when CURRENCY_IN = 'ibc/6F24240309E0D0F9E7E72B1650599371418441F09AB408268E92D46CBAD3B0C6' then 'DOT'

when CURRENCY_IN = 'factory/sei189adguawugk3e55zn63z8r9ll29xrjwca636ra7v7gxuzn98sxyqwzt47l/4tLQqCLaoKKfNFuPjA9o39YbKUwhR1F8N29Tz3hEbfP2' then 'WETH'

when CURRENCY_IN = 'factory/sei189adguawugk3e55zn63z8r9ll29xrjwca636ra7v7gxuzn98sxyqwzt47l/Hq4tuDzhRBnxw3tFA5n6M52NVMVcC19XggbyDiJKCD6H' then 'USDCet'

when CURRENCY_IN = 'factory/sei189adguawugk3e55zn63z8r9ll29xrjwca636ra7v7gxuzn98sxyqwzt47l/HktfLoADCk9mnjv7XJiN4YXK9ayE6xinLzt8wzcsR2rY' then 'USDTet'

when CURRENCY_IN = 'factory/sei189adguawugk3e55zn63z8r9ll29xrjwca636ra7v7gxuzn98sxyqwzt47l/7omXa4gryZ5NiBmLep7JsTtTtANCVKXwT9vbN91aS1br' then 'WBTC'

when CURRENCY_IN = 'factory/sei189adguawugk3e55zn63z8r9ll29xrjwca636ra7v7gxuzn98sxyqwzt47l/7edDfnf4mku8So3t4Do215GNHwASEwCWrdhM5GqD51xZ' then 'USDCar'

when CURRENCY_IN = 'factory/sei189adguawugk3e55zn63z8r9ll29xrjwca636ra7v7gxuzn98sxyqwzt47l/9hJDBDaxqQQhF5HhaPUykeLncBa38XQ5uoNxN3tPQu5r' then 'WETHar'

when CURRENCY_IN = 'factory/sei189adguawugk3e55zn63z8r9ll29xrjwca636ra7v7gxuzn98sxyqwzt47l/DUVFMY2neJdL8aE4d3stcpttDDm5aoyfGyVvm29iA9Yp' then 'USDCpo'

when CURRENCY_IN = 'factory/sei189adguawugk3e55zn63z8r9ll29xrjwca636ra7v7gxuzn98sxyqwzt47l/3VKKYtbQ9iq8f9CaZfgR6Cr3TUj6ypXPAn6kco6wjcAu' then 'USDCop'