DATE | NEW_WALLET | TOTAL_UNIQUE_ADD | |
|---|---|---|---|
1 | 2025-03-19 00:00:00.000 | 770 | 108948 |
2 | 2025-03-18 00:00:00.000 | 653 | 108178 |
3 | 2025-03-17 00:00:00.000 | 906 | 107525 |
4 | 2025-03-16 00:00:00.000 | 5184 | 106619 |
5 | 2025-03-15 00:00:00.000 | 1774 | 101435 |
6 | 2025-03-14 00:00:00.000 | 1257 | 99661 |
7 | 2025-03-13 00:00:00.000 | 1211 | 98404 |
8 | 2025-03-12 00:00:00.000 | 856 | 97193 |
9 | 2025-03-11 00:00:00.000 | 1281 | 96337 |
10 | 2025-03-10 00:00:00.000 | 2080 | 95056 |
11 | 2025-03-09 00:00:00.000 | 1817 | 92976 |
12 | 2025-03-08 00:00:00.000 | 1066 | 91159 |
13 | 2025-03-07 00:00:00.000 | 921 | 90093 |
14 | 2025-03-06 00:00:00.000 | 1640 | 89172 |
15 | 2025-03-05 00:00:00.000 | 608 | 87532 |
16 | 2025-03-04 00:00:00.000 | 790 | 86924 |
17 | 2025-03-03 00:00:00.000 | 1086 | 86134 |
18 | 2025-03-02 00:00:00.000 | 570 | 85048 |
19 | 2025-03-01 00:00:00.000 | 797 | 84478 |
20 | 2025-02-28 00:00:00.000 | 752 | 83681 |
0xHaM-dTotal New Users copy
Updated 2 days 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
›
⌄
-- forked from Total New Users @ https://flipsidecrypto.xyz/studio/queries/e0042f13-9cab-44ef-a599-abf5c6d6eeb3
WITH eventTb AS (
SELECT
BLOCK_TIMESTAMP,
TX_HASH,
FROM_ADDRESS,
'Axie Infinity' as first_game,
FROM ronin.core.fact_transactions
WHERE TO_ADDRESS in (
'0x9d3936dbd9a794ee31ef9f13814233d435bd806c'
,'0x32950db2a7164ae833121501c797d79e7b79d74c'
,'0x05b0bb3c1c320b280501b86706c3551995bc8571'
,'0x3e0674b1ddc84b0cfd9d773bb2ce23fe8f445de3'
)
)
,
first_ever_txs AS (
SELECT
FROM_ADDRESS,
min(BLOCK_TIMESTAMP) as BLOCK_TIMESTAMP,
FROM eventTb
group by 1
)
SELECT
date_trunc('d', BLOCK_TIMESTAMP) as date,
count(DISTINCT FROM_ADDRESS) as new_wallet,
sum(new_wallet) over (order by date) as total_unique_add
FROM first_ever_txs
where date >= '2025-01-01'
and date < current_date
GROUP by 1
ORDER by 1 DESC
Last run: 1 day ago
78
3KB
7s