mlhUntitled Query
    Updated 2022-11-23
    SELECT date_trunc('month', block_timestamp) as month,
    PLATFORM_NAME,
    count(DISTINCT tx_hash) as sales,
    COUNT(DISTINCT BUYER_ADDRESS) as buyers,
    sum(PRICE_USD) as sales_volume,
    (sum(PRICE_USD))/(COUNT(DISTINCT BUYER_ADDRESS)) as avg_usd_per_buyer
    FROM ethereum.core.ez_nft_sales
    WHERE nft_address LIKE lower('0x629A673A8242c2AC4B7B8C5D8735fbeac21A6205')
    GROUP BY 1,2
    Run a query to Download Data