binhachonTracer Voters - Sushiswap
    Updated 2022-02-26
    with liquidity_pools as (
    select
    pool_address,
    pool_name,
    token0,
    token1
    from ethereum.dex_liquidity_pools
    where platform ilike '%sushi%'
    and (token0 = '0x9c4a4204b79dd291d6b6571c5be8bbcd0622f050' or token1 = '0x9c4a4204b79dd291d6b6571c5be8bbcd0622f050')
    ),
    liquidity_pool_token as (
    select
    user_address,
    contract_address,
    pool_name,
    amount_usd
    from ethereum.erc20_balances
    inner join liquidity_pools on (user_address = pool_address and (contract_address = token0 or contract_address = token1))
    where balance_date in (select distinct balance_date from ethereum.erc20_balances order by balance_date desc limit 1)
    ),
    account_balance as (
    select
    user_address,
    pool_name,
    count(amount_usd) as number_of_line,
    case
    when number_of_line = 1 then sum(coalesce(amount_usd,0)) * 2
    else sum(coalesce(amount_usd,0)) end
    as balance
    from liquidity_pool_token
    group by user_address, pool_name
    order by balance desc
    limit 3
    ),
    SLP_raw_transactions as (
    select
    Run a query to Download Data