rmasSushiSwap: Celsius and Sushi - MasterChef Staking
Updated 2022-07-13
999
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
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