SELECT
date_trunc('month', block_timestamp) as date,
-- project_name,
-- contract_address,
sum(price_usd) AS total_sales,
count(tx_id) AS n_sales
FROM
ethereum.nft_events
WHERE event_type = 'sale'
AND event_platform = 'opensea'
-- WHERE
-- event_platform = 'opensea' AND event_type = 'sale'
GROUP BY 1
ORDER BY 1 DESC
-- GROUP BY
-- project_name, contract_address, tx_currency
-- ORDER BY total_sales DESC