WEEK_START_DATE | USER_TYPE | USER_COUNT | AVG_STAKE_AMOUNT | |
|---|---|---|---|---|
1 | 2024-11-11 00:00:00.000 | new | 7 | 1107.266880475 |
2 | 2024-11-11 00:00:00.000 | experienced | 14 | 17917.298470749 |
3 | 2024-11-18 00:00:00.000 | new | 17 | 5120.388873603 |
4 | 2024-11-18 00:00:00.000 | experienced | 39 | 2313.005346643 |
5 | 2024-11-25 00:00:00.000 | new | 15 | 7939.379436102 |
6 | 2024-11-25 00:00:00.000 | experienced | 69 | 1333.751592469 |
7 | 2024-12-02 00:00:00.000 | experienced | 11 | 5304.783229877 |
8 | 2024-12-02 00:00:00.000 | new | 9 | 33678.366500141 |
9 | 2024-12-09 00:00:00.000 | experienced | 4 | 1544.39758724 |
10 | 2024-12-09 00:00:00.000 | new | 17 | 16743.386179291 |
11 | 2024-12-16 00:00:00.000 | experienced | 4 | 1886.378167297 |
12 | 2024-12-16 00:00:00.000 | new | 6 | 120.843395207 |
13 | 2024-12-23 00:00:00.000 | experienced | 3 | 352.655354002 |
14 | 2024-12-23 00:00:00.000 | new | 4 | 19049.551304807 |
15 | 2024-12-30 00:00:00.000 | new | 5 | 4407.673269185 |
16 | 2024-12-30 00:00:00.000 | experienced | 2 | 73770.64539909 |
17 | 2025-01-06 00:00:00.000 | new | 4 | 46283.468468603 |
18 | 2025-01-06 00:00:00.000 | experienced | 6 | 27424.629474987 |
19 | 2025-01-13 00:00:00.000 | experienced | 5 | 52434.154767148 |
20 | 2025-01-13 00:00:00.000 | new | 5 | 41.747615105 |
picasoWeekly New vs Experienced Stakers
Updated 2025-01-26
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 staking_events AS (
SELECT
ORIGIN_FROM_ADDRESS AS wallet_address,
DATE_TRUNC('day', BLOCK_TIMESTAMP) AS stake_date,
livequery.utils.udf_hex_to_int(
regexp_substr_all(SUBSTR(DATA, 3), '.{64}')[1]
) / POWER(10, 18) AS amount
FROM flow.core_evm.fact_event_logs
WHERE ORIGIN_FUNCTION_SIGNATURE = '0xac76d450'
AND EVENT_INDEX = 2
AND CONTRACT_ADDRESS = '0xfe8189a3016cb6a3668b8ccdac520ce572d4287a'
),
first_time_stakers AS (
SELECT
wallet_address,
MIN(stake_date) AS first_stake_date
FROM staking_events
GROUP BY wallet_address
),
staker_type AS (
SELECT
s.wallet_address,
s.stake_date,
s.amount,
CASE
WHEN fts.first_stake_date = s.stake_date THEN 'new'
ELSE 'experienced'
END AS user_type
FROM staking_events s
LEFT JOIN first_time_stakers fts
ON s.wallet_address = fts.wallet_address
)
SELECT
Last run: 3 months ago
22
1KB
13s