binhachonCopy of Untitled Query
    Updated 2022-01-23
    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,
    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
    tx_id,
    Run a query to Download Data