-- forked from metricsdao / [03] MDAO 101: SQL WHERE @ https://flipsidecrypto.xyz/metricsdao/q/mdao-101-sql-select-statement-2-IX1O9a
-- MetricsDAO Blockchain Analytics 101
-- https://docs.metricsdao.xyz/analyst-resources/blockchain-data-101
SELECT
*
FROM ethereum.core.fact_transactions
WHERE block_timestamp::DATE BETWEEN '2022-10-01' AND '2022-11-01'
LIMIT 4;