alitaslimiPools Liquidity Overview
Updated 2022-07-30
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
36
›
⌄
WITH
prices AS (
SELECT
symbol AS token,
decimals,
AVG(price) AS price
FROM
ethereum.core.fact_hourly_token_prices
WHERE
hour BETWEEN (CURRENT_DATE - 31) AND (CURRENT_DATE - 1)
AND (symbol IN ('WBTC', 'WETH', 'USDC', 'LINK', 'GNO') OR token_address = '0xc770eefad204b5180df6a14ee197d99d808ee52d')
GROUP BY
token,
decimals
),
inflows AS (
SELECT
CASE
WHEN COALESCE(event_inputs:token, event_inputs:vault, event_inputs:reserve) = '0x8e5bbbb09ed1ebde8674cda39a0c169401db4252' THEN 'WBTC'
WHEN COALESCE(event_inputs:token, event_inputs:vault, event_inputs:reserve) = '0x6a023ccd1ff6f2045c3309768ead9e68f978f6e1' THEN 'WETH'
WHEN COALESCE(event_inputs:token, event_inputs:vault, event_inputs:reserve) = '0xddafbb505ad214d7b80b1f830fccc89b60fb7a83' THEN 'USDC'
WHEN COALESCE(event_inputs:token, event_inputs:vault, event_inputs:reserve) = '0xe2e73a1c69ecf83f464efce6a5be353a37ca09b2' THEN 'LINK'
WHEN COALESCE(event_inputs:token, event_inputs:vault, event_inputs:reserve) = '0x9c58bacc331c9aa871afd802db6379a98e80cedb' THEN 'GNO'
WHEN COALESCE(event_inputs:token, event_inputs:vault, event_inputs:reserve) = '0x21a42669643f45bc0e086b8fc2ed70c23d67509d' THEN 'FOX'
ELSE COALESCE(event_inputs:token, event_inputs:vault, event_inputs:reserve)
END AS token,
SUM(event_inputs:amount) AS amount
FROM
gnosis.core.fact_event_logs
WHERE
block_timestamp::date BETWEEN (CURRENT_DATE - 31) AND (CURRENT_DATE - 1) AND event_removed = FALSE AND tx_status = 'SUCCESS'
AND origin_to_address = '0x5e15d5e33d318dced84bfe3f4eace07909be6d9c' AND contract_address = origin_to_address
AND event_name IN ('Deposit', 'Repay')
GROUP BY
token
),
Run a query to Download Data