BRIDGES | BRIDGERS | |
|---|---|---|
1 | 41 | 6 |
2 | 91 | 2 |
3 | 46 | 3 |
4 | 6 | 973 |
5 | 33 | 7 |
6 | 30 | 7 |
7 | 56 | 1 |
8 | 74 | 2 |
9 | 44 | 2 |
10 | 99 | 1 |
11 | 9 | 438 |
12 | 11 | 238 |
13 | 54 | 2 |
14 | 34 | 10 |
15 | 68 | 2 |
16 | 38 | 11 |
17 | 60 | 3 |
18 | 40 | 2 |
19 | 8 | 566 |
20 | 37 | 2 |
0-MIDuser dis
Updated 2025-03-04
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
›
⌄
with tab1 as (
select
ORIGIN_FROM_ADDRESS
,count(distinct TX_HASH) as bridges
from arbitrum.core.ez_decoded_event_logs
where EVENT_NAME='LiFiTransferStarted'
and DECODED_LOG:bridgeData:integrator='jumper.exchange'
and ORIGIN_TO_ADDRESS='0x1231deb6f5749ef6ce6943a275a1d3e7486f4eae'
and BLOCK_TIMESTAMP::date>=current_date-30
group by 1
)
select bridges
,count(distinct ORIGIN_FROM_ADDRESS) as bridgers
from tab1
group by 1
Last run: about 2 months ago
78
592B
42s