Is there a limit to wixdata.query rows returned

i am trying to delete old rows in code and it is only getting the first 50.

Yes. 50 is the default. You can get up to 1,000 using limit():
https://www.wix.com/corvid/reference/wix-data.WixDataQuery.html#limit

Thank you