-- SELECT
-- COUNT (tx_hash) as "n_address"
-- FROM ethereum.core.fact_transactions
-- WHERE
--Block_timestamp BETWEEN '2022-10-01' AND '2022-11-01'
--SELECT
--COUNT (tx_hash) as "number of NFT sales"
--FROM ethereum.core.ez_nft_sales
-- WHERE Block_timestamp BETWEEN '2022-10-01' AND '2022-11-01'
SELECT *
FROM ethereum.core.ez_dex_swaps
WHERE event_name = 'Swap'
BETWEEN '2022-10-01' AND '2022-11-01'
AND platform = 'Uniswap-v2'