freemartianUser Bridge From EVMs to Aptos (Total)
    Updated 2024-06-14
    -- Optimism Aptos bridge: 0x86bb63148d17d445ed5398ef26aa05bf76dd5b59
    -- Arbitrum Aptos bridge: 0x1bacc2205312534375c8d1801c27d28370656cff
    -- Ethereum Aptos Bridge: 0x50002cdfe7ccb0c41f519c6eb0653158d11cd907
    -- Polygon Aptos Bridge: 0x488863d609f3a673875a914fbee7508a1de45ec6
    -- Avalanch Aptos Bridge: 0xa5972eee0c9b5bbb89a5b16d1d65f94c9ef25166
    -- BSC Aptos Bridge: 0x2762409baa1804d94d8c0bcff8400b78bf915d5b

    -- optimism,arbitrum,polygon,avalanch,BSC layerzero endpoint: 0x3c2269811836af69497e5f486a85d7316753cf62
    -- ethereum layerzero endpoint: 0x66a71dcef29a0ffbdbe3c6a460a3b5bc225cd675




    -- ===== Optimism =======
    with op_fee AS(
    SELECT
    -- block_timestamp,
    tx_hash,
    -- origin_from_address,
    amount AS fee_amount,
    amount_usd AS fee_amount_usd,
    'ETH' AS fee_symbol
    FROM optimism.core.ez_native_transfers
    WHERE from_address = '0x86bb63148d17d445ed5398ef26aa05bf76dd5b59'
    AND to_address = '0x3c2269811836af69497e5f486a85d7316753cf62'
    ORDER BY block_timestamp DESC
    ),

    op_bridge AS (
    SELECT
    block_timestamp,
    tx_hash,
    origin_from_address,
    symbol,
    amount,
    amount_usd
    QueryRunArchived: QueryRun has been archived