0xHaM-dUntitled Query
    Updated 2023-04-03
    SELECT
    'Blur' as marketplace,
    ROUND(COUNT(DISTINCT TX_HASH)/COUNT(DISTINCT BUYER_ADDRESS),0) AS volume,
    ROUND(SUM(PRICE)/COUNT(DISTINCT BUYER_ADDRESS),0) AS amount
    FROM ethereum.core.ez_nft_sales
    WHERE PLATFORM_NAME = 'blur'
    UNION ALL
    SELECT
    'Hyperspace' as marketplace,
    ROUND(COUNT(DISTINCT TX_id)/COUNT(DISTINCT PURCHASER),0) AS volume,
    ROUND(SUM(SALES_AMOUNT)/COUNT(DISTINCT PURCHASER),0) AS amount
    FROM solana.core.fact_nft_sales
    WHERE marketplace = 'hyperspace'
    Run a query to Download Data