DATE | N_LIQUIDATS | N_LIQUIDATORS | N_LIQUIDATEES | CUM_N_LIQUIDATS | |
|---|---|---|---|---|---|
1 | 2025-04-15 00:00:00.000 | 3 | 3 | 3 | 14204 |
2 | 2025-04-14 00:00:00.000 | 3 | 3 | 3 | 14201 |
3 | 2025-04-13 00:00:00.000 | 6 | 4 | 6 | 14198 |
4 | 2025-04-12 00:00:00.000 | 3 | 2 | 3 | 14192 |
5 | 2025-04-11 00:00:00.000 | 3 | 3 | 3 | 14189 |
6 | 2025-04-10 00:00:00.000 | 1 | 1 | 1 | 14186 |
7 | 2025-04-09 00:00:00.000 | 26 | 5 | 26 | 14185 |
8 | 2025-04-08 00:00:00.000 | 9 | 1 | 9 | 14159 |
9 | 2025-04-07 00:00:00.000 | 685 | 15 | 662 | 14150 |
10 | 2025-04-06 00:00:00.000 | 809 | 16 | 784 | 13465 |
11 | 2025-04-05 00:00:00.000 | 1 | 1 | 1 | 12656 |
12 | 2025-04-04 00:00:00.000 | 250 | 8 | 246 | 12655 |
13 | 2025-04-03 00:00:00.000 | 80 | 8 | 80 | 12405 |
14 | 2025-04-02 00:00:00.000 | 21 | 6 | 21 | 12325 |
15 | 2025-04-01 00:00:00.000 | 5 | 3 | 5 | 12304 |
16 | 2025-03-31 00:00:00.000 | 5 | 1 | 5 | 12299 |
17 | 2025-03-29 00:00:00.000 | 1 | 1 | 1 | 12294 |
18 | 2025-03-28 00:00:00.000 | 4 | 3 | 4 | 12293 |
19 | 2025-03-26 00:00:00.000 | 2 | 2 | 2 | 12289 |
20 | 2025-03-25 00:00:00.000 | 3 | 3 | 3 | 12287 |
0xHaM-dLiquidate Events Over Time
Updated 2025-04-15
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 LiquidateTb as (
SELECT
BLOCK_TIMESTAMP,
TX_HASH,
EVENT_TYPE,
split((split((split(EVENT_TYPE, '<')[1]), '>')[0]),', ')[0] as token_address1,
split((split((split(EVENT_TYPE, '<')[1]), '>')[0]),', ')[1] as token_address2,
split(EVENT_RESOURCE, '<')[1] as asset,
EVENT_DATA:liquidatee as liquidatee,
EVENT_DATA:liquidatee_profile_name as liquidatee_profile_name,
EVENT_DATA:liquidation_fee_amount as liquidation_fee_amount,
EVENT_DATA:liquidator as liquidator,
EVENT_DATA:redeem_lp::Boolean as redeem_lp,
c.symbol as symbol_1,
c.DECIMALS as DECIMALS_1,
d.symbol as symbol_2,
d.DECIMALS as DECIMALS_2,
EVENT_DATA:redeem_lp_amount/pow(10,d.DECIMALS) as redeem_lp_amount,
EVENT_DATA:repay_amount/pow(10,c.DECIMALS) as repay_amount,
EVENT_DATA:repay_amount_in/pow(10,c.DECIMALS) as repay_amount_in,
EVENT_DATA:withdraw_lp_amount/pow(10,d.DECIMALS) as withdraw_lp_amount
FROM aptos.core.fact_events a
JOIN aptos.core.dim_tokens c on split((split((split(EVENT_TYPE, '<')[1]), '>')[0]),', ')[0] = c.token_address
JOIN aptos.core.dim_tokens d on split((split((split(EVENT_TYPE, '<')[1]), '>')[0]),', ')[1] = d.token_address
-- JOIN aptos.core.fact_transactions b using(BLOCK_TIMESTAMP,TX_HASH)
WHERE EVENT_ADDRESS = '0x9770fa9c725cbd97eb50b2be5f7416efdfd1f1554beb0750d4dae4c64e860da3'
-- AND TX_HASH = '0xf3d455db96f34987f9dec2e4f6265155ddddc14260a216d777153b0b881ca199'
AND EVENT_MODULE = 'controller'
AND EVENT_RESOURCE ilike 'LiquidateEven%'
AND SUCCESS = 'true'
AND TX_TYPE = 'user_transaction'
GROUP by all
)
, agg as (
SELECT
BLOCK_TIMESTAMP,
Last run: 13 days ago
...
322
13KB
57s