flipside

    Golden State Warriors
    yasmin-n-d-r-hGolden State Warriors
    Updated 2022-07-11
    SELECT date(block_timestamp) as date1, COUNT(DISTINCT tx_id) as sale_volume_warriors,
    sum(sale_volume_warriors) over (order by date1) as cum_sales
    FROM flow.core.fact_nft_sales
    WHERE nft_id IN (SELECT distinct nft_id FROM flow.core.dim_topshot_metadata WHERE nft_collection LIKE '%TopShot%' AND team = 'Golden State Warriors')
    AND date1 BETWEEN '2022-05-01' AND '2022-05-31'
    GROUP by date1