trader,

from_amount,

case when from_currency = 'uosmo' then 'OSMO' else from_currency end as from_currency,

case when to_currency = 'ibc/27394FB092D2ECCD56123C74F36E4C1F926001CEADA9CA97EA622B25F41E5EB2' THEN 'ATOM'

when to_currency = 'ibc/D189335C6E4A68B513C10AB227BF1C1D38C746766278BA3EEB4FB14124F1D858' then 'USDC'

when to_currency = 'ibc/BE1BB42D4BE3C30D50B68D7C41DB4DFCE9678E8EF8C539F6E6A9345048894FCC' then 'USTC'

when to_currency = 'ibc/46B44899322F3CD854D2D46DEEF881958467CDD4B3B10086DA49296BBED94BED' then 'JUNO'

when to_currency = 'ibc/D1542AA8762DB13087D8364F3EA6509FD6F009A34F00426AF9E4F9FA85CBBF1F' then 'WBTC'

when to_currency = 'ibc/6AE98883D4D5D5FF9E50D7130F1305DA2FFA0C652D1DD9C123657C6B4EB2DF8A' then 'EVMOS'

when to_currency = 'ibc/EA1D43981D5C9A1C4AAEA9C23BB1D4FA126BA9BC7020A25E0AE4AA841EA25DC5' then 'WETH'

else to_currency end as to_currency,

to_amount from osmosis.core.fact_swaps

where block_timestamp >= '2022-06-01' and

from_currency = 'uosmo'

and to_currency != 'uosmo'

order by 3 desc

limit 100