block_timestamp::date AS date,

COUNT(DISTINCT TX_ID) AS TX_Count,

COUNT(DISTINCT SIGNERS[0]) AS Users_Count

FROM solana.core.fact_transactions

WHERE

(

inner_instructions[1]:instructions[0]:parsed:info:mint = 'USDH1SM1ojwWUga67PGrgFWUHibbjqMvuMaDkRJTgkX'

OR inner_instructions[0]:instructions[0]:parsed:info:mint = 'USDH1SM1ojwWUga67PGrgFWUHibbjqMvuMaDkRJTgkX'

OR pre_token_balances[0]:mint = 'USDH1SM1ojwWUga67PGrgFWUHibbjqMvuMaDkRJTgkX'

OR pre_token_balances[1]:mint = 'USDH1SM1ojwWUga67PGrgFWUHibbjqMvuMaDkRJTgkX'

)

AND instructions[0]:programId = '6LtLpnUFNByNXLyCoK9wA2MykKAmQNZKBdY8s47dehDc'

AND SUCCEEDED = 'TRUE'

GROUP BY date

ORDER BY date