Zanyar_98Number of new users - Daily chart
    Updated 2022-11-07
    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