rmasSushiSwap: Celsius and Sushi - MasterChef Staking
    Updated 2022-07-13
    WITH

    celsius_addresses AS (
    SELECT *
    FROM flipside_prod_db.crosschain.address_labels
    WHERE label_subtype = 'general_contract'
    AND lower(address_name) LIKE '%celsius%'
    ),

    liquidity_pools AS (
    SELECT
    'ethereum' AS blockchain
    , lp.pool_address
    , coalesce(t0.symbol || '-' || t1.symbol || ' SLP', lp.pool_name) AS pool_name
    , lp.token0 AS token0_address
    , (CASE WHEN lp.token0 = '0xdfe66b14d37c77f4e9b180ceb433d1b164f0281d' THEN 'stETH' ELSE t0.symbol END) AS token0_symbol
    , (CASE WHEN lp.token0 = '0xdfe66b14d37c77f4e9b180ceb433d1b164f0281d' THEN 18 ELSE t0.decimals END) AS token0_decimals
    , lp.token1 AS token1_address
    , (CASE WHEN lp.token1 = '0xdfe66b14d37c77f4e9b180ceb433d1b164f0281d' THEN 'stETH' ELSE t1.symbol END) AS token1_symbol
    , (CASE WHEN lp.token1 = '0xdfe66b14d37c77f4e9b180ceb433d1b164f0281d' THEN 18 ELSE t1.decimals END) AS token1_decimals
    FROM ethereum.core.dim_dex_liquidity_pools AS lp
    LEFT JOIN ethereum.core.dim_contracts AS t0
    ON t0.address = lp.token0
    LEFT JOIN ethereum.core.dim_contracts AS t1
    ON t1.address = lp.token1
    WHERE lp.platform = 'sushiswap'

    UNION

    SELECT
    'polygon' AS blockchain
    , pool_address
    Run a query to Download Data