SELECT DATE_TRUNC('month', block_timestamp::DATE) AS Month, platform_name, SUM(price_usd) as USD_Volume

FROM ethereum.core.ez_nft_sales

WHERE (block_timestamp::date > '2021-06-30') AND project_name LIKE 'doodles'

GROUP BY Month, platform_name)

PIVOT (

AVG(usd_volume) FOR platform_name in ('opensea','rarible','sudoswap','x2y2','looksrare','nftx','larva labs','blur')) as p1