DAY | NEW_WALLETS | TOTAL_WALLETS | |
|---|---|---|---|
1 | 2023-12-12 00:00:00.000 | 1351 | 524606 |
2 | 2023-07-04 00:00:00.000 | 2 | 104 |
3 | 2023-08-19 00:00:00.000 | 57094 | 306372 |
4 | 2023-09-07 00:00:00.000 | 5262 | 442297 |
5 | 2023-12-27 00:00:00.000 | 2536 | 578880 |
6 | 2023-09-20 00:00:00.000 | 1253 | 495804 |
7 | 2023-10-17 00:00:00.000 | 198 | 506994 |
8 | 2023-08-21 00:00:00.000 | 15278 | 340626 |
9 | 2023-11-07 00:00:00.000 | 126 | 510243 |
10 | 2023-12-06 00:00:00.000 | 244 | 518505 |
11 | 2023-09-18 00:00:00.000 | 4157 | 486209 |
12 | 2023-11-04 00:00:00.000 | 131 | 509767 |
13 | 2023-12-17 00:00:00.000 | 6058 | 544500 |
14 | 2023-10-11 00:00:00.000 | 195 | 505868 |
15 | 2024-01-14 00:00:00.000 | 7808 | 737050 |
16 | 2023-06-29 00:00:00.000 | 3 | 99 |
17 | 2023-05-30 00:00:00.000 | 54 | 54 |
18 | 2023-08-11 00:00:00.000 | 22 | 228 |
19 | 2023-09-16 00:00:00.000 | 3731 | 478903 |
20 | 2023-07-31 00:00:00.000 | 21 | 142 |
jackguySei Users 1
Updated 2024-01-29
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
›
⌄
SELECT
*,
sum(new_wallets) over (ORDER by day) as total_wallets
FROM (
SELECT
day,
count(*) as new_wallets
FROM (
SELECT
tx_from as user,
min(date_trunc('day', block_timestamp)) as day
FROM sei.core.fact_transactions
WHERE block_timestamp > '2023-05-30'
--LIMIT 100
GROUP by 1
)
GROUP BY 1
)
Last run: about 1 year agoAuto-refreshes every 3 hours
...
206
8KB
26s