-- forked from 2023-02-22 04:24 PM @ https://flipsidecrypto.xyz/edit/queries/e3c9b74b-9aff-488b-a230-43b68c93abac
SELECT
COUNT(*) AS Txn_Volume,
SUM(price) AS Net_Sales,
DATE_TRUNC('month', block_timestamp) block_timestamp
FROM
flow.core.ez_nft_sales
WHERE
nft_collection = 'A.0b2a3299cc857e29.TopShot'
GROUP BY
DATE_TRUNC('month', block_timestamp)
ORDER BY
DATE_TRUNC('month', block_timestamp) DESC;