TYPE | DATE | N_TXNS | N_USER | VALUE | |
|---|---|---|---|---|---|
1 | unstake | 2025-02-25 00:00:00.000 | 43 | 16 | -3128.5493455 |
2 | stake | 2025-02-25 00:00:00.000 | 42 | 16 | 2804.3603576 |
3 | stake | 2025-02-24 00:00:00.000 | 358 | 95 | 27650.8969535 |
4 | unstake | 2025-02-24 00:00:00.000 | 337 | 66 | -29614.33323332 |
5 | unstake | 2025-02-23 00:00:00.000 | 297 | 59 | -31593.42120028 |
6 | stake | 2025-02-23 00:00:00.000 | 302 | 76 | 28402.98679833 |
7 | unstake | 2025-02-22 00:00:00.000 | 341 | 69 | -38140.03704843 |
8 | stake | 2025-02-22 00:00:00.000 | 360 | 89 | 38701.05747462 |
9 | unstake | 2025-02-21 00:00:00.000 | 557 | 91 | -80688.46576625 |
10 | stake | 2025-02-21 00:00:00.000 | 764 | 90 | 66447.5256338 |
11 | stake | 2025-02-20 00:00:00.000 | 656 | 151 | 43846.15830467 |
12 | unstake | 2025-02-20 00:00:00.000 | 555 | 126 | -39639.42129017 |
13 | unstake | 2025-02-19 00:00:00.000 | 526 | 90 | -55090.46531306 |
14 | stake | 2025-02-19 00:00:00.000 | 545 | 118 | 63077.31098854 |
15 | unstake | 2025-02-18 00:00:00.000 | 725 | 80 | -35829.28242573 |
16 | stake | 2025-02-18 00:00:00.000 | 967 | 106 | 33788.92118787 |
17 | unstake | 2025-02-17 00:00:00.000 | 571 | 72 | -40743.3526756 |
18 | stake | 2025-02-17 00:00:00.000 | 591 | 90 | 37882.27060035 |
19 | unstake | 2025-02-16 00:00:00.000 | 614 | 109 | -106192.85300317 |
20 | stake | 2025-02-16 00:00:00.000 | 685 | 135 | 184464.0592464 |
SocioAnalyticaThala (LSD) liquid staking [user and txns]
Updated 2025-02-25
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 txs as (
SELECT
tx_hash
FROM aptos.core.fact_events
WHERE EVENT_RESOURCE = 'StakeThalaAPTEvent'
)
SELECT
'stake' as type,
date_trunc('d', block_timestamp) as date,
count(DISTINCT tx_hash) as n_txns,
count(DISTINCT ACCOUNT_ADDRESS) as n_user,
sum(amount/pow(10,8)) as value
FROM aptos.core.fact_transfers
WHERE token_address = '0xfaf4e633ae9eb31366c9ca24214231760926576c7b625313b3688b5e900731f6::staking::ThalaAPT'
AND TRANSFER_EVENT = 'DepositEvent'
AND SUCCESS
AND tx_hash not in (SELECT tx_hash from txs)
GROUP BY date
UNION
SELECT
'unstake' as type,
date_trunc('d', block_timestamp) as date,
count(DISTINCT tx_hash) as n_txns,
count(DISTINCT ACCOUNT_ADDRESS) as n_user,
-1 * sum(amount/pow(10,8)) as value
FROM aptos.core.fact_transfers
WHERE token_address = '0xfaf4e633ae9eb31366c9ca24214231760926576c7b625313b3688b5e900731f6::staking::ThalaAPT'
AND TRANSFER_EVENT = 'WithdrawEvent'
AND SUCCESS
AND tx_hash not in (SELECT tx_hash from txs)
GROUP BY date
ORDER BY date DESC
Last run: 2 months ago
...
926
55KB
33s