SELECT tx_id

FROM solana.core.fact_events

WHERE program_id = 'A66HabVL3DzNzeJgcHYtRRNW1ZRMKwBfrdSR4kLsZ9DJ'

AND succeeded = 'True'

AND block_timestamp > '2022-05-19'

AND block_timestamp <= CURRENT_DATE - 1

), loans AS (

SELECT date_trunc('day', block_timestamp) AS day,

CASE

WHEN account_keys::string ILIKE '%FuydvCEeh5sa4YyPzQuoJFBRJ4sF5mwT4rbeaWMi3nuN%' THEN 'Flip'

ELSE 'Perpetual'

END AS loan_type

FROM solana.core.fact_transactions

WHERE log_messages[1] = 'Program log: Instruction: ApproveLoanByAdmin'

AND tx_id IN (SELECT tx_id FROM frakt_events)

AND block_timestamp > '2022-05-19'

AND block_timestamp <= CURRENT_DATE - 1

SELECT day, loan_type, COUNT(*) AS count

FROM loans

GROUP BY day, loan_type

ORDER BY day, loan_type