strawbettyDistribution of rewards payouts
Updated 2022-04-19
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
33
34
35
36
›
⌄
with gov2_rewards as (
SELECT *
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'
),
less_than_10 as (
select 'less than 10',count(*)
from gov2_rewards
where amount < 10
),
between_10_and_100 as (
select 'between 10 and 100',count(*)
from gov2_rewards
where amount between 10 and 100
),
between_100_and_500 as (
select 'between 100 and 500',count(*)
from gov2_rewards
where amount between 100 and 500
),
between_500_and_2000 as (
select 'between 500 and 2000',count(*)
from gov2_rewards
where amount between 500 and 2000
),
more_than_2000 as (
select 'more than 2000',count(*)
from gov2_rewards
where amount > 2000
)
select * from less_than_10
union ALL
select * from between_10_and_100
union ALL
Run a query to Download Data