with ibc_sei as (

SELECT

'IBC --> SEI' as type,

block_timestamp,

tx_id,

sender as user,

receiver as SEI_user,

CASE when currency = 'ibc/ED07A3391A112B175915CD8FAF43A2DA8E4790EDE12566649D0C2F97716B8518'

then 'OSMO' --uosmo

when currency = 'ibc/6CDD4663F2F09CD62285E2D45891FC149A3568E316CE3EBBE201A71A78A69388'

then 'ATOM' end as symbol ,--uatom

amount / 1e6 as value

FROM sei.core.fact_transfers

WHERE TRANSFER_TYPE like 'IBC_TRANSFER_IN'

AND (currency = 'ibc/6CDD4663F2F09CD62285E2D45891FC149A3568E316CE3EBBE201A71A78A69388'

OR currency = 'ibc/ED07A3391A112B175915CD8FAF43A2DA8E4790EDE12566649D0C2F97716B8518')

AND sender ilike 'osmo%'

AND receiver ilike 'sei%'

UNION

SELECT

'SEI --> IBC' as type,

block_timestamp,

tx_id,

sender as SEI_user,

receiver as user,

CASE when currency = 'ibc/ED07A3391A112B175915CD8FAF43A2DA8E4790EDE12566649D0C2F97716B8518'

then 'OSMO'

when currency = 'ibc/6CDD4663F2F09CD62285E2D45891FC149A3568E316CE3EBBE201A71A78A69388'

then 'ATOM' end as symbol ,

amount / 1e6 as value

FROM sei.core.fact_transfers

WHERE TRANSFER_TYPE like 'IBC_TRANSFER_OUT'

AND (currency = 'ibc/6CDD4663F2F09CD62285E2D45891FC149A3568E316CE3EBBE201A71A78A69388'

OR currency = 'ibc/ED07A3391A112B175915CD8FAF43A2DA8E4790EDE12566649D0C2F97716B8518')