BRIDGERS | BRIDGES | DST_CHAINS | BRIDGE_PLATFORMS | |
|---|---|---|---|---|
1 | 18735 | 27063 | 33 | 12 |
0-MIDtotal bsc
Updated 2024-04-15
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
›
⌄
select --BLOCK_TIMESTAMP::date as date
count(distinct ORIGIN_FROM_ADDRESS) as bridgers
,count(distinct TX_HASH) as bridges
,count(distinct DECODED_LOG:bridgeData:destinationChainId) as dst_chains
,count(distinct DECODED_LOG:bridgeData:bridge) as bridge_platforms
from bsc.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
Last run: about 1 month ago
1
21B
57s