SELECT a.signers[0] as solend_users

FROM solana.fact_transactions a

INNER JOIN solana.dim_labels b

ON a.instructions[0]:programId = b.address

WHERE b.label_subtype != 'token_contract'

AND b.label = 'solend'

AND b.label != 'solana'

AND a.succeeded = 'TRUE'),

ACTIVE_USERS AS (SELECT block_timestamp::date AS dt, signers[0] AS active_users, COUNT(DISTINCT tx_id) AS num_txs

FROM solana.core.fact_transactions

WHERE succeeded = 'TRUE' AND block_timestamp::date > CURRENT_DATE - 30

AND signers[0] IN (SELECT solend_users FROM USERS)

GROUP BY 1, 2

HAVING num_txs >= 1

ORDER BY num_txs DESC)

SELECT dt, COUNT(DISTINCT active_users) AS daily_active_users, sum(daily_active_users) over (ORDER BY dt ASC) AS cumulative_active_users

FROM active_users

GROUP BY 1