tokens as (

select

ft.value:SYMBOL as symbol,

ft.value:CONTRACT_ADDRESS as contract_address

from (

select

livequery.live.udf_api (

'https://flipsidecrypto.xyz/api/v1/queries/461a1e57-e206-4684-ac7e-e73b6213fdf9/data/latest'

):data as data

) lq,

table(flatten(input => lq.data)) ft

),

raw as (

select

block_timestamp,

tx_hash,

origin_from_address as swapper,

case platform

when 'balancer' then 'Balancer'

when 'curve' then 'Curve'

when 'fraxswap' then 'Fraxswap'

when 'gmx' then 'GMX'

when 'hashflow' then 'Hashflow'

when 'kyberswap-v1' then 'KyberSwap'

when 'kyberswap-v2' then 'KyberSwap'

when 'pangolin' then 'Pangolin'

when 'platypus' then 'Platypus'

when 'sushiswap' then 'Sushiswap'

when 'trader-joe-v1' then 'Trader Joe'

when 'trader-joe-v2' then 'Trader Joe'

when 'uniswap-v2' then 'Uniswap'

when 'uniswap-v3' then 'Uniswap'

when 'woofi' then 'WOOFi'