elvisSOL Q1.3 Total Liquidity in Saber's daoSOL-SOL
Updated 2022-05-03
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
›
⌄
SELECT date_trunc('hour', block_timestamp) as dt, AVG(WSOL), AVG(DAOSOL) FROM (
SELECT block_timestamp,
posttokenbalances[0]:uiTokenAmount:uiAmount as amount0, posttokenbalances[0]:mint as mint0, posttokenbalances[0]:owner as owner0,
posttokenbalances[1]:uiTokenAmount:uiAmount as amount1, posttokenbalances[1]:mint as mint1, posttokenbalances[1]:owner as owner1,
posttokenbalances[2]:uiTokenAmount:uiAmount as amount2, posttokenbalances[2]:mint as mint2, posttokenbalances[2]:owner as owner2,
posttokenbalances[3]:uiTokenAmount:uiAmount as amount3, posttokenbalances[3]:mint as mint3, posttokenbalances[3]:owner as owner3,
posttokenbalances[4]:uiTokenAmount:uiAmount as amount4, posttokenbalances[4]:mint as mint4, posttokenbalances[4]:owner as owner4,
posttokenbalances[5]:uiTokenAmount:uiAmount as amount5, posttokenbalances[5]:mint as mint5, posttokenbalances[5]:owner as owner5,
CASE
WHEN mint0 = 'So11111111111111111111111111111111111111112' AND owner0 = '41CKnj1gy1AXQ1nf2dB9Ubst3QGHxjWkFLd78KLpGYsr' THEN amount0
WHEN mint1 = 'So11111111111111111111111111111111111111112' AND owner1 = '41CKnj1gy1AXQ1nf2dB9Ubst3QGHxjWkFLd78KLpGYsr' THEN amount1
WHEN mint2 = 'So11111111111111111111111111111111111111112' AND owner2 = '41CKnj1gy1AXQ1nf2dB9Ubst3QGHxjWkFLd78KLpGYsr' THEN amount2
WHEN mint3 = 'So11111111111111111111111111111111111111112' AND owner3 = '41CKnj1gy1AXQ1nf2dB9Ubst3QGHxjWkFLd78KLpGYsr' THEN amount3
WHEN mint4 = 'So11111111111111111111111111111111111111112' AND owner4 = '41CKnj1gy1AXQ1nf2dB9Ubst3QGHxjWkFLd78KLpGYsr' THEN amount4
WHEN mint5 = 'So11111111111111111111111111111111111111112' AND owner5 = '41CKnj1gy1AXQ1nf2dB9Ubst3QGHxjWkFLd78KLpGYsr' THEN amount5
END as WSOL,
CASE
WHEN mint0 = 'GEJpt3Wjmr628FqXxTgxMce1pLntcPV4uFi8ksxMyPQh' AND owner0 = '41CKnj1gy1AXQ1nf2dB9Ubst3QGHxjWkFLd78KLpGYsr' THEN amount0
WHEN mint1 = 'GEJpt3Wjmr628FqXxTgxMce1pLntcPV4uFi8ksxMyPQh' AND owner1 = '41CKnj1gy1AXQ1nf2dB9Ubst3QGHxjWkFLd78KLpGYsr' THEN amount1
WHEN mint2 = 'GEJpt3Wjmr628FqXxTgxMce1pLntcPV4uFi8ksxMyPQh' AND owner2 = '41CKnj1gy1AXQ1nf2dB9Ubst3QGHxjWkFLd78KLpGYsr' THEN amount2
WHEN mint3 = 'GEJpt3Wjmr628FqXxTgxMce1pLntcPV4uFi8ksxMyPQh' AND owner3 = '41CKnj1gy1AXQ1nf2dB9Ubst3QGHxjWkFLd78KLpGYsr' THEN amount3
WHEN mint4 = 'GEJpt3Wjmr628FqXxTgxMce1pLntcPV4uFi8ksxMyPQh' AND owner4 = '41CKnj1gy1AXQ1nf2dB9Ubst3QGHxjWkFLd78KLpGYsr' THEN amount4
WHEN mint5 = 'GEJpt3Wjmr628FqXxTgxMce1pLntcPV4uFi8ksxMyPQh' AND owner5 = '41CKnj1gy1AXQ1nf2dB9Ubst3QGHxjWkFLd78KLpGYsr' THEN amount5
END as DAOSOL
FROM solana.events WHERE block_timestamp >= '2022-02-01T00:00:00Z'
AND index = 4
--AND tx_id = '5ptLnEaEAjC45QRKGS8RLDFp3UwdzarWSuN65yT2inV1WuFha7HE8bvREHzs1KTSyrSLRHhJG7darVj6dav4Lrow'
AND inner_instruction:instructions[2]:parsed:info:mint = 'monKYjV2bHTjbJVWCCcwhxE8C96sdTKR2HUNUHCjh4z'
AND inner_instruction:instructions[2]:parsed:info:mintAuthority = '41CKnj1gy1AXQ1nf2dB9Ubst3QGHxjWkFLd78KLpGYsr'
AND succeeded = TRUE
)
GROUP BY dt
--LIMIT 10
Run a query to Download Data