strawbettystake vs unstake actions over time
    Updated 2022-03-24
    select
    block_timestamp::date as date,
    try_base64_decode_string(tx_message:txn:note::string) as action,
    CASE WHEN action = 'Market: mt' THEN 'Stake'
    WHEN action = 'Market: rcu' THEN 'Unstake' end as label,
    count(*)
    from algorand.application_call_transaction
    where app_id = '482608867'
    and date_trunc('day', block_timestamp) <= '2022-03-18'
    and action IN ('Market: mt', 'Market: rcu')
    group by 1, 2 , 3
    Run a query to Download Data