owene20LendingPool_Flows
Updated 2024-12-17
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
›
⌄
-- Big, dumb query to get values of flows into lending platforms and calculate utilization rates
-- Note about protocol_market: these are the internal token addresses, NOT the pool IDS
-- May need to do more work to match to pools...
WITH DEPS AS (
SELECT
date(BLOCK_TIMESTAMP) as Date,
SUM(AMOUNT) as DEPOSITS,
Platform, protocol_market, Token_address, token_symbol
FROM ethereum.defi.ez_lending_deposits
-- WHERE DEPS.PLATFORM IN ('Aave V2', 'Aave V3', 'Compound V2', 'Compound V3')
WHERE Platform IN ('Aave V2', 'Aave V3')
GROUP BY Date, Platform, protocol_market, Token_address, token_symbol
),
BORS AS(
SELECT
date(BLOCK_TIMESTAMP) as Date,
SUM(AMOUNT) as BORROWS,
Platform, protocol_market, Token_address, token_symbol
FROM ethereum.defi.ez_lending_borrows
-- WHERE DEPS.PLATFORM IN ('Aave V2', 'Aave V3', 'Compound V2', 'Compound V3')
WHERE Platform IN ('Aave V2', 'Aave V3')
GROUP BY Date, Platform, protocol_market, Token_address, token_symbol
),
WITHS AS(
SELECT
date(BLOCK_TIMESTAMP) as Date,
SUM(AMOUNT) as WITHDRAWS,
Platform, protocol_market, Token_address, token_symbol
FROM ethereum.defi.ez_lending_withdraws
-- WHERE DEPS.PLATFORM IN ('Aave V2', 'Aave V3', 'Compound V2', 'Compound V3')
WHERE Platform IN ('Aave V2', 'Aave V3')
GROUP BY Date, Platform, protocol_market, Token_address, token_symbol
),
-- Liquidations affect both deposits and borrows, as liquidated collateral used to close positions
-- For the sake of utilization rate, liquidations come in twice: both for the collateral and the borrowed asset
QueryRunArchived: QueryRun has been archived