flipside

    base ronin bridge ccip
    Sandeshbase ronin bridge ccip
    Updated 2025-02-10
    with bridges as
    (
    select *,
    regexp_substr_all(SUBSTR(input,11),'.{64}') as segmented
    , utils.udf_hex_to_int(segmented[0]) as destination_chain
    , segmented[8] as destination_address
    , segmented[11] as token_address
    , TRY_CAST(utils.udf_hex_to_int(segmented[12]) AS DOUBLE) as token_amount
    , case when concat('0x',substr(token_address,25,64))='0x88fb150bdc53a65fe94dea0c9ba0a6daf8c6e196' then '0x514910771af9ca656af840dff83e8264ecf986ca'
    else concat('0x',substr(token_address,25,64))
    end as price_address

    from base.core.fact_traces
    where 1=1
    -- and tx_hash=lower('0x585d52e419ce876885df28c3beb44adf3609172a8508b661d9dcd5203d25631d')
    and to_address='0x881e3a65b4d4a04dd529061dd0071cf975f58bcd'
    and block_timestamp > '2025-02-06'
    and type='CALL'
    and trace_address='ORIGIN'
    and tx_status='SUCCESS'
    and trace_status='SUCCESS'
    )
    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('0x881e3A65B4d4a04dD529061dd0071cf975F58bCD') as bridge_address
    , 'bridge' as event_name
    , 'chainlink' as platform
    , br.from_address as sender
    , br.to_address as receiver
    , concat('0x',substr(br.destination_address,25,64)) as destination_chain_receiver
    Last run: about 2 months 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
    		260305102025-02-06 13:59:27.0000x4cbe437aa7a83457221d657207d78199ec3309540x881e3a65b4d4a04dd529061dd0071cf975f58bcd0x96f4e9f90x4b33e484ff3c6789c60a4f29c068e3f3065f91d7f2b8d12ebee5b35337ef3aac00x881e3a65b4d4a04dd529061dd0071cf975f58bcdbridgechainlink0x4cbe437aa7a83457221d657207d78199ec3309540x881e3a65b4d4a04dd529061dd0071cf975f58bcd0x920c267ed50fd5e5e79d68130e39bceb2541a994ronin20200xe2816b27a5613b0aaf5d6dafa80584156e2fb1b6JAIHOZ2.4e+23240000485.4456132025-02-10 18:54:23.6902025-02-10 18:54:23.690
    2
    		260281052025-02-06 12:39:17.0000x4cbe437aa7a83457221d657207d78199ec3309540x881e3a65b4d4a04dd529061dd0071cf975f58bcd0x96f4e9f90xb30fc83ec822eb50a368591c5d0413746cb939cedbefcbb8b2c6f7fa04efa6f600x881e3a65b4d4a04dd529061dd0071cf975f58bcdbridgechainlink0x4cbe437aa7a83457221d657207d78199ec3309540x881e3a65b4d4a04dd529061dd0071cf975f58bcd0x920c267ed50fd5e5e79d68130e39bceb2541a994ronin20200xe2816b27a5613b0aaf5d6dafa80584156e2fb1b6JAIHOZ2.41597e+23241597500.51408893112025-02-10 18:54:23.6902025-02-10 18:54:23.690
    3
    		260276812025-02-06 12:25:09.0000xe62c3960916c327e2bc60fa407e0a69802e03f5d0x881e3a65b4d4a04dd529061dd0071cf975f58bcd0x96f4e9f90x19d0ee2d65d890e48eda8938d48231836bfd4b87475e9056cf66a423d969d90a00x881e3a65b4d4a04dd529061dd0071cf975f58bcdbridgechainlink0xe62c3960916c327e2bc60fa407e0a69802e03f5d0x881e3a65b4d4a04dd529061dd0071cf975f58bcd0xe62c3960916c327e2bc60fa407e0a69802e03f5dronin20200xe2816b27a5613b0aaf5d6dafa80584156e2fb1b6JAIHOZ9.0205e+219020.518.687679645102025-02-10 18:54:23.6902025-02-10 18:54:23.690
    4
    		260338032025-02-06 15:49:13.0000x4cbe437aa7a83457221d657207d78199ec3309540x881e3a65b4d4a04dd529061dd0071cf975f58bcd0x96f4e9f90xed582e9084e2e7d0b7638975b4f18b1562d53bb9c105ed39d981f9908cda897900x881e3a65b4d4a04dd529061dd0071cf975f58bcdbridgechainlink0x4cbe437aa7a83457221d657207d78199ec3309540x881e3a65b4d4a04dd529061dd0071cf975f58bcd0x920c267ed50fd5e5e79d68130e39bceb2541a994ronin20200xe2816b27a5613b0aaf5d6dafa80584156e2fb1b6JAIHOZ3.21823e+23321823646.82239301162025-02-10 18:54:23.6902025-02-10 18:54:23.690
    5
    		260327342025-02-06 15:13:35.0000x4cbe437aa7a83457221d657207d78199ec3309540x881e3a65b4d4a04dd529061dd0071cf975f58bcd0x96f4e9f90xfda0fa3a89ab41b7b1d2a73ab374a5fa081c6b13db0f1050b89bab6e3eaa8b9300x881e3a65b4d4a04dd529061dd0071cf975f58bcdbridgechainlink0x4cbe437aa7a83457221d657207d78199ec3309540x881e3a65b4d4a04dd529061dd0071cf975f58bcd0x920c267ed50fd5e5e79d68130e39bceb2541a994ronin20200xe2816b27a5613b0aaf5d6dafa80584156e2fb1b6JAIHOZ3.22912e+23322912649.01114144152025-02-10 18:54:23.6902025-02-10 18:54:23.690
    6
    		260286322025-02-06 12:56:51.0000xa2d6868124f56b1ac9951439862d30e8925b7cb70x881e3a65b4d4a04dd529061dd0071cf975f58bcd0x96f4e9f90xde067c0161c1c6962beac182c951f4ab676e6c1e899d65a4332f05ad05840a0000x881e3a65b4d4a04dd529061dd0071cf975f58bcdbridgechainlink0xa2d6868124f56b1ac9951439862d30e8925b7cb70x881e3a65b4d4a04dd529061dd0071cf975f58bcd0xa2d6868124f56b1ac9951439862d30e8925b7cb7ronin20200x88fb150bdc53a65fe94dea0c9ba0a6daf8c6e196LINK49022164872381000004.90221648797.308997272122025-02-10 18:54:23.6902025-02-10 18:54:23.690
    7
    		260307952025-02-06 14:08:57.0000x4cbe437aa7a83457221d657207d78199ec3309540x881e3a65b4d4a04dd529061dd0071cf975f58bcd0x96f4e9f90x4773f0d58525fcb9cc56ce44299f45b574a065e5ca2b7846704663453907977300x881e3a65b4d4a04dd529061dd0071cf975f58bcdbridgechainlink0x4cbe437aa7a83457221d657207d78199ec3309540x881e3a65b4d4a04dd529061dd0071cf975f58bcd0x920c267ed50fd5e5e79d68130e39bceb2541a994ronin20200xe2816b27a5613b0aaf5d6dafa80584156e2fb1b6JAIHOZ2.44235e+23244235486.41109895142025-02-10 18:54:23.6902025-02-10 18:54:23.690
    8
    		260725732025-02-07 13:21:33.0000x2c3c48dcfa3875b5d181033a5fffe1584270462a0x881e3a65b4d4a04dd529061dd0071cf975f58bcd0x96f4e9f90x585d52e419ce876885df28c3beb44adf3609172a8508b661d9dcd5203d25631d00x881e3a65b4d4a04dd529061dd0071cf975f58bcdbridgechainlink0x2c3c48dcfa3875b5d181033a5fffe1584270462a0x881e3a65b4d4a04dd529061dd0071cf975f58bcd0x468201e260fead6c7553529355f522d14f0e569eronin20200xe2816b27a5613b0aaf5d6dafa80584156e2fb1b6JAIHOZ2.60729591615038e+212607.295916155.205987756282025-02-10 18:54:23.6902025-02-10 18:54:23.690
    9
    		260759322025-02-07 15:13:31.0000x5da68eddb1e2dcc38f760fce824f6bca56b4f8e90x881e3a65b4d4a04dd529061dd0071cf975f58bcd0x96f4e9f90xf900daf91e562551a9fc85e279ede3d51ff73f5e6fe0b4036d14c9e3cfa916b800x881e3a65b4d4a04dd529061dd0071cf975f58bcdbridgechainlink0x5da68eddb1e2dcc38f760fce824f6bca56b4f8e90x881e3a65b4d4a04dd529061dd0071cf975f58bcd0x5da68eddb1e2dcc38f760fce824f6bca56b4f8e9ronin20200xe2816b27a5613b0aaf5d6dafa80584156e2fb1b6JAIHOZ1.40557043209954e+2214055.70432099528.652272144292025-02-10 18:54:23.6902025-02-10 18:54:23.690
    10
    		260772222025-02-07 15:56:31.0000x4cbe437aa7a83457221d657207d78199ec3309540x881e3a65b4d4a04dd529061dd0071cf975f58bcd0x96f4e9f90x1c678550172aabc1fe73c616a8e44282c02eecd38836360a93a65f831631fefe00x881e3a65b4d4a04dd529061dd0071cf975f58bcdbridgechainlink0x4cbe437aa7a83457221d657207d78199ec3309540x881e3a65b4d4a04dd529061dd0071cf975f58bcd0x920c267ed50fd5e5e79d68130e39bceb2541a994ronin20200xe2816b27a5613b0aaf5d6dafa80584156e2fb1b6JAIHOZ3.22778e+23322778657.97649744302025-02-10 18:54:23.6902025-02-10 18:54:23.690
    11
    		260800412025-02-07 17:30:29.0000x4cbe437aa7a83457221d657207d78199ec3309540x881e3a65b4d4a04dd529061dd0071cf975f58bcd0x96f4e9f90x281f4595d0b27f234ddfbea5e51a133048a3a78852aec7cc6ef94674d9b2eb4a00x881e3a65b4d4a04dd529061dd0071cf975f58bcdbridgechainlink0x4cbe437aa7a83457221d657207d78199ec3309540x881e3a65b4d4a04dd529061dd0071cf975f58bcd0x920c267ed50fd5e5e79d68130e39bceb2541a994ronin20200xe2816b27a5613b0aaf5d6dafa80584156e2fb1b6JAIHOZ4.85251e+23485251986.02032698312025-02-10 18:54:23.6902025-02-10 18:54:23.690
    12
    		260670702025-02-07 10:18:07.0000x4cbe437aa7a83457221d657207d78199ec3309540x881e3a65b4d4a04dd529061dd0071cf975f58bcd0x96f4e9f90x34949afd626895daabd13e5c1b4cd6425f732c4e46a6a134705730978d237e8b00x881e3a65b4d4a04dd529061dd0071cf975f58bcdbridgechainlink0x4cbe437aa7a83457221d657207d78199ec3309540x881e3a65b4d4a04dd529061dd0071cf975f58bcd0x920c267ed50fd5e5e79d68130e39bceb2541a994ronin20200xe2816b27a5613b0aaf5d6dafa80584156e2fb1b6JAIHOZ4.06646e+23406646801.3366076262025-02-10 18:54:23.6902025-02-10 18:54:23.690
    13
    		260720632025-02-07 13:04:33.0000xce4bc90c3c313ad1b21085b3242a0600146285e60x881e3a65b4d4a04dd529061dd0071cf975f58bcd0x96f4e9f90x7dad6a594a1157d09fe6dce0d1daef5c3e160aee8d0c7fa8ed51c6d6eb48988b00x881e3a65b4d4a04dd529061dd0071cf975f58bcdbridgechainlink0xce4bc90c3c313ad1b21085b3242a0600146285e60x881e3a65b4d4a04dd529061dd0071cf975f58bcd0xce4bc90c3c313ad1b21085b3242a0600146285e6ronin20200xe2816b27a5613b0aaf5d6dafa80584156e2fb1b6JAIHOZ4.7184535605296e+214718.453560539.421336224272025-02-10 18:54:23.6902025-02-10 18:54:23.690
    14
    		260569632025-02-07 04:41:13.0000xc6bff1fffb7ba06734a09c2c27f245842d4fbe4c0x881e3a65b4d4a04dd529061dd0071cf975f58bcd0x96f4e9f90xc3be9e03801a438ecfe39a513da778ff27fe069fcdb436951b74b04dabe72e4d00x881e3a65b4d4a04dd529061dd0071cf975f58bcdbridgechainlink0xc6bff1fffb7ba06734a09c2c27f245842d4fbe4c0x881e3a65b4d4a04dd529061dd0071cf975f58bcd0xc6bff1fffb7ba06734a09c2c27f245842d4fbe4cronin20200xe2816b27a5613b0aaf5d6dafa80584156e2fb1b6JAIHOZ2.26759791343266e+23226759.791343266444.73490837252025-02-10 18:54:23.6902025-02-10 18:54:23.690
    15
    		260408962025-02-06 19:45:39.0000xc639cbf8213b647ac8c4c04873ef79f2c6beb46f0x881e3a65b4d4a04dd529061dd0071cf975f58bcd0x96f4e9f90xfff623c68b111151e455e291758d86f3e38952a191cd60cb1571c02404fe03b300x881e3a65b4d4a04dd529061dd0071cf975f58bcdbridgechainlink0xc639cbf8213b647ac8c4c04873ef79f2c6beb46f0x881e3a65b4d4a04dd529061dd0071cf975f58bcd0xc639cbf8213b647ac8c4c04873ef79f2c6beb46fronin20200xe2816b27a5613b0aaf5d6dafa80584156e2fb1b6JAIHOZ4.00584244808449e+2240058.42448084573.046136457172025-02-10 18:54:23.6902025-02-10 18:54:23.690
    16
    		260415282025-02-06 20:06:43.0000x3929b8db9089098026baeb5127498a3f1f1d3cd80x881e3a65b4d4a04dd529061dd0071cf975f58bcd0x96f4e9f90xf67f0526842ad0d5cb80b21d01226262687a2fc2800ccd176ecd54a87e1d65e300x881e3a65b4d4a04dd529061dd0071cf975f58bcdbridgechainlink0x3929b8db9089098026baeb5127498a3f1f1d3cd80x881e3a65b4d4a04dd529061dd0071cf975f58bcd0x3929b8db9089098026baeb5127498a3f1f1d3cd8ronin20200xe2816b27a5613b0aaf5d6dafa80584156e2fb1b6JAIHOZ4000000000000000000004000.731332182025-02-10 18:54:23.6902025-02-10 18:54:23.690
    17
    		260425982025-02-06 20:42:23.0000x02496a2cdefa76eb4e9b19d3c348d314d364ef790x881e3a65b4d4a04dd529061dd0071cf975f58bcd0x96f4e9f90x4585e2bc665992cc137703d15770dd5878e3350817521db9d54065edf6c1dd0200x881e3a65b4d4a04dd529061dd0071cf975f58bcdbridgechainlink0x02496a2cdefa76eb4e9b19d3c348d314d364ef790x881e3a65b4d4a04dd529061dd0071cf975f58bcd0x02496a2cdefa76eb4e9b19d3c348d314d364ef79ronin20200x88fb150bdc53a65fe94dea0c9ba0a6daf8c6e196LINK16000000000000000001.629.776202025-02-10 18:54:23.6902025-02-10 18:54:23.690
    18
    		260426492025-02-06 20:44:05.0000x02496a2cdefa76eb4e9b19d3c348d314d364ef790x881e3a65b4d4a04dd529061dd0071cf975f58bcd0x96f4e9f90x90ee93c13f6b15f52698fd6c4dbb1b3ec3ba978f58b84c0640cc5bd1d05b690d00x881e3a65b4d4a04dd529061dd0071cf975f58bcdbridgechainlink0x02496a2cdefa76eb4e9b19d3c348d314d364ef790x881e3a65b4d4a04dd529061dd0071cf975f58bcd0x02496a2cdefa76eb4e9b19d3c348d314d364ef79ronin20200x88fb150bdc53a65fe94dea0c9ba0a6daf8c6e196LINK934586200557276000.093458620061.739264919212025-02-10 18:54:23.6902025-02-10 18:54:23.690
    19
    		260422652025-02-06 20:31:17.0000x76a1b438e6536455828adc9d074508ca665147320x881e3a65b4d4a04dd529061dd0071cf975f58bcd0x96f4e9f90x04aff3c463bba383de77de4dd48da7d5594fc8cdb0366cbd81b7fcd1ffbe410200x881e3a65b4d4a04dd529061dd0071cf975f58bcdbridgechainlink0x76a1b438e6536455828adc9d074508ca665147320x881e3a65b4d4a04dd529061dd0071cf975f58bcd0x76a1b438e6536455828adc9d074508ca66514732ronin20200xe2816b27a5613b0aaf5d6dafa80584156e2fb1b6JAIHOZ1.452582811592e+2214525.8281159226.558007319192025-02-10 18:54:23.6902025-02-10 18:54:23.690
    20
    		262054332025-02-10 15:10:13.0000xbcce3c51035ec19dca7c402e7561706a0425a5ef0x881e3a65b4d4a04dd529061dd0071cf975f58bcd0x96f4e9f90x713841ee4304c36e3efd92d25a18ffe25d160a1ae9fd13b6866b503025e5e67100x881e3a65b4d4a04dd529061dd0071cf975f58bcdbridgechainlink0xbcce3c51035ec19dca7c402e7561706a0425a5ef0x881e3a65b4d4a04dd529061dd0071cf975f58bcd0xbcce3c51035ec19dca7c402e7561706a0425a5efronin20200xe2816b27a5613b0aaf5d6dafa80584156e2fb1b6JAIHOZ1.03270415890661e+2210327.04158906622.145101443612025-02-10 18:54:23.6902025-02-10 18:54:23.690
    63
    35KB
    152s