KaskoazulUntitled Query
Updated 2023-01-20
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
WITH users_first_interaction AS (
SELECT
tx_signer
, min(block_timestamp) as first_date
FROM
near.core.fact_transactions
WHERE
tx_receiver = 'social.near'
GROUP BY
tx_signer
)
SELECT
first_date::DATE as fecha
, COUNT(DISTINCT tx_signer) AS daily_new_users
, SUM(daily_new_users) OVER (ORDER BY fecha) AS cumulative_new_users
FROM
users_first_interaction
GROUP BY
fecha
ORDER BY
fecha DESC
-- WITH tx_with_method AS (
-- SELECT
-- ft.block_timestamp
-- , ft.tx_hash
-- , ft.action_id
-- --, SPLIT(ft.action_id, '-', 2) AS action_no
-- , ft.action_name
-- , ft.method_name
-- , ft.args
-- , ft.deposit / POW(10,24) AS deposit_near
Run a query to Download Data