binhachonSushi Rewards - pools info API
    Updated 2022-01-20
    with liquidity_pools as (
    select
    pool_address,
    pool_name,
    token0,
    token1
    from ethereum.dex_liquidity_pools
    where platform ilike '%sushi%'
    ),
    liquidity_pool_token as (
    select
    user_address,
    contract_address,
    amount_usd
    from ethereum.erc20_balances
    left 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,
    count(amount_usd) as number_of_line,
    case
    when number_of_line = 1 then sum(amount_usd) * 2
    else sum(amount_usd) end
    as balance
    from liquidity_pool_token
    group by user_address
    ),
    dex_24h_volume as (
    select
    pool_address as pool_address_24h,
    sum(amount_usd) as volume_24h,
    volume_24h * 0.003 as fee_24h
    from ethereum.dex_swaps
    where block_timestamp > getdate() - interval'1 day'
    Run a query to Download Data