select
date_trunc('day', block_timestamp) as "DTE" ,count(distinct block_id) as "TOTAL BLOCKS" ,count(distinct tx_id) as "TOTAL CALL TRASACTIONS",
count(distinct sender) as "Unique Wallets","TOTAL CALL TRASACTIONS" / "TOTAL BLOCKS" AS "AVG TRANCATIONS PER BLOCK"
from algorand.application_call_transaction
where "DTE" between '2021-06-01' and '2022-06-30'
group by 1
order by 1 desc