OneDataAnalystTotal Stats
    Updated 2022-10-30
    WITH t1 AS (
    SELECT BLOCK_TIMESTAMP, MARKETPLACE, PURCHASER, SELLER, MINT, SALES_AMOUNT
    FROM solana.core.fact_nft_sales
    WHERE SUCCEEDED = 'TRUE'
    AND MARKETPLACE IN ('hyperspace', 'coral cube')
    )

    SELECT
    MARKETPLACE,
    SUM(SALES_AMOUNT) AS Sales_vol,
    COUNT(*) AS Sales,
    COUNT(DISTINCT PURCHASER) AS buyers,
    COUNT(DISTINCT SELLER) AS Sellers,
    SUM(SALES_AMOUNT)/COUNT(DISTINCT BLOCK_TIMESTAMP::DATE) AS Sale_vol_per_day,
    COUNT(*)/COUNT(DISTINCT BLOCK_TIMESTAMP::DATE) AS Sales_per_day,
    SUM(SALES_AMOUNT)/COUNT(*) AS Sale_vol_per_sale,
    COUNT(*)/COUNT(DISTINCT PURCHASER) AS Purchase_per_buyer,
    COUNT(DISTINCT BLOCK_TIMESTAMP::DATE) AS age

    FROM t1

    GROUP BY 1
    ORDER BY 1
    Run a query to Download Data