kaibladeOpensea Most Popular Collections
    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)

    -- SELECT nft_address
    -- FROM opensea_sales
    -- WHERE project_name = 'opensea'
    -- daily_blur_sales AS
    -- (
    SELECT
    (CASE
    WHEN project_name IS NOT NULL THEN project_name
    WHEN nft_address = '0xb16dfd9aaaf874fcb1db8a296375577c1baa6f21' THEN 'Nyolings'
    WHEN nft_address = '0x8e6e63e05fffc220f808674e6ce14c82799d9f84' THEN 'Down Mother Ducks (DMD)'
    WHEN nft_address = '0x942bc2d3e7a589fe5bd4a5c6ef9727dfd82f5c8a' THEN 'Art Blocks Explorations'
    WHEN nft_address = '0x5802c586f657c787902280ac091d81832d7faf84' THEN 'Bored y00ts AC'
    Run a query to Download Data