select
DATE_TRUNC('day',block_timestamp) as block_day,
count(distinct(TX_FROM_ADDRESS))
from solana.transactions
where DATE_TRUNC('day',block_timestamp) >= '2022-1-1' and succeeded = 'TRUE'
group by block_day
order by block_day
-- select * from solana.transactions
-- where succeeded = 'TRUE'
-- limit 100