select
date_trunc('day', block_timestamp) as day,
count (distinct signers [0])
from
solana.core.fact_events
where
program_id = 'RtokEFPPbXqDrzAHJHt16fwN6hZmepfPpSvW7y47g5r'
and block_timestamp >= current_date - 30
and succeeded = 'true'
group by
date_trunc('day', block_timestamp)
order by
date_trunc('day', block_timestamp) desc