2844Applications on Algorand-DAILY
    Updated 2022-07-01
    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
    Run a query to Download Data