-- MetricsDAO Blockchain Analytics 101
-- https://docs.metricsdao.xyz/analyst-resources/blockchain-data-101
select
count(distinct tx_hash) as unique_transactions
from ethereum.core.ez_dex_swaps
where block_timestamp between '2022-06-01' and '2022-06-30'
and pool_name in
(
'ENS-WETH LP',
'USDC-ENS LP',
'WETH-ENS LP'
);