msafadoostNFL ALL DAY sales volume growth
    Updated 2022-09-05
    WITH sale_volume AS (

    SELECT date(BLOCK_TIMESTAMP) as dates,
    sum(PRICE) as prices,
    COUNT(TX_ID) AS number_of_sales,
    COUNT(DISTINCT(buyer)) AS number_of_buyers,
    COUNT(DISTINCT(seller)) AS number_of_sellers
    FROM flow.core.fact_nft_sales
    WHERE NFT_COLLECTION = 'A.e4cf4bdc1751c65d.AllDay'
    AND BLOCK_TIMESTAMP >= '2022-08-04'
    AND BLOCK_TIMESTAMP <= '2022-08-28'
    AND TX_SUCCEEDED = 'TRUE'
    GROUP by 1
    ),
    prices AS (
    SELECT date(TIMESTAMP) as dates,
    avg(PRICE_USD) as prices2
    FROM flow.core.fact_prices
    WHERE SYMBOL LIKE 'FLOW'
    AND TIMESTAMP >= '2022-08-04'
    AND TIMESTAMP <= '2022-08-28'
    GROUP by 1
    )
    SELECT dates,
    sum(prices*prices2) as daily_price,
    sum(daily_price)over(order by dates) as cumulative_price,
    number_of_sales,
    sum(number_of_sales)over(order by dates) as cumulative_sales,
    number_of_buyers,
    number_of_sellers
    FROM prices JOIN sale_volume USING(dates)
    GROUP by 1,4,6,7
    ORDER by 1

    Run a query to Download Data