this search is working without time field how i can make it work with time bound.
POST _sql?format=txt
{
"query":"SELECT network,usage.total from clients where usage.total <= 1000 AND '@timestamp' < now() - INTERVAL 7 MINUTE order by usage.total DESC"
}