select date_trunc('day',block_timestamp) as blockday,count( distinct TX_FROM_ADDRESS) as total_active_users
from solana.transactions
where SUCCEEDED = true
and DATE(blockday) > CURRENT_DATE() - 7
group by date_trunc('day',block_timestamp)
order by blockday