iboo-jbj2MVthe Price Swap table,
Updated 2022-05-12
9
1
2
3
4
5
6
7
8
9
›
⌄
select
DATEDIFF(SECOND, min(block_timestamp),max(block_timestamp)) as time_elapsed,
count(DISTINCT receiver) as total_receiver,
count(tx_id) as total_payment_count,
sum(amount) as total_payout
from algorand.payment_transaction
where block_timestamp::date > '2022-03-30'
and sender='57QZ4S7YHTWPRAM3DQ2MLNSVLAQB7DTK4D7SUNRIEFMRGOU7DMYFGF55BY'
and try_base64_decode_string(tx_message:txn:note) like '%af/gov1:j{"rewardsPrd":2%'
Run a query to Download Data