msafadoostdaily sales volume
    Updated 2022-07-01
    WITH sale_volume AS (
    SELECT date(BLOCK_TIMESTAMP) as dates,
    sum(PRICE) as prices,
    'Top Shot' as label
    FROM flow.core.fact_nft_sales
    WHERE NFT_COLLECTION = 'A.0b2a3299cc857e29.TopShot'
    GROUP by 1
    UNION
    SELECT date(BLOCK_TIMESTAMP) as dates,
    sum(PRICE),
    'All Day' as label
    FROM flow.core.fact_nft_sales
    WHERE NFT_COLLECTION = 'A.e4cf4bdc1751c65d.AllDay'
    GROUP by 1
    UNION
    sELECT date(BLOCK_TIMESTAMP) as dates,
    sum(PRICE),
    'Ufc Nft' as label
    FROM flow.core.fact_nft_sales
    WHERE NFT_COLLECTION = 'A.329feb3ab062d289.UFC_NFT'
    GROUP by 1
    ),
    prices AS (
    SELECT date(TIMESTAMP) as dates2,
    avg(PRICE_USD) as prices2
    FROM flow.core.fact_prices
    WHERE SYMBOL LIKE 'FLOW'
    GROUP by 1
    )
    SELECT dates,
    label,
    sum(prices*prices2) as daily_price,
    sum(daily_price)over(partition by label order by dates)
    FROM prices JOIN sale_volume ON dates2 = dates
    GROUP by 1,2
    Run a query to Download Data