Zanyar_98Number of new users - Daily chart
Updated 2022-11-07Copy Reference Fork
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
›
⌄
WITH New_Users AS (
SELECT MIN(BLOCK_TIMESTAMP) AS "Start activity", From_Address
FROM optimism.core.fact_transactions
GROUP BY From_Address
HAVING "Start activity"::DATE BETWEEN '2022-07-01' AND '2022-07-31'
),
OP_PRICE AS
(SELECT HOUR::DATE "Days", AVG(PRICE) "Op price($)"
FROM optimism.core.fact_hourly_token_prices WHERE
"Days" BETWEEN '2022-07-01' AND '2022-07-31' AND TOKEN_ADDRESS = '0x4200000000000000000000000000000000000042'
GROUP BY "Days"),
Daily_New_Users AS (
SELECT "Start activity"::DATE AS DAYS, COUNT(FROM_Address) "Number of new users"
FROM New_Users
WHERE Days BETWEEN '2022-07-01' AND '2022-07-31' GROUP BY DAYS)
SELECT DAYS, "Number of new users","Op price($)"
FROM Daily_New_Users JOIN OP_PRICE ON (Days = "Days")
Run a query to Download Data