flipside

    Celsius farming on Sushi by pair
    articoloquintoCelsius farming on Sushi by pair
    Updated 2022-07-09
    select l."POOL_NAME" as "pool", s."SLP amount" from(
    select CONTRACT_ADDRESS, sum(AMOUNT) as "SLP amount" from ethereum.core.ez_token_transfers
    where ORIGIN_TO_ADDRESS = '0xc2edad668740f1aa35e4d8f227fb8e17dca888cd'
    and ORIGIN_FUNCTION_SIGNATURE = '0xe2bbb158'
    and ORIGIN_FROM_ADDRESS in(select ADDRESS from flipside_prod_db.crosschain.address_labels
    where PROJECT_NAME = 'celsius network')
    and SYMBOL = 'SLP'
    group by 1) as s
    inner join(
    select POOL_NAME, POOL_ADDRESS from flipside_prod_db.ethereum.dex_liquidity_pools) as l
    on s."CONTRACT_ADDRESS" = l."POOL_ADDRESS"
    order by 2 desc


    Run a query to Download Data