count (distinct tx_id) as transctions,

count (distinct signers[0]) as Users,

sum(inner_instructions[1]:instructions[0]:parsed:info:amount/1e6) as Volume

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'

and instructions[0]:programId = 'HubbLeXBb7qyLHt3x7gvYaRrxQmmgExb7fCJgDqFuB6T'

and succeeded = 'TRUE'

group by 1