POOL_NAME | POOL_ADDRESS | TOTAL_STAKE_TX_COUNT | TOTAL_UNSTAKE_TX_COUNT | TOTAL_TX_COUNT | TOTAL_UNIQUE_WALLETS | TOTAL_STAKING_WALLETS | TOTAL_UNSTAKING_WALLETS | TOTAL_STAKED | TOTAL_UNSTAKED | NET_STAKED | AVG_STAKE_SIZE | AVG_UNSTAKE_SIZE | FIRST_ACTIVITY | LAST_ACTIVITY | DAYS_ACTIVE | CURRENT_PROPS_PRICE | NET_STAKED_USD | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | Maxi Holders 3 - Long Term Staking | 0x7ce7832582ff498f9215d8ad71c72a3bcfb3151fb36671682c71b1d224a0f1a2 | 259 | 4 | 263 | 94 | 94 | 3 | 15002801.9950002 | 2802 | 14999999.9950002 | 57925.876428572 | 700.5 | 2025-02-22 15:00:23.066 | 2025-04-08 08:23:05.772 | 45 | 0.02656227 | 398434.049867194 |
2 | August Grand Finale - Long Term High Yield | 0xe611d3cedc39a0a70b756672d61252a1130f37a7909ed249aaaff04523a611e3 | 780 | 116 | 896 | 148 | 148 | 57 | 11375624.4900004 | 1375624.49833324 | 9999999.99166719 | 14584.133961539 | 11858.831882183 | 2024-08-28 18:00:15.014 | 2025-03-22 21:17:09.038 | 206 | 0.02656227 | 265622.699778662 |
3 | $PROPS Flexible Staking Pool | 0x3d9aa685e9fbcd77840dc5cb99362406645d99d2897c808c884bb9575343598e | 133 | 90 | 223 | 88 | 88 | 53 | 8351332.72500003 | 5546123.82500001 | 2805208.90000002 | 62791.97537594 | 61623.598055556 | 2024-02-23 12:08:17.277 | 2025-04-22 03:08:28.707 | 424 | 0.02656227 | 74512.716208203 |
aureasarsanedespropbase 3
Updated 5 days ago
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 base_data AS (
SELECT
tx_hash,
block_timestamp,
account_address as wallet,
event_resource,
event_address as pool_address,
event_data:amount/pow(10,8) as props_amount
FROM aptos.core.fact_events
WHERE payload_function ilike '%propbase_staking%'
AND event_module = 'propbase_staking'
AND event_resource IN ('StakeEvent','UnStakeEvent')
),
pool_metrics AS (
SELECT
pool_address,
COUNT(DISTINCT CASE WHEN event_resource = 'StakeEvent' THEN tx_hash END) as total_stake_tx_count,
COUNT(DISTINCT CASE WHEN event_resource = 'UnStakeEvent' THEN tx_hash END) as total_unstake_tx_count,
COUNT(DISTINCT wallet) as total_unique_wallets,
COUNT(DISTINCT CASE WHEN event_resource = 'StakeEvent' THEN wallet END) as total_staking_wallets,
COUNT(DISTINCT CASE WHEN event_resource = 'UnStakeEvent' THEN wallet END) as total_unstaking_wallets,
SUM(CASE WHEN event_resource = 'StakeEvent' THEN props_amount ELSE 0 END) as total_staked,
SUM(CASE WHEN event_resource = 'UnStakeEvent' THEN props_amount ELSE 0 END) as total_unstaked,
AVG(CASE WHEN event_resource = 'StakeEvent' THEN props_amount END) as avg_stake_size,
AVG(CASE WHEN event_resource = 'UnStakeEvent' THEN props_amount END) as avg_unstake_size,
MIN(block_timestamp) as first_activity,
MAX(block_timestamp) as last_activity
FROM base_data
GROUP BY pool_address
)
SELECT
CASE
WHEN m.pool_address = '0xe611d3cedc39a0a70b756672d61252a1130f37a7909ed249aaaff04523a611e3'
THEN 'August Grand Finale - Long Term High Yield'
Last run: 5 days ago
3
864B
11s