MetiocreSushi fake pools
    Updated 2022-05-05
    with all_sushipools as (
    select *
    from
    ethereum.dex_liquidity_pools
    where platform = 'sushiswap' -- ) select sum(amount_usd) as "amount in usd" ,balance_date as "balance date" , platform
    )
    select
    *
    from
    ethereum.erc20_balances,
    all_sushipools
    where
    user_address = POOL_ADDRESS
    and (
    contract_address = token0
    or contract_address = token1
    )
    and balance_date >= '2022-01-01'
    and
    (amount_usd > 500000000 or amount_usd < 50000)
    Run a query to Download Data