select block_timestamp::date as date
,count (DISTINCT receiver) as receivers
, sum(amount )as amount ,
count (tx_id)as tx_ids
from algorand.payment_transaction
where block_timestamp::date > '2022-03-30'
and try_base64_decode_string(tx_message:txn:note::string) like '%af/gov1:j{"rewardsPrd":2%'
and sender = '57QZ4S7YHTWPRAM3DQ2MLNSVLAQB7DTK4D7SUNRIEFMRGOU7DMYFGF55BY'
group by 1