PapasotGardian staking rewards algostake
    Updated 2023-01-02
    SELECT
    date_trunc('day',block_timestamp) as block_day,
    sum(asset_amount) as staking_rewards

    from algorand.asset_transfer_transaction

    where sender = '4ZK3UPFRJ643ETWSWZ4YJXH3LQTL2FUEI6CIT7HEOVZL6JOECVRMPP34CY'
    and asset_transferred = '692432647'

    group by block_day
    order by block_day
    Run a query to Download Data