Query does not support timedelta (checked in version Pandas 1.0.5). You can work around it using:
df[df['index'] >= datetime.now() - datetime.timedelta(10, 'S')]