KaskoazulGoanna Donations
Updated 2022-03-11
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
›
⌄
SELECT
block_timestamp::date as fecha,
sum(amount) as donated_per_day,
sum(donated_per_day) over (order by fecha) as acc_amount,
count(tx_id) as donations,
sum(donations) over (order by fecha) as acc_donations,
count (distinct sender) as wallets,
sum(wallets) over (order by fecha) as acc_donors
FROM
algorand.payment_transaction
WHERE
receiver = '2XBL47CKYWTNAIVUQCTAMFBL75EXXRT3TBG2ZK7SOG7MDBER7Q3XNL77XQ'
GROUP BY fecha
ORDER BY fecha
Run a query to Download Data