date_trunc('day', block_timestamp) as DAYs,

COUNT(DISTINCT tx_id) as transactions, sum(transactions) over (order by DAYs) as cum_txn,

COUNT(DISTINCT signers[0]) as users, sum(users) over (order by DAYs) as cum_user

from solana.core.fact_transactions

where block_timestamp >= CURRENT_DATE - 270

and instructions[0]:programId = 'HubbLeXBb7qyLHt3x7gvYaRrxQmmgExb7fCJgDqFuB6T'

and succeeded = TRUE

group by 1