kaibladeBlur NFT Sales Volume Stats
    Updated 2022-12-10
    WITH nft_sales AS
    (SELECT *
    FROM ethereum.core.ez_nft_sales
    WHERE block_timestamp::date >= CURRENT_DATE - INTERVAL '2 months'
    ),

    blur_sales AS
    (SELECT *, 'WETH' AS symbol
    FROM nft_sales
    WHERE platform_name = 'blur'),

    opensea_sales AS
    (SELECT *
    FROM nft_sales
    WHERE platform_name = 'opensea'),


    eth_price AS
    (SELECT hour, decimals, symbol
    FROM ethereum.core.fact_hourly_token_prices
    WHERE symbol = 'WETH'
    ORDER BY hour DESC
    LIMIT 1),

    daily_blur_sales AS
    (SELECT DATE_TRUNC('day', block_timestamp) AS "Days", COUNT(tx_hash) AS "Sales Volume"
    FROM blur_sales
    GROUP BY "Days")

    SELECT (SELECT SUM ("Sales Volume") FROM daily_blur_sales) AS total_sales_volume,
    (SELECT AVG ("Sales Volume") FROM daily_blur_sales) AS avg_sales_volume,
    (SELECT MAX("Sales Volume") FROM daily_blur_sales) AS max_sales_volume,
    (SELECT MIN("Sales Volume") FROM daily_blur_sales) AS min_sales_volume



    Run a query to Download Data