nitsPayout distribution
Updated 2022-04-11
9
1
2
3
4
5
6
7
8
›
⌄
SELECT block_timestamp, sum(amount) as total_paid
from
(select try_base64_decode_string(tx_message:txn:note::string), *
from algorand.payment_transaction
where block_timestamp::date > '2022-03-30' and sender = '57QZ4S7YHTWPRAM3DQ2MLNSVLAQB7DTK4D7SUNRIEFMRGOU7DMYFGF55BY'
and try_base64_decode_string(tx_message:txn:note::string) like '%af/gov1:j{"rewardsPrd":2,"%' )
GROUP by 1
-- LIMIT 10
Run a query to Download Data