Mikey_Celsius and Sushi 1 - 1
Updated 2022-07-10Copy Reference Fork
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
›
⌄
WITH address AS(
SELECT DISTINCT ADDRESS AS address
FROM flipside_prod_db.crosschain.address_labels
WHERE PROJECT_NAME ILIKE '%Celsius %' AND LABEL_SUBTYPE NOT ILIKE '%token%'
),
borrow AS
(
SELECT origin_from_address, AMOUNT_IN_USD
FROM flipside_prod_db.crosschain.ez_swaps
WHERE AMOUNT_IN_USD is not null AND platform = 'sushiswap' AND origin_from_address <> pool_address
)
SELECT SUM(tu.AMOUNT_IN_USD), ty.address
FROM address ty
JOIN borrow tu
ON tu.origin_from_address = ty.address
GROUP BY 2
Run a query to Download Data