BRIDGE_ROUTE | MESSAGES_COUNT | TXS_COUNT | SAMPLE_TX | |
|---|---|---|---|---|
1 | Base ---> Aptos | 2731 | 2731 | 0x99edfef080f01e3a92f093b1c560b89a66e6de721996b6a445f772b2a78f9969 |
2 | Base ---> Mantle | 15 | 15 | 0x1945bbb6f6dce1ec04ff40214ff58a67fb2643123c38f87d37b2af19851db02a |
3 | Base ---> Solana | 89810 | 89810 | 0x03d718934c0dfab73e6232fd92fe5e5af533789f24f044a06bb7b468652e5c6a |
4 | Base ---> Celo | 37037 | 37037 | 0x045442a3805fd134a867156f64273503dced96c1833a2baa2f6d9f72b3dfa006 |
5 | Base ---> Ethereum | 13653 | 13652 | 0x3424d362d3f5e4d83192ff1d9b704696da9387b743b4433799508c5198d26d0f |
6 | Base ---> Arbitrum | 34544 | 34371 | 0x92f818b992ecc804e94f44500fcc299343a1656ceb553ee62fa17fccddad632e |
7 | Base ---> Base | 12 | 12 | 0xaa82ac7c91879060e2d8fac27702d67100a6d9be77f46bd8baaee461d1320fdf |
8 | 67817 | 67800 | 0x38ba73b5f38c15b2719b41e8b2eca181fa089b6e258206e638d073ac0a6b6e87 | |
9 | Base ---> Oasis | 45 | 45 | 0xa87f447947f2fa21259cc4ae6e6b93892e7658a5e3784fb6fa845070d38c156c |
10 | Base ---> BNB Smart Chain | 27643 | 27636 | 0xe93e2d3ef26d5e59bcec1a3257e30c273a457cc2041143d227d01597d49b8a42 |
11 | Base ---> Fantom | 13448 | 13447 | 0xb396c435c0f47f2ecbe18bdecb716dbe527b78dbd996b011aa17fd37f5d0bd19 |
12 | Base ---> Optimism | 31035 | 31034 | 0x7bc0868500f6817aded1ecd4b6cde3b90ec2e0f8ffb0c6f31ad2c152e2f61e41 |
13 | Base ---> Karura | 21 | 21 | 0xe4821b4e348133e3091e7f6bbc222ce359b1844b3fc3680852a0a6b04c5d35df |
14 | Base ---> Terra | 1 | 1 | 0x360a3a359062128d8df53244eca7fed9161532306a9c9a083e1c2a9aaa9d3381 |
15 | Base ---> Avalanche | 39900 | 39900 | 0x954c85ca4d08450b01ff40ff804a8f829699bc21ba0bb0d7f6de490fb87066e6 |
16 | Base ---> Blast | 15 | 15 | 0x1fff61d66096bebc48bc80b860fd5ea1cf441ddfa05f9ca10242536aa32ad156 |
17 | Base ---> Klaytn (Kaia) | 24733 | 24733 | 0x88bf043945960a07c9ebdb8968b4399b547101dd15fae85e0c3bf232adeec975 |
18 | Base ---> Injective | 140 | 140 | 0xf89af7ddd55dd2dfdeeb18218a1ef8036598892d829d6c0a3b7e11a0fdbd4381 |
19 | Base ---> Sei | 158 | 158 | 0x41de43a1bd14d07d985b144104da09cda93209af86a2fb4c22a5e915c9d00413 |
20 | Base ---> Sui | 5286 | 5286 | 0x146248fab513e83db9e59f5862587243b25b037baebb3c868266bb530c0c1517 |
hbd199403 - Wormhole Base Query
Updated 2025-02-22
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
with chains as (
select *
from $query('37c1dce8-7951-4a2e-afb3-918dcc3c3417')),
base as (
select
a.BLOCK_TIMESTAMP,
'Base' || ' ---> ' || Chain_Name as bridge_route,
'0x' || substr(TOPICS[1], 27, 42) as sender_address,
length(A.DATA) as length,
a.TX_HASH,
a.ORIGIN_FROM_ADDRESS,
a.ORIGIN_TO_ADDRESS,
A.ORIGIN_FUNCTION_SIGNATURE,
ethereum.public.udf_hex_to_int(substr(A.data, 3, 64)) as sequence,
ethereum.public.udf_hex_to_int(substr(A.data, 67, 64)) as nonce,
ethereum.public.udf_hex_to_int(substr(A.data, 131, 64)) as Unknown1,
ethereum.public.udf_hex_to_int(substr(A.data, 192, 64)) as consistencyLevel,
ethereum.public.udf_hex_to_int(substr(A.data, 255, 64)) as Unknown2,
ethereum.public.udf_hex_to_int(substr(A.data, 323, 2)) as payloadType,
case
when length = '386' and a.ORIGIN_FUNCTION_SIGNATURE in ('0xbb926d9e','0x4cd480bd') and sender_address = '0x9f4be852679c595ee265b17a345a0702eca908e2' and substr(A.data, 325, 2) = '01' then '2' -- Ethereum
when length = '386' and a.ORIGIN_FUNCTION_SIGNATURE in ('0xbb926d9e','0x4cd480bd') and sender_address = '0x9f4be852679c595ee265b17a345a0702eca908e2' and substr(A.data, 325, 2) = '02' then '4' -- BNB
when length = '386' and a.ORIGIN_FUNCTION_SIGNATURE in ('0xbb926d9e','0x4cd480bd') and sender_address = '0x9f4be852679c595ee265b17a345a0702eca908e2' and substr(A.data, 325, 2) = '04' then '1' -- Solana
when length = '386' and a.ORIGIN_FUNCTION_SIGNATURE in ('0xbb926d9e','0x4cd480bd') and sender_address = '0x9f4be852679c595ee265b17a345a0702eca908e2' and substr(A.data, 325, 2) = '05' then '5' -- Polygon
when length = '386' and a.ORIGIN_FUNCTION_SIGNATURE in ('0xbb926d9e','0x4cd480bd') and sender_address = '0x9f4be852679c595ee265b17a345a0702eca908e2' and substr(A.data, 325, 2) = '06' then '23' -- Arbitrum
when length = '386' and a.ORIGIN_FUNCTION_SIGNATURE in ('0xbb926d9e','0x4cd480bd') and sender_address = '0x9f4be852679c595ee265b17a345a0702eca908e2' and substr(A.data, 325, 2) = '08' then '6' -- Avalanche
when length = '386' and a.ORIGIN_FUNCTION_SIGNATURE in ('0xbb926d9e','0x4cd480bd') and sender_address = '0x9f4be852679c595ee265b17a345a0702eca908e2' and substr(A.data, 325, 2) = '09' then '30' -- Base
when length = '386' and a.ORIGIN_FUNCTION_SIGNATURE in ('0xbb926d9e','0x4cd480bd') and sender_address = '0x9f4be852679c595ee265b17a345a0702eca908e2' and substr(A.data, 325, 2) = '0a' then '24' -- Optimism
when length = '386' and a.ORIGIN_FUNCTION_SIGNATURE in ('0xbb926d9e','0x4cd480bd') and sender_address = '0x9f4be852679c595ee265b17a345a0702eca908e2' and substr(A.data, 325, 2) = '0b' then '14' -- Celo
when length = '642' and sender_address in ('0x8d2de8d2f73f1f4cab472ac9a881c9b123c79627','0x496a6c57dbc1c7770cb9afe118e3268f979bc53f') then ethereum.public.udf_hex_to_int(substr(A.data, 521, 4))
when length = '706' and sender_address in ('0x8d2de8d2f73f1f4cab472ac9a881c9b123c79627','0xc95b6b051c485bb661414207139a3f8b5c48f08c') then ethereum.public.udf_hex_to_int(substr(A.data, 521, 4))
when length = '770' and sender_address in ('0x8d2de8d2f73f1f4cab472ac9a881c9b123c79627') AND A.ORIGIN_FUNCTION_SIGNATURE = '0xf7264c83' then ethereum.public.udf_hex_to_int(substr(A.data, 521, 4))
when length = '770' and A.ORIGIN_FUNCTION_SIGNATURE = '0xb293f97f' then ethereum.public.udf_hex_to_int(substr(A.data, 749, 4))
when length = '834' and sender_address in ('0x8d2de8d2f73f1f4cab472ac9a881c9b123c79627','0x11aa521c888d84f374b63823d9b873caa3591f55') then ethereum.public.udf_hex_to_int(substr(A.data, 521, 4))
when length = '834' and sender_address in ('0x706f82e9bb5b0813501714ab5974216704980e31') and A.ORIGIN_FUNCTION_SIGNATURE = '0x8b0301b1' then ethereum.public.udf_hex_to_int(substr(A.data, 411, 4))
Last run: about 2 months ago
27
3KB
205s