crypto_gostTotal sale
    Updated 2024-12-17
    WITH recent_sales AS (
    SELECT
    project_name,
    SUM(price_usd) AS total_sales_usd,
    COUNT(*) AS total_transactions
    FROM
    AVALANCHE.nft.ez_nft_sales
    WHERE
    project_name ILIKE '%HatchyPocket%';
    AND block_timestamp >= DATEADD(DAY, -30, CURRENT_TIMESTAMP)
    AND event_type = 'sale'
    GROUP BY
    project_name
    ),
    all_time_sales AS (
    SELECT
    project_name,
    SUM(price_usd) AS total_sales_usd,
    COUNT(*) AS total_transactions
    FROM
    AVALANCHE.nft.ez_nft_sales
    WHERE
    project_name ILIKE '%HatchyPocket%'
    AND event_type = 'sale'
    GROUP BY
    project_name
    )
    SELECT
    rs.project_name,
    rs.total_sales_usd AS sales_last_30_days_usd,
    rs.total_transactions AS transactions_last_30_days,
    ats.total_sales_usd AS all_time_sales_usd,
    ats.total_transactions AS all_time_transactions
    FROM
    recent_sales rs
    JOIN
    Last run: 2 months ago
    PROJECT_NAME
    SALES_LAST_30_DAYS_USD
    TRANSACTIONS_LAST_30_DAYS
    ALL_TIME_SALES_USD
    ALL_TIME_TRANSACTIONS
    1
    HatchyPocket281.05371711601.5336190311048
    2
    HatchyPocket Gen21482.31984418650866.1320604757207
    3
    HatchyPocket Gen2 Eggs26.314342748.17497958493
    3
    165B
    2s