Bitquery

Tool to query the combined database, which merges archive and real-time databases. use when you need both historical and up-to-the-second blockchain data in one request.

Tool to use graphql aliases to rename fields in the response for clarity and disambiguation. use when you need to query multiple metrics with identical field names in one call.

Tool to query the archive database. use when you need full historical blockchain data (delayed by tens of minutes to hours).

Tool to generate a graphql metric snippet with conditional logic. use when you need to apply filters directly on metric calculations via the `if` attribute.

Tool to use the count distinct metric to aggregate unique values for a field. use when you need to count the number of unique occurrences in a dataset.

Tool to use the count metric to aggregate the number of records matching a graphql query. use when you need simple record counts.

Tool to select the database (archive, realtime, combined) to query at the top level of a graphql request. use after determining whether you need live, historical, or combined blockchain data.

Tool to access streaming data across various blockchain networks for evaluation purposes. use when querying chains not available via the v2 endpoint; limited to real-time data only.

Tool to subscribe to real-time mempool updates for evm chains (ethereum, bnb, etc.). use after constructing your graphql subscription to stream pending transactions live.

Tool to select the blockchain network for graphql queries. use before constructing dataset or metric queries to ensure the correct chain is targeted.

Tool to fetch graphql dataset options via schema introspection. use when you need to discover root-level query fields and their arguments before building queries.

Tool to generate graphql priceasymmetry filter snippet. use when you need to filter trades based on price asymmetry metric.

Tool to calculate quantiles to understand the distribution of numerical data. use when you need percentile metrics (e.g., median or quartiles) of a numerical field in a dataset.

Realtime database query

Tool to generate a graphql metric snippet filtering by its value using selectwhere. use when you need to include only metrics meeting specific value conditions (e.g., only positive sums).

Tool to compute statistical metrics (mean, median, etc.) over one variable in a dataset. use when you need precise summary statistics in your graphql query.

Tool to calculate the sum of a specified field's values across defined dimensions. use when you need to aggregate total values in a dataset.

Tool to estimate the count of unique values using the uniq metric. use when you need approximate or exact unique counts for analytics on blockchain datasets.