piperBase - Active Wallets copy
Updated 2023-10-14
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
›
⌄
SELECT
TO_CHAR(BLOCK_TIMESTAMP, 'YYYY-MM-DD') AS "Date",
COUNT(DISTINCT FROM_ADDRESS) AS "Daily Actice Wallets",
SUM("Daily Actice Wallets") OVER (ORDER BY "Date") AS "Total Active Wallets (Cum.)",
CASE
WHEN (BLOCK_TIMESTAMP >= '2023-08-09' AND BLOCK_TIMESTAMP < '2023-09-10') THEN '1st month'
WHEN (BLOCK_TIMESTAMP >= '2023-09-11' AND BLOCK_TIMESTAMP < '2023-10-10') THEN '2nd month'
END AS result
FROM
base.core.fact_transactions
WHERE
BLOCK_TIMESTAMP >= '2023-08-09' AND BLOCK_TIMESTAMP <= '2023-10-10'
AND
STATUS = 'SUCCESS'
GROUP BY 1, 4
ORDER BY 1 DESC
Run a query to Download Data