rackhaelFLOW 1 concept
Updated 2023-04-14
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
›
⌄
WITH cte AS (
SELECT
DATE_TRUNC('DAY', MIN(BLOCK_TIMESTAMP)) AS date,
PAYER AS user,
TX_ID
FROM flow.core.fact_transactions
WHERE DATE_TRUNC('YEAR', BLOCK_TIMESTAMP) >= '2023-01-01'
GROUP BY PAYER, TX_ID
)
SELECT
date,
COUNT(DISTINCT user) AS new_users,
COUNT(TX_ID) AS transactions_per_day
FROM cte
GROUP BY date
ORDER BY date;
Run a query to Download Data