date_trunc('day', block_timestamp) as DAY,

count(DISTINCT (SIGNERS[0])) AS USER

from solana.core.fact_transactions where

(array_contains('9xQeWvG816bUx9EPjHmaT23yvVM2ZWbrrpZb9PusVFin'::variant ,INSTRUCTIONS[0]:accounts))

AND SUCCEEDED = 'TRUE' AND DAY > DateAdd(d, -35, GetDate())

group by 1