Rodolfo-LimaLP Provider Over Time
Updated 2022-08-23
99
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
›
⌄
WITH SUSHI_TVL AS (
SELECT
BALANCE_DATE,
POOL_NAME,
LP.POOL_ADDRESS,
SUM(AMOUNT_USD) AS TVL
FROM
ethereum.core.dim_dex_liquidity_pools LP
INNER JOIN flipside_prod_db.ethereum.erc20_balances BAL ON BAL.USER_ADDRESS = LP.POOL_ADDRESS
WHERE BALANCE_DATE >= CURRENT_DATE - INTERVAL '90days'
AND AMOUNT_USD > 0
AND LP.PLATFORM = 'sushiswap'
GROUP BY 1,2,3
ORDER BY 1 ASC
),
LP_PROVIDER_DEPOSIT AS (
SELECT
E.BLOCK_TIMESTAMP::DATE AS DATE,
POOL_NAME,
COUNT(DISTINCT(E.ORIGIN_FROM_ADDRESS)) AS UNIQUE_ADDRESS
FROM
ethereum.core.fact_event_logs E
INNER JOIN SUSHI_TVL B ON B.POOL_ADDRESS = E.EVENT_INPUTS:to::STRING
WHERE E.EVENT_INPUTS:to::STRING IN (SELECT POOL_ADDRESS FROM SUSHI_TVL)
GROUP BY 1,2
ORDER BY 1 ASC, 3 DESC
)
SELECT
*
FROM LP_PROVIDER_DEPOSIt
limit 1000
Run a query to Download Data