BlockTrackerinbound bridge [ based of tokens ]
    Updated 5 days ago
    with Lz_bridge_data as (
    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'
    Last run: 5 days ago
    SYMBOL
    BRIDGE_VOLUME
    1
    WBTC.e
    551114.01400195
    2
    MOVE
    589804.04545754
    3
    WETH.e
    796954.145375177
    4
    USDC.e
    1043503.575214
    5
    USDT.e
    2155345.230297
    5
    133B
    5s