bintuparisTotal Deposits
Updated 2025-01-20
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
›
⌄
⌄
/* '73a2yN8Qd4dN8g9RJBeHCUywMdXaKoh7LRuF7Gj9dL8Z' -- FOR COLLECTING FEES
'Ec6MuWtpvFcVyMsp7vipKCg1CMkKrWHZpWPdnJF16G57' -- CALCULATE HOW MUCH KMNO HAS BEEN STAKED OR UNSTAKED
'9DrvZvyWh1HuAoZxvYWMvkf2XCzryCpGgHqrMjyDWpmo' -- CALCULATE DEPOSIT AND WITHDRAW
*/
SELECT
ROUND (SUM(t.amount), 2) AS total_deposit_amount,
count(DISTINCT t.tx_id) AS total_deposits, count(distinct t.tx_from) AS depositors
FROM
solana.core.fact_transfers AS t
JOIN solana.core.fact_decoded_instructions AS I
ON t.tx_id = i.tx_id
WHERE
MINT = '2b1kV6DkPAnxd5ixfnxCpjxmKwqjjaYmCZfHsFu24GXo'
AND TX_TO = '9DrvZvyWh1HuAoZxvYWMvkf2XCzryCpGgHqrMjyDWpmo'
AND i.event_type = 'depositReserveLiquidityAndObligationCollateral'
QueryRunArchived: QueryRun has been archived