select date_trunc('day', block_timestamp) as date_time,
count(distinct sender) as total_transactions
from flipside_prod_db.algorand.application_call_transaction
where date_trunc('day', block_timestamp) between '2021-06-01' and '2021-12-31'
group by date_time