PapasotStaked gard
    Updated 2023-01-03
    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