DATE_TRUNC('DAY', BLOCK_TIMESTAMP) AS event_day,

COUNT(DISTINCT value) AS unique_users

FROM

solana.core.ez_events_decoded,

LATERAL FLATTEN(input => SIGNERS)

WHERE

PROGRAM_ID = 'LBUZKhRxPF3XUpBCjp4YzTKgLccjZhTSDM9YuVaPwxo'

AND BLOCK_ID >= 228499898

AND SUCCEEDED

GROUP BY

event_day

ORDER BY

event_day