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

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/cardano-components/cardano-db-sync