select
TO_ADDRESS as address,
sum(asset_usd) as reward_amount_usd,
sum(asset_amount) as reward_amount_rune,
avg(asset_usd) as average_amount_usd,
avg(asset_amount) as average_amount_rune
from thorchain.bond_actions
where bond_type = 'bond_reward'
group by address
order by reward_amount_rune desc