--SELECT
-- COUNT (tx_hash) as n_swaps,
-- COUNT (DISTINCT tx_hash) as "Number of transactions"
--FROM ethereum.core.ez_dex_swaps
--WHERE
-- (pool_name LIKE 'ENS-%'
-- OR pool_name LIKE '%-ENS %')
-- AND (block_timestamp::DATE BETWEEN '2022-12-01' AND '2022-12-31')
SELECT *
FROM ethereum.core.fact_transactions
WHERE
block_timestamp :: DATE BETWEEN '2022-10-01' AND '2022-10-31'