PEAK_INTENTS | LOWEST_INTENTS | GROWTH_PERCENT | |
|---|---|---|---|
1 | 19 | 1 | 1800 |
10Blockchainpurring-brown
Updated 2025-03-02
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
›
⌄
WITH daily_intents AS (
SELECT
DATE_TRUNC('day', BLOCK_TIMESTAMP) AS date,
PREDECESSOR_ID AS user
FROM near.defi.fact_intents
WHERE TOKEN_ID = 'nep141:aurora'
)
SELECT
date,
COUNT(DISTINCT user) AS active_users,
COUNT(DISTINCT CASE WHEN first_date = date THEN user END) AS new_users,
COUNT(DISTINCT CASE WHEN first_date < date THEN user END) AS returning_users
FROM (
SELECT
date,
user,
MIN(date) OVER (PARTITION BY user) AS first_date
FROM daily_intents
) t
GROUP BY date
ORDER BY date;
Last run: about 2 months ago
1
13B
2s