flipside

    ronin bridge ccip
    Sandeshronin bridge ccip
    Updated 2025-02-10
    with bridge_data as
    (
    select *, regexp_substr_all(SUBSTR(input,11),'.{64}') as segmented
    , utils.udf_hex_to_int(segmented[0]) as destination_chain_selector
    , concat('0x', substr(segmented[8],25,40)) as destination_address
    , concat('0x', substr(segmented[11],25,40)) as token_address
    , utils.udf_hex_to_int(segmented[12]) as token_amount
    , case when token_address='0x3902228d6a3d2dc44731fd9d45fee6a61c722d0b' then '0x514910771af9ca656af840dff83e8264ecf986ca'
    when token_address='0x9f28c9c2da4a833cbfaaacbf7eb62267334d7149' then '0xdbb7a34bf10169d6d2d0d02a6cbb436cf4381bfa'
    else token_address
    end as price_address
    from ronin.core.fact_traces
    where 1=1
    -- and tx_hash=lower('0x600ca84b1009c8f2b8c2d318613f3e511532dbcc000ea0e9f11e99f7ee713a8c')
    and to_address='0x46527571d5d1b68ee7eb60b18a32e6c60dceaf99'
    and block_timestamp >='2025-02-01'
    and type='CALL'
    and trace_address='ORIGIN'
    and trace_succeeded='TRUE'
    and tx_succeeded='TRUE'
    )
    select
    br.block_number
    , br.block_timestamp
    , br.origin_from_address
    , br.origin_to_address
    , br.origin_function_signature
    , br.tx_hash
    , br.trace_index as event_index
    , lower('0x46527571d5d1b68ee7eb60b18a32e6c60dceaf99') as bridge_address
    , 'bridge' as event_name
    , 'chainlink' as platform
    , br.from_address as sender
    , br.to_address as receiver
    , br.destination_address as destination_chain_receiver
    , case when br.destination_chain_selector='15971525489660198786' then 'base'
    Last run: about 1 month ago
    BLOCK_NUMBER
    BLOCK_TIMESTAMP
    ORIGIN_FROM_ADDRESS
    ORIGIN_TO_ADDRESS
    ORIGIN_FUNCTION_SIGNATURE
    TX_HASH
    EVENT_INDEX
    BRIDGE_ADDRESS
    EVENT_NAME
    PLATFORM
    SENDER
    RECEIVER
    DESTINATION_CHAIN_RECEIVER
    DESTINATION_CHAIN
    DESTINATION_CHAIN_ID
    TOKEN_ADDRESS
    TOKEN_SYMBOL
    AMOUNT_UNADJ
    AMOUNT
    AMOUNT_USD
    EZ_BRIDGE_ACTIVITY_ID
    INSERTED_TIMESTAMP
    MODIFIED_TIMESTAMP
    1
    		422529242025-02-03 19:22:02.0000x920c267ed50fd5e5e79d68130e39bceb2541a9940x46527571d5d1b68ee7eb60b18a32e6c60dceaf990x96f4e9f90xcba959b0c62943f26b265583ac7ef90c4bb144951e0027b276894e0cded014c500x46527571d5d1b68ee7eb60b18a32e6c60dceaf99bridgechainlink0x920c267ed50fd5e5e79d68130e39bceb2541a9940x46527571d5d1b68ee7eb60b18a32e6c60dceaf990x4cbe437aa7a83457221d657207d78199ec330954base159715254896601987860xf299c912186195d02111d22c3ab863650256e05fJAIHOZ8000000000000000000000008000001943.024402025-02-10 18:48:02.1792025-02-10 18:48:02.179
    2
    		422534132025-02-03 19:46:29.0000x920c267ed50fd5e5e79d68130e39bceb2541a9940x46527571d5d1b68ee7eb60b18a32e6c60dceaf990x96f4e9f90xcb13c28ec73c09edc57134180a5d0cc77d5b4197a67ddd2dd239a35b54a9445300x46527571d5d1b68ee7eb60b18a32e6c60dceaf99bridgechainlink0x920c267ed50fd5e5e79d68130e39bceb2541a9940x46527571d5d1b68ee7eb60b18a32e6c60dceaf990x4cbe437aa7a83457221d657207d78199ec330954base159715254896601987860xf299c912186195d02111d22c3ab863650256e05fJAIHOZ400000000000000000000000400000971.512412025-02-10 18:48:02.1792025-02-10 18:48:02.179
    3
    		422266152025-02-02 21:26:32.0000xde5700dc1df19fb63f85e85e9844e1853b91c91c0x46527571d5d1b68ee7eb60b18a32e6c60dceaf990x96f4e9f90x312d87972f920a39693a2fe513403582a877efb3a2b9f1bcf41f07e704a7674e00x46527571d5d1b68ee7eb60b18a32e6c60dceaf99bridgechainlink0xde5700dc1df19fb63f85e85e9844e1853b91c91c0x46527571d5d1b68ee7eb60b18a32e6c60dceaf990xde5700dc1df19fb63f85e85e9844e1853b91c91cethereum50092975507151572690x9f28c9c2da4a833cbfaaacbf7eb62267334d7149ZENT4300000000000000000000004300009080.2971242025-02-10 18:48:02.1792025-02-10 18:48:02.179
    4
    		423094702025-02-05 18:29:36.0000x7c5b15e5e361e7b91d2648256ac50bc561979f3c0x46527571d5d1b68ee7eb60b18a32e6c60dceaf990x96f4e9f90x488f08335a3bdf4630727253c7784e07d65eb01a1de2138fde1ce260d7f957e100x46527571d5d1b68ee7eb60b18a32e6c60dceaf99bridgechainlink0x7c5b15e5e361e7b91d2648256ac50bc561979f3c0x46527571d5d1b68ee7eb60b18a32e6c60dceaf990x7c5b15e5e361e7b91d2648256ac50bc561979f3cethereum50092975507151572690x9f28c9c2da4a833cbfaaacbf7eb62267334d7149ZENT88000000000000000000008800160.776528572025-02-10 18:48:02.1792025-02-10 18:48:02.179
    5
    		421778992025-02-01 04:50:08.0000xf5a5c5bc7620b8c4fe9545e4196c7eef1cd0c2b60x46527571d5d1b68ee7eb60b18a32e6c60dceaf990x96f4e9f90x4d07f2fac2ceeb1aa4befa934817596d4d0d54bbb8e77a16d3e0724be6406af600x46527571d5d1b68ee7eb60b18a32e6c60dceaf99bridgechainlink0xf5a5c5bc7620b8c4fe9545e4196c7eef1cd0c2b60x46527571d5d1b68ee7eb60b18a32e6c60dceaf990xf5a5c5bc7620b8c4fe9545e4196c7eef1cd0c2b6base159715254896601987860xf299c912186195d02111d22c3ab863650256e05fJAIHOZ42187676944619202757644218.76769446215.26611715512025-02-10 18:48:02.1792025-02-10 18:48:02.179
    6
    		421803892025-02-01 06:54:38.0000x35dded91fbe7f6fa095c80c4a1e096baf4e1d3240x46527571d5d1b68ee7eb60b18a32e6c60dceaf990x96f4e9f90xe12ce229816bee20d214d40069eea706f4338408814e60c1904cd056b42c9b3a00x46527571d5d1b68ee7eb60b18a32e6c60dceaf99bridgechainlink0x35dded91fbe7f6fa095c80c4a1e096baf4e1d3240x46527571d5d1b68ee7eb60b18a32e6c60dceaf990xf1447cdb00c864d04c58747e1c6ea1dca893eae2base159715254896601987860x3902228d6a3d2dc44731fd9d45fee6a61c722d0bLINK1200000000000000000.123.063622025-02-10 18:48:02.1792025-02-10 18:48:02.179
    7
    		421946092025-02-01 18:46:03.0000x572fab1b48b62849f1b0100cc5724d948e0df69c0x46527571d5d1b68ee7eb60b18a32e6c60dceaf990x96f4e9f90x9268b955fb91d4ba04d4482ad990de638d1f8aa94c47889adf14c94b264fa9c700x46527571d5d1b68ee7eb60b18a32e6c60dceaf99bridgechainlink0x572fab1b48b62849f1b0100cc5724d948e0df69c0x46527571d5d1b68ee7eb60b18a32e6c60dceaf990x572fab1b48b62849f1b0100cc5724d948e0df69cbase159715254896601987860x3902228d6a3d2dc44731fd9d45fee6a61c722d0bLINK2937316879555665680.2937316887.17292782102025-02-10 18:48:02.1792025-02-10 18:48:02.179
    8
    		423071772025-02-05 16:34:55.0000x7c5b15e5e361e7b91d2648256ac50bc561979f3c0x46527571d5d1b68ee7eb60b18a32e6c60dceaf990x96f4e9f90x184e79e10e40830346be01eead572bbc342cc8e6de01d0a3c8c6b0a0752528e300x46527571d5d1b68ee7eb60b18a32e6c60dceaf99bridgechainlink0x7c5b15e5e361e7b91d2648256ac50bc561979f3c0x46527571d5d1b68ee7eb60b18a32e6c60dceaf990x7c5b15e5e361e7b91d2648256ac50bc561979f3cethereum50092975507151572690x9f28c9c2da4a833cbfaaacbf7eb62267334d7149ZENT2300000000000000000000230042.256451562025-02-10 18:48:02.1792025-02-10 18:48:02.179
    9
    		423595852025-02-07 12:15:45.0000x468201e260fead6c7553529355f522d14f0e569e0x46527571d5d1b68ee7eb60b18a32e6c60dceaf990x96f4e9f90x600ca84b1009c8f2b8c2d318613f3e511532dbcc000ea0e9f11e99f7ee713a8c00x46527571d5d1b68ee7eb60b18a32e6c60dceaf99bridgechainlink0x468201e260fead6c7553529355f522d14f0e569e0x46527571d5d1b68ee7eb60b18a32e6c60dceaf990x2c3c48dcfa3875b5d181033a5fffe1584270462abase159715254896601987860xf299c912186195d02111d22c3ab863650256e05fJAIHOZ26072959161503817468062607.295916155.211723807782025-02-10 18:48:02.1792025-02-10 18:48:02.179
    10
    		423616832025-02-07 14:00:43.0000x9fe7b48b198c50884436adb555fb70f6cd37116a0x46527571d5d1b68ee7eb60b18a32e6c60dceaf990x96f4e9f90x9a0cce82a2196a019176c9e3b28e8154bf73c63f47805260a0942ba32744e95100x46527571d5d1b68ee7eb60b18a32e6c60dceaf99bridgechainlink0x9fe7b48b198c50884436adb555fb70f6cd37116a0x46527571d5d1b68ee7eb60b18a32e6c60dceaf990x9fe7b48b198c50884436adb555fb70f6cd37116abase159715254896601987860xf299c912186195d02111d22c3ab863650256e05fJAIHOZ200000000000000000000020003.96596792025-02-10 18:48:02.1792025-02-10 18:48:02.179
    11
    		422944352025-02-05 05:57:48.0000xd2b453d1f3cc21b68ba174011a783fec2f82a0780x46527571d5d1b68ee7eb60b18a32e6c60dceaf990x96f4e9f90x08afaec15540c74e116bb8d7866ef6105aba85142a285438d59a869e371d352800x46527571d5d1b68ee7eb60b18a32e6c60dceaf99bridgechainlink0xd2b453d1f3cc21b68ba174011a783fec2f82a0780x46527571d5d1b68ee7eb60b18a32e6c60dceaf990xd2b453d1f3cc21b68ba174011a783fec2f82a078base159715254896601987860xf299c912186195d02111d22c3ab863650256e05fJAIHOZ7119988820963963354507971199.88820964164.855509162532025-02-10 18:48:02.1792025-02-10 18:48:02.179
    12
    		422630602025-02-04 03:48:53.0000xa745ff4e25d2877804b9d16e91b4a06c9d5c4e100x46527571d5d1b68ee7eb60b18a32e6c60dceaf990x96f4e9f90x1ffedc83cc5461776c6efe45c8f62e699d92aaa96d29682941d1f2daadbea7b500x46527571d5d1b68ee7eb60b18a32e6c60dceaf99bridgechainlink0xa745ff4e25d2877804b9d16e91b4a06c9d5c4e100x46527571d5d1b68ee7eb60b18a32e6c60dceaf990xa745ff4e25d2877804b9d16e91b4a06c9d5c4e10base159715254896601987860xf299c912186195d02111d22c3ab863650256e05fJAIHOZ190267430907652459006190.2674309080.4771507606452025-02-10 18:48:02.1792025-02-10 18:48:02.179
    13
    		422726252025-02-04 11:47:12.0000xa369f85586800b79139141b556a60c289027a3160x46527571d5d1b68ee7eb60b18a32e6c60dceaf990x96f4e9f90x6be410275507a4c1558968304f6ab4a517402893da2558ab60bc6d11d92b1b9600x46527571d5d1b68ee7eb60b18a32e6c60dceaf99bridgechainlink0xa369f85586800b79139141b556a60c289027a3160x46527571d5d1b68ee7eb60b18a32e6c60dceaf990x4580d538a03531325e1c9cd772e5d0ea49cd3cdebase159715254896601987860xf299c912186195d02111d22c3ab863650256e05fJAIHOZ160005558090244689475951160005.558090245371.016087933462025-02-10 18:48:02.1792025-02-10 18:48:02.179
    14
    		421957322025-02-01 19:42:13.0000x6d30504a50e17a35570f3e44d9e9679d84564cd30x46527571d5d1b68ee7eb60b18a32e6c60dceaf990x96f4e9f90x8161199d02ea07dcd2cd113c62af1f5cd28505b0ec0c7848d0ee85ea148987c300x46527571d5d1b68ee7eb60b18a32e6c60dceaf99bridgechainlink0x6d30504a50e17a35570f3e44d9e9679d84564cd30x46527571d5d1b68ee7eb60b18a32e6c60dceaf990x6d30504a50e17a35570f3e44d9e9679d84564cd3base159715254896601987860xf299c912186195d02111d22c3ab863650256e05fJAIHOZ7793000000000000000000779322.38936693122025-02-10 18:48:02.1792025-02-10 18:48:02.179
    15
    		421975232025-02-01 21:11:47.0000x920c267ed50fd5e5e79d68130e39bceb2541a9940x46527571d5d1b68ee7eb60b18a32e6c60dceaf990x96f4e9f90x3ab1b5eadf595f305bb9f4383f45bb258736d4a07209e48b3793fb9cc9a0aa9900x46527571d5d1b68ee7eb60b18a32e6c60dceaf99bridgechainlink0x920c267ed50fd5e5e79d68130e39bceb2541a9940x46527571d5d1b68ee7eb60b18a32e6c60dceaf990x4cbe437aa7a83457221d657207d78199ec330954base159715254896601987860xf299c912186195d02111d22c3ab863650256e05fJAIHOZ159503000000000000000000159503443.15037496132025-02-10 18:48:02.1792025-02-10 18:48:02.179
    16
    		424299582025-02-09 22:54:52.0000x054b8a46f93c246e0e1892b1cf1838d1db573e660x46527571d5d1b68ee7eb60b18a32e6c60dceaf990x96f4e9f90xbbf7bdd7ed3b5b618ab11e3f92c113af290f9d28586c80ecb2a0b4469b8cd96500x46527571d5d1b68ee7eb60b18a32e6c60dceaf99bridgechainlink0x054b8a46f93c246e0e1892b1cf1838d1db573e660x46527571d5d1b68ee7eb60b18a32e6c60dceaf990xf5d8f53a36c4bbef078e352ef38cc06132320d3cbase159715254896601987860x3902228d6a3d2dc44731fd9d45fee6a61c722d0bLINK1873693005040385520.18736930053.481321603892025-02-10 18:48:02.1792025-02-10 18:48:02.179
    17
    		424357922025-02-10 03:46:36.0000x99ae854b8ca1d35498aa73738393236748d400840x46527571d5d1b68ee7eb60b18a32e6c60dceaf990x96f4e9f90xd6c82c89c925e2f124272013e6f620ea0fc1dcc20733dadda927dd4e913cc04100x46527571d5d1b68ee7eb60b18a32e6c60dceaf99bridgechainlink0x99ae854b8ca1d35498aa73738393236748d400840x46527571d5d1b68ee7eb60b18a32e6c60dceaf990x99ae854b8ca1d35498aa73738393236748d40084base159715254896601987860xf299c912186195d02111d22c3ab863650256e05fJAIHOZ100000000000000000000000100000197.496902025-02-10 18:48:02.1792025-02-10 18:48:02.179
    18
    		422759462025-02-04 14:33:16.0000x920c267ed50fd5e5e79d68130e39bceb2541a9940x46527571d5d1b68ee7eb60b18a32e6c60dceaf990x96f4e9f90x3ba29b02f9ed614cb161cd61d14bb293e6c538560ea3a1b2cf87a91c87b9ae4200x46527571d5d1b68ee7eb60b18a32e6c60dceaf99bridgechainlink0x920c267ed50fd5e5e79d68130e39bceb2541a9940x46527571d5d1b68ee7eb60b18a32e6c60dceaf990x4cbe437aa7a83457221d657207d78199ec330954base159715254896601987860xf299c912186195d02111d22c3ab863650256e05fJAIHOZ160000000000000000000000160000399.8512492025-02-10 18:48:02.1792025-02-10 18:48:02.179
    19
    		422058642025-02-02 04:08:51.0000x24763fa8f7adf94965c0ecfe16769ce388f950160x46527571d5d1b68ee7eb60b18a32e6c60dceaf990x96f4e9f90xc8b86afadff04976a162ea6d70a45128a96f29985418f5424e63ea8e49c8dfdd00x46527571d5d1b68ee7eb60b18a32e6c60dceaf99bridgechainlink0x24763fa8f7adf94965c0ecfe16769ce388f950160x46527571d5d1b68ee7eb60b18a32e6c60dceaf990xe0b0b9eba23eb41a33583a4011c9cf6632a5b4b2base159715254896601987860x3902228d6a3d2dc44731fd9d45fee6a61c722d0bLINK41410076280585218314.14100762893.835232852162025-02-10 18:48:02.1792025-02-10 18:48:02.179
    20
    		422153522025-02-02 12:03:20.0000x838a8e76b939daca5b1bfcf39ef637192c9e624d0x46527571d5d1b68ee7eb60b18a32e6c60dceaf990x96f4e9f90x3d008734aace7ccb2b23005b8c260c8e8f2c0d91ab249a3eab24db013bcb76c900x46527571d5d1b68ee7eb60b18a32e6c60dceaf99bridgechainlink0x838a8e76b939daca5b1bfcf39ef637192c9e624d0x46527571d5d1b68ee7eb60b18a32e6c60dceaf990x838a8e76b939daca5b1bfcf39ef637192c9e624dbase159715254896601987860xf299c912186195d02111d22c3ab863650256e05fJAIHOZ61939867447169801311416193.98674471715.682616979172025-02-10 18:48:02.1792025-02-10 18:48:02.179
    92
    54KB
    6s