SELECT DAY, ADDRESS, USERS_SOLANA FROM (select Block_Timestamp::date as day, instructions[0]['programId'] as address, count(distinct SIGNERS[0]) as users_SOLANA
from solana.core.fact_transactions where SUCCEEDED='TRUE' and day BETWEEN '2022-10-01' and '2022-10-30' group by 1, address ORDER by day asc)
WHERE ADDRESS = 'HAbiTatJVqoCJd9asyr6RxMEdwtfrQugwp7VAFyKWb1g';