-- forked from metricsdao / [10] MDAO 101: SQL WHERE BETWEEN @ https://flipsidecrypto.xyz/metricsdao/q/09-mdao-101-sql-where-in-JD0IC2
-- MetricsDAO Blockchain Analytics 101
-- https://docs.metricsdao.xyz/analyst-resources/blockchain-data-101
SELECT
*
FROM ethereum.core.ez_nft_sales
WHERE transaction_date::DATE BETWEEN '2022-10-01' AND '2022-10-31'
AND status = 'successful';