maybeyonasalgo_appcall_overall
    Updated 2022-07-01
    with call_data as (
    select
    block_timestamp,
    block_id,
    case when block_timestamp >= '2022-01-01' then '2022 q1 q2' else '2021 q3 q4' end as q_type,
    tx_id,
    sender,
    app_id
    from algorand.application_call_transaction
    where block_timestamp >= '2021-07-01'
    )

    select
    q_type,
    count(tx_id) as txs,
    count(distinct sender) as wallets
    from call_data
    group by 1



    Run a query to Download Data