PROTOCOL | VOLUME | |
|---|---|---|
1 | across | 6310935.49028356 |
2 | symbiosis | 140867.62510399 |
3 | relay | 12047.078032525 |
0-MIDbr pro zk-after base
Updated 2025-01-20
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 tab1 as (
select DECODED_LOG:bridgeData:bridge as protocol
,TX_HASH
from base.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>='2025-01-06' and BLOCK_TIMESTAMP::date<='2025-01-19'
and DECODED_LOG:bridgeData:destinationChainId=324
),
tab2 as (
select
AMOUNT_USD
,TX_HASH
from base.core.ez_token_transfers
where ORIGIN_TO_ADDRESS='0x1231deb6f5749ef6ce6943a275a1d3e7486f4eae'
and BLOCK_TIMESTAMP::date>='2025-01-06' and BLOCK_TIMESTAMP::date<='2025-01-19'
and ORIGIN_FROM_ADDRESS=FROM_ADDRESS
and TX_HASH in (select TX_HASH from tab1)
)
select protocol
,sum(AMOUNT_USD) as volume
from tab1
left join tab2
on tab1.TX_HASH=tab2.TX_HASH
group by 1
order by 2 desc
Last run: 3 months ago
3
85B
14s