superflyNew Users
Updated 2025-01-26
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
›
⌄
WITH first_time_users AS (
SELECT
from_address AS user_address,
MIN(DATE(block_timestamp)) AS first_transaction_date
FROM
flow.core_evm.fact_transactions
GROUP BY
from_address
)
SELECT
DATE(first_transaction_date) AS date,
COUNT(*) AS new_users_count
FROM
first_time_users
WHERE
DATE(first_transaction_date) BETWEEN '{{start_date}}' AND '{{end_date}}'
GROUP BY
DATE(first_transaction_date)
ORDER BY
date
QueryRunArchived: QueryRun has been archived