ποΈ Date and Time
Format
ποΈ Calculations
Attributes `maximum` `minimum` `where` can be appended to an element in query.
ποΈ Combined Queries
Several queries can be combined and return results in one request:
ποΈ Filtering
In most cases you do not need the full dataset, but just a portion, related to the
ποΈ Indexed Fields Reference (where & orderBy)
Use indexed fields in where and orderBy for correct, fast queries. Reference of indexed fields per cube, dataset, and chain.
ποΈ Limits
Results are limited by using attributes `limit` and `limitBy`
ποΈ Query Aggregated Metrics
This is the most effective query.
ποΈ Array Intersection
The array_intersect feature is an advanced query format that generates an intersection of addresses from specified datasets. You can use the where clause to introduce filters that refine your results according to desired criteria. The output is a list of addresses that share a common link to the two datasets.
ποΈ Usage Patterns
GraphQL is a language, and the schema is just a restriction how do you use
ποΈ Query Fact Records
This is the simplest type of query. You just define the attributes which you need in the results,
ποΈ Subscription on Aggregated Metrics
It is a subscription to the results of Query Aggregated Metrics.
ποΈ Subscription on Facts
It is a subscription to the results of Query Fact Records.
ποΈ GraphQL query optimization for APIs
GraphQL is an open-source query language for APIs. It allows clients to define the required data structure, and the server responds with only that data. This allows for more efficient and flexible communication between the client and server, as well as enabling better performance and easier development of APIs.
ποΈ How to Filter Abnormal Prices
You might see abnormal prices when you fetch data from Bitquery APIs. There can be two possibilities as to why these abnormal prices associated with trades are appearing in your API response.
ποΈ Accessing Queries on Postman
You can run the queries and subscriptions on Postman as well. Below is the link to the collection:
ποΈ GraphQL Query Principles - Bitquery API Schema & Data
Learn how to query blockchain data with GraphQL. Schema definition, query vs subscription, dataset options, and Bitquery API structure.
ποΈ Sorting
Ordering can be applied to the results of the query, sorting the results in a way you define.
ποΈ GraphQL Joins
Starting March 2025, Bitquery APIs support joins on the v2 endpoint.
ποΈ Expressions
What is a Calculate Expression?
ποΈ Relative Time Filters
Bitquery's GraphQL API now supports relative time filtering. This filtering option simplify querying time-dependent blockchain data without manually calculating or formatting exact UTC timestamps.
ποΈ Filtering JSON Arguments
Starting October 2025, we support filtering of JSON arguments in Solana instructions. This feature allows you to query blockchain data based on the parsed argument values within program instructions.