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