binhachonStaking GARD on Algostake - Identify staking address
    Updated 2022-05-22
    with transactions as (
    select
    sender,
    -asset_amount as amount
    from flipside_prod_db.algorand.asset_transfer_transaction
    where asset_transferred = 684649988
    and asset_amount > 0
    and tx_group_id is not null
    union all
    select
    asset_receiver as sender,
    asset_amount as amount
    from flipside_prod_db.algorand.asset_transfer_transaction
    where asset_transferred = 684649988
    and asset_amount > 0
    and tx_group_id is not null
    )
    select
    sender,
    sum(amount)/1e6
    from transactions
    group by 1
    order by 2 desc

    Run a query to Download Data