DATE | Sector | USERS | address creation rate | TRANSACTIONS | AVG_TRANSACTIONS | |
|---|---|---|---|---|---|---|
1 | 2024-02-01 00:00:00.000 | nft | 1 | 0.033333 | 809 | 809 |
2 | 2024-09-01 00:00:00.000 | nft | 4 | 0.133333 | 36 | 36 |
3 | 2024-03-01 00:00:00.000 | nft | 1 | 0.033333 | 147 | 147 |
4 | 2023-12-01 00:00:00.000 | nft | 1 | 0.033333 | 546 | 546 |
5 | 2023-09-01 00:00:00.000 | nft | 17 | 0.566667 | 36 | 36 |
6 | 2023-09-01 00:00:00.000 | nft | 1 | 0.033333 | 184 | 184 |
7 | 2023-02-01 00:00:00.000 | nft | 671 | 22.366667 | 5 | 5 |
8 | 2024-03-01 00:00:00.000 | nft | 3 | 0.1 | 83 | 83 |
9 | 2023-02-01 00:00:00.000 | nft | 8 | 0.266667 | 68 | 68 |
10 | 2023-04-01 00:00:00.000 | nft | 2 | 0.066667 | 77 | 77 |
11 | 2024-09-01 00:00:00.000 | nft | 1 | 0.033333 | 680 | 680 |
12 | 2023-02-01 00:00:00.000 | nft | 4 | 0.133333 | 132 | 132 |
13 | 2024-04-01 00:00:00.000 | nft | 13 | 0.433333 | 396 | 396 |
14 | 2024-01-01 00:00:00.000 | nft | 12529 | 417.633333 | 3 | 3 |
15 | 2023-10-01 00:00:00.000 | nft | 1 | 0.033333 | 115 | 115 |
16 | 2023-08-01 00:00:00.000 | nft | 1 | 0.033333 | 312 | 312 |
17 | 2023-01-01 00:00:00.000 | nft | 2 | 0.066667 | 204 | 204 |
18 | 2023-01-01 00:00:00.000 | nft | 65 | 2.166667 | 31 | 31 |
19 | 2023-08-01 00:00:00.000 | nft | 1 | 0.033333 | 609 | 609 |
20 | 2023-01-01 00:00:00.000 | nft | 1 | 0.033333 | 663 | 663 |
Haisenbergnew-users-daily1
Updated 2025-03-29
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
›
⌄
-- forked from new-users @ https://flipsidecrypto.xyz/studio/queries/c2b5abeb-deaf-419e-a442-ab322f54aae5
With new_users AS (
SELECT
DISTINCT sender,
label_type as sector,
min(block_timestamp) as intial_transaction,
count(DISTINCT tx_hash) as transactions
FROM aptos.core.fact_transactions s
LEFT JOIN aptos.core.dim_labels a
ON SUBSTRING(s.PAYLOAD_FUNCTION, 1, CHARINDEX('::', s.PAYLOAD_FUNCTION) - 1) = a.address
WHERE block_timestamp::date >= '{{Start_Date}}' AND block_timestamp::date <= '{{End_Date}}'
AND block_timestamp::date <= current_date - 1
AND label_type NOT IN ('token', 'chadmin', 'cex')
GROUP BY 1,2
HAVING sector IS NOT NULL)
--base AS (
SELECT
date_trunc('month', intial_transaction) as date,
sector as "Sector",
count(sender) as users,
users/30 as "address creation rate",
transactions,
avg(transactions) as avg_transactions
FROM new_users
GROUP BY 1, 2, 5
ORDER BY 2 DESC
Last run: 2 months ago
...
48375
2MB
212s