winnie-fsUsers copy
Updated 2024-07-30
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
›
⌄
-- forked from Azin / Users @ https://flipsidecrypto.xyz/Azin/q/GGNWjNtLpJpB/users
WITH T1 AS
(SELECT
MIN(BLOCK_TIMESTAMP )AS DOTE
, ORIGIN_FROM_ADDRESS
FROM
kaia.core.fact_event_logs
GROUP BY 2)
SELECT
COUNT(*) AS "New users"
, DOTE::DATE AS Date
, SUM(COUNT(*)) OVER (ORDER BY DATE) AS "Total users"
FROM
T1
WHERE
DOTE IS NOT NULL
GROUP BY 2
ORDER BY 2 DESC
QueryRunArchived: QueryRun has been archived