nitsAction Distribution Yieldly
    Updated 2022-03-29
    SELECT action, count(*) as total_events from
    (SELECT try_base64_decode_string(tx_message:txn:apaa[0]::string) as action
    , *
    from algorand.application_call_transaction
    where app_id = '596947890')
    where action is not NULL
    GROUP by 1
    2 desc
    limit 100
    Run a query to Download Data