zakkisyedTop 25 Projects by Volume
    Updated 2023-04-06
    WITH weekly_sales AS (
    SELECT
    PLATFORM_NAME,
    PROJECT_NAME,
    DATE_TRUNC('week', BLOCK_TIMESTAMP) AS week,
    SUM(PRICE_USD) AS sale_volume
    FROM
    ethereum.core.ez_nft_sales
    WHERE
    BLOCK_TIMESTAMP >= '2022-01-01'
    AND PROJECT_NAME IS NOT NULL
    GROUP BY
    1, 2, 3
    ),

    weekly_rankings AS (
    SELECT
    PLATFORM_NAME,
    week,
    PROJECT_NAME,
    sale_volume,
    RANK() OVER (PARTITION BY PLATFORM_NAME, week ORDER BY sale_volume DESC) AS ranking
    FROM
    weekly_sales


    )

    SELECT
    PLATFORM_NAME,
    week,
    PROJECT_NAME,
    sale_volume
    FROM
    weekly_rankings
    WHERE
    Run a query to Download Data