# GraphQL API

**URL:** https://community.bitquery.io/c/api/5.md?page=1

[Latest](https://community.bitquery.io/latest.md) · [Categories](https://community.bitquery.io/categories.md) · [Tags](https://community.bitquery.io/tags.md)

**Page:** 2

---

## [Anyone else having problems with the IDE?](https://community.bitquery.io/t/anyone-else-having-problems-with-the-ide/2130)

<div class="topic-metadata">

**Author:** [@twinnie](https://community.bitquery.io/u/twinnie)\
**Replies:** 10\
**Last updated:** [November 28, 2024, 12:47pm UTC](https://community.bitquery.io/t/anyone-else-having-problems-with-the-ide/2130 "2024-11-28T12:47:42Z")

</div>

I’m trying to use the IDE but about a month ago it just randomly stopped while I was using it, and I get an error saying “No active billing period”. There’s a red cross floating in the middle and on the left it says “No …

---

## [Is it possible to track transactions that are in a state not confirmed from a particular wallet? ](https://community.bitquery.io/t/is-it-possible-to-track-transactions-that-are-in-a-state-not-confirmed-from-a-particular-wallet/2171)

<div class="topic-metadata">

**Author:** [@Fima](https://community.bitquery.io/u/Fima)\
**Replies:** 1\
**Last updated:** [November 27, 2024, 8:10am UTC](https://community.bitquery.io/t/is-it-possible-to-track-transactions-that-are-in-a-state-not-confirmed-from-a-particular-wallet/2171 "2024-11-27T08:10:29Z")

</div>

I need to write an algorithm using Bitquery API to retrieve transactions from a specific wallet. With ETH it’s easier, as it has a mempool where you can just track the transaction and its state from a specific wallet. Bu…

---

## [Combine several intervals in a single query?](https://community.bitquery.io/t/combine-several-intervals-in-a-single-query/2168)

<div class="topic-metadata">

**Author:** [@Pierrot](https://community.bitquery.io/u/Pierrot)\
**Replies:** 1\
**Last updated:** [November 27, 2024, 6:47am UTC](https://community.bitquery.io/t/combine-several-intervals-in-a-single-query/2168 "2024-11-27T06:47:14Z")

</div>

Hi, I would like to retrive OHLCV data for different timeframes. Should I do one query per timeframe or is there a way to combine different timeframes? Something like Time({ interval: {in: minutes, count:…

---

## [First wallets to transfer to mint address (SOL)](https://community.bitquery.io/t/first-wallets-to-transfer-to-mint-address-sol/2151)

<div class="topic-metadata">

**Author:** [@max3pin](https://community.bitquery.io/u/max3pin)\
**Replies:** 1\
**Last updated:** [November 19, 2024, 10:30am UTC](https://community.bitquery.io/t/first-wallets-to-transfer-to-mint-address-sol/2151 "2024-11-19T10:30:01Z")

</div>

I’m trying to figure out a query with the v1 API around the first wallets that purchased a token from the mint address. So I tried: query MyQuery { solana(network: solana) { transfers( options: {limit: 50, asc: “bloc…

---

## [BitQuery not parsing events that have a struct as among it's argument](https://community.bitquery.io/t/bitquery-not-parsing-events-that-have-a-struct-as-among-its-argument/2149)

<div class="topic-metadata">

**Author:** [@Poly112](https://community.bitquery.io/u/Poly112)\
**Replies:** 1\
**Last updated:** [November 11, 2024, 3:13pm UTC](https://community.bitquery.io/t/bitquery-not-parsing-events-that-have-a-struct-as-among-its-argument/2149 "2024-11-11T15:13:07Z")

</div>

query MyQuery { EVM(network: arbitrum, dataset: realtime) { Events( where: {Transaction: {Hash: {is: "0xc5e0fcb248e3aacd952fd4580f714469f58a4575431d1b81557a80b47d1c9dc9"}}} ) { Arguments { I…

---

## [No Active Billing Period](https://community.bitquery.io/t/no-active-billing-period/2146)

<div class="topic-metadata">

**Author:** [@bigshooTer](https://community.bitquery.io/u/bigshooTer)\
**Replies:** 1\
**Last updated:** [November 6, 2024, 10:05am UTC](https://community.bitquery.io/t/no-active-billing-period/2146 "2024-11-06T10:05:09Z")

</div>

I joined bitquery a couple months ago. I logged in and tried to execute a query but I just get “no active billing period” error. I can’t execute any queries. Seems others have reported this issue too. How do I resolv…

---

## [Need help with some queries](https://community.bitquery.io/t/need-help-with-some-queries/2136)

<div class="topic-metadata">

**Author:** [@Poly112](https://community.bitquery.io/u/Poly112)\
**Replies:** 2\
**Last updated:** [November 4, 2024, 8:44am UTC](https://community.bitquery.io/t/need-help-with-some-queries/2136 "2024-11-04T08:44:15Z")

</div>

I need help with the following queries: Getting the total supply of a token in Solana. Not all tokens have a total supply of 1 billion. Getting the wallets with minimum of x trades within a time frame Getting al…

---

## [Getting Total supply in Solana and counting how many times an event has been emitted by a Smart contract](https://community.bitquery.io/t/getting-total-supply-in-solana-and-counting-how-many-times-an-event-has-been-emitted-by-a-smart-contract/2134)

<div class="topic-metadata">

**Author:** [@Poly112](https://community.bitquery.io/u/Poly112)\
**Replies:** 0\
**Last updated:** [November 4, 2024, 5:08am UTC](https://community.bitquery.io/t/getting-total-supply-in-solana-and-counting-how-many-times-an-event-has-been-emitted-by-a-smart-contract/2134 "2024-11-04T05:08:27Z")

</div>

Please I need help with the following queries: Getting the total supply of a token in Solana. Not all tokens have a total supply of 1 billion. Getting the wallets with minimum of x trades within a time frame Get…

---

## [Not returning number of holders for token](https://community.bitquery.io/t/not-returning-number-of-holders-for-token/2127)

<div class="topic-metadata">

**Author:** [@vectordude](https://community.bitquery.io/u/vectordude)\
**Replies:** 1\
**Last updated:** [October 28, 2024, 10:47am UTC](https://community.bitquery.io/t/not-returning-number-of-holders-for-token/2127 "2024-10-28T10:47:42Z")

</div>

My code was working 2 weeks ago and now for some reason it is not now. I am requesting the number of holders for BRETT token on BASE NETWORK. I saw there were some outages on the base api wondering if it has anything to …

---

## [Get transactions that have been in the ethereum mempool for over X number of seconds](https://community.bitquery.io/t/get-transactions-that-have-been-in-the-ethereum-mempool-for-over-x-number-of-seconds/2129)

<div class="topic-metadata">

**Author:** [@testing](https://community.bitquery.io/u/testing)\
**Replies:** 1\
**Last updated:** [October 28, 2024, 7:39am UTC](https://community.bitquery.io/t/get-transactions-that-have-been-in-the-ethereum-mempool-for-over-x-number-of-seconds/2129 "2024-10-28T07:39:15Z")

</div>

I am trying to create a query that will be able to isolate transactions that have been in the mempool for an abnormal amount of time. How can I go about doing that?

---

## [Get transaction input and output address when filtering for both in OR condition](https://community.bitquery.io/t/get-transaction-input-and-output-address-when-filtering-for-both-in-or-condition/2122)

<div class="topic-metadata">

**Author:** [@franz](https://community.bitquery.io/u/franz)\
**Replies:** 1\
**Last updated:** [October 25, 2024, 10:55am UTC](https://community.bitquery.io/t/get-transaction-input-and-output-address-when-filtering-for-both-in-or-condition/2122 "2024-10-25T10:55:34Z")

</div>

I have a query that fetch transactions for a specific address. I managed to create the filter in OR condition, so that inputAddress OR outputAddress must match the given one. That works but it seems it misses the inform…

---

## [May i ask how to write a query to get top 10 coins on solana by day volume?](https://community.bitquery.io/t/may-i-ask-how-to-write-a-query-to-get-top-10-coins-on-solana-by-day-volume/2116)

<div class="topic-metadata">

**Author:** [@milshop](https://community.bitquery.io/u/milshop)\
**Replies:** 1\
**Last updated:** [October 18, 2024, 7:42am UTC](https://community.bitquery.io/t/may-i-ask-how-to-write-a-query-to-get-top-10-coins-on-solana-by-day-volume/2116 "2024-10-18T07:42:00Z")

</div>

i didn’t see on docs, it’s appreciated if someone can help me.

---

## [How improve performance in the calculation of a portfolio data](https://community.bitquery.io/t/how-improve-performance-in-the-calculation-of-a-portfolio-data/2113)

<div class="topic-metadata">

**Author:** [@jramirez](https://community.bitquery.io/u/jramirez)\
**Replies:** 3\
**Last updated:** [October 11, 2024, 9:58am UTC](https://community.bitquery.io/t/how-improve-performance-in-the-calculation-of-a-portfolio-data/2113 "2024-10-11T09:58:45Z")

</div>

Hi guys, I am currently calculating the portfolio of an address this way: First I get all the tokens with balance from a particular wallet. Once I have the list of token addresses, I get all the trades in the last 6 m…

---

## [Not returning the top token holders on BASE NETWORK](https://community.bitquery.io/t/not-returning-the-top-token-holders-on-base-network/2108)

<div class="topic-metadata">

**Author:** [@scotsoradis121](https://community.bitquery.io/u/scotsoradis121)\
**Replies:** 5\
**Last updated:** [October 11, 2024, 6:01am UTC](https://community.bitquery.io/t/not-returning-the-top-token-holders-on-base-network/2108 "2024-10-11T06:01:26Z")

</div>

For some reason this code is not returning the top holders of the token it is starting somewhere way below that and then just listing random balances I want it to return the top 10 holders why is it not doing that ? imp…

---

## [How to get an ALGO address history for 2023?](https://community.bitquery.io/t/how-to-get-an-algo-address-history-for-2023/2111)

<div class="topic-metadata">

**Author:** [@johnonchainw](https://community.bitquery.io/u/johnonchainw)\
**Replies:** 1\
**Last updated:** [October 9, 2024, 9:57am UTC](https://community.bitquery.io/t/how-to-get-an-algo-address-history-for-2023/2111 "2024-10-09T09:57:57Z")

</div>

Hi, I’d like to download an ALGO address history for 2023 (in JSON or csv). There are 50,000 transactions and I wasn’t able to get it from https://ide.bitquery.io/ Any help would be appreciated. Thanks

---

## [Query Data trade data on BSC](https://community.bitquery.io/t/query-data-trade-data-on-bsc/2105)

<div class="topic-metadata">

**Author:** [@lamtanphiho1](https://community.bitquery.io/u/lamtanphiho1)\
**Replies:** 0\
**Last updated:** [October 2, 2024, 8:48am UTC](https://community.bitquery.io/t/query-data-trade-data-on-bsc/2105 "2024-10-02T08:48:07Z")

</div>

Instead of getting the query on dexrabbit , you can use the example at ohlc-for-bsc - Blockchain Data API

---

## [Can I show the General information of a token ?](https://community.bitquery.io/t/can-i-show-the-general-information-of-a-token/2103)

<div class="topic-metadata">

**Author:** [@lamtanphiho1](https://community.bitquery.io/u/lamtanphiho1)\
**Replies:** 0\
**Last updated:** [October 2, 2024, 8:17am UTC](https://community.bitquery.io/t/can-i-show-the-general-information-of-a-token/2103 "2024-10-02T08:17:35Z")

</div>

Can I show the general information of a token including parameters like : name simbol decimal supply Holders price USD LP deployer created at market cap 24h dex volume in one query?

---

## [Top 10 traders of a SPL token](https://community.bitquery.io/t/top-10-traders-of-a-spl-token/2083)

<div class="topic-metadata">

**Author:** [@agent99](https://community.bitquery.io/u/agent99)\
**Replies:** 2\
**Last updated:** [September 29, 2024, 1:58pm UTC](https://community.bitquery.io/t/top-10-traders-of-a-spl-token/2083 "2024-09-29T13:58:56Z")

</div>

Hello! I’m looking for a query to get top 10 traders of a SPL token. Need the wallet address of the trader and profit amount Can someone help me please? Thank you.

---

## [Issues with data](https://community.bitquery.io/t/issues-with-data/1851)

<div class="topic-metadata">

**Author:** [@twinnie](https://community.bitquery.io/u/twinnie)\
**Replies:** 15\
**Last updated:** [September 19, 2024, 11:15am UTC](https://community.bitquery.io/t/issues-with-data/1851 "2024-09-19T11:15:13Z")

</div>

If you run the query below then buyAmount and sellAmount look quite normal at first but then when it gets to about 9:00 the figures go up by a lot They’re like 2 quadrillion times bigger. The numbers are around 1,500,000…

---

## [How to calculate balance of stellar address?](https://community.bitquery.io/t/how-to-calculate-balance-of-stellar-address/2039)

<div class="topic-metadata">

**Author:** [@danglephuc](https://community.bitquery.io/u/danglephuc)\
**Replies:** 2\
**Last updated:** [September 16, 2024, 9:46am UTC](https://community.bitquery.io/t/how-to-calculate-balance-of-stellar-address/2039 "2024-09-16T09:46:48Z")

</div>

I tried to calculate balance of stellar address by sum of amount in “balanceEffects” of address. But the result is different with the balance in “address.tokenBalances”. It’s always a little bit missing.

---

## [How to get price data from defi on Solana](https://community.bitquery.io/t/how-to-get-price-data-from-defi-on-solana/2017)

<div class="topic-metadata">

**Author:** [@cypherrr](https://community.bitquery.io/u/cypherrr)\
**Replies:** 2\
**Last updated:** [September 13, 2024, 1:35pm UTC](https://community.bitquery.io/t/how-to-get-price-data-from-defi-on-solana/2017 "2024-09-13T13:35:47Z")

</div>

I’m trying to get real-time price data from pumpfun on the Solana network using bitquery api. However I’m met with this error, I’ve tried the examples on both v1 and v2, nothing seems to work: {'errors': \[{'message': 'F…

---

## [Incorrect balance amount](https://community.bitquery.io/t/incorrect-balance-amount/2075)

<div class="topic-metadata">

**Author:** [@dsf-andylim](https://community.bitquery.io/u/dsf-andylim)\
**Replies:** 5\
**Last updated:** [September 12, 2024, 7:24am UTC](https://community.bitquery.io/t/incorrect-balance-amount/2075 "2024-09-12T07:24:46Z")

</div>

The balance amount of some token holders are incorrect (decimal point missing). Attached screenshot for your reference. Bitquery data

---

## [How to determine if a Dex trade was a buy or sell](https://community.bitquery.io/t/how-to-determine-if-a-dex-trade-was-a-buy-or-sell/2069)

<div class="topic-metadata">

**Author:** [@DrRocky](https://community.bitquery.io/u/DrRocky)\
**Replies:** 0\
**Last updated:** [September 9, 2024, 1:59pm UTC](https://community.bitquery.io/t/how-to-determine-if-a-dex-trade-was-a-buy-or-sell/2069 "2024-09-09T13:59:44Z")

</div>

I am trying to get the price of a token DEX transaction. My example query and the response are below. You can see the response has both a BUY and SELL side entry in the transaction, which makes sense because this is a tr…

---

## [How to identify the token buyer/seller in AMM based transaction](https://community.bitquery.io/t/how-to-identify-the-token-buyer-seller-in-amm-based-transaction/2067)

<div class="topic-metadata">

**Author:** [@DrRocky](https://community.bitquery.io/u/DrRocky)\
**Replies:** 0\
**Last updated:** [September 9, 2024, 1:53pm UTC](https://community.bitquery.io/t/how-to-identify-the-token-buyer-seller-in-amm-based-transaction/2067 "2024-09-09T13:53:16Z")

</div>

I am trying to get the prices from some Dex trades but I cannot seem to identify the squence of entries in the transactions (and who is the original buyer/seller of the token) For example, this is my query (API1) { e…

---

## [Could Someone Give me Advice on Using Bitquery API for Historical Blockchain Data?](https://community.bitquery.io/t/could-someone-give-me-advice-on-using-bitquery-api-for-historical-blockchain-data/2052)

<div class="topic-metadata">

**Author:** [@fetah96190](https://community.bitquery.io/u/fetah96190)\
**Replies:** 1\
**Last updated:** [September 5, 2024, 3:02pm UTC](https://community.bitquery.io/t/could-someone-give-me-advice-on-using-bitquery-api-for-historical-blockchain-data/2052 "2024-09-05T15:02:17Z")

</div>

Hello there, I am new to blockchain data analysis and I am keen to dive deeper into historical data using the Bitquery API. I have explored the documentation but could; use some guidance on best practices and efficient …

---

## [Why my post has been hidden?](https://community.bitquery.io/t/why-my-post-has-been-hidden/2054)

<div class="topic-metadata">

**Author:** [@fetah96190](https://community.bitquery.io/u/fetah96190)\
**Replies:** 0\
**Last updated:** [August 30, 2024, 7:37am UTC](https://community.bitquery.io/t/why-my-post-has-been-hidden/2054 "2024-08-30T07:37:01Z")

</div>

Hello there, Recently I posted a query on this website- https://community.bitquery.io/t/akismet-has-temporarily-hidden-your-post/2053 After few minutes, I got a notification that left me disappointed as it shows my …

---

## [How to Fetch and Analyze DeFi Transactions Using Bitquery's API?](https://community.bitquery.io/t/how-to-fetch-and-analyze-defi-transactions-using-bitquerys-api/2047)

<div class="topic-metadata">

**Author:** [@miaco](https://community.bitquery.io/u/miaco)\
**Replies:** 1\
**Last updated:** [August 29, 2024, 3:41pm UTC](https://community.bitquery.io/t/how-to-fetch-and-analyze-defi-transactions-using-bitquerys-api/2047 "2024-08-29T15:41:40Z")

</div>

Hey guys… :wave: :wave: I am looking to use Bitquery’s API to fetch and analyze DeFi transactions. I have been exploring the documentation and various resources, but I am running into a few hurdles and would greatly app…

---

## [Help with Bitquery Explorer API for Fetching Ethereum Transaction Data](https://community.bitquery.io/t/help-with-bitquery-explorer-api-for-fetching-ethereum-transaction-data/2046)

<div class="topic-metadata">

**Author:** [@miaco](https://community.bitquery.io/u/miaco)\
**Replies:** 1\
**Last updated:** [August 29, 2024, 6:02am UTC](https://community.bitquery.io/t/help-with-bitquery-explorer-api-for-fetching-ethereum-transaction-data/2046 "2024-08-29T06:02:16Z")

</div>

Hey guys… :innocent: I am trying to use the Bitquery Explorer API to fetch Ethereum transaction data based on specific criteria like date range, wallet addresses and transaction types (e.g., swaps, transfers). I am fair…

---

## [Err code 500 with API using google app script lang](https://community.bitquery.io/t/err-code-500-with-api-using-google-app-script-lang/1535)

<div class="topic-metadata">

**Author:** [@srob2](https://community.bitquery.io/u/srob2)\
**Replies:** 4\
**Last updated:** [August 28, 2024, 12:48pm UTC](https://community.bitquery.io/t/err-code-500-with-api-using-google-app-script-lang/1535 "2024-08-28T12:48:57Z")

</div>

script code in google app script lang with err in the last line (fetch func): const API\_KEY = “BQ…Lv” function MyTest(){ let query = query{ bitcoin{ blocks{ count } } } ; let opts = { method:…

---

## [Pump Fun Api and Python Request issue](https://community.bitquery.io/t/pump-fun-api-and-python-request-issue/2041)

<div class="topic-metadata">

**Author:** [@scotsoradis121](https://community.bitquery.io/u/scotsoradis121)\
**Replies:** 2\
**Last updated:** [August 23, 2024, 10:11pm UTC](https://community.bitquery.io/t/pump-fun-api-and-python-request-issue/2041 "2024-08-23T22:11:08Z")

</div>

Hello this is my first time using bitquery and I was having some errors with my request function. Sorry I know this is probably a very trivial error if any one can spot it that would be much appreciated. When I run the p…

[Previous page](https://community.bitquery.io/c/api/5.md)

[Next page](https://community.bitquery.io/c/api/5.md?page=2)
