msafadoostNew Projects VS Old Projects
    Updated 2022-07-18
    WITH new_coll AS (
    SELECT min(BLOCK_TIMESTAMP) as min_date,
    NFT_COLLECTION
    FROM flow.core.fact_nft_sales
    GROUP by 2
    ),
    newc as (
    SELECT NFT_COLLECTION FROM new_coll
    WHERE min_date >= CURRENT_DATE -30
    ),
    oldc AS (
    SELECT NFT_COLLECTION FROM new_coll
    WHERE min_date < CURRENT_DATE -30
    )
    SELECT COUNT(TX_ID),
    'New Projects' as label
    FROM flow.core.fact_nft_sales
    WHERE NFT_COLLECTION IN (
    SELECT NFT_COLLECTION FROM newc
    )
    AND BLOCK_TIMESTAMP >= CURRENT_DATE - 30
    UNION
    SELECT COUNT(TX_ID),
    'Old Projects' as label
    FROM flow.core.fact_nft_sales
    WHERE NFT_COLLECTION IN (
    SELECT NFT_COLLECTION FROM oldc
    )
    AND BLOCK_TIMESTAMP >= CURRENT_DATE - 30
    Run a query to Download Data