select *

select sum(SAVER_E8)

from thorchain.defi.fact_rewards_event_entries

where thorchain.defi.fact_rewards_event_entries.block_timestamp>='2024-04-03 06:00:00.000'

and thorchain.defi.fact_rewards_event_entries.block_timestamp<='2024-04-03 07:00:00.000'

and thorchain.defi.fact_rewards_event_entries.pool_name='BTC.BTC'

select * from thorchain.defi.fact_rewards_event_entries

where pool_name='AVAX.AVAX'

order by block_timestamp desc

limit 10