Updated 2022-04-19

    SELECT DISTINCT pool_name
    from ethereum.dex_swaps D
    where block_timestamp::date > '2022-01-15'
    and platform <>'curve'
    and platform <> 'sushiswap'
    and AMOUNT_USD is not null
    and AMOUNT_USD > 10000000



    and pool_name is not like '%BurnX-WETH LP%'
    and pool_name is not like '%MGH-WETH 3000 60 UNI-V3 LP%'
    and pool_name is not like '%QOM-WETH LP%'
    and pool_name is not like '%BUILD-WETH LP%'
    and pool_name is not like '%WETH-BEAN UNI-V2 LP%'
    and pool_name is not like '%CAT-WETH LP%'
    and pool_name is not like '%WETH-BEAN UNI-V2 LP%'
    and pool_name is not like '%CAT-WETH LP%'
    and pool_name is not like '%LAMBO-WETH LP%'
    and pool_name is not like '%SHINTAMA-WETH LP%'
    and pool_name is not like '%Para-WETH LP%'
    and pool_name is not like '%SHIBURN-WETH LP%'
    and pool_name is not like '%VOLT-WETH LP%'
    and pool_name is not like '%COLLAR-WETH LP%'
    and pool_name is not like '%$WEAPON-WETH LP%'
    and pool_name is not like '%ABC-WETH LP%'
    and pool_name is not like '%EVDC-WETH LP%'
    and pool_name is not like '%UTD-USDC 10000 200 UNI-V3 LP%'



    Run a query to Download Data