princefarzamUSDH Vault
    Updated 2022-04-21
    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