-- forked from 2023-10-11 01:41 PM @ https://flipsidecrypto.xyz/edit/queries/3878012a-bfc1-4ed6-a3b9-e6d59657287a

select

count(DISTINCT tx_id) as txs,

count(DISTINCT signers[0]) as users

from solana.core.fact_events

join solana.core.fact_transactions using(tx_id,block_timestamp,succeeded)

join lateral flatten (input => log_messages) f

where program_id = '3parcLrT7WnXAcyPfkCz49oofuuf2guUKkjuFkAhZW8Y'

and block_timestamp::date > '2023-12-10'

and succeeded