Updated 2022-11-21
    SELECT
    date_trunc('WEEK', block_timestamp) as date,
    COUNT(DISTINCT TX_ID) as Nft_Sales,
    COUNT(DISTINCT BUYER) as Buyers ,
    COUNT(DISTINCT NFT_ID) as New_NFTs ,
    COUNT(DISTINCT NFT_COLLECTION) as New_NFT_Collections ,
    sum(PRICE) as volume,
    sum(Buyers) over (order by date) as cumulative_Buyers_growth,
    sum(Nft_Sales) over (order by date) as cumulative_Nft_Sales_growth,
    sum(volume) over (order by date) as cumulative__volume_growth
    FROM flow.core.ez_nft_sales WHERE TX_SUCCEEDED='TRUE'AND date > CURRENT_DATE - 365
    GROUP by 1
    order by date desc
    Run a query to Download Data