FIRST_DAY | NEW_USERS | TOTAL_USERS | |
|---|---|---|---|
1 | 2024-01-23 00:00:00.000 | 1063 | 216284 |
2 | 2024-01-22 00:00:00.000 | 1568 | 215221 |
3 | 2024-01-21 00:00:00.000 | 1524 | 213653 |
4 | 2024-01-20 00:00:00.000 | 1576 | 212129 |
5 | 2024-01-19 00:00:00.000 | 1450 | 210553 |
6 | 2024-01-18 00:00:00.000 | 1340 | 209103 |
7 | 2024-01-17 00:00:00.000 | 1487 | 207763 |
8 | 2024-01-16 00:00:00.000 | 1979 | 206276 |
9 | 2024-01-15 00:00:00.000 | 1469 | 204297 |
10 | 2024-01-14 00:00:00.000 | 2024 | 202828 |
11 | 2024-01-13 00:00:00.000 | 1727 | 200804 |
12 | 2024-01-12 00:00:00.000 | 1495 | 199077 |
13 | 2024-01-11 00:00:00.000 | 1583 | 197582 |
14 | 2024-01-10 00:00:00.000 | 1584 | 195999 |
15 | 2024-01-09 00:00:00.000 | 1670 | 194415 |
16 | 2024-01-08 00:00:00.000 | 1602 | 192745 |
17 | 2024-01-07 00:00:00.000 | 1338 | 191143 |
18 | 2024-01-06 00:00:00.000 | 1395 | 189805 |
19 | 2024-01-05 00:00:00.000 | 1520 | 188410 |
20 | 2024-01-04 00:00:00.000 | 1848 | 186890 |
jackguy2023-10-13 06:55 AM
Updated 2024-01-23
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
›
⌄
SELECT
*,
sum(new_users) over (ORDER by first_day) as total_users
FROM (
SELECT
first_day,
count(*) as new_users
FROM (
SELECT
tx_to as user,
min(date(block_timestamp)) as first_day
from solana.core.fact_transfers
WHERE mint LIKE 'J1toso1uCk3RLmjorhTtrVwY9HJ7X8V9yYac6Y7kGCPn'
GROUP by 1
UNION
SELECT
tx_from as user,
min(date(block_timestamp)) as first_day
from solana.core.fact_transfers
WHERE mint LIKE 'J1toso1uCk3RLmjorhTtrVwY9HJ7X8V9yYac6Y7kGCPn'
GROUP by 1
)
GROUP BY 1
)
ORDER BY first_day DESC
Last run: over 1 year ago
...
451
16KB
399s