POOLS | TVL | |
|---|---|---|
1 | thAPT - APT | 10163582 |
2 | MOD - THL | 2624452.39 |
3 | USDC - USDC | 2005255.1 |
4 | ABTC - WBTC | 362142.4 |
5 | AmnisApt - APT | 184636.25 |
6 | USDC - MOD | 44549.4 |
7 | APT - stAPT | 40798.02 |
8 | USDC - WETH | 28285.53 |
9 | MOD - APT | 25247.91 |
10 | THL - APT | 9252.64 |
11 | APT - EchoCoin002 | 3768.67 |
12 | APT - sthAPT | 2560.8 |
13 | WETH - APT | 1618.67 |
14 | USDC - EchoCoin002 | 1292.88 |
15 | WAR - APT | 712.96 |
16 | USDC - WBTC | 482.75 |
17 | USDC - stAPT | 241.34 |
18 | Cake - APT | 151.06 |
19 | THL - sthAPT | 55.51 |
20 | USDT - EchoCoin002 | 43.26 |
SocioAnalyticaThala (add-remove) liquidity
Updated 2025-02-25
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 add_remove as (
SELECT
block_timestamp,
tx_hash,
'AddLiquidity' as lp_action,
SPLIT_PART(SPLIT(event_type, ',')[0], '<', 2) as token_1,
SPLIT(event_type, ',')[1] as token_2,
SPLIT_PART(SPLIT(event_type, ',')[0], '::', 5) as symbol_1,
SPLIT_PART(SPLIT(event_type, ',')[1], '::', 3) as symbol_2,
event_data:amount_0 as amounts_1,
event_data:amount_1 as amounts_2,
success,
tx_type,
event_module,
event_index,
EVENT_RESOURCE,
PAYLOAD_FUNCTION
FROM aptos.core.fact_events
WHERE
event_resource ilike 'AddLiquidityEvent%'
AND event_address = '0x48271d39d0b05bd6efca2278f22277d6fcc375504f9839fd73f74ace240861af'
UNION
SELECT
block_timestamp,
tx_hash,
'RemoveLiquidity' as lp_action,
SPLIT_PART(SPLIT(event_type, ',')[0], '<', 2) as token_1,
SPLIT(event_type, ',')[1] as token_2,
SPLIT_PART(SPLIT(event_type, ',')[0], '::', 5) as symbol_1,
SPLIT_PART(SPLIT(event_type, ',')[1], '::', 3) as symbol_2,
event_data:amount_0 as amounts_1,
event_data:amount_1 as amounts_2,
success,
tx_type,
event_module,
Last run: 2 months ago
82
2KB
87s