If you don't want to run a node or services yourself you can use https://api.koios.rest/#overview
If you run your own node or are friendly with someone who does you can use DB-Sync.
DB-Sync is a PostgreSQL relational DB of Cardano blockchain data.
You can query it using standard SQL.
DB-Sync: https://github.com/input-output-hk/cardano-db-sync
DB Schema: https://github.com/input-output-hk/cardano-db-sync/blob/master/doc/schema.md
Example queries: https://github.com/input-output-hk/cardano-db-sync/blob/master/doc/interesting-queries.md
Docs: https://docs.cardano.org/explore-cardano/cardano-architecture/about-db-sync-and-its-components