DAY | BLOCKCHAIN | CUMULATIVE_COUNT | CUMULATIVE_COUNT_TOTAL | |
|---|---|---|---|---|
1 | 2025-01-25 00:00:00.000 | ETH | 1792 | 7278 |
2 | 2025-01-24 00:00:00.000 | DOGE | 866 | 7279 |
3 | 2025-01-24 00:00:00.000 | AVAX | 643 | 7279 |
4 | 2025-01-24 00:00:00.000 | BTC | 1833 | 7279 |
5 | 2025-01-24 00:00:00.000 | ETH | 1793 | 7279 |
6 | 2025-01-24 00:00:00.000 | BSC | 305 | 7279 |
7 | 2025-01-24 00:00:00.000 | LTC | 949 | 7279 |
8 | 2025-01-23 00:00:00.000 | BSC | 306 | 7288 |
9 | 2025-01-23 00:00:00.000 | GAIA | 336 | 7288 |
10 | 2025-01-23 00:00:00.000 | ETH | 1795 | 7288 |
11 | 2025-01-23 00:00:00.000 | AVAX | 645 | 7288 |
12 | 2025-01-23 00:00:00.000 | BTC | 1835 | 7288 |
13 | 2025-01-23 00:00:00.000 | BCH | 334 | 7288 |
14 | 2025-01-23 00:00:00.000 | DOGE | 867 | 7288 |
15 | 2025-01-23 00:00:00.000 | LTC | 950 | 7288 |
16 | 2025-01-22 00:00:00.000 | GAIA | 337 | 7304 |
17 | 2025-01-22 00:00:00.000 | DOGE | 869 | 7304 |
18 | 2025-01-22 00:00:00.000 | BTC | 1839 | 7304 |
19 | 2025-01-22 00:00:00.000 | LTC | 952 | 7304 |
20 | 2025-01-22 00:00:00.000 | BCH | 335 | 7304 |
pietrektSavers Addresses
Updated 2025-05-08
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
›
⌄
WITH pos_staker_records AS (select block_timestamp, blockchain, from_address as address, 1 as dir
from thorchain.defi.fact_swaps_events where _DIRECTION = '1' and MEMO like '%+:%' and MEMO like '%/%' and block_timestamp is not null),
neg_staker_records AS (select block_timestamp, blockchain, from_address as address, 0 as dir
from thorchain.defi.fact_withdraw_events where MEMO like '%-:%' and MEMO like '%/%' and block_timestamp is not null and basis_points = '10000'),
staker_events AS (SELECT * FROM pos_staker_records UNION ALL SELECT * FROM neg_staker_records),
staker_events_detailed AS (SELECT *, LAG(dir, 1, 0) OVER(PARTITION BY address, blockchain ORDER BY block_timestamp) as prev_dir
FROM staker_events),
staker_gain AS (SELECT block_timestamp::date as date, blockchain, COUNT(*) as gain
FROM staker_events_detailed WHERE prev_dir = 0 and dir = 1 GROUP BY date, blockchain),
staker_loss AS (SELECT block_timestamp::date as date, blockchain, -COUNT(*) as gain
FROM staker_events_detailed WHERE prev_dir = 1 and dir = 0 GROUP BY date, blockchain),
staker_combined AS (SELECT * FROM staker_gain UNION ALL SELECT * FROM staker_loss),
staker_change AS (SELECT date, blockchain, SUM(gain) as change FROM staker_combined GROUP BY date, blockchain),
staker_accum AS (SELECT date as day, blockchain,
SUM(change) OVER(PARTITION BY blockchain ORDER BY date) as cumulative_count,
SUM(change) OVER(ORDER BY date) as cumulative_count_total
FROM staker_change as c1)
SELECT * FROM staker_accum ORDER BY day desc
Last run: 13 days ago
...
5402
230KB
3s