PapasotYieldly staking pools actions (stake/claim/w)
    Updated 2023-01-02
    select
    date_trunc('day',block_timestamp) as block_day,
    try_base64_decode_string(tx_message:txn:apaa[0]::string) as note,
    count(note)
    from algorand.application_call_transaction
    where
    block_timestamp >= '2022-01-01'
    and app_id = 233725850
    and note is not null


    group BY
    block_day,note
    order by
    block_day
    Run a query to Download Data