msafadoostgenerated sales volume over time
    Updated 2022-07-24
    WITH top10 AS (
    SELECT {{Features}} as typess,
    sum(PRICE) as volume
    FROM flow.core.fact_nft_sales JOIN flow.core.dim_topshot_metadata USING(NFT_ID)
    WHERE TX_SUCCEEDED = 'TRUE'
    GROUP by 1
    ORDER by 2 DESC
    LIMIT 10
    ),
    types AS (
    SELECT
    DATE(BLOCK_TIMESTAMP) AS dates,
    {{Features}} as typesss,
    sum(PRICE) as volume,
    COUNT({{Features}}) as counts
    FROM flow.core.fact_nft_sales JOIN flow.core.dim_topshot_metadata USING(NFT_ID)
    WHERE TX_SUCCEEDED = 'TRUE'
    AND {{Features}} IN (
    SELECT typess
    FROM top10
    )
    GROUP by 1,2
    ),
    usd_prices AS (
    SELECT DATE(TIMESTAMP) as dates,
    avg(PRICE_USD) AS usd_price
    FROM flow.core.fact_prices
    WHERE TOKEN = 'Flow'
    GROUP by 1
    )
    SELECT dates,
    typesss,
    volume*usd_price as usd_prices,
    sum(usd_prices)over(partition by typesss ORDER by dates) as cumulative,
    counts
    FROM types JOIN usd_prices USING(dates)
    Run a query to Download Data