select

block_timestamp,

tx_hash,

sender,

'inbound' as event_type,

event_address,

EVENT_RESOURCE,

event_data : amount_received_ld ::int as amount_raw,

event_data : guid as guid,

30325 as dst_eid,

event_data : src_eid as src_eid,

event_data : to_address as wallet_address

from movement.core.fact_events a

where 1 = 1

and event_module = 'oft_core'

and EVENT_RESOURCE = 'OftReceived'

and block_timestamp::date >= '2025-03-03'

and SUCCESS

union all

select

block_timestamp,

tx_hash,

sender,

'outbound' as event_type,

event_address,

EVENT_RESOURCE,

event_data : amount_sent_ld ::int as amount_raw,

event_data : guid as guid,

event_data : dst_eid as dst_eid,

30325 as src_eid,

event_data : from_address as wallet_address

from movement.core.fact_events

where 1 = 1

and event_module = 'oft_core'

and EVENT_RESOURCE = 'OftSent'