CODXIIIMonthly All Time Users
Updated 2023-04-14
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
›
⌄
-- forked from Daily All Time Users @ https://flipsidecrypto.xyz/edit/queries/90a5f1d5-bba8-427d-8452-2c12e42d342a
WITH table_1 AS (
SELECT
TX_ID,
BLOCK_TIMESTAMP,
PROPOSER
FROM
flow.core.fact_transactions
)
SELECT
date_trunc('month', BLOCK_TIMESTAMP) AS Date,
COUNT(DISTINCT PROPOSER) AS Users,
COUNT(DISTINCT TX_ID) AS TXS_NUM,
SUM(Users) over (ORDER BY Date) AS "Cumul User"
FROM
table_1
GROUP BY 1
ORDER BY 1
Run a query to Download Data