StangFAST05 - Type active day
Updated 2023-04-13
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 new_users as (
SELECT
c.proposer
, min( c.block_timestamp ) AS min_date
FROM
flow.core.fact_transactions c
GROUP BY
1
ORDER BY
1 DESC
)
,
conclus AS
(
SELECT
a.proposer
, count( DISTINCT( a.block_timestamp::date ) ) AS active_days
, count( DISTINCT( a.tx_id ) ) AS transaction_count
FROM
flow.core.fact_transactions a
INNER JOIN
new_users b
ON a.proposer = b.proposer
WHERE
a.block_timestamp::date < '2023-04-01'
Run a query to Download Data