lagandispenserThe number of application calls over time
    Updated 2022-06-30
    select date_trunc('week',BLOCK_TIMESTAMP) as weekly , case when BLOCK_TIMESTAMP BETWEEN '2021-06-01' and '2021-12-30' then 'the last 6 months of 2021'
    when BLOCK_TIMESTAMP BETWEEN '2022-01-01' and '2022-06-30' then 'the first 6 months of 2022' end as range ,
    count (DISTINCT TX_GROUP_ID ) as num_calls, sum (num_calls) over (partition by range order by weekly ) as cum_app_calls ,
    COUNT (DISTINCT APP_ID ) as num_app_IDs, count (DISTINCT SENDER) as num_wallets from flipside_prod_db.algorand.application_call_transaction
    group by 1,2 having range is not NULL
    Run a query to Download Data