mlhMiami Heat
    Updated 2022-07-09
    WITH Miami_Heat AS
    (
    SELECT NFT_ID
    FROM flow.core.dim_topshot_metadata
    WHERE (TEAM IN('Miami Heat')))

    SELECT
    date_trunc('day',block_timestamp) as days,
    count (distinct tx_id) as transactions,
    sum(PRICE) as volume
    FROM flow.core.fact_nft_sales
    WHERE NFT_ID IN (SELECT NFT_ID FROM Miami_Heat)
    and block_timestamp BETWEEN '2022-05-01' and '2022-05-29'
    group by 1
    order by 1 asc
    Run a query to Download Data