SELECT

date_trunc('hour',block_timestamp) as datetime,

count(distinct tx_id) as total_tx,

count(distinct signers[0]) as unique_signers,

count(signers[0]) as all_signers,

total_tx / all_signers as tx_per_user

from

solana.core.fact_events

where program_id =

'5vzwztHZBMekRQDzy9K1PiQrWw3qYYvfwcgapnwcdJLC'

group BY

order by datetime