select date(block_timestamp) as day, count(distinct tx_from_address)/1000 as daily_unique_signers_in_K, sum(DAILY_UNIQUE_SIGNERS_IN_K) over (order by day) as cumulative_unique_users_daily from solana.transactions
where block_timestamp > CURRENT_DATE -7
GROUP by day
order by day
limit 100