binhachonApplications on Algorand
    Updated 2022-06-30
    with first_6_months as (
    select
    date_trunc('day', block_timestamp) as time,
    'Second half of 2021' as category,
    count(distinct tx_group_id) as number_of_txs,
    count(distinct sender) as number_of_users
    from flipside_prod_db.algorand.application_call_transaction
    where time >= '2021-07-01'
    and time < '2022-01-01'
    group by 1, 2
    ),
    last_6_months as (
    select
    date_trunc('day', block_timestamp) as time,
    'First half of 2022' as category,
    count(distinct tx_group_id) as number_of_txs,
    count(distinct sender) as number_of_users
    from flipside_prod_db.algorand.application_call_transaction
    where time >= '2022-01-01'
    and time < '2022-07-01'
    group by 1, 2
    )
    select
    *,
    row_number() over (order by time) as rank
    from first_6_months
    union all
    select
    *,
    row_number() over (order by time) as rank
    from last_6_months
    Run a query to Download Data