SYMBOL | VOLUME | |
---|---|---|
1 | USDC | 4743685.14351845 |
2 | USDT | 401126.505220811 |
3 | WETH | 46806.001919865 |
4 | WBTC | 43541.56411348 |
5 | wstETH | 17178.81404525 |
6 | weETH | 9057.891448831 |
7 | DAI | 5199.462777021 |
8 | ARB | 4035.497767534 |
9 | ezETH | 3577.681573128 |
10 | TIA.n | 1969.85615589 |
11 | rsETH | 1736.944291596 |
12 | cbBTC | 1173.10797513 |
13 | uniETH | 1170.16506259 |
14 | ZRO | 759.966905989 |
15 | LINK | 231.249007267 |
16 | XAI | 174.535874384 |
17 | LOGX | 143.811510571 |
18 | GSWIFT | 139.620543301 |
19 | uniBTC | 105.1047795 |
20 | ETHFI | 62.598938789 |
0-MIDtoken % share zk
Updated 2025-01-14
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
›
⌄
with tab1 as (
select
TX_HASH
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>='2025-01-06' and BLOCK_TIMESTAMP::date<='2025-01-12'
and DECODED_LOG:bridgeData:destinationChainId=324
)
select SYMBOL
,sum(AMOUNT_USD) as volume
from arbitrum.core.ez_token_transfers
where ORIGIN_TO_ADDRESS='0x1231deb6f5749ef6ce6943a275a1d3e7486f4eae'
and BLOCK_TIMESTAMP::date>='2025-01-06' and BLOCK_TIMESTAMP::date<='2025-01-12'
and ORIGIN_FROM_ADDRESS=FROM_ADDRESS
and TX_HASH in (select TX_HASH from tab1)
and AMOUNT_USD is not null
group by 1
order by 2 desc
Last run: 3 months ago
28
644B
7s