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