metricsdao[12] MDAO 101: SQL COUNT
    Updated 2023-03-16
    -- 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'
    );
    Run a query to Download Data