PapasotYieldly staking pools actions
    Updated 2023-01-03
    select
    date_trunc('day',block_timestamp) as block_day,
    count(tx_id) as application_actions,
    count(distinct(sender)) as Stakers,
    case
    when app_id = '717256390' then 'ALCH'
    when app_id = '710518651' then 'COSG'
    when app_id = '625053603' then 'NURD'
    when app_id = '593270704' then 'TINY'
    when app_id = '591414576' then 'DEFLY'
    when app_id = '511597182' then 'AKITA'
    when app_id = '596950925' then 'HDL'
    else 'other' end as pool
    --try_base64_decode_string(tx_message:txn:apaa[0]::string) as note
    from algorand.application_call_transaction
    where
    block_timestamp > '2022-01-01'
    and app_id = 717256390
    or app_id = 710518651
    or app_id = 625053603
    or app_id = 593270704
    or app_id = 591414576
    or app_id = 511597182
    or app_id = 596950925


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