princefarzamUSDH Vault
Updated 2022-04-21
9
1
2
3
4
5
6
7
8
9
›
⌄
SELECT
date_trunc('day',BLOCK_TIMESTAMP) AS DAY,
sum(INNER_INSTRUCTION:instructions[0]:parsed:info:amount::INT)/1e6 AS amount_deposited
FROM solana.fact_events
WHERE INDEX = 0
AND PROGRAM_ID='HubbLeXBb7qyLHt3x7gvYaRrxQmmgExb7fCJgDqFuB6T'
AND INSTRUCTION:accounts[8]::string='GE6PqKhREVLRTGZs7rV5mJ2L3FAcj2fqohWCzTjhCTdQ'
GROUP BY 1
ORDER BY 1 ASC
Run a query to Download Data