flipside

    ronin-bridge copy
    Sandeshronin-bridge copy
    Updated 2025-03-25
    -- forked from ronin-bridge @ https://flipsidecrypto.xyz/studio/queries/0dc8df79-d431-4d2f-ae88-5b024b0b9f92

    WITH chain_ids AS (
    SELECT *
    FROM (
    VALUES
    (1, 'ethereum', 'Ethereum Mainnet'),
    (10, 'optimism', 'Optimism'),
    (137, 'polygon', 'Polygon'),
    (42161, 'arbitrum', 'Arbitrum One'),
    (43114, 'avalanche', 'Avalanche C-Chain'),
    (56, 'bsc', 'BNB Smart Chain'),
    (8453, 'base', 'Base'),
    (2020, 'ronin', 'Ronin'),
    (5, 'ethereum', 'Goerli Testnet'),
    (11155111, 'ethereum', 'Sepolia Testnet'),
    (80001, 'polygon', 'Mumbai Testnet'),
    (421613, 'arbitrum', 'Arbitrum Goerli'),
    (97, 'bsc', 'BSC Testnet'),
    (43113, 'avalanche', 'Avalanche Fuji Testnet'),
    (84531, 'base', 'Base Goerli')
    ) AS v (chain_id, blockchain, network_name)
    ),
    eth_to_ronin_native as (
    select
    'ronin'::VARCHAR as blockchain
    ,'axie infinity: ronin bridge v2'::VARCHAR as platfrom
    , edl.block_number::INT as block_number
    , edl.block_timestamp::TIMESTAMP as block_timestamp
    , edl.tx_hash::VARCHAR as tx_hash, decoded_log
    -- , edl.decoded_log['recepit']['mainchain']['chainId']
    , case when edl.decoded_log['receipt']['mainchain']['chainId'] =1 then 'ethereum'
    else edl.decoded_log['receipt']['mainchain']
    end as source_chain
    , 'ronin'::VARCHAR as destination_chain
    , edl.contract_address::VARCHAR as bridge_address
    Last run: 22 days ago
    BLOCKCHAIN
    PLATFORM
    BLOCK_NUMBER
    BLOCK_TIMESTAMP
    TX_HASH
    SOURCE_CHAIN
    DESTINATION_CHAIN
    BRIDGE_ADDRESS
    SOURCE_ADDRESS
    DESTINATION_ADDRESS
    DIRECTION
    TOKEN_ADDRESS
    TOKEN_SYMBOL
    AMOUNT_RAW
    AMOUNT
    AMOUNT_USD
    INSERTED_TIMESTAMP
    MODIFIED_TIMESTAMP
    1
    		ethereumchainlink216880952025-01-23 15:29:47.0000xfb7bbb7510d3f2052d31b7347115bd675ef2190a9d6eaf73d0319cae4d974935ethereumronin0x80226fc0ee2b096224eeac085bb9a8cba1146f7d0x6b2c9d575165a56c6d27c72bdd1d0019fc64c3520x6b2c9d575165a56c6d27c72bdd1d0019fc64c352outbound0xdbb7a34bf10169d6d2d0d02a6cbb436cf4381bfaZENT2.0333193522689e+23203331.935226895472.7075031032025-03-25 11:42:51.9432025-03-25 11:42:51.943
    2
    		ethereumchainlink216872542025-01-23 12:40:59.0000x639df319f0b287f9ef8f29ca3f03f94bb1192189088a82e7d85d26438d383c4cethereumronin0x80226fc0ee2b096224eeac085bb9a8cba1146f7d0x1aafacc008099845d6c35df8c5925c8e659c44000x1aafacc008099845d6c35df8c5925c8e659c4400outbound0xdbb7a34bf10169d6d2d0d02a6cbb436cf4381bfaZENT1.1200286378156e+23112002.863781562909.2161452372025-03-25 11:42:51.9432025-03-25 11:42:51.943
    3
    		ethereumchainlink219981592025-03-07 23:03:59.0000x56bb32621caa8eab596ecf84d9488470e0620c88d4534b5f2ea0abeb7452f4e2ethereumronin0x80226fc0ee2b096224eeac085bb9a8cba1146f7d0x38534292ae0d2acbda022505fc7fd475af6af7a00x38534292ae0d2acbda022505fc7fd475af6af7a0outbound0xdbb7a34bf10169d6d2d0d02a6cbb436cf4381bfaZENT1.5e+2215000195.799952025-03-25 11:42:51.9432025-03-25 11:42:51.943
    4
    		ethereumchainlink215709642025-01-07 07:00:47.0000x2cb2d8588a9f53c80edf2b0a122d65054ca3ae26b61ae76a2fac1e97b3323e2bethereumronin0x80226fc0ee2b096224eeac085bb9a8cba1146f7d0xfa366026a8def1a6dcf752ba52b3d197c26e36e00xfa366026a8def1a6dcf752ba52b3d197c26e36e0outbound0xdbb7a34bf10169d6d2d0d02a6cbb436cf4381bfaZENT1000000001e-103.763423e-122025-03-25 11:42:51.9432025-03-25 11:42:51.943
    5
    		ethereumchainlink218856902025-02-20 06:09:23.0000x846db3d355a320dcd639c1a127f964fd9efb1e6b9b5fdaa8f9d4ba63ac7ffa75ethereumronin0x80226fc0ee2b096224eeac085bb9a8cba1146f7d0x7fb6486837e04e0a8d6e794a2344f32d14bef07a0x89a30a52a13ef116c55dd4676a5e8d7394199fdeoutbound0xdbde08d475bd50e2d1a6af34c7b10dd430d8396eCGX950122971402248000000950.12297140219.555297982025-03-25 11:42:51.9432025-03-25 11:42:51.943
    6
    		ethereumchainlink218852832025-02-20 04:47:35.0000xaa1965a43d59c5105c8afe2e010794070952d0e8f2ddb036ebf331e8eb32e763ethereumronin0x80226fc0ee2b096224eeac085bb9a8cba1146f7d0xc055492f9fa0585c4194eefd58986112d643720b0xc055492f9fa0585c4194eefd58986112d643720boutbound0xdbb7a34bf10169d6d2d0d02a6cbb436cf4381bfaZENT6.970132e+2269701.321130.1058368862025-03-25 11:42:51.9432025-03-25 11:42:51.943
    7
    		ethereumchainlink218689402025-02-17 21:59:59.0000x46c718bf63aa10020a42999c5eb93e81c8f04b02027fee617ff3dd23a9c7a36cethereumronin0x80226fc0ee2b096224eeac085bb9a8cba1146f7d0x0d33f5b46c442c48854b23c8a719f940c3b2bedb0x0d33f5b46c442c48854b23c8a719f940c3b2bedboutbound0xdbde08d475bd50e2d1a6af34c7b10dd430d8396e1.25e+242025-03-25 11:42:51.9432025-03-25 11:42:51.943
    8
    		ethereumchainlink218424062025-02-14 04:45:35.0000xb613fae405a7f5804cfbe6c023af23f71d9b3990d272d9b298ac023df493981bethereumronin0x80226fc0ee2b096224eeac085bb9a8cba1146f7d0xc055492f9fa0585c4194eefd58986112d643720b0xc055492f9fa0585c4194eefd58986112d643720boutbound0xdbb7a34bf10169d6d2d0d02a6cbb436cf4381bfaZENT6.97119631795e+2269711.96317951247.2146418862025-03-25 11:42:51.9432025-03-25 11:42:51.943
    9
    		ethereumchainlink218472432025-02-14 21:01:59.0000xf6295b97cc1837b34993393114e730fd53b3375dcd4d74ec581751bd54133a79ethereumronin0x80226fc0ee2b096224eeac085bb9a8cba1146f7d0xc055492f9fa0585c4194eefd58986112d643720b0xc055492f9fa0585c4194eefd58986112d643720boutbound0x514910771af9ca656af840dff83e8264ecf986caLINK3002192664156330000030.021926642583.6262539122025-03-25 11:42:51.9432025-03-25 11:42:51.943
    10
    		ethereumchainlink218473102025-02-14 21:15:23.0000x9cc784faec72acb826feb3bb8efdfe9dbee68d4d4f82170a2689c98c11dcea40ethereumronin0x80226fc0ee2b096224eeac085bb9a8cba1146f7d0xc055492f9fa0585c4194eefd58986112d643720b0xc055492f9fa0585c4194eefd58986112d643720boutbound0x514910771af9ca656af840dff83e8264ecf986caLINK7143919708682050000071.4391970871388.7779913682025-03-25 11:42:51.9432025-03-25 11:42:51.943
    11
    		ethereumchainlink219305692025-02-26 12:40:59.0000x847b1c05961d2a613f2e54bef7cdb5aa3709b2e144bc4ccf08559da5d3ab099fethereumronin0x80226fc0ee2b096224eeac085bb9a8cba1146f7d0x9de6de21007312eeb6cd90500ffecafec297b70d0x9de6de21007312eeb6cd90500ffecafec297b70doutbound0x996d67aa9b37df96428ad3608cb21352bf1fdb901e+222025-03-25 11:42:51.9432025-03-25 11:42:51.943
    12
    		ethereumchainlink215806762025-01-08 15:32:47.0000xc8203e77fd879f8e22d749c911b616f21aae180069420ce83b15e5fdc134e0d2ethereumronin0x80226fc0ee2b096224eeac085bb9a8cba1146f7d0xc254a645fd1b8e25f18f4728a3620fc0aaefb30c0x45dfcaa8cb80b6399ee56d77c60733f7a65984d6outbound0xdbb7a34bf10169d6d2d0d02a6cbb436cf4381bfaZENT1.2739200237e+23127392.002374192.7790866422025-03-25 11:42:51.9432025-03-25 11:42:51.943
    13
    		ethereumchainlink215805462025-01-08 15:06:47.0000x91129fa56e7f5ff83a6b2550bb2e2e5d5220eb3a7005e63354a1e2472e9a8c35ethereumronin0x80226fc0ee2b096224eeac085bb9a8cba1146f7d0x9839fbc1562d83e54025b40f1a9b8d54228e83ce0x3d494371a362292ad133b7f894d787c73b05a685outbound0xdbb7a34bf10169d6d2d0d02a6cbb436cf4381bfaZENT5.40693027299972e+215406.930273177.9551600562025-03-25 11:42:51.9432025-03-25 11:42:51.943
    14
    		ethereumchainlink215805222025-01-08 15:01:59.0000xb46211c6699e52ed8e7fbf85c3b4f103653afccbb8d756f731357d1d6d915b49ethereumronin0x80226fc0ee2b096224eeac085bb9a8cba1146f7d0x516a7292fe0a067c12627e550ee936fa8665f7ac0x516a7292fe0a067c12627e550ee936fa8665f7acoutbound0xdbb7a34bf10169d6d2d0d02a6cbb436cf4381bfaZENT2.96612404197937e+2229661.240419794976.2232024172025-03-25 11:42:51.9432025-03-25 11:42:51.943
    15
    		ethereumchainlink215804802025-01-08 14:53:35.0000x99d83c763a2903e9763366db3d9fb88a447d16b97134bec058e9d20bbec4eeb8ethereumronin0x80226fc0ee2b096224eeac085bb9a8cba1146f7d0xc254a645fd1b8e25f18f4728a3620fc0aaefb30c0x45dfcaa8cb80b6399ee56d77c60733f7a65984d6outbound0xdbb7a34bf10169d6d2d0d02a6cbb436cf4381bfaZENT1.1820513843e+23118205.138433953.6285419932025-03-25 11:42:51.9432025-03-25 11:42:51.943
    16
    		ethereumchainlink215803082025-01-08 14:19:11.0000x1c181dbccd2f8d26aeedc0f375607bad7aaaf04ceaf562ec9651aaf494085f5bethereumronin0x80226fc0ee2b096224eeac085bb9a8cba1146f7d0xc254a645fd1b8e25f18f4728a3620fc0aaefb30c0x45dfcaa8cb80b6399ee56d77c60733f7a65984d6outbound0xdbb7a34bf10169d6d2d0d02a6cbb436cf4381bfaZENT1.0840691646e+23108406.916463625.9056480832025-03-25 11:42:51.9432025-03-25 11:42:51.943
    17
    		ethereumchainlink220321032025-03-12 16:53:11.0000x2bcda8c1cacdf9b192b3a121156c2663b368e10808772b1ef8e4ddf8635e344fethereumronin0x80226fc0ee2b096224eeac085bb9a8cba1146f7d0xd7c051b9940a81566b9b940d7b7daf8455a3997b0x0edaaf7bfe39e6569657534244ae1ce683a74628outbound0x996d67aa9b37df96428ad3608cb21352bf1fdb905000000000000000000002025-03-25 11:42:51.9432025-03-25 11:42:51.943
    18
    		ethereumchainlink216269922025-01-15 02:46:35.0000x7b61fdbc3d6f51560dd5b616024f007f836ee0f4d5b5528880c59fe07cb78655ethereumronin0x80226fc0ee2b096224eeac085bb9a8cba1146f7d0x0ffce4de18ee383d24629d701858dacf5294aee10x5b714f5ce0a09ab2fec8362dc1c254c7b7d6e6bdoutbound0x514910771af9ca656af840dff83e8264ecf986caLINK1025303714482840000010.253037145208.2391844112025-03-25 11:42:51.9432025-03-25 11:42:51.943
    19
    		ethereumchainlink216279492025-01-15 05:58:47.0000x0fc91fc9d6e4e3b10b930af8526f5f5d13087cfa75cf7a95625dc7fb9a4f8248ethereumronin0x80226fc0ee2b096224eeac085bb9a8cba1146f7d0x5d002ac59c7e6462ca655f36bfc3fcd83a63e81c0x5d002ac59c7e6462ca655f36bfc3fcd83a63e81coutbound0xdbb7a34bf10169d6d2d0d02a6cbb436cf4381bfaZENT2.148724122e+2221487.24122694.2757551662025-03-25 11:42:51.9432025-03-25 11:42:51.943
    20
    		ethereumchainlink216018292025-01-11 14:26:23.0000xaffb2a2123ed6d53d92f8c4851ecfa2160dc1f6e08da30963815de80cb52612dethereumronin0x80226fc0ee2b096224eeac085bb9a8cba1146f7d0x5d6eea3118ed0beab2fd754343d1ee368cbec4500x5d6eea3118ed0beab2fd754343d1ee368cbec450outbound0xdbb7a34bf10169d6d2d0d02a6cbb436cf4381bfaZENT3.312e+213312102.83329442025-03-25 11:42:51.9432025-03-25 11:42:51.943
    ...
    148
    63KB
    109s