shadabBTC_USERS
Updated 2024-11-21
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
›
⌄
SELECT
date_trunc('day', first_tx) as days,
count(DISTINCT PUBKEY_SCRIPT_ADDRESS) as new_users,
sum(new_users) over(
ORDER BY
days
) as cumulative_users
FROM
(
SELECT
PUBKEY_SCRIPT_ADDRESS,
min(block_timestamp) as first_tx
FROM
bitcoin.core.fact_outputs
GROUP BY
1
)
GROUP BY
1
QueryRunArchived: QueryRun has been archived