zakkisyedDaily users
    Updated 2023-06-12
    WITH daily_users AS (
    SELECT
    PLATFORM_NAME,
    DATE_TRUNC('day', BLOCK_TIMESTAMP) AS dt,
    COUNT(DISTINCT BUYER_ADDRESS) AS unique_users
    FROM
    ethereum.core.ez_nft_sales
    WHERE
    BLOCK_TIMESTAMP >= '2022-01-01'
    GROUP BY
    1, 2
    )

    SELECT
    PLATFORM_NAME,
    daily_users.dt AS date,
    daily_users.unique_users AS daily_users,
    daily_users.unique_users - LAG(daily_users.unique_users, 1) OVER (PARTITION BY PLATFORM_NAME ORDER BY daily_users.dt) AS daily_users_change,
    100 * (daily_users.unique_users - LAG(daily_users.unique_users, 1) OVER (PARTITION BY PLATFORM_NAME ORDER BY daily_users.dt)) / LAG(daily_users.unique_users, 1) OVER (PARTITION BY PLATFORM_NAME ORDER BY daily_users.dt) AS daily_users_change_pct
    FROM
    daily_users
    ORDER BY
    PLATFORM_NAME, date ASC

    Run a query to Download Data