msafadoostTotal sale volume over NBA Conference Finals period for all teams
    Updated 2022-07-08
    SELECT
    TEAM,
    sum(PRICE) as volume
    FROM flow.core.fact_nft_sales JOIN flow.core.dim_topshot_metadata
    ON flow.core.fact_nft_sales.NFT_ID = flow.core.dim_topshot_metadata.NFT_ID
    WHERE BLOCK_TIMESTAMP >= '2022-05-17'
    AND BLOCK_TIMESTAMP < '2022-05-30'
    and flow.core.fact_nft_sales.NFT_COLLECTION = 'A.0b2a3299cc857e29.TopShot'
    AND TX_SUCCEEDED = 'TRUE'
    GROUP by 1
    ORDER by 2 DESC
    Run a query to Download Data