Yes, SubQuery Network is a secure platform. It suffered zero vulnerabilities so far and is backed by censorship-resistant validators design with significant level of decentralization. It also managed to build solid community around its products.