PAIR_NAME | # of Add premium TXs | # of Liquidated Positions | % of total positions | |
|---|---|---|---|---|
1 | WETH-mwstETH-WPUNKS:20 | 7 | 31 | 2.4087 |
2 | USDB-BAG | 1 | 61 | 28.7736 |
3 | ezETH-WETH | 18 | 240 | 12.2324 |
4 | YES-WETH | 0 | 7 | 43.75 |
5 | WETH-BAG | 0 | 4 | 80 |
6 | WETH-PAC | 0 | 1 | 20 |
7 | USDB-PAC | 0 | 8 | 53.3333 |
8 | WETH-WBTC | 0 | 15 | 18.75 |
9 | ORBIT-WETH | 1 | 23 | 36.5079 |
10 | OHNO-WETH | 0 | 9 | 81.8182 |
11 | WETH-JUICE | 0 | 1 | 50 |
12 | USDB-PTC | 0 | 1 | 50 |
13 | WETH-BLAST | 1 | 4 | 13.3333 |
14 | WETH-mwstETH-WPUNKS:40 | 0 | 4 | 4.6512 |
15 | USDB-axlUSDC | 0 | 1 | 100 |
16 | USDB-OLE | 0 | 1 | 5 |
17 | USDB-USDe | 0 | 30 | 2.9098 |
18 | USDB-WETH | 508 | 9485 | 17.5925 |
19 | WETH-YIELD | 0 | 1 | 100 |
20 | PUMP-WETH | 1 | 68 | 40 |
rezarwzStatus of Liquidated Positions by Pair
Updated 2025-03-12
999
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 pool_Address as (
SELECT
DISTINCT DECODED_LOG:pool as pool_ca,
DECODED_LOG:token0 as token0_ca,
DECODED_LOG:token1 as token1_ca
FROM
blast.core.ez_decoded_event_logs
where
tx_hash in (
SELECT
TX_HASH
from
blast.core.fact_traces
WHERE
TYPE ILIKE 'create%'
AND to_address IS NOT NULL
AND input IS NOT NULL
AND input != '0x'
AND tx_status = 'SUCCESS'
AND trace_status = 'SUCCESS'
and to_address in(
SELECT
lo2.decoded_log:pool as pool
FROM
blast.core.ez_decoded_event_logs lo
inner join blast.core.ez_decoded_event_logs lo2 on lo2.tx_hash = lo.tx_hash
WHERE
lo.contract_Address = '0x121b5ac4de4a3e6f4171956bc26ceda40cb61a56'
and lo.event_name = 'OpenPosition'
and lo2.event_name = 'Collect'
and lo2.CONTRACT_NAME is not null
)
)
and event_name = 'PoolCreated'
and TX_STATUS = 'SUCCESS'
),
Last run: about 2 months ago
23
584B
443s