select

block_timestamp,

tx_hash,

concat('0x',substring(data, 27, 40)) as address,

case concat('0x',substring(data, 91, 40))

when '0xff970a61a04b1ca14834a43f5de4533ebddb5cc8' then 'USDC'

when '0x82af49447d8a07e3bd95bd0d56f35241523fbab1' then 'WETH'

when '0x2f2a2543b76a4166549f7aab2e75bef0aefc5b0f' then 'WBTC'

when '0xda10009cbd5d07dd0cecc66161fc93d7c9000da1' then 'DAI'

when '0x17fc002b466eec40dae837fc4be5c67993ddbd6f' then 'FRAX'

when '0xf97f4df75117a78c1a5a0dbb814af92458539fb4' then 'LINK'

when '0xfd086bc7cd5c481dcc9c85ebe478a1c0b69fcbb9' then 'USDT'

when '0xfa7f8980b0f1e64a2062791cc3b0871572f1f7f0' then 'UNI'

when '0xfea7a6a0b346362bf88a9e4a88416b77a57d6c2a' then 'MIM'

end as token_in,

case concat('0x',substring(data, 155, 40))

when '0xff970a61a04b1ca14834a43f5de4533ebddb5cc8' then 'USDC'

when '0x82af49447d8a07e3bd95bd0d56f35241523fbab1' then 'WETH'

when '0x2f2a2543b76a4166549f7aab2e75bef0aefc5b0f' then 'WBTC'

when '0xda10009cbd5d07dd0cecc66161fc93d7c9000da1' then 'DAI'

when '0x17fc002b466eec40dae837fc4be5c67993ddbd6f' then 'FRAX'

when '0xf97f4df75117a78c1a5a0dbb814af92458539fb4' then 'LINK'

when '0xfd086bc7cd5c481dcc9c85ebe478a1c0b69fcbb9' then 'USDT'

when '0xfa7f8980b0f1e64a2062791cc3b0871572f1f7f0' then 'UNI'

when '0xfea7a6a0b346362bf88a9e4a88416b77a57d6c2a' then 'MIM'

end as token_out,

case

when concat('0x',substring(data, 91, 40)) in ('0xff970a61a04b1ca14834a43f5de4533ebddb5cc8', '0xfd086bc7cd5c481dcc9c85ebe478a1c0b69fcbb9')

then ethereum.public.udf_hex_to_int(substring(data, 3 + 3 * 64, 64))::float/1e6

when concat('0x',substring(data, 91, 40)) = '0x2f2a2543b76a4166549f7aab2e75bef0aefc5b0f'

then ethereum.public.udf_hex_to_int(substring(data, 3 + 3 * 64, 64))::float/1e8

else ethereum.public.udf_hex_to_int(substring(data, 3 + 3 * 64, 64))::float/1e18

end as token_in_amount,

case

when concat('0x',substring(data, 155, 40)) in ('0xff970a61a04b1ca14834a43f5de4533ebddb5cc8', '0xfd086bc7cd5c481dcc9c85ebe478a1c0b69fcbb9')