zakkisyedSushi LP vs Sushi Token holders
    Updated 2022-02-09
    with

    pools as(
    select pool_address, pool_name
    from ethereum.dex_liquidity_pools
    where platform = 'sushiswap'
    ),
    pools_holding as (
    select count(contract_address) as holders, avg(balance) as avg_holdings, contract_address, pool_name
    from ethereum.erc20_balances
    join pools
    on pools.pool_address = erc20_balances.contract_address
    where contract_address IN (select pool_address from pools)
    and balance_date = '2022-01-05'
    and balance is not null
    group by contract_address, pool_name
    order by holders desc
    limit 20
    ),
    sushi_holder_addresses as (
    select contract_address, balance, user_address, 'SUSHI' as pool_name
    from ethereum.erc20_balances
    join (
    select user_address as lp_user
    from ethereum.erc20_balances
    join pools
    on pools.pool_address = erc20_balances.contract_address
    where contract_address IN (select pool_address from pools)
    and balance_date = '2022-01-05'
    and balance is not null
    ) lps
    on user_address = lps.lp_user
    where contract_address = '0x6b3595068778dd592e39a122f4f5a5cf09c90fe2'
    and balance_date = '2022-01-05'
    ),
    Run a query to Download Data