jackguyQualified Pools
    Updated 2022-07-06
    with pools as (
    SELECT
    pool_name,
    platform,
    pool_address
    FROM ethereum.core.dim_dex_liquidity_pools
    ), tab1 as (
    SELECT
    pool_name,
    platform,
    symbol,
    avg(amount_usd) as val
    FROM flipside_prod_db.ethereum.erc20_balances
    LEFT outer JOIN pools ON user_address = pool_address
    WHERE user_address in (SELECT pool_address from pools)
    AND balance_date > CURRENT_DATE - 5
    and not amount_usd is NULL
    group BY 1,2,3
    )

    SELECT
    pool_name,
    platform,
    sum(val) as bal_usd
    from tab1
    GROUP BY 1,2
    HAVING bal_usd BETWEEN 100000 AND 1000000000





    Run a query to Download Data