date_trunc('day',block_timestamp) as dt1,

count(distinct signers[0]) as total_user,

sum(total_user) over(order by dt1 asc) as rate_total

from solana.fact_transactions

where block_timestamp>= CURRENT_DATE-180

and succeeded='TRUE'

group by 1