DAY | RICH_COUNT_50K | RICH_COUNT_10K | RICH_COUNT_1K | |
|---|---|---|---|---|
1 | 2025-05-19 00:00:00.000 | 76 | 301 | 1217 |
2 | 2025-05-18 00:00:00.000 | 76 | 300 | 1216 |
3 | 2025-05-17 00:00:00.000 | 75 | 301 | 1217 |
4 | 2025-05-16 00:00:00.000 | 302 | 1218 | |
5 | 2025-05-15 00:00:00.000 | 76 | 304 | 1220 |
6 | 2025-05-13 00:00:00.000 | 77 | 304 | 1220 |
7 | 2025-05-12 00:00:00.000 | 78 | 306 | 1223 |
8 | 2025-05-11 00:00:00.000 | 79 | 308 | 1227 |
9 | 2025-05-10 00:00:00.000 | 80 | 310 | 1231 |
10 | 2025-05-09 00:00:00.000 | 1233 | ||
11 | 2025-05-08 00:00:00.000 | 311 | 1236 | |
12 | 2025-05-07 00:00:00.000 | 81 | 310 | 1236 |
13 | 2025-05-06 00:00:00.000 | 80 | 309 | 1234 |
14 | 2025-05-04 00:00:00.000 | 81 | 1234 | |
15 | 2025-05-02 00:00:00.000 | 80 | 311 | 1235 |
16 | 2025-05-01 00:00:00.000 | 79 | 310 | 1234 |
17 | 2025-04-30 00:00:00.000 | 78 | 310 | 1233 |
18 | 2025-04-29 00:00:00.000 | 78 | 310 | 1233 |
19 | 2025-04-28 00:00:00.000 | 311 | 1234 | |
20 | 2025-04-27 00:00:00.000 | 1233 |
pietrektvthor Distribution
Updated 2 hours 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 transactions AS (SELECT to_address as address, amount, to_date(block_timestamp) as date FROM ethereum.core.ez_token_transfers as c1 WHERE c1.contract_address = '0x815c23eca83261b6ec689b60cc4a58b54bc24d8d' UNION ALL SELECT from_address as address, amount*(-1), to_date(block_timestamp) as date FROM ethereum.core.ez_token_transfers as c2 WHERE c2.contract_address = '0x815c23eca83261b6ec689b60cc4a58b54bc24d8d'),
daily_change AS (SELECT SUM(amount) as change, date, address FROM transactions GROUP BY date, address),
daily_change_indexed AS (SELECT date, address, change, ROW_NUMBER() OVER(PARTITION BY address ORDER BY date) AS rownum FROM daily_change),
daily_change_balance AS (SELECT date, address, change, (SELECT SUM(change) FROM daily_change_indexed AS c2 WHERE c2.address = c1.address AND c2.rownum <= c1.rownum) AS balance FROM daily_change_indexed AS c1),
rich_increase AS (SELECT date, COUNT(*) as C FROM daily_change_balance as c1 WHERE c1.balance >= 50000 AND c1.balance - c1.change < 50000 GROUP BY date),
rich_decrease AS (SELECT date, COUNT(*) * (-1) as C FROM daily_change_balance as c1 WHERE c1.balance < 50000 AND c1.balance - c1.change >= 50000 GROUP BY date),
combination AS (SELECT * FROM rich_increase UNION ALL SELECT * FROM rich_decrease),
rich_change AS (SELECT date, SUM(C) AS change, ROW_NUMBER() OVER(ORDER BY date) as rownum FROM combination GROUP BY date),
rich_count_50k AS (SELECT date as day, (SELECT SUM(change) FROM rich_change AS c2 WHERE c2.rownum <= c1.rownum) as rich_count_50k FROM rich_change c1 WHERE day is not null ORDER BY date),
-------------------------
transactions2 AS (SELECT to_address as address, amount, to_date(block_timestamp) as date FROM ethereum.core.ez_token_transfers as c1 WHERE c1.contract_address = '0x815c23eca83261b6ec689b60cc4a58b54bc24d8d' UNION ALL SELECT from_address as address, amount*(-1), to_date(block_timestamp) as date FROM ethereum.core.ez_token_transfers as c2 WHERE c2.contract_address = '0x815c23eca83261b6ec689b60cc4a58b54bc24d8d'),
daily_change2 AS (SELECT SUM(amount) as change, date, address FROM transactions2 GROUP BY date, address),
daily_change_indexed2 AS (SELECT date, address, change, ROW_NUMBER() OVER(PARTITION BY address ORDER BY date) AS rownum FROM daily_change2),
daily_change_balance2 AS (SELECT date, address, change, (SELECT SUM(change) FROM daily_change_indexed2 AS c2 WHERE c2.address = c1.address AND c2.rownum <= c1.rownum) AS balance FROM daily_change_indexed2 AS c1),
rich_increase2 AS (SELECT date, COUNT(*) as C FROM daily_change_balance2 as c1 WHERE c1.balance >= 10000 AND c1.balance - c1.change < 10000 GROUP BY date),
rich_decrease2 AS (SELECT date, COUNT(*) * (-1) as C FROM daily_change_balance2 as c1 WHERE c1.balance < 10000 AND c1.balance - c1.change >= 10000 GROUP BY date),
combination2 AS (SELECT * FROM rich_increase2 UNION ALL SELECT * FROM rich_decrease2),
rich_change2 AS (SELECT date, SUM(C) AS change, ROW_NUMBER() OVER(ORDER BY date) as rownum FROM combination2 GROUP BY date),
rich_count_10k AS (SELECT date as day, (SELECT SUM(change) FROM rich_change2 AS c2 WHERE c2.rownum <= c1.rownum) as rich_count_10k FROM rich_change2 c1 WHERE day is not null ORDER BY date),
Last run: about 2 hours agoAuto-refreshes every 24 hours
...
1066
43KB
14s