# \#open **URL:** https://community.bitquery.io/tag/open/17.md [Latest](https://community.bitquery.io/latest.md) · [Categories](https://community.bitquery.io/categories.md) · [Tags](https://community.bitquery.io/tags.md) --- ## [Solana Historical Balances](https://community.bitquery.io/t/solana-historical-balances/2343)
**Author:** [@kafuka](https://community.bitquery.io/u/kafuka)\ **Replies:** 3\ **Last updated:** [May 23, 2025, 7:42am UTC](https://community.bitquery.io/t/solana-historical-balances/2343 "2025-05-23T07:42:19Z")
how to get Solana historical balance? in V1, V2? EAP? in v1, I tried this: query MyQuery { solana { address(address: {is: "MfDuWeqSHEqTFVYZ7LoexgAK9dxk7cy4DFJWjWMGVWa"}) { address balance } bl… --- ## [Tron Historical Balances](https://community.bitquery.io/t/tron-historical-balances/2344)
**Author:** [@kafuka](https://community.bitquery.io/u/kafuka)\ **Replies:** 1\ **Last updated:** [April 7, 2025, 6:35am UTC](https://community.bitquery.io/t/tron-historical-balances/2344 "2025-04-07T06:35:28Z")
I can get Tron historical balances by the query below, but it is only between 2 block heights. Can I specify an unix timestamp or iso time like “2025-01-01T00:00:00Z” ? query MyQuery { tron { address(address: {is… --- ## [Track wallet address trades on Solana](https://community.bitquery.io/t/track-wallet-address-trades-on-solana/2241)
**Author:** [@rrqol123](https://community.bitquery.io/u/rrqol123)\ **Replies:** 3\ **Last updated:** [January 29, 2025, 12:42pm UTC](https://community.bitquery.io/t/track-wallet-address-trades-on-solana/2241 "2025-01-29T12:42:15Z")
Hey, I’ve seen that the correct query for tracking a specific wallet address trades across the Solana blockchain (such as trades from Solana to memcoins) is: subscription { Solana { DEXTrades( where: {Trade: {Buy: {… --- ## [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)
**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")
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… --- ## [How to calculate balance of stellar address?](https://community.bitquery.io/t/how-to-calculate-balance-of-stellar-address/2039)
**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")
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)
**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")
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… --- ## [GraphQL | Bitcoin - Problem with offset](https://community.bitquery.io/t/graphql-bitcoin-problem-with-offset/1978)
**Author:** [@Pedro](https://community.bitquery.io/u/Pedro)\ **Replies:** 6\ **Last updated:** [July 3, 2024, 8:50am UTC](https://community.bitquery.io/t/graphql-bitcoin-problem-with-offset/1978 "2024-07-03T08:50:52Z")
Hello im currently trying to get the transaction for this address " bc1ql2ek3acvgfxrklcpmuk43hnvpnd7g52arqgf63gs7gfpq2f9seqs40yj65 ". The problem is when i m trying to test the offset in some cases if i change the offs… --- ## [Token trade information](https://community.bitquery.io/t/token-trade-information/1927)
**Author:** [@aman9723](https://community.bitquery.io/u/aman9723)\ **Replies:** 0\ **Last updated:** [May 16, 2024, 12:28am UTC](https://community.bitquery.io/t/token-trade-information/1927 "2024-05-16T00:28:47Z")
For any token/weth pair, I want to get the below info for (5m, 1h, 6h, and 24h timeframes) in realtime whenver a trade takes place. Also suppose no trade takes place for 5mins then also the data should update. Use case … --- ## [Why there are duplicate blocks in results of API v2?](https://community.bitquery.io/t/why-there-are-duplicate-blocks-in-results-of-api-v2/1899)
**Author:** [@sean](https://community.bitquery.io/u/sean)\ **Replies:** 3\ **Last updated:** [May 13, 2024, 8:02am UTC](https://community.bitquery.io/t/why-there-are-duplicate-blocks-in-results-of-api-v2/1899 "2024-05-13T08:02:09Z")
query MyQuery { EVM(dataset: archive, network: eth) { MinerRewards(limit: {count: 10}, orderBy: {ascending: Block\_Number}) { Reward { Total ..... } Block { Number … --- ## [exchangeName in dexTrades subscription](https://community.bitquery.io/t/exchangename-in-dextrades-subscription/1701)
**Author:** [@voices](https://community.bitquery.io/u/voices)\ **Replies:** 1\ **Last updated:** [October 4, 2023, 6:21am UTC](https://community.bitquery.io/t/exchangename-in-dextrades-subscription/1701 "2023-10-04T06:21:08Z")
Hey, I’m looking to create a DEXTrades subscription that’ll get a bunch of objects based on the exchangeName - here’s the query I’m looking to recreate as subscription: { ethereum(network: ethereum) { dexTrades( … --- ## [Streaming v2 Balance of Address](https://community.bitquery.io/t/streaming-v2-balance-of-address/1693)
**Author:** [@NoFace](https://community.bitquery.io/u/NoFace)\ **Replies:** 1\ **Last updated:** [September 28, 2023, 1:15pm UTC](https://community.bitquery.io/t/streaming-v2-balance-of-address/1693 "2023-09-28T13:15:39Z")
I’m unable to get the balance of an address in streaming mode, it only gives me the changes to the balance, not the total, the same in query mode gives me the total… { EVM(dataset: combine… --- ## [Unable to maintain ws connection in nodejs](https://community.bitquery.io/t/unable-to-maintain-ws-connection-in-nodejs/1691)
**Author:** [@NoFace](https://community.bitquery.io/u/NoFace)\ **Replies:** 4\ **Last updated:** [September 27, 2023, 3:37pm UTC](https://community.bitquery.io/t/unable-to-maintain-ws-connection-in-nodejs/1691 "2023-09-27T15:37:38Z")
Hi, this is the best I could do, it receives a couple of objects at best and then disconnects, why? import { WebSocket, WebSocketServer } from "ws"; const BQ\_API\_KEY = process.env.BQ\_API\_KEY; const BITQUERY\_WS\_URL = "… --- ## [Query request: Transfer to burn address](https://community.bitquery.io/t/query-request-transfer-to-burn-address/1684)
**Author:** [@NoFace](https://community.bitquery.io/u/NoFace)\ **Replies:** 1\ **Last updated:** [September 27, 2023, 11:50am UTC](https://community.bitquery.io/t/query-request-transfer-to-burn-address/1684 "2023-09-27T11:50:33Z")
Trying to check if tokens have been transferred to burn, I need a query for sum and another for each transfer; Need to specify the currency (lp) and the receiver (burn) This code is what I got but it does not work: E… --- ## [How to get whale txs over 100kUSD](https://community.bitquery.io/t/how-to-get-whale-txs-over-100kusd/1384)
**Author:** [@ben](https://community.bitquery.io/u/ben)\ **Replies:** 4\ **Last updated:** [February 18, 2023, 8:02am UTC](https://community.bitquery.io/t/how-to-get-whale-txs-over-100kusd/1384 "2023-02-18T08:02:16Z")
how to get whale txs over 100kUSD ? how to get currencies which supports the above metric? --- ## [How to get CEX net inflow /outflow for algorad](https://community.bitquery.io/t/how-to-get-cex-net-inflow-outflow-for-algorad/1383)
**Author:** [@ben](https://community.bitquery.io/u/ben)\ **Replies:** 1\ **Last updated:** [February 7, 2023, 12:12pm UTC](https://community.bitquery.io/t/how-to-get-cex-net-inflow-outflow-for-algorad/1383 "2023-02-07T12:12:14Z")
how to get list of metrics supported for algorad ? --- ## [BUG with bsc token DexTrades](https://community.bitquery.io/t/bug-with-bsc-token-dextrades/1106)
**Author:** [@kkmg](https://community.bitquery.io/u/kkmg)\ **Replies:** 4\ **Last updated:** [November 2, 2022, 7:56am UTC](https://community.bitquery.io/t/bug-with-bsc-token-dextrades/1106 "2022-11-02T07:56:39Z")
DEX TRADES of this token are empty -BSCSCAN link example to check -Here the token should appear but nope… the buy currency is empty… Bitquery bug right? --- ## [Query Error - Too many simultaneous queries](https://community.bitquery.io/t/query-error-too-many-simultaneous-queries/652)
**Author:** [@terrafirma](https://community.bitquery.io/u/terrafirma)\ **Replies:** 3\ **Last updated:** [October 28, 2022, 6:02pm UTC](https://community.bitquery.io/t/query-error-too-many-simultaneous-queries/652 "2022-10-28T18:02:19Z")
Hi all, Can anyone help me - I’ve receiving this response back to a balances query - Only me using my api-key playing about in javascript. First bitquery fails with “errors”:\[{“message”:"ActiveRecord::ActiveRecordError… --- ## [Updating GIFA Token (GIFX) Data](https://community.bitquery.io/t/updating-gifa-token-gifx-data/1153)
**Author:** [@sultan](https://community.bitquery.io/u/sultan)\ **Replies:** 0\ **Last updated:** [August 2, 2022, 8:58am UTC](https://community.bitquery.io/t/updating-gifa-token-gifx-data/1153 "2022-08-02T08:58:53Z")
Hi, Bitquery I am Sultan, a marketing manager at GIFA Token (GIFX) ERC20 Token in Ethereum Mainnet. A Smart Contract with the address 0x1cc811afa7e997cdeaeab3f5879b028e765b0c57. I want to update some of the information … --- ## [Transfers and Balances are Unreliable. (Incorrect data)](https://community.bitquery.io/t/transfers-and-balances-are-unreliable-incorrect-data/546)
**Author:** [@planxnx](https://community.bitquery.io/u/planxnx)\ **Replies:** 5\ **Last updated:** [July 20, 2022, 2:21pm UTC](https://community.bitquery.io/t/transfers-and-balances-are-unreliable-incorrect-data/546 "2022-07-20T14:21:45Z")
I’ve used graphql api for get historical transfer data for many wallets and found incorrect data in address balance or address transfer. The amount of tokens is displayed as a negative number or some amount of tokens is… --- ## [Is there an easier way to get these](https://community.bitquery.io/t/is-there-an-easier-way-to-get-these/1098)
**Author:** [@Bro](https://community.bitquery.io/u/Bro)\ **Replies:** 2\ **Last updated:** [July 5, 2022, 4:39am UTC](https://community.bitquery.io/t/is-there-an-easier-way-to-get-these/1098 "2022-07-05T04:39:31Z")
Hello, does anybody know what’s the easiest way to get these… 1H% change, 24H% change, 7D% change? I saw on the forum that people have said I have to get latest price and then use some time interval and then I’m guessi… --- ## [Has anybody integrated BitQuery with Charts.js?](https://community.bitquery.io/t/has-anybody-integrated-bitquery-with-charts-js/1097)
**Author:** [@three](https://community.bitquery.io/u/three)\ **Replies:** 1\ **Last updated:** [June 26, 2022, 4:23am UTC](https://community.bitquery.io/t/has-anybody-integrated-bitquery-with-charts-js/1097 "2022-06-26T04:23:14Z")
Hello! I was wondering if anybody had integrated BitQuery with Charts.js or had any tutorials they found? --- ## [Error message with query](https://community.bitquery.io/t/error-message-with-query/1093)
**Author:** [@Bro](https://community.bitquery.io/u/Bro)\ **Replies:** 1\ **Last updated:** [June 18, 2022, 12:15pm UTC](https://community.bitquery.io/t/error-message-with-query/1093 "2022-06-18T12:15:03Z")
I’ve noticed that sometimes I’ll get an error response from BitQuery that says something about the query taking too long to process, like its timing out. Then I’ll try the same query again and it’ll work the second time… --- ## [Get token amounts and symbols in add\_liquidity transaction?](https://community.bitquery.io/t/get-token-amounts-and-symbols-in-add-liquidity-transaction/1065)
**Author:** [@evanct](https://community.bitquery.io/u/evanct)\ **Replies:** 2\ **Last updated:** [May 31, 2022, 5:20pm UTC](https://community.bitquery.io/t/get-token-amounts-and-symbols-in-add-liquidity-transaction/1065 "2022-05-31T17:20:07Z")
For a given pool address I want to get all of the add\_liquidity method calls, with the token amounts of each liquidity addition. { ethereum { smartContractCalls( date: {since: "2022-05-15"} options: {l… --- ## [How to search token by name or symbol like poocoin?](https://community.bitquery.io/t/how-to-search-token-by-name-or-symbol-like-poocoin/1067)
**Author:** [@linthertoss](https://community.bitquery.io/u/linthertoss)\ **Replies:** 1\ **Last updated:** [May 30, 2022, 5:01am UTC](https://community.bitquery.io/t/how-to-search-token-by-name-or-symbol-like-poocoin/1067 "2022-05-30T05:01:42Z")
I don’t know how to search tokens by name or symbol on bitquery? So can your guys help me with that? --- ## [Cors error after following React + trading view tutorial](https://community.bitquery.io/t/cors-error-after-following-react-trading-view-tutorial/818)
**Author:** [@Defi](https://community.bitquery.io/u/Defi)\ **Replies:** 0\ **Last updated:** [January 18, 2022, 3:19pm UTC](https://community.bitquery.io/t/cors-error-after-following-react-trading-view-tutorial/818 "2022-01-18T15:19:50Z")
I followed along with the tutorial and cloned tradingview-two/src at main · sayon-bitquery/tradingview-two · GitHub After adding in my API key to the datafeed.js file and copying the nessessary files from the trading vi… --- ## [Solana daily transaction volume in USD](https://community.bitquery.io/t/solana-daily-transaction-volume-in-usd/758)
**Author:** [@pseudoboss](https://community.bitquery.io/u/pseudoboss)\ **Replies:** 7\ **Last updated:** [January 7, 2022, 9:21am UTC](https://community.bitquery.io/t/solana-daily-transaction-volume-in-usd/758 "2022-01-07T09:21:16Z")
I’m trying to sum up all daily transaction volume on Solana (denominated in USD). To do this, I started by forking the existing community Bitcoin query. The Solana query I created (see here) returns daily transaction vol… --- ## [Query blocks by time period](https://community.bitquery.io/t/query-blocks-by-time-period/509)
**Author:** [@huangwenxiansheng](https://community.bitquery.io/u/huangwenxiansheng)\ **Replies:** 3\ **Last updated:** [January 3, 2022, 3:11pm UTC](https://community.bitquery.io/t/query-blocks-by-time-period/509 "2022-01-03T15:11:36Z")
Query blocks by time period --- ## [Incomplete / inconsistent price data for PancakeSwap v2 transactions](https://community.bitquery.io/t/incomplete-inconsistent-price-data-for-pancakeswap-v2-transactions/72)
**Author:** [@dan](https://community.bitquery.io/u/dan)\ **Replies:** 13\ **Last updated:** [October 26, 2021, 3:15pm UTC](https://community.bitquery.io/t/incomplete-inconsistent-price-data-for-pancakeswap-v2-transactions/72 "2021-10-26T15:15:51Z")
Hello there, I am getting very inconsistent price data for different tokens on BSC. As I understand, poocoin.app is using BitQuery as a backend, and I can see full candles at different resolutions there, including 60mi… --- ## [Include Transaction Signature as part of SolanaTransferUniq](https://community.bitquery.io/t/include-transaction-signature-as-part-of-solanatransferuniq/734)
**Author:** [@zain](https://community.bitquery.io/u/zain)\ **Replies:** 3\ **Last updated:** [December 15, 2021, 4:20pm UTC](https://community.bitquery.io/t/include-transaction-signature-as-part-of-solanatransferuniq/734 "2021-12-15T16:20:31Z")
Hello, Based on SOL architecture it would be helpful to include the original transaction signer as part of SolanaTransferUniq so we can determine DAU/MAU, etc. for associated transfers. Using Sender\_Address which is av… --- ## [Error: Net::ReadTimeout with #\](https://community.bitquery.io/t/error-net-readtimeout-with-tcpsocket-closed/704)
**Author:** [@david\_bloxtax](https://community.bitquery.io/u/david_bloxtax)\ **Replies:** 6\ **Last updated:** [December 7, 2021, 12:40pm UTC](https://community.bitquery.io/t/error-net-readtimeout-with-tcpsocket-closed/704 "2021-12-07T12:40:34Z")
Every api call return error Net::ReadTimeout with #TCPSocket:(closed) periodically But one time in two minutes it work [Next page](https://community.bitquery.io/tag/open/17.md?match_all_tags=true&page=1&tags%5B%5D=open)