princefarzamThe amount of USDH deposited on the solend pool
    Updated 2022-04-20
    SELECT
    date_trunc('day',BLOCK_TIMESTAMP) AS DAY,
    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
    GROUP BY 1
    ORDER BY 1 ASC

    Run a query to Download Data