Why is MariaDB 10 refusing to use my index on a date field?
The optimizer seems to think that your index is not selective enough. I think that you can do one or more of the following things:


ANALYZE TABLE bets;
ALTER TABLE bets ADD INDEX bets_time_amount (time, amount); /* this is a covering index */
add a FORCE INDEX to your SELECT