PapasotStaked gard
Updated 2023-01-03
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
›
⌄
with gardians as(
SELECT
sender,
asset_amount
from algorand.asset_transfer_transaction
where asset_receiver = '4ZK3UPFRJ643ETWSWZ4YJXH3LQTL2FUEI6CIT7HEOVZL6JOECVRMPP34CY'
and asset_transferred = '684649988'
)
select
sum(amount)/1000000 as staked_Gard,
count(a.sender) as Stakers,
staked_Gard/Stakers as average_staked_Gard
from algorand.account_asset
left join gardians a on a.sender = address
where asset_id = '684649988' and
address = a.sender
Run a query to Download Data