bhavaniGetting Started
Updated 2024-11-05Copy Reference Fork
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 RecentWithdrawals AS (
SELECT
LIQUIDITY_POOL_ADDRESS,
LIQUIDITY_PROVIDER,
SUM(AMOUNT) AS TOTAL_WITHDRAWN,
COUNT(*) AS NUM_WITHDRAWALS
FROM
solana.defi.fact_liquidity_pool_actions
WHERE
SUCCEEDED = TRUE
AND ACTION = 'withdraw'
AND BLOCK_TIMESTAMP >= CURRENT_DATE - INTERVAL '365 DAY'
GROUP BY
LIQUIDITY_POOL_ADDRESS, LIQUIDITY_PROVIDER
),
RecentDeposits AS (
SELECT
LIQUIDITY_POOL_ADDRESS,
LIQUIDITY_PROVIDER,
SUM(AMOUNT) AS TOTAL_DEPOSITED
FROM
solana.defi.fact_liquidity_pool_actions
WHERE
SUCCEEDED = TRUE
AND ACTION = 'deposit'
AND BLOCK_TIMESTAMP >= CURRENT_DATE - INTERVAL '365 DAY'
GROUP BY
LIQUIDITY_POOL_ADDRESS, LIQUIDITY_PROVIDER
)
SELECT
w.LIQUIDITY_POOL_ADDRESS,
w.LIQUIDITY_PROVIDER,
w.TOTAL_WITHDRAWN,
d.TOTAL_DEPOSITED,
w.NUM_WITHDRAWALS,
w.TOTAL_WITHDRAWN / NULLIF(d.TOTAL_DEPOSITED, 0) AS WITHDRAW_TO_DEPOSIT_RATIO,
QueryRunArchived: QueryRun has been archived