2844ALL TEAMS SELLS
    Updated 2022-07-09
    select COUNT (TX_ID) AS "VOLUME", SUM(PRICE) AS "USD PRICE",
    TEAM ,
    CASE
    WHEN BLOCK_TIMESTAMP::date <'2022-05-17' THEN 'BEFORE FINAL'
    WHEN BLOCK_TIMESTAMP::date >'2022-05-16' AND BLOCK_TIMESTAMP::date <'2022-05-30' THEN 'FINAL'
    WHEN BLOCK_TIMESTAMP::date >'2022-05-29' THEN 'AFTER FINAL'
    END AS "PERIOD"
    from flow.core.fact_nft_sales S
    INNER JOIN flow.core.dim_topshot_metadata M ON S.NFT_ID=M.NFT_ID
    where S.NFT_COLLECTION = 'A.0b2a3299cc857e29.TopShot'
    and CURRENCY not in ('A.1654653399040a61.FlowToken')
    GROUP BY 3,4
    ORDER BY 2
    Run a query to Download Data