select

when event_data:token0Key ilike '%FlowToken' then 'FLOW'

when event_data:token0Key ilike '%FiatToken' then 'USDC'

when event_data:token0Key ilike '%OzoneToken' then 'OZONE'

when event_data:token0Key ilike '%TeleportedTetherToken' then 'USDT'

when event_data:token0Key ilike '%ThulToken' then 'THUL'

when event_data:token0Key ilike '%StarVault' then 'stFLOVATAR'

when event_data:token0Key ilike '%BloctoToken' then 'BLT'

when event_data:token0Key ilike '%StarlyToken' then 'STARLY'

when event_data:token0Key ilike '%MyToken' then 'MY'

when event_data:token0Key ilike '%stFlowToken' then 'stFLOW'

when event_data:token0Key ilike '%sFlowToken' then 'sFLOW'

when event_data:token0Key ilike '%SdmToken' then 'SDM'

end as token0,

when event_data:token1Key ilike '%FlowToken' then 'FLOW'

when event_data:token1Key ilike '%FiatToken' then 'USDC'

when event_data:token1Key ilike '%OzoneToken' then 'OZONE'

when event_data:token1Key ilike '%TeleportedTetherToken' then 'USDT'

when event_data:token1Key ilike '%ThulToken' then 'THUL'

when event_data:token1Key ilike '%StarVault' then 'stFLOVATAR'

when event_data:token1Key ilike '%BloctoToken' then 'BLT'

when event_data:token1Key ilike '%StarlyToken' then 'STARLY'

when event_data:token1Key ilike '%MyToken' then 'MY'

when event_data:token1Key ilike '%stFlowToken' then 'stFLOW'

when event_data:token1Key ilike '%sFlowToken' then 'sFLOW'

when event_data:token1Key ilike '%SdmToken' then 'SDM'

end as token1,

event_data:numPairs::number as pool_id,

swap_contract as event_contract

from flow.core.fact_events

join flow.core.dim_swap_pool_labels