KaskoazulPlanetwatch rewards Top 10
Updated 2022-01-29
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
›
⌄
-- Algorand Bounty - Planetwatch Rewards
--PlanetWatch is an environmental monitoring company that pays users in Planets to carry air quality sensors
-- How many wallets have been rewarded for participating in the PlanetWatch Air monitoring program?
-- Show us how the number of wallets being rewarded daily changes over time.
-- Show us how the number of daily rewards has changed over time
-- What day were the most rewards issued? Was there an event correlated with this?
-- Who are the top 10 earners of Planets?
--Rewards Wallet Address: ZW3ISEHZUHPO7OZGMKLKIIMKVICOUDRCERI454I3DB2BH52HGLSO67W754
--Asset ID: 27165954
SELECT
--block_timestamp,
--asset_id,
asset_receiver,
--sender,
--tx_id,
--asset_amount,
sum(asset_amount)
FROM
algorand.asset_transfer_transaction
WHERE
sender = 'ZW3ISEHZUHPO7OZGMKLKIIMKVICOUDRCERI454I3DB2BH52HGLSO67W754'
AND asset_id = '27165954'
AND asset_amount > 0
--AND block_timestamp > current_date - 90
GROUP by 1
ORDER by 2 desc
LIMIT 10
Run a query to Download Data