with received as (

SELECT block_timestamp,

receiver 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%'

and amount > 0

),

sent as (

SELECT block_timestamp,

sender as SEI_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')

AND receiver ilike 'osmo%'

AND sender ilike 'sei%'

and amount > 0

,

token_price as (