BRIDGE_ROUTE | COUNT(*) | TXS | ANY_VALUE(TX_HASH) | |
|---|---|---|---|---|
1 | Base ---> TelosEVM | 7676 | 7676 | 0xefe3857a2593568e40bb7bd4efeb9c60ef4672d23ef840aecdb8de115f70d8b2 |
2 | Base ---> Metis | 85970 | 85970 | 0x1b5a468869841b3135460fab8977fb2cd9025786eba1c25d574531572adbf94a |
3 | Base ---> Berachain | 18 | 18 | 0x3a731865713bc0234b8e15b6bfe87fa2c0a94e3970d3faba5b9804e73acd311a |
4 | Base ---> Polygon ZkEVM | 31231 | 31231 | 0x95fc24bc2726cdd52fe1ec4c28a70e573de1608450b9fc26be533dc9c56e7b5d |
5 | Base ---> Conflux ESpace | 38423 | 38423 | 0x8648e67911e5dae9206f3a3544c903e42732d653e53232401ff684175669c5d7 |
6 | Base ---> ZKSync Era | 46385 | 46385 | 0x4c03ee71ab556ef707f69bc0adfad86275cd0eedb01c4a68754a076c7c7b5f39 |
7 | Base ---> Fuse | 13434 | 13434 | 0xae3e756e73280a62a782b97957dc001232efe016b43bf44ee9496b66104be119 |
8 | Base ---> Shimmer | 29817 | 29817 | 0x2b5c92ee1c4ce5ba8690d00016516c9a94ae82213e1d95e0e439e055be3ce363 |
9 | Base ---> Astar | 47728 | 47728 | 0xf3e1272798c92dde74bf40333c37943780a6b52758bd575bc6b6f810e4f3f882 |
10 | Base ---> Kava | 135514 | 135514 | 0x8c8c694981ae7a73217f024426c97016e4de8e0da16815d15c2f0b9819c95bf5 |
11 | Base ---> X Layer | 84 | 84 | 0x9f718c08fd0e5f03ee4cb2ce9aa8752aae03a083f6661cb19192386e67c7be35 |
12 | Base ---> Tiltyard | 35 | 35 | 0xd6dc6ecb263462fad190352b23b8c98a4dfaac347168e737193b641adc71869c |
13 | Base ---> Optimism | 824160 | 819280 | 0x9be9514437ea0367770db044894966c2b7d35da3554d60555c8096d894e22909 |
14 | Base ---> Arbitrum | 961981 | 955046 | 0xeb07a9c732ec22b3c23428bea509f715d4a80bc8053082def9efec5eab896653 |
15 | Base ---> Ethereum | 58506 | 58419 | 0x0087bb84eb01c424b7676973e166b38e06153350444093f00f83b44778bb7083 |
16 | Base ---> Mode | 456 | 456 | 0x5e4d3c7d5f06b1e9d3788f8e7708c373e16611b89a1a8a59ee948fb22d29872e |
17 | Base ---> BNB Smart Chain | 256294 | 255759 | 0x36a16b1574b559df25a573914c2446eaafc81ba23e669fdea6cbc89690955aaa |
18 | Base ---> re.al | 2612 | 2612 | 0x0e6ba505110e06abb05b3527dc06d8ac592f2f0dc2bdc726b2bf64346a62e077 |
19 | Base ---> Etherlink | 6692 | 6692 | 0xa112c705602147b2f625fb5296c88b78dd5539d7f4d7eb56f173e9d46f4a5d3d |
20 | Base ---> Merlin | 157 | 157 | 0x5712e990e8a8e575fca2bf7c719a74dbf54de8137218805d1a50e843d1f38559 |
hbd1994L0 - Base
Updated 2025-02-08
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
›
⌄
with chains as (
select *
from $query('df27f0fa-3f6b-4987-b94b-8d46c3d4cd28')),
base as (
select
BLOCK_TIMESTAMP,
'Base' || ' ---> ' || NETWORK_NAME as bridge_route,
TX_HASH,
ORIGIN_FROM_ADDRESS,
ORIGIN_TO_ADDRESS,
CONTRACT_ADDRESS,
ORIGIN_FUNCTION_SIGNATURE,
DATA,
ethereum.public.udf_hex_to_int(substr(data, (3 + (64*0)), 64)) as unknown1,
ethereum.public.udf_hex_to_int(substr(data, (3 + (64*1)), 64)) as unknown2,
ethereum.public.udf_hex_to_int(substr(data, (3 + (64*2)), 16)) as nounce,
ethereum.public.udf_hex_to_int(substr(data, (19 + (64*2)), 4)) as source,
'0x' || substr(data, 23 + (64*2) , 40 ) as Source_Omnichain_Application,
ethereum.public.udf_hex_to_int(substr(data, (63 + (64*2)), 4)) as dest,
'0x' || substr(data, 67 + (64*2) , 40 ) as Destination_Omnichain_Application,
'0x' || substr(data, 107 + (64*2) , 40 ) as Destination_address
from base.core.fact_event_logs
left join chains on dest = eid
where TOPICS[0] = '0xe9bded5f24a4168e4f3bf44e00298c993b22376aad8c58c7dda9718a54cbea82'
--and tx_hash = '0x0ba09e88e5dd1914df8c85b66dc39910c4067fd50456fbf8d458ed8a4ca65687'
and TX_STATUS = 'SUCCESS'
and CONTRACT_ADDRESS = '0x38de71124f7a447a01d67945a51edce9ff491251'
--and ORIGIN_TO_ADDRESS = '0x8d2de8d2f73f1f4cab472ac9a881c9b123c79627'
order by 1 desc )
select
BRIDGE_ROUTE, count(*), count(distinct tx_hash) as txs, any_value(tx_hash)
from base
group by 1
Last run: 2 months ago
54
5KB
359s