princefarzamThe most popular pools where users are depositing USDH
Updated 2022-04-21
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 SABER_USDC AS(
SELECT
SUM(INNER_INSTRUCTION:instructions[0]:parsed:info:amount::INT)/1e6 AS USDH_AMOUNT
FROM solana.fact_events
WHERE INDEX = 1
AND PROGRAM_ID = 'SSwpkEEcbUqx4vtoEByFjSkhKdCT862DNVb52nZg1UZ'
AND INSTRUCTION:accounts[5]::string='6YjT74rmcfCpw8LSjPNx5JTmZoYLGrTKnf9arfSgZ4SR' --USDH wallet address for saber
),
SABER_solUST AS (
SELECT
SUM(INNER_INSTRUCTION:instructions[1]:parsed:info:amount::INT)/1e6 AS USDH_AMOUNT
FROM solana.fact_events
WHERE INDEX = 1
AND PROGRAM_ID = 'SSwpkEEcbUqx4vtoEByFjSkhKdCT862DNVb52nZg1UZ'
AND INSTRUCTION:accounts[6]::string='6rkPHSqZb7StM4HwS9EuVrmfkV7tRdc7dnsFhyB6cefE' --USDH wallet address for saber
),
MERCURIAL_USDT_USDC AS (
SELECT
SUM(INNER_INSTRUCTION:instructions[0]:parsed:info:amount::INT)/1e6 AS USDH_AMOUNT
FROM solana.fact_events
WHERE PROGRAM_ID = 'MERLuDFBMmsHnsBPZw2sDQZHvXFMwp8EdjudcU2HKky'
AND INDEX = 4
AND INSTRUCTION:accounts[4]::string='3bFWy2hz9yGxvbgoRmzjUqkoYbCTWUDu7sZPHUYV39Pf' --USDH wallet address for mercurial
AND INNER_INSTRUCTION:instructions[0]:parsed:info:amount::INT <> 0
),
SOLEND AS (
SELECT
SUM(INNER_INSTRUCTION:instructions[0]:parsed:info:amount::INT)/1e6 AS USDH_AMOUNT
FROM solana.fact_events
WHERE INDEX = 3
AND PROGRAM_ID='So1endDq2YkqhipRh3WViPa8hdiSpxWy6z3Z6tMCpAo'
AND INSTRUCTION:accounts[3]::string='BMgsTqMrAYg2mvpqWYYkzUDjhVmipZjVMGRFE9z5y8GF' --solend account
AND INSTRUCTION:accounts[4]::string='DE9WN39kGuqZwsBpmd8Fs8F7b4T38nzpiNo8DseznLBU' --USDH pool
),
Run a query to Download Data