Pmisha-bmlMdxRaining_Rune_easy
    Updated 2022-01-18
    select sum(asset_usd) as total_rewards,count (tx_id) as Payment_frequency, to_address ,bond_type
    from thorchain.bond_actions
    where BOND_TYPE = 'bond_reward'
    -- and to_address in (select node_address from thorchain.new_node_events)
    group by 3,4
    order by total_rewards DESC limit 10
    Run a query to Download Data