get bets based on user_id and filter the ones that are still open in sandbox code