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