Starter Queries
Every query below is saved in the Bitquery IDE and was executed against the live API before publishing. Pick a chain, then a data type. Queries marked as needing history use the archive or combined dataset — the comment at the top of each of those queries shows the single line to change.
Table of Contents
- Arc Mainnet
- Bitcoin
- Solana
- Robinhood Chain
- Polymarket
- Perpetuals
- TRON
- Cross-Chain
- Ethereum
- BSC
- Base
- Arbitrum
- Optimism
- Polygon
- Avalanche
- Celo
- Cronos
- Klaytn
- Litecoin
- Bitcoin Cash
- Dogecoin
- Dash
- Zcash
- Cardano
- Ripple
- Stellar
- Algorand
- Filecoin
- Trading API
- Stablecoins
- NFTs
- Futures DEXs
- x402
Arc Mainnet
Trades
Quick start: latest Arc mainnet swaps
This query returns the newest swaps with USD values and the DEX name.
▶️ Quick start: latest Arc mainnet swaps
Latest trades on Arc
The most recent swaps on the network. Trade.Buy is the currency the trader received and Trade.Sell is what they paid.
Trades of a token on Arc
DEXTradeByTokens returns one row per token side of every trade, so a token filter catches it whether it was bought or sold. Side.Type says which direction the trade was from the token's point of view.
Trades on one DEX on Arc
Filter by Dex.ProtocolName. Values seen on Arc mainnet are uniswap_v4, uniswap_v3, uniswap_v2, curve_v1 and aerodrome_v1.
Trades in one pool on Arc
For Uniswap v2 and v3 the pool has its own address in Trade.Dex.SmartContract. This example reads a live v3 BUILDOG/USDC pool.
Trades of a wallet on Arc
Transaction.From is the externally owned account that signed the swap. Trade.Buy.Buyer and Trade.Sell.Seller are the addresses that received and paid the tokens, which can be a router rather than the signer.
Most traded tokens on Arc
Tokens ranked by trade count over the last 24 hours. Native USDC is the quote on most pools, so it tops the list; the rows under it are the tokens people actually trade.
Trade count by DEX protocol on Arc
Which DEXes carry mainnet volume. Uniswap v4 led the launch-day check.
▶️ Trade count by DEX protocol on Arc
Most active traders on Arc
Signers ranked by swap count. The top rows often include bots and routers, so inspect the address before treating it as a person.
Transfers
Latest transfers on Arc
The most recent token and native USDC transfers on Arc mainnet.
Native USDC transfers on Arc
Currency: {Native: true} selects value transfers of the gas token. The floor of 100 USDC keeps dust and fee movements out.
▶️ Native USDC transfers on Arc
Transfers of a token on Arc
Filter on the token contract. This example reads the ERC-20 USDC interface; swap in EURC or any test token.
▶️ Transfers of a token on Arc
Transfers of an address on Arc
Incoming and outgoing transfers in one list. Replace the address with any wallet or contract.
▶️ Transfers of an address on Arc
Sent and received totals per token on Arc
Two aliased selections give the outbound and inbound sums per currency for a wallet.
▶️ Sent and received totals per token on Arc
Transfers between two addresses on Arc
Flows from one address to another, in either direction. Useful for tracing a faucet, a bridge or a counterparty.
▶️ Transfers between two addresses on Arc
Large transfers on Arc
This catches ERC-20 USDC moves above 10,000 and returns both token and USD amounts.
Most transferred tokens on Arc
Tokens ranked by transfer count over 24 hours, with distinct senders and receivers. The system ledger address is excluded.
▶️ Most transferred tokens on Arc
Hourly transfer volume of a token on Arc
Transfer volume of ERC-20 USDC bucketed by hour, for charts and alerts.
▶️ Hourly transfer volume of a token on Arc
Balances & Holders
Portfolio of a wallet on Arc
Every currency an address holds, with the computed balance and when it last changed. Native USDC has Native: true; the ERC-20 interface at 0x3600... is listed separately.
▶️ Portfolio of a wallet on Arc
Balance of one token on Arc
The balanceOf equivalent for ERC-20 USDC. For the gas token use Currency: {Native: true} instead of a contract filter.
▶️ Balance of one token on Arc
Balances of several wallets on Arc
One call for a batch of addresses, grouped by address and currency.
▶️ Balances of several wallets on Arc
Top holders of a token on Arc
Current EURC holders ranked by token balance. Add Balance: {Amount: {gt: "0"}} so wallets that once held the token but now hold zero do not appear.
▶️ Top holders of a token on Arc
Balance history of a wallet on Arc
Each change to a wallet's ERC-20 USDC balance, newest first, with the transaction behind it. Positive amounts are inflows.
▶️ Balance history of a wallet on Arc
Net change per currency over a window on Arc
Sum the updates per currency to see what a wallet gained or lost over the last 24 hours.
▶️ Net change per currency over a window on Arc
Price & OHLC
OHLCV candles for a token on Arc
Hourly candles for EURC priced in ERC-20 USDC. Block.Time(interval: ...) buckets the trades; open and close take the price at the lowest and highest block in the bucket. Change count and in for other intervals.
▶️ OHLCV candles for a token on Arc
Latest price of a token on Arc
The price of the most recent EURC trade against ERC-20 USDC. Trade.PriceInUSD is populated on Arc mainnet.
▶️ Latest price of a token on Arc
Supply & Market Cap
Total supply of a token on Arc
TransactionBalances records the token's total supply after each transaction that touched it. The latest row is the current supply, already adjusted for decimals.
▶️ Total supply of a token on Arc
Liquidity & Pools
New Uniswap v4 pools on Arc
Uniswap v4 carried most launch-day swaps. A new pool is an Initialize event on the PoolManager; its arguments give the pool id, the two currencies, the fee tier, tick spacing, hook address and opening price.
▶️ New Uniswap v4 pools on Arc
New Uniswap v3 and v2 pools on Arc
Several v3 and v2 factory deployments appeared on mainnet, so filter on the event name rather than one factory address. PoolCreated is v3, PairCreated is v2; both carry the two tokens and the new pool address in their arguments.
▶️ New Uniswap v3 and v2 pools on Arc
Transactions
Latest transactions on Arc
The most recent transactions on Arc mainnet, newest first.
Transaction by hash on Arc
The equivalent of eth_getTransactionByHash plus eth_getTransactionReceipt in one call. The example hash is a live USDC value transfer; replace it with any recent hash.
Transactions of an address on Arc
Sent and received transactions of one address, newest first. This is the explorer's address page.
▶️ Transactions of an address on Arc
Failed transactions on Arc
Transactions whose receipt status is 0. Join the reverted calls query on the hash to see the revert reason.
Gas fees in USDC on Arc
Because gas is paid in USDC, Fee.SenderFee is already a dollar amount. This gives the average, median and total fee per hour along with the average effective gas price.
Events & Calls
Latest calls on Arc
The most recent top-level calls, one per transaction.
Calls of one method on Arc
Filter on the decoded method name and the contract. This reads transfer calls into the ERC-20 USDC contract with their decoded arguments.
Calls by 4-byte selector on Arc
When the ABI is not registered, filter on the selector in Call.Input instead. This matches approve(address,uint256) by its 0x095ea7b3 prefix on any contract.
▶️ Calls by 4-byte selector on Arc
Internal calls of a transaction on Arc
The full call tree of one transaction, ordered by call index. Replace the hash with any recent transaction from the Transactions API.
▶️ Internal calls of a transaction on Arc
Contract deployments on Arc
Call.Create: true marks a call that deployed a contract. The new address is in Receipt.ContractAddress for top-level deployments; for factory deployments read Call.To on the create call.
▶️ Contract deployments on Arc
Reverted calls on Arc
Calls that reverted, with the error string when the EVM returned one. Useful for debugging a contract under test.
Most called methods on Arc
Method signatures ranked by call count over 24 hours. ERC-20 transfer, balanceOf and approve dominate, followed by Uniswap v4 hook callbacks.
Calls that move native USDC on Arc
Internal calls that carried native USDC value. This is how value moves between contracts shows up, since those movements are not ERC-20 Transfer events.
▶️ Calls that move native USDC on Arc
Events from one contract on Arc
LogHeader.Address is the address filter of eth_getLogs. This reads the latest events of the ERC-20 USDC contract.
▶️ Events from one contract on Arc
One event across all contracts on Arc
Filter by decoded signature name to watch one event type from every contract that emits it. This catches every Swap, from Uniswap v2 pairs, v3 pools and the v4 PoolManager alike.
▶️ One event across all contracts on Arc
Filter by raw topic0 on Arc
When you have the signature hash rather than the name, filter on Log.Signature.SignatureHash. This is the ERC-20 Transfer(address,address,uint256) hash, written without 0x.
▶️ Filter by raw topic0 on Arc
Filter by a decoded argument on Arc
Server-side filtering on decoded values is what a node cannot do. This finds every event whose argument named to equals a wallet, across all contracts and signatures.
▶️ Filter by a decoded argument on Arc
Busiest contracts and signatures on Arc
Which contracts and event types dominate the log stream over 24 hours. Run this first on any network you have not explored yet.
▶️ Busiest contracts and signatures on Arc
Undecoded events on Arc
Events whose ABI is not registered arrive with an empty Signature.Name and no Arguments, but the raw Topics and Log.SmartContract are still there. This lists the contracts emitting the most undecoded events; if one matters to you, ask support to register its ABI.
Launchpads
Latest launches on Arc
Use the same filters with query, a row limit, and descending block time to fetch the newest launches.
Launch count by platform on Arc
Group launch events by emitting contract to compare activity during the last hour. The result uses contract addresses, so map them to the table above in your app.
▶️ Launch count by platform on Arc
Trades for a launched token on Arc
Copy the token address from Topics[1] into Trade.Currency.SmartContract. This example follows a token launched through RadarDEX.
▶️ Trades for a launched token on Arc
OHLCV for a launched token on Arc
This query builds five-minute candles for the same token against Arc's ERC-20 USDC interface. It returns USD volume, open, high, low, close, and trade count.
▶️ OHLCV for a launched token on Arc
Blocks & Validators
Datasets and history on Arc
On 16 September 2026, only the realtime path answered. Its depth changes, so measure the current window before running a long-range query.
▶️ Datasets and history on Arc
Latest blocks on Arc
Change query to subscription and drop limit and orderBy to receive each block header as it is indexed.
Block by number on Arc
Header, gas and transaction count of one Arc mainnet block.
Block and throughput statistics on Arc
Blocks, transactions, average transactions per block and average gas per block for each of the last 24 hours. Divide the block count by 3600 to get blocks per second.
▶️ Block and throughput statistics on Arc
Bitcoin
Transfers
Inflows and Outflows of a wallet
This API returns all incoming and outgoing transactions for a specific Bitcoin wallet address.
▶️ Inflows and Outflows of a wallet
Balances & Holders
Balance of an address at a past date
What one Bitcoin address held as of a chosen date. Move the date in the Variables pane.
▶️ Balance of an address at a past date
Bitcoin Balance for multiple addresses
This query calculates the combined balance of multiple Bitcoin wallet addresses by summing their total inflows and outflows: Balance = Total Output - Total Input. You can also set a date to get balances as of a specific point in time.
▶️ Bitcoin Balance for multiple addresses
BTC balance api for multiple addresses
Pass an array of addresses to inputAddress and outputAddress with {in: [...]} to get per-wallet totals in a single request. Useful for exchanges, custodians, and portfolio dashboards that monitor many wallets at once.
▶️ BTC balance api for multiple addresses
Bitcoin balance
Returns total BTC sent (inputs) and received (outputs) for an address, along with USD-equivalent values and first / last activity dates. Subtract inputs.value from outputs.value to get the current balance.
Bitcoin balance at a given height
Need to know what a wallet held at a particular point in time? The height filter caps inputs and outputs at a given block number, which is exactly what you need for audits, tax reporting, and point-in-time portfolio snapshots.
▶️ Bitcoin balance at a given height
Bitcoin balance on a given block height
Sum outputs and subtract inputs with a height: {lteq: N} cap to get the wallet's balance at a specific point on-chain. Useful for audits, tax snapshots, and point-in-time portfolio reporting.
▶️ Bitcoin balance on a given block height
Price & OHLC
Latest Bitcoin price
The current BTC price in USD from the Crypto Price API. bid:bitcoin blends native BTC, WBTC, cbBTC and other wrapped versions across chains into one price, returned with USD volume and market cap.
Latest Bitcoin price on each chain
One latest USD price per BTC representation (WBTC on Ethereum, cbBTC on Base and so on) from the Tokens cube. Use it to spot a wrapped BTC trading away from the blended price.
▶️ Latest Bitcoin price on each chain
Latest BTC/USDT price on every market
The latest BTC/USDT price from each DEX market across chains, one row per market. Useful for comparing venues and finding arbitrage gaps.
▶️ Latest BTC/USDT price on every market
Btc price in 2016
Pulls the BTC/USD price implied by any output on a given date — Bitquery stores the spot value at the time of each transaction, so you can derive a historical price by dividing USD value by BTC value.
Transactions
Details of Bitcoin Transaction
This API provides comprehensive details of a specific Bitcoin transaction in a single query.
▶️ Details of Bitcoin Transaction
Blocks & Validators
Bitcoin miners rewards
Mining rewards live in coinbase outputs (the first transaction in every block, txIndex: 0) with outputDirection: mining.
Get miners activity in a specific timeframe
Pulls the activity count per miner address inside a date range. Drop or extend the date window to size the cohort however you need.
▶️ Get miners activity in a specific timeframe
Get miners first activity
For a specific set of miner addresses, this query returns the first block each one mined. Useful for cohort analysis, miner onboarding studies, or building "first seen" timelines.
Solana
Trades
Get Swaps by Pair Address
Get all trades related transactions for a specific pair address. Trading cube — real-time and roughly the last 30 days. For anything older, use the DEXTradeByTokens entries at the bottom of this section.
Get Trades by Wallet Address
Get all trades related transactions (buy, sell) for a specific wallet address. Trading cube — real-time and roughly the last 30 days. For anything older, use the DEXTradeByTokens entries at the bottom of this section.
▶️ Get Trades by Wallet Address
Get Volume Stats for Solana Chain
Traded volume, trade count and active wallets for Solana over a stated window, from DEXTradeByTokens. Two things this query has to work around. Solana.DEXTrades keeps about 12 hours and has no archive, so it cannot answer this at all. And a uniq in the same selection as sum and count corrupts those aggregates and freezes the time filter with them - asking for 1, 3 or 6 days then returns the same totals - so active wallets is computed in its own aliased call. The volume sum also excludes single trades above $1M, which are mispriced rows; without that guard the total reads about $32 quadrillion a day instead of about $16 billion.
▶️ Get Volume Stats for Solana Chain
Get Multiple Token Analytics — historical (beyond 30 days)
Returns analytics data for multiple token addresses. Built from raw DEX trades, so it reaches back further than the Trading cube's ~30 days. For live prices prefer the Trading cube entries at the top of this section.
▶️ Get Multiple Token Analytics — historical (beyond 30 days)
Get Token Metadata — historical (beyond 30 days)
Get the token metadata for contract (mint, standard, name, symbol). Built from raw DEX trades, so it reaches back further than the Trading cube's ~30 days. For live prices prefer the Trading cube entries at the top of this section.
▶️ Get Token Metadata — historical (beyond 30 days)
Get Token Pair Stats — historical (beyond 30 days)
Get the pair stats by using pair address. Built from raw DEX trades, so it reaches back further than the Trading cube's ~30 days. For live prices prefer the Trading cube entries at the top of this section.
▶️ Get Token Pair Stats — historical (beyond 30 days)
Get Token Pairs by Address — historical (beyond 30 days)
Get the supported pairs for a specific token address. Built from raw DEX trades, so it reaches back further than the Trading cube's ~30 days. For live prices prefer the Trading cube entries at the top of this section.
▶️ Get Token Pairs by Address — historical (beyond 30 days)
Realised PnL, avg buy price, buy volume, sell volume of a Trader for specific token — historical (beyond 30 days)
Get realised PnL, average buy price, buy volume, and sell volume for a token on Solana of a trader for over a time window. Built from raw DEX trades, so it reaches back further than the Trading cube's ~30 days. For live prices prefer the Trading cube entries at the top of this section.
Search tokens by name, symbol, mint address — historical (beyond 30 days)
Search for tokens based on contract address, token name or token symbol. Built from raw DEX trades, so it reaches back further than the Trading cube's ~30 days. For live prices prefer the Trading cube entries at the top of this section.
▶️ Search tokens by name, symbol, mint address — historical (beyond 30 days)
Buys Sells BuyVolume SellVolume Makers TotalTradedVolume PriceinUSD for solana token pair — historical (beyond 30 days)
Returns the essential stats for a token such as buy volume, sell volume, total buys, total sells, makers, total trade volume, buyers, sellers (in last 5 min, 1 hour) of a specific token. Built from raw DEX trades, so it reaches back further than the Trading cube's ~30 days. For live prices prefer the Trading cube entries at the top of this section.
Transfers
Simple SOL transfers (Transactions not trades)
This API returns simple SOL transfers; in other words, it contains transactions that are simple token transfers, not trades.
▶️ Simple SOL transfers (Transactions not trades)
Solana Token Transfers for a Specific Address
This API retrieves the history of token transfers (both sent and received) for a specific Solana address within a defined time period.
▶️ Solana Token Transfers for a Specific Address
Solana Transfers
This query gets the latest 10 transfers on Solana. You can increase the limit to get more transfers. This query only uses real-time data.
Solana Historical Transfers
Solana Historical Transfers.
▶️ Solana Historical Transfers
Currency with elon inclusion
You can search tokens on Solana using names or symbols case insensitively also using our APIs and get prices and other details.
▶️ Currency with elon inclusion
Solana token transfers of Bags fm tokens
Track all transfers of Bags FM tokens across wallets. This Bags FM token transfers endpoint provides complete transfer history. 🔗.
▶️ Solana token transfers of Bags fm tokens
Total txn fees paid by the Account
Get the total fees (in SOL and USD) paid by a specific Solana account across all transfers.
▶️ Total txn fees paid by the Account
Transaction fees paid by Account aggregated by currency
Get total fees paid by a Solana account for transferring each type of token.
▶️ Transaction fees paid by Account aggregated by currency
Transfers of a wallet
Fetches the recent 10 transfers of a specific wallet address 9nnLbotNTcUhvbrsA6Mdkx45Sm82G35zo28AqUvjExn8.
Wallet transfers with transaction fees paid
Track wallet token transfers and get the fees paid for each by the address.
▶️ Wallet transfers with transaction fees paid
Balances & Holders
Solana Instruction Balance Updates
This query returns Solana balance update info for any balance update event, including the address, amount, currency details, and the details of the program responsible for this update.
▶️ Solana Instruction Balance Updates
Balance updates
Returns balance update associated with a instruction invocation.
Solana balance updates executing burn instruction
The query below uses the InstructionBalanceUpdates API to fetch balance updates that occur when token burn instructions execute.
▶️ Solana balance updates executing burn instruction
Trades of wallets with balance Updates in that trades
Trades made by the wallets in addressList, with the balance updates from those same transactions joined on. Uses DEXTradeByTokens rather than Solana.DEXTrades: DEXTrades keeps only about 12 hours on Solana and has no archive, so the previous version returned no rows whenever the wallet had not traded in the last half day. DEXTradeByTokens keeps about 7 days and supports archive for older windows.
▶️ Trades of wallets with balance Updates in that trades
Price & OHLC
Token price from top market (rank 1)
Prices SOL from its single top market rather than blending every pool — the recommended way to price one specific token. Replace token in the Variables pane, lowercase.
▶️ Token price from top market (rank 1)
Get OHLCV by Pair Address
You can get charting data easily with this query. Adjust the intervals as necessary. This query supports historical data. Trading cube — real-time and roughly the last 30 days. For anything older, use the DEXTradeByTokens entries at the bottom of this section.
Get Latest Price of a Token in USD
Get Latest Price of a Token in USD. Uses the Pairs cube. Replace the address in the where clause to use it. Trading cube — real-time and roughly the last 30 days. For anything older, use the DEXTradeByTokens entries at the bottom of this section.
▶️ Get Latest Price of a Token in USD
Historical Price and Volume Data (Volume & Price, Last 24h using Trading API)
Use this API to get historical price and volume for a specific token over the past 24 hours. Trading cube — real-time and roughly the last 30 days. For anything older, use the DEXTradeByTokens entries at the bottom of this section.
▶️ Historical Price and Volume Data (Volume & Price, Last 24h using Trading API)
Get Token Prices on Solana — historical (beyond 30 days)
Returns price information for multiple Solana tokens in a single request. Built from raw DEX trades, so it reaches back further than the Trading cube's ~30 days. For live prices prefer the Trading cube entries at the top of this section.
▶️ Get Token Prices on Solana — historical (beyond 30 days)
Price change 5min, 1hr, 6hr precentage of a specific token — historical (beyond 30 days)
With this, you can get the price change 5min, 1hr, 6hr precentage of a specific token. Built from raw DEX trades, so it reaches back further than the Trading cube's ~30 days. For live prices prefer the Trading cube entries at the top of this section.
▶️ Price change 5min, 1hr, 6hr precentage of a specific token — historical (beyond 30 days)
Top 10 solana tokens by price change in last 1 hr — historical (beyond 30 days)
With this, you can get top 10 solana tokens by price change in last 1 hr. Built from raw DEX trades, so it reaches back further than the Trading cube's ~30 days. For live prices prefer the Trading cube entries at the top of this section.
▶️ Top 10 solana tokens by price change in last 1 hr — historical (beyond 30 days)
ATH of multiple tokens quantile Solana — historical (beyond 30 days)
ATH of multiple tokens quantile Solana. Uses the DEXTradeByTokens cube. Needs the historical data add-on — see the comment at the top of the query. Built from raw DEX trades, so it reaches back further than the Trading cube's ~30 days. For live prices prefer the Trading cube entries at the top of this section.
▶️ ATH of multiple tokens quantile Solana — historical (beyond 30 days)
ATH with price delta Solana — historical (beyond 30 days)
Fetches a Solana token’s ATH price, ATH date, and price change percentages over the past 24h, 7d, and 30d using Bitquery Solana APIs. Try the. Built from raw DEX trades, so it reaches back further than the Trading cube's ~30 days. For live prices prefer the Trading cube entries at the top of this section.
▶️ ATH with price delta Solana — historical (beyond 30 days)
AldrinAmm OHLC for specific pair — historical (beyond 30 days)
If you want to get OHLC data for any specific currency pair on AldrinAmm, you can use this api. Only use. Built from raw DEX trades, so it reaches back further than the Trading cube's ~30 days. For live prices prefer the Trading cube entries at the top of this section.
▶️ AldrinAmm OHLC for specific pair — historical (beyond 30 days)
Get Latest Price of Apple xStock in USD Real-time — historical (beyond 30 days)
You can use the following query to get the latest price of a Apple xStock on Solana. Built from raw DEX trades, so it reaches back further than the Trading cube's ~30 days. For live prices prefer the Trading cube entries at the top of this section.
▶️ Get Latest Price of Apple xStock in USD Real-time — historical (beyond 30 days)
Supply & Market Cap
Sandisk - Backpack Securities MCAP
See the Pairs cube for full field reference. Trading cube — real-time and roughly the last 30 days. For anything older, use the DEXTradeByTokens entries at the bottom of this section.
▶️ Sandisk - Backpack Securities MCAP
Top Tokens by Market Cap on solana
Ranks tokens on Solana by Supply.MarketCap, with 24h window, 1s interval, $1,000+ USD volume, limitBy per Token_Id, up to 50 rows. Token.Network is Solana. Trading cube — real-time and roughly the last 30 days. For anything older, use the DEXTradeByTokens entries at the bottom of this section.
▶️ Top Tokens by Market Cap on solana
Bags.fm token creation using Solana token supply updates
Bags.fm token creation using Solana token supply updates. Uses the TokenSupplyUpdates cube. Replace the address in the where clause to use it.
▶️ Bags.fm token creation using Solana token supply updates
Market cap of token
You can fetch Marketcap of a token using below query.
Token burn example solana
You can also track real-time token burn using the TokenSupplyUpdates API. Check out the.
Token supply
Will return the latest token supply of a specific token. We are getting here supply for this 6D7NaB2xsLd7cauWu1wKk6KBsJohJmP2qZH9GEfVi5Ui token PostBalance will give you the current supply for this token.
▶️ Token supply
Tokens with market cap range
Lets say we need to get the tokens whose marketcap has crossed the 1M USD mark but is less than 2M USD for various reasons like automated trading. We can get the token details that have crossed a particular marketcap using.
▶️ Tokens with market cap range
Top 10 marketcap jump tokens in last 1hr
Use below query to get top 10 marketcap jump tokens in last 1hr.
▶️ Top 10 marketcap jump tokens in last 1hr
Top Solana tokens based on market cap
Top Solana tokens based on market cap. Uses the TokenSupplyUpdates cube.
▶️ Top Solana tokens based on market cap
Marketcap of tokens — historical (beyond 30 days)
Returns the ATH (All-Time High) market cap, starting market cap, and related price metrics for multiple tokens. It calculates market cap using a 1 billion token supply and uses quantile to find the ATH price. Built from raw DEX trades, so it reaches back further than the Trading cube's ~30 days. For live prices prefer the Trading cube entries at the top of this section.
▶️ Marketcap of tokens — historical (beyond 30 days)
Liquidity & Pools
All Token Pairs Across DEXs with Current Liquidity
This query retrieves all instances of a specific token pair across decentralized exchanges (DEXs) on Solana, along with their current liquidity.
▶️ All Token Pairs Across DEXs with Current Liquidity
Latest Pools Created on Launchpad
This query returns the latest created pools on Raydium launchpad. You can set the limit here also.
▶️ Latest Pools Created on Launchpad
Liquidity of All Pools of a Token on Solana
Get latest liquidity snapshots for all pools where a token is either base or quote currency.
▶️ Liquidity of All Pools of a Token on Solana
Solana Pool Liquidity Changes
This query retrieves the latest changes to liquidity pools on Solana, including the change amount and the price at which the change happened. This query also uses only the real-time data set.
▶️ Solana Pool Liquidity Changes
All liquidity add instructions track on Solana
Tracks liquidity addition events on Solana DEX pools by monitoring specific instructions.
▶️ All liquidity add instructions track on Solana
CPMM pools created
The mint addresses for the tokens being used in the pool are listed for example tokenMint1 and tokenMint0 , indicating which tokens the CPMM will support.
Get LP Latest liqudity on Solana
Get LP Latest liqudity on Solana. Uses the DEXPools cube. Replace the address in the where clause to use it.
▶️ Get LP Latest liqudity on Solana
Get all the liquidity pools info for a particular token
Will give the information on all the liquidity pools of a particular token EKpQGSJtjMFqKZ9KQanSqYXRcF8fBopzLHYxdM65zcjm.
▶️ Get all the liquidity pools info for a particular token
Liquidity change in recent month
Liquidity change in recent month. Uses the DEXTradeByTokens cube. Needs the historical data add-on — see the comment at the top of the query.
▶️ Liquidity change in recent month
Liquidity lock using instructions balance update
Using the below query, you can retrieve latest liquidity locks made using streamflow.
▶️ Liquidity lock using instructions balance update
Events & Calls
Not Anchor Error Solana Logs
To exclude instructions containing specific log phrases such as 'AnchorError' you can use the notLike filter.
▶️ Not Anchor Error Solana Logs
Solana Zeta Market logs
If you need to filter out the instructions from Solana logs that involve a particular exchange but you don’t have any information, like address and protocol, then you can use the “includes” keyword on Logs.
Pump.fun
First buyers of a token (sniper detection)
The earliest buyers of a token, in time order - snipers are the first rows, buying within seconds of launch at the lowest price. Replace token in the Variables pane.
▶️ First buyers of a token (sniper detection)
Top 10 pump fun tokens by Marketcap change in last 5mins
This query returns the top 10 pump fun tokens by Marketcap change in last 5mins. You can increase the limit to get more tokens.
▶️ Top 10 pump fun tokens by Marketcap change in last 5mins
Top PumpFun Tokens by Marketcap
Top Pump.fun and PumpSwap tokens on Solana over the last hour, ranked by USD volume. Ranked by volume rather than market cap on purpose: Solana market caps in the cube saturate against whatever ceiling you filter on, so sorting by them surfaces tokens with broken supply figures. Supply.MarketCap is still returned for reference. The previous version sorted Solana.DEXTrades by raw buy price over a window 18 months outside that cube's ~12 hour retention and returned USDC as the top Pump.fun token.
▶️ Top PumpFun Tokens by Marketcap
Get Bonding Curve Progress of a Token on Pump Fun
Returns Bonding Curve Percentage of a Token on the Pump Fun.
▶️ Get Bonding Curve Progress of a Token on Pump Fun
ATH Market Cap of Pump Fun Tokens in a Specific Timeframe
Use Bitquery's DEXTradeByTokens with dataset: combined, Trade.PriceInUSD(maximum: Trade_PriceInUSD), and quantile(of: Trade_PriceInUSD, level: 0.98) to get ATH price. Market cap = ATH price × 1 billion (Pump.fun tokens have 1B supply).
▶️ ATH Market Cap of Pump Fun Tokens in a Specific Timeframe
All tokens traded on Pump.fun in the last 1 hour
To get all tokens traded on Pump.fun in the last 1 hour, use a query that filters trades by the Pump.fun protocol and a block time within the past hour.
▶️ All tokens traded on Pump.fun in the last 1 hour
How do I get tokens that reached a specific market cap on Pump.fun?
To find tokens on Pump.fun that have reached a specific market capitalization threshold, you can use the following Bitquery GraphQL example.
▶️ How do I get tokens that reached a specific market cap on Pump.fun?
Latest creator fee transfers on pumpfun amm
Latest creator fee transfers on pumpfun amm. Uses the InstructionBalanceUpdates cube. Replace the address in the where clause to use it.
▶️ Latest creator fee transfers on pumpfun amm
Pumpfun transfers type v1 to pumpfun migrations
Retrieve Pump.fun token migrations on a specific date. The API returns transfers to the PumpSwap migration receiver address for the given date.
▶️ Pumpfun transfers type v1 to pumpfun migrations
Pumpswap latest Trades API
Latest PumpSwap trades from the Trading cube, with USD price and trade size on every row. The Trading cube reaches back about 30 days on Solana; Solana.DEXTrades keeps only about 12 hours.
▶ ️ Pumpswap latest Trades API
Top 10 pump fun tokens by Price change in last 5min
Use the below query to get top 10 Pump.fun tokens by price change in the last 5 minutes.
▶️ Top 10 pump fun tokens by Price change in last 5min
Top 100 graduating pump fun tokens in last 5 minutes
We can use below query to get top 100 About to Graduate Pump Fun Tokens. You can run and test the saved query.
▶️ Top 100 graduating pump fun tokens in last 5 minutes
Top traders on pumpswap
Aggregate DEXTradeByTokens by Transaction.Signer with limitBy and orderBy on trade count or volume (USD). Filter Dex.ProgramAddress to PumpSwap and optionally WSOL as the side currency to rank active wallets on the AMM.
All Pump fun tokens created by an address
All Pump fun tokens created by an address. Uses the TokenSupplyUpdates cube. Replace the address in the where clause to use it.
▶️ All Pump fun tokens created by an address
First transfers of a pump fun token
Retrieves the first transfer of a token to each address, providing the timestamp when each address first received the token.
▶️ First transfers of a pump fun token
Meteora
Get the Top Traders of a specific Token on Meteora DAMM v2 DEX
The below query gets the Top Traders of the specified Token on Meteora DAMM v2. This provides insights into the most active traders and their trading patterns.
▶️ Get the Top Traders of a specific Token on Meteora DAMM v2 DEX
Get the Top Traders of a specific Token on Meteora DLMM DEX
The below query gets the Top Traders of the specified Token on Meteora DLMM. This provides insights into the most active traders and their trading patterns.
▶️ Get the Top Traders of a specific Token on Meteora DLMM DEX
Get the Top Traders of a specific Token on Meteora DYN DEX
The below query gets the Top Traders of the specified Token EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v on Meteora DYN.
▶️ Get the Top Traders of a specific Token on Meteora DYN DEX
Meteora DAMM v2 OHLC API
If you want to get OHLC (Open, High, Low, Close) data for any specific currency pair on Meteora DAMM v2, you can use this API. This provides technical analysis data for charting and trading strategies.
Meteora DLMM OHLC API
If you want to get OHLC (Open, High, Low, Close) data for any specific currency pair on Meteora DLMM, you can use this API. This provides technical analysis data for charting and trading strategies.
Meteora DYN OHLC API
If you want to get OHLC data for any specific currency pair on Meteora DYN, you can use this api. Only use.
Volatility of WSOL USDC Pair on AldrinAmm Dex on Solana
Standard deviation of the WSOL/USDC price on AldrinAmm over the last five days. Uses DEXTradeByTokens, which keeps about 7 days, rather than Solana.DEXTrades, which keeps about 12 hours and has no archive. trades is returned alongside the volatility so an empty window reads as 0 trades instead of passing for zero volatility.
▶️ Volatility of WSOL USDC Pair on AldrinAmm Dex on Solana
Volatility of WSOL USDC Pair on Lifinity Dex on Solana
Standard deviation of the WSOL/USDC price on Lifinity over the last five days. This pair is currently inactive on Lifinity, so the query returns 0 trades - change the ProtocolFamily to a busier venue such as Raydium or Meteora to see a live figure. Uses DEXTradeByTokens rather than Solana.DEXTrades, which keeps about 12 hours and has no archive.
▶️ Volatility of WSOL USDC Pair on Lifinity Dex on Solana
Volatility of a Pair on Meteora Dynamic
Standard deviation of the WSOL/USDC price on Meteora over the last five days. The previous version asked Solana.DEXTrades for a two-hour window more than a year old and reported a volatility of 0, which meant no data rather than no movement. trades is returned alongside so an empty window is visible.
▶️ Volatility of a Pair on Meteora Dynamic
Get the Top Traders of a specific Token on Meteora DBC
The below query gets the Top Traders of the specified Token 4kJkgxzuk1gcjsgRSVhdeSiC15ibQLRDKTuqtf2i16Dm on Meteora DBC.
▶️ Get the Top Traders of a specific Token on Meteora DBC
Raydium
Top 100 About to Graduate Raydium Launchpad Tokens
Returns top 100 About to Graduate Raydium Launchpadn Tokens.
▶️ Top 100 About to Graduate Raydium Launchpad Tokens
Historical PumpFun Migrated Token on Raydium and Pumpswap.
Historical PumpFun Migrated Token on Raydium and Pumpswap. Uses the DEXTradeByTokens cube. Adjust the date range in the where clause. Needs the historical data add-on — see the comment at the top of the query.
▶️ Historical PumpFun Migrated Token on Raydium and Pumpswap.
Get Bonding Curve Progress of a Raydium Launchpad Token
Returns Bonding Curve Percentage of a Raydium Launchpad Token.
▶️ Get Bonding Curve Progress of a Raydium Launchpad Token
Latest Price of a Token on Raydium Launchpad
This query returns the latest price of a token on the Raydium launchpad.
▶️ Latest Price of a Token on Raydium Launchpad
Latest Trades for a specific currency on Raydium
This query returns the latest trades for a token on Raydium. You can set the limit here also.
▶️ Latest Trades for a specific currency on Raydium
DecreaseLiquidityV2 latest raydium clmm
DecreaseLiquidityV2 latest raydium clmm. Uses the Instructions cube. Replace the address in the where clause to use it.
▶️ DecreaseLiquidityV2 latest raydium clmm
IncreaseLiquidityV2 latest raydium clmm
IncreaseLiquidityV2 latest raydium clmm. Uses the Instructions cube. Replace the address in the where clause to use it.
▶️ IncreaseLiquidityV2 latest raydium clmm
Live price of token on raydium - updated
You can use the following query to get the latest price of a token on Raydium DEX on Solana.
▶️ Live price of token on raydium - updated
Raydium CLMM Pool Creation
The mint addresses for the tokens being used in the pool are listed for example tokenMint1 could be any newly deployed token and tokenMint0 can be WSOL , indicating which tokens the CLMM pool will support.
Raydium OHLC for specific pair
If you want to get OHLC data for any specific currency pair on Raydium DEX, you can use.
▶️ Raydium OHLC for specific pair
Top Bought Solana Tokens
Will give most bought Solana Tokens on Raydium.
Top sold Solana Tokens
Will give most sold Solana Tokens on Raydium.
LetsBonk.fun
Latest Price of a LetsBonk.fun Token on Launchpad
Provides the most recent price data for a specific LetsBonk.fun token token Mint Address launched on Raydium Launchpad. You can filter by the token’s MintAddress, and the query will return the last recorded trade price.
▶️ Latest Price of a LetsBonk.fun Token on Launchpad
Latest Trades of a letsbonk.fun token on Launchpad
Fetches the most recent trades of a LetsBonk.fun Token token Mint Address on the Raydium Launchpad. Run the query.
▶️ Latest Trades of a letsbonk.fun token on Launchpad
Liquidity for a Letsbonk.fun token pair
Liquidity for a Letsbonk.fun token pair. Uses the DEXPools cube. Replace the address in the where clause to use it.
▶️ Liquidity for a Letsbonk.fun token pair
Ohlc for letsbonk.fun token
Ohlc for letsbonk.fun token. Uses the DEXTradeByTokens cube. Change the token address in the where clause to use it.
▶️ Ohlc for letsbonk.fun token
Pool address for letsbonk.fun token
Pool address for letsbonk.fun token. Uses the DEXTradeByTokens cube. Change the token address in the where clause to use it.
▶️ Pool address for letsbonk.fun token
Top buyers of a letsbonk.fun token on launchpad
Top buyers of a letsbonk.fun token on launchpad. Uses the DEXTradeByTokens cube. Change the token address in the where clause to use it.
▶️ Top buyers of a letsbonk.fun token on launchpad
Top sellers of a letsbonk.fun token on launchpad
Top sellers of a letsbonk.fun token on launchpad. Uses the DEXTradeByTokens cube. Change the token address in the where clause to use it.
▶️ Top sellers of a letsbonk.fun token on launchpad
Robinhood Chain
Trades
Largest Trades on Robinhood Chain (24h, USD)
Largest Trades on Robinhood Chain (24h, USD). Uses the Trades cube.
▶️ Largest Trades on Robinhood Chain (24h, USD)
Pools trade Latest trades for a token
Tokens also migrate onto other venues once liquid — the same token can show uniswap_v3 and pancake_swap_v3 markets with WETH and USDG quotes.
▶️ Pools trade Latest trades for a token
Pools trade Top tokens by volume
The two-step pattern: pass a token set harvested from TokenCreated into the Trading cube.
▶️ Pools trade Top tokens by volume
Pools trade Crowd Launch bids
The launch transaction also contains the token's mint, the entry contract's TokenCreated, and the auction's first TickInitialized / ClearingPriceUpdated events, so one transaction hash links token, creator, and auction contract.
▶️ Pools trade Crowd Launch bids
Pools trade Latest launches
The decoded TokenCreated event on the two entry contracts is the cleanest launch feed — one row per launch.
▶️ Pools trade Latest launches
Pools trade Launches per day
Grouping by LogHeader.Address too shows the split between the two entry contracts.
▶️ Pools trade Launches per day
Pools trade Most active token creators
Useful for spotting spam-bot deployers — a single wallet can mint hundreds of tokens a day.
▶️ Pools trade Most active token creators
Pools trade PoolKey from TokenLaunched
Pools trade PoolKey from TokenLaunched. Uses the Events cube.
▶️ Pools trade PoolKey from TokenLaunched
Pools trade Token description and image
The filter below pins the factory by address because the entry contract emits a different TokenCreated under the same name (see Reading decoded arguments).
▶️ Pools trade Token description and image
Pools trade TokenDistributed decoded event
Topic0 filtering remains available and is the precise way to pin one exact signature — useful for the overloaded TokenCreated above. Supply the hash without a 0x prefix; see the dataset note below for its one limitation.
▶️ Pools trade TokenDistributed decoded event
Transfers
Ape.store Newly created tokens
Every transfer query on this page is identical except two values: the launchpad address in Transaction.To and the launch-mint Amount.
▶️ Ape.store Newly created tokens
Bags.fm Newly created tokens
Every transfer query on this page is identical except two values: the launchpad address in Transaction.To and the launch-mint Amount.
▶️ Bags.fm Newly created tokens
Bankr Bot Newly created tokens
Every transfer query on this page is identical except two values: the launchpad address in Transaction.To and the launch-mint Amount.
▶️ Bankr Bot Newly created tokens
Flap.sh Newly created tokens using transfer data
Track Flap.sh mints as transfers from the zero address with amount 1000000000 in transactions sent to the Flap.sh contract.
▶️ Flap.sh Newly created tokens using transfer data
Klik Finance Newly created tokens using transfers
Every transfer query on this page is identical except two values: the launchpad address in Transaction.To and the launch-mint Amount.
▶️ Klik Finance Newly created tokens using transfers
Robinhood Chain API - Latest Token Transfers
Robinhood Chain API - Latest Token Transfers. Uses the Transfers cube.
▶️ Robinhood Chain API - Latest Token Transfers
Robinhood Chain Token Lookup by Contract Address
Metadata splits across two sources. Name, symbol, decimals, and contract are indexed on every transfer's Currency object — one query against the launch mint gives you all four for any token.
▶️ Robinhood Chain Token Lookup by Contract Address
Token Lookup by Contract Address - Robinhood Chain
Follow the steps here: How to generate Bitquery API token ➤.
▶️ Token Lookup by Contract Address - Robinhood Chain
Transfers for a token on robinhood
Filter with Transfer.Currency.SmartContract. Example: WETH on Robinhood.
▶️ Transfers for a token on robinhood
Transfers for a wallet on Robinhood
Filter where the address is either Transfer.Sender or Transfer.Receiver to build a full transfer history. Replace the sample address with your wallet or contract.
▶️ Transfers for a wallet on Robinhood
Balances & Holders
Pools trade Per-transaction balance changes
A stream of this filtered to SlippageBasisPoints: {gt: 100} is a ready-made "toxic fill" alert for a token's pool.
▶️ Pools trade Per-transaction balance changes
Wallet Token Balances on Robinhood Chain
Wallet Token Balances on Robinhood Chain. Uses the Balances cube. Replace the address in the where clause to use it. Needs the historical data add-on — see the comment at the top of the query.
▶️ Wallet Token Balances on Robinhood Chain
Price & OHLC
Latest price of a token on a pool
This API endpoint retrieves the latest price of a token for a particular token pair or liquidity pool using the Trading.Pairs cube.
▶️ Latest price of a token on a pool
Latest price of a token
If you want to monitor price for a particular pool, we suggest usage of Trading.Pairs instead of Trading.Tokens where you could specify the pool address.
Pools trade OHLCV price candles
Deduplicate on (TransactionHeader.Hash, Block.Time, Side, Amounts.Base, Pair.QuoteToken.Symbol, Trader.Address) before aggregating.
▶️ Pools trade OHLCV price candles
Supply & Market Cap
Pools trade Token holders and supply
Pools trade Token holders and supply. Uses the Holders cube. Change the token address in the where clause to use it. Needs the historical data add-on — see the comment at the top of the query.
▶️ Pools trade Token holders and supply
Liquidity & Pools
Pools trade Per-swap slippage
Pools trade Per-swap slippage.
▶️ Pools trade Per-swap slippage
Pools trade Pool creation Initialize
The v4 PoolManager's Initialize is decoded, so you can read the same PoolKey without manual decoding — at the cost of having to scope it to a token.
▶️ Pools trade Pool creation Initialize
Transactions
Daily Active Wallets on Robinhood Chain
Daily Active Wallets on Robinhood Chain. Uses the Transactions cube. Needs the historical data add-on — see the comment at the top of the query.
▶️ Daily Active Wallets on Robinhood Chain
Robinhood Chain Daily Transaction Count
Robinhood Chain Daily Transaction Count. Uses the Transactions cube. Needs the historical data add-on — see the comment at the top of the query.
▶️ Robinhood Chain Daily Transaction Count
Robinhood Chain Gas Usage and Gas Price
Robinhood Chain Gas Usage and Gas Price. Uses the Transactions cube.
▶️ Robinhood Chain Gas Usage and Gas Price
Events & Calls
All events from Flap.sh
Every transfer query on this page is identical except two values: the launchpad address in Transaction.To and the launch-mint Amount.
Flap.sh Newly created tokens using logs TokenCreated
Filter Flap.sh TokenCreated events and decode argument values (token address, metadata fields, and related parameters).
▶️ Flap.sh Newly created tokens using logs TokenCreated
New Contracts Deployed on Robinhood Chain
To pin one exact ABI variant — or to match an undecoded method — filter the 4-byte selector instead (uppercase hex, no 0x)
▶️ New Contracts Deployed on Robinhood Chain
Blocks & Validators
Robinhood Chain Blocks per Day and Block Time
Robinhood Chain Blocks per Day and Block Time. Uses the Blocks cube. Needs the historical data add-on — see the comment at the top of the query.
▶️ Robinhood Chain Blocks per Day and Block Time
Uniswap
Uniswap v4 Pools on Robinhood Chain
New Uniswap v4 pools: decoded Initialize events on the PoolManager with currencies, fee tier, tick spacing and hooks.
▶️ Uniswap v4 Pools on Robinhood Chain
Uniswap v4 Hooks in Use on Robinhood Chain
Uniswap v4 Hooks in Use on Robinhood Chain. Uses the Events cube. Replace the address in the where clause to use it.
▶️ Uniswap v4 Hooks in Use on Robinhood Chain
Uniswap v4 Pool Liquidity on Robinhood Chain (pools.trade)
Three realtime cubes carry data traders usually have to compute themselves. All three are realtime-only on Robinhood — dataset: archive and dataset: combined both error — so use them for live monitoring and persist what you need.
▶️ Uniswap v4 Pool Liquidity on Robinhood Chain (pools.trade)
Polymarket
Trades
Latest Trades
Fetch the most recent prediction market trades with full details, ordered by block time.
Total Volume and Yes/No Volume for a Market
Aggregate USD volume for a market over a time window: total volume plus volume per outcome (e.g. Yes/No). Pass the market's outcome token AssetIds in $marketAssets.
▶️ Total Volume and Yes/No Volume for a Market
Trades for a Specific Trader
Fetch all trades where the given address is either Buyer or Seller. Pass the trader address as the $trader variable.
▶️ Trades for a Specific Trader
How do I count trades for a specific Polymarket trader?
Use PredictionTrades with any filter on Buyer or Seller to return the total trade count for a wallet. Add ProtocolName: "polymarket" to restrict to Polymarket only. Replace the address with your target wallet.
▶️ How do I count trades for a specific Polymarket trader?
How do I get top buyers and sellers on Polymarket by volume?
Use PredictionTrades with limitBy and sum(of: Trade_OutcomeTrade_CollateralAmountInUSD) grouped by Buyer (or Seller) to rank the top 100 wallets by volume over the last 5 days. Useful for leaderboards, whale tracking, and trader analytics.
▶️ How do I get top buyers and sellers on Polymarket by volume?
Latest prediction market trades
Fetch the most recent prediction market trades with full details, ordered by block time.
▶️ Latest prediction market trades
Prediction_trades
Prediction_trades.
Top 100 markets by volumein last24 hrs
Rank Polymarket markets by buy + sell collateral USD, with buy/sell breakdown, trade count, distinct buyers/sellers, and optional resolution join. Uses limitBy: Trade_Prediction_Question_Id so each row is one market.
▶️ Top 100 markets by volumein last24 hrs
Top AI markets by volume Polymarket
Returns AI markets (title includes the standalone word " AI ") ranked by USD trading volume in the last 24 hours, with buyer and seller counts. Adjust time_ago, limit, and the title keyword as needed.
▶️ Top AI markets by volume Polymarket
Top Buyers/Sellers of Bitcoin up down market
Returns the top 10 buyers and top 10 sellers by traded volume in Bitcoin Up or Down markets on Polymarket over the last 24 hours. Results are aggregated by trader address and ordered by buy_amount (buyers) or sell_amount (sellers).
▶️ Top Buyers/Sellers of Bitcoin up down market
Markets
Created vs Resolved Count (Last 24 Hours)
Count how many Created and Resolved events occurred in the last 24 hours.
▶️ Created vs Resolved Count (Last 24 Hours)
Latest Creations + Resolutions
Fetch the most recent creation and resolution events with full details, ordered by block time.
▶️ Latest Creations + Resolutions
Latest Market Creations
Fetch the most recent Created events (new markets). All possible outcomes per market are in Prediction.Condition.Outcomes.
Latest Market Resolutions
Query that returns the 10 most recent Resolved events. Winning outcome is in Prediction.Outcome; Prediction.OutcomeToken holds the asset ID and contract details.
Latest Prediction managements (resolutions, creations)
Fetch the most recent creation and resolution events with full details, ordered by block time.
▶️ Latest Prediction managements (resolutions, creations)
Latest polymarket creations
Fetch the most recent Created events. For each market, all possible outcomes are listed under Prediction.Condition.Outcomes.
▶️ Latest polymarket creations
Latest polymarket resolutions
Latest polymarket resolutions.
▶️ Latest polymarket resolutions
Latest resolved crudeoil markets
Returns the 10 most recent Resolved events for Polymarket Crude Oil markets.
▶️ Latest resolved crudeoil markets
Latest resolved sports markets
Returns the 10 most recent Resolved sports markets (management description includes "sports"), including the resolved/winning Outcome and full question metadata. Use this to grade results and settle bets.
▶️ Latest resolved sports markets
Query latest created resolved prediction markets for Bitcoin
Query latest created resolved prediction markets for Bitcoin.
▶️ Query latest created resolved prediction markets for Bitcoin
Settlements
Latest Settlements
Fetch the most recent settlements with full details, ordered by block time.
Latest Whale Settlements
Find the most recent high-value redemptions (e.g. amount ≥ 10,000 in outcome token units). Useful for tracking large payouts and whale activity.
Redemption / Merge / Split Count (Last 1 Hour)
Count how many settlement events occurred in the last hour, grouped by event signature (Split, Merge, Redemption).
▶️ Redemption / Merge / Split Count (Last 1 Hour)
Top 10 Market Questions by Redeemed Amount (Last 1 Hour)
Aggregate redemptions by market question and sort by total redeemed amount. See which markets had the most payout activity recently.
▶️ Top 10 Market Questions by Redeemed Amount (Last 1 Hour)
Top 10 Redeemers (Last 1 Hour)
Rank addresses by total amount redeemed in the last hour across all markets. Useful for leaderboards and whale tracking.
▶️ Top 10 Redeemers (Last 1 Hour)
Top 10 Winners of a Specific Market Question
Rank holders by total redeemed amount for one market (filter by question title).
▶️ Top 10 Winners of a Specific Market Question
Latest prediction market settlements
Fetch the most recent settlements with full details, ordered by block time.
▶️ Latest prediction market settlements
Latest whale settlements on prediction market
Find the most recent high-value redemptions (e.g. amount ≥ 10,000 USD). Useful for tracking large payouts and whale activity.
▶️ Latest whale settlements on prediction market
Redemptions, merge, split count in last 1 hour
Count how many settlement events occurred in the last hour, grouped by event signature (Split, Merge, Redemption).
▶️ Redemptions, merge, split count in last 1 hour
Top 10 redeemers
Rank addresses by total amount redeemed in the last hour across all markets. Useful for leaderboards and whale tracking.
Transfers
Freshwallet check for polymarket
Look up the buyer's earliest on-chain activity. If the wallet's first transfer is close to the time of its first big bet, it is a fresh wallet and scores high. Replace the address with the buyer from Step 1.
▶️ Freshwallet check for polymarket
FundingSource for poylmarket
FundingSource for poylmarket. Uses the Transfers cube. Change the token address in the where clause to use it. Needs the historical data add-on — see the comment at the top of the query.
▶️ FundingSource for poylmarket
SiblingWallets for polymarket
Take the funder from Step 3 and list every other wallet it funded. Wallets sharing a funder are likely controlled by the same operator. A large cluster placing correlated bets is a strong signal.
▶️ SiblingWallets for polymarket
Balances & Holders
Polymarket TVL
Summarize USDC.e (0x2791Bca1f2de4661ED88A30C99A7a9449Aa84174) held by Conditional Tokens and neg-risk wrapped collateral contracts. Extend the Address list if you track additional custodians.
Price & OHLC
Current Price per Outcome (Latest Trade)
Get the latest trade price for each outcome in a market. Uses limitBy for one row per outcome, with Price and PriceInUSD at the most recent block time.
▶️ Current Price per Outcome (Latest Trade)
Current price inside the market for all options based on latest trade
Get the latest trade price for each outcome in a market (e.g. Yes/No, Up/Down—each market defines its own outcome labels).
▶️ Current price inside the market for all options based on latest trade
Latest price of outcomes of a crude oil market
Returns the latest trade price (and price in USD) per outcome for a single market by MarketId. Replace "1570893" with the target Crude Oil market ID from Polymarket or from the creation/resolution queries above.
▶️ Latest price of outcomes of a crude oil market
OHLC of a outcome of a gold market
Returns OHLC (Open, High, Low, Close) in USD for one outcome of a Gold market, bucketed by time (e.g. 1-minute intervals). Replace MarketId "1606192" and outcome "Down" with the desired market and outcome label (e.g. "Up" or "Down").
▶️ OHLC of a outcome of a gold market
Polymarket AI odds movement OHLC
Returns OHLC (Open, High, Low, Close) in USD for one outcome of an AI market, bucketed by interval (here 5 minutes). It shows how the implied probability moved over time, and powers charts and backtests. Replace "<MARKET_ID>" and "<OUTCOME_LABEL>"
▶️ Polymarket AI odds movement OHLC
Polymarket sports odds movement OHLC
Returns OHLC (Open, High, Low, Close) in USD for one outcome of a game, bucketed by interval (here 5 minutes). It shows how the win probability moved over time, and powers line-movement charts and strategy backtests.
▶️ Polymarket sports odds movement OHLC
Liquidity & Pools
Top cricket Markets by Liquidity
Returns the top 100 cricket related polymarkets sorted by liquidity position in the past 24 hours.
▶️ Top cricket Markets by Liquidity
Top FIFA World Cup Markets by Liquidity
Returns the top 100 FIFA World Cup related polymarkets sorted by liquidity position in the past 24 hours. Here position is the metric used for sorting, hence it could be regarded as the liquidity position of the particular market.
▶️ Top FIFA World Cup Markets by Liquidity
Perpetuals
Hyperliquid
Hyperliquid BTC Perp Trades
Hyperliquid BTC Perp Trades. Uses the Trades cube.
▶️ Hyperliquid BTC Perp Trades
Hyperliquid Latest Trades (Perps + Spot + HIP-3)
Each fill carries the execution (price, size, side, aggressor flag), the position it changed (leverage, margin mode, size before, realized PnL) and fees. Direction is one of Open Long, Open Short, Close Long, Close Short.
▶️ Hyperliquid Latest Trades (Perps + Spot + HIP-3)
Hyperliquid Trader Leverage Updates
Hyperliquid Trader Leverage Updates.
▶️ Hyperliquid Trader Leverage Updates
Hyperliquid BTC OHLCV Candles (1 minute)
The Candles cube provides OHLCV per market and interval. Interval.Time.Duration is the candle length in seconds (e.g. 60 for one minute), Start the interval open time. OHLCV values are floats.
▶️ Hyperliquid BTC OHLCV Candles (1 minute)
Hyperliquid Mark Prices (All Markets)
Follow the steps here: How to generate Bitquery API token ➤.
▶️ Hyperliquid Mark Prices (All Markets)
Phoenix
Phoenix Perps Fills by Trader Wallet - Solana
Stream every stop-loss and take-profit placement as it happens.
▶️ Phoenix Perps Fills by Trader Wallet - Solana
Trader Realized PnL on Solana Perps
Rows with Size: 0 are markets they've fully closed — drop them and the rest is the live book, with entry prices.
▶️ Trader Realized PnL on Solana Perps
Whale Trades on Solana Perps (Phoenix)
Positive = received, negative = paid. Replace the field list with total: sum(of: Position_Funding) for the net carry cost of holding their positions.
▶️ Whale Trades on Solana Perps (Phoenix)
Solana Perps OHLC Candles from Mark Price
As a query, add orderBy: { descending: Block_Time } and a limit for the recent whale prints.
▶️ Solana Perps OHLC Candles from Mark Price
Collateral deposits and withdrawals
Deposits and withdrawals of collateral on Phoenix perpetuals, newest first, with trader, signer and fee. Filter by Type for one side only.
▶️ Collateral deposits and withdrawals
TRON
Trades
Historical Tron Token Trades within 30 Days
This query returns the historical trades on the TRON network for a token with the time window of past 30 days. Trading cube — real-time and roughly the last 30 days. For anything older, use the DEXTradeByTokens entries at the bottom of this section.
▶️ Historical Tron Token Trades within 30 Days
Tron DEX Trades
This query returns the latest trades on the TRON network from a trader perspective. Trading cube — real-time and roughly the last 30 days. For anything older, use the DEXTradeByTokens entries at the bottom of this section.
Tron Dex Trade By Tokens
This query returns the latest token trades on the TRON network. Trading cube — real-time and roughly the last 30 days. For anything older, use the DEXTradeByTokens entries at the bottom of this section.
Sunmpump launchtoDEX
This query allows you to track when tokens are launched on SunSwap using the launchToDEX function. It returns the most recent 10 token launches, displaying details such as the token address, transaction hash, block timestamp, and the method call signature.
Sunswap v2 latest Trades — historical (beyond 30 days)
Retrieves details about each trade, including the amounts and prices of tokens bought and sold, as well as information about the trading pair. Built from raw DEX trades, so it reaches back further than the Trading cube's ~30 days. For live prices prefer the Trading cube entries at the top of this section.
▶️ Sunswap v2 latest Trades — historical (beyond 30 days)
Historical Tron Token Trades beyond 30 Days — historical (beyond 30 days)
This query returns the historical token trades on the TRON network for time window beyond 30 days. Built from raw DEX trades, so it reaches back further than the Trading cube's ~30 days. For live prices prefer the Trading cube entries at the top of this section.
▶️ Historical Tron Token Trades beyond 30 Days — historical (beyond 30 days)
All dexs info — historical (beyond 30 days)
Fetches all the DEXs information on Tron network such as unique sellers, unique buyers etc. Built from raw DEX trades, so it reaches back further than the Trading cube's ~30 days. For live prices prefer the Trading cube entries at the top of this section.
▶️ All dexs info — historical (beyond 30 days)
DEX Markets for a token — historical (beyond 30 days)
Fetches the DEXs where a specific token is being traded on Tron network. Built from raw DEX trades, so it reaches back further than the Trading cube's ~30 days. For live prices prefer the Trading cube entries at the top of this section.
▶️ DEX Markets for a token — historical (beyond 30 days)
First 100 buyers tron token — historical (beyond 30 days)
Find the earliest buyers of any Tron token by using Tron DEXTradeByTokens API. This is widely used for memecoin sniper detection, early-holder analysis, and alpha groups monitoring SunPump / SunSwap launches. Built from raw DEX trades, so it reaches back further than the Trading cube's ~30 days. For live prices prefer the Trading cube entries at the top of this section.
▶️ First 100 buyers tron token — historical (beyond 30 days)
Peg health tron — historical (beyond 30 days)
Browse multi-chain stablecoin DEX prices on DEXrabbit's Stablecoins category. Built from raw DEX trades, so it reaches back further than the Trading cube's ~30 days. For live prices prefer the Trading cube entries at the top of this section.
▶️ Peg health tron — historical (beyond 30 days)
Transfers
Historical TRON Transfers for a Wallet
This query returns the historical transfers for a wallet in a given time window on the TRON network and includes details such as token amount transferred, sender, receiver, and token info.
▶️ Historical TRON Transfers for a Wallet
Latest TRON Transfers
This query returns the most recent transfers on the TRON network and includes details such as token amount transferred, sender, receiver, and token info.
Daily transfer volume tron
Aggregate daily transfer volume in USD for any TRC20 token for analytics dashboards, weekly newsletters, and on-chain reports for stablecoins, governance tokens, and memecoins on Tron.
Top transfers of a token
Retrieves the top 10 transfers by amount of the token TXL6rJbvmjD46zeN1JssfgxvSo99qC8MRT.
Tron total txn fees paid by the Account
Get the total fees (in SOL and USD) paid by a specific Tron account across all transfers.
▶️ Tron total txn fees paid by the Account
Transfers of a wallet API
Fetches the recent 10 transfers of a specific wallet address TFXttAWURRrXrd9JvFPVLEh1esJK8NHxn7.
Tron Transaction fees paid by Account aggregated by currency
Get total fees paid by a Tron account for transferring each type of token.
▶️ Tron Transaction fees paid by Account aggregated by currency
Tron wallet transfers with transaction fees paid
Track wallet token transfers and get the fees paid for each by the address.
▶️ Tron wallet transfers with transaction fees paid
Balances & Holders
Historical Balance of a Wallet for a Currency
This query returns the current balance of a wallet for all currencies on the TRON network.
▶️ Historical Balance of a Wallet for a Currency
Top token holders of a token
Returns the top holders of a token ranked by current balance. Use the Holders API with orderBy and limit.
▶️ Top token holders of a token
Tron Balances for Native currency
Returns the native TRX balance for a wallet (not TRC10 or TRC20 tokens). Filter with Currency: { Native: true } instead of a token contract address.
▶️ Tron Balances for Native currency
Tron USDT Balance At Date (Balances Cube)
Unlike summing Transfers, this includes mints, burns, and genesis supply.
▶️ Tron USDT Balance At Date (Balances Cube)
Tron balances by date
Returns balance snapshots over time for an address. Use dataset: archive. Order by Block_Date descending and use limit to paginate. Add Currency.SmartContract under Currency to filter by a specific token.
Tron token balance
Add a Currency.SmartContract filter. Always use the contract address, not the token name.
TronWalletPortfolio Tron
Returns balances for all the currecies owned by a wallet address. Use Amount(selectWhere: { gt: "0" }) to exclude zero balances and dataset: combined for the latest balances.
SunPump Bonding Curve TRX Balance
TRX balance in bonding curve based on dex trades. Calculated as balance = in_sum - out_sum
▶️ SunPump Bonding Curve TRX Balance
SunPump Historical Bonding Curve TRX Balance
Calculated as balance = in_sum - out_sum
▶️ SunPump Historical Bonding Curve TRX Balance
Liquidity & Pools
Sun Pump Virtual Liquidity Pools
Sun Pump does not use a dedicated pool for each pair; instead, all liquidity is managed within a single contract. You can query the virtual liquidity pools directly by running the following query.
▶️ Sun Pump Virtual Liquidity Pools
Events & Calls
Latest created Sunpump tokens
If you remove subscription from the below GraphQL query it will become API, for example check.
▶️ Latest created Sunpump tokens
Latest tokens created on Sunpump
The Arguments include the token address, creator, and token index. You can run it.
▶️ Latest tokens created on Sunpump
TokenPurchased on Sunpump
This query allows you to track TokenPurchased events on SunPump. It retrieves the 10 most recent token purchase events, showing important details such as the token address, buyer information, transaction hash, and token amount involved.
Cross-Chain
Trades
Volume of Multiple Tokens Across Different Chains
Get volume and price change data for multiple tokens trading on different chains (Solana, Ethereum, BSC, Tron) in a single query. Returns volume for 1h, 4h, and 24h periods, plus price change percentages. > Note: For EVM chains (Ethereum, BSC, etc.) in the Trading API, use **all lowercase…
▶️ Volume of Multiple Tokens Across Different Chains
Price & OHLC
SMA and Volume Data (for past 28, 14 and 7 Days Time)
Use this API to get SMA and volume over the past 28 days, with 14 days, and 7 days breakdowns. Note that the oldest possible data it could return is 30 days ago. Trading cube — real-time and roughly the last 30 days. For anything older, use the DEXTradeByTokens entries at the bottom of this section.
▶️ SMA and Volume Data (for past 28, 14 and 7 Days Time)
Historical OHLC of a Token Pair Across Chains
This query fetches historical OHLC (Open, High, Low, Close) price data for a token pair across different blockchains for as long back as 30 days. For native tokens, you only need to specify their ID (e.g., bid:eth for ETH). Trading cube — real-time and roughly the last 30 days. For anything older, use the DEXTradeByTokens entries at the bottom of this section.
▶️ Historical OHLC of a Token Pair Across Chains
Latest Price of Any Token
This query gives you bitcoin currency 1-sec OHLC across different blockchains. You can adjust duration in Duration: {eq: 1} filter. Trading cube — real-time and roughly the last 30 days. For anything older, use the DEXTradeByTokens entries at the bottom of this section.
OHLC of a currency on multiple blockchains
This query retrieves the OHLC (Open, High, Low, Close) prices of a currency(in this eg Bitcoin; it will include all sorts of currencies whose underlying asset is Bitcoin like cbBTC, WBTC, etc) across all supported blockchains, aggregated into a given time interval (e.g., 60 seconds in this example). Trading cube — real-time and roughly the last 30 days. For anything older, use the DEXTradeByTokens entries at the bottom of this section.
▶️ OHLC of a currency on multiple blockchains
Historical Price and Volume Data for a Token Pair beyond 30 days
Use this API to get historical price and volume for a specific token pair address on a specific network for the time window beyond the 30 days. Trading cube — real-time and roughly the last 30 days. For anything older, use the DEXTradeByTokens entries at the bottom of this section.
▶️ Historical Price and Volume Data for a Token Pair beyond 30 days
All time High Trade Price for a Token — historical (beyond 30 days)
Retrieves the all-time high (ATH) price in USD for a specified token contract. All time high price could lie beyond the 30 days window provided by Trading API, hence we use these network specific APIs to get the ATH for a token. While this provides the option to go beyond the 30 days time…. Built from raw DEX trades, so it reaches back further than the Trading cube's ~30 days. For live prices prefer the Trading cube entries at the top of this section.
▶️ All time High Trade Price for a Token — historical (beyond 30 days)
Ethereum
Trades
Latest DEX trades for a token
Most recent swaps for one token across every Ethereum DEX. Change the token address in the Currency: {SmartContract:} filter. Trading cube — real-time and roughly the last 30 days. For anything older, use the DEXTradeByTokens entries at the bottom of this section.
▶️ Latest DEX trades for a token
Trades by a wallet
Every buy and sell made by one address. Replace the wallet in Transaction: {From:}. Trading cube — real-time and roughly the last 30 days. For anything older, use the DEXTradeByTokens entries at the bottom of this section.
All events on fluid DEX VaultFactory
Get a comprehensive list of all events emitted by the Fluid DEX Vault Factory contract. This query aggregates event counts by signature to identify which events are most frequently emitted, helping you understand the contract's activity patterns.
▶️ All events on fluid DEX VaultFactory
Address is Buyer or Seller V2 — historical (beyond 30 days)
Returns trades where the specified address is either as a buyer or a seller. This is achieved by utilizing the any filter, which acts as an OR condition to encompass both buyer and seller roles in the results. Built from raw DEX trades, so it reaches back further than the Trading cube's ~30 days. For live prices prefer the Trading cube entries at the top of this section.
▶️ Address is Buyer or Seller V2 — historical (beyond 30 days)
First 500 buyers of a token — historical (beyond 30 days)
Earliest buyers of a token in order, useful for launch and insider analysis. Needs the historical data add-on — see the comment at the top of the query. Built from raw DEX trades, so it reaches back further than the Trading cube's ~30 days. For live prices prefer the Trading cube entries at the top of this section.
▶️ First 500 buyers of a token — historical (beyond 30 days)
Realised PnL, buy and sell volume — historical (beyond 30 days)
Profit and loss for a wallet on one token, from its own trade history. Needs the historical data add-on — see the comment at the top of the query. Built from raw DEX trades, so it reaches back further than the Trading cube's ~30 days. For live prices prefer the Trading cube entries at the top of this section.
▶️ Realised PnL, buy and sell volume — historical (beyond 30 days)
Buys, Sells, BuyVolume, SellVolume, Makers, TotalTradedVolume, PriceinUSD for a eth pair — historical (beyond 30 days)
Will fetch the buys, sells, buy volume, sell volume and also the number of makers for a particular token just like how DEXScreener shows in its UI. Built from raw DEX trades, so it reaches back further than the Trading cube's ~30 days. For live prices prefer the Trading cube entries at the top of this section.
Coin ticker api — historical (beyond 30 days)
Coin ticker api. Uses the DEXTradeByTokens cube. Change the token address in the where clause to use it. Built from raw DEX trades, so it reaches back further than the Trading cube's ~30 days. For live prices prefer the Trading cube entries at the top of this section.
▶️ Coin ticker api — historical (beyond 30 days)
Dex info — historical (beyond 30 days)
Will fetch a specific DEX stats for the selected network. Built from raw DEX trades, so it reaches back further than the Trading cube's ~30 days. For live prices prefer the Trading cube entries at the top of this section.
▶️ Dex info — historical (beyond 30 days)
Dex markets — historical (beyond 30 days)
Will fetch all the DEXs info for the selected network. Built from raw DEX trades, so it reaches back further than the Trading cube's ~30 days. For live prices prefer the Trading cube entries at the top of this section.
▶️ Dex markets — historical (beyond 30 days)
Transfers
ERC-20 transfers by wallet
Recent token transfers in and out of one address. Replace the address in the where clause.
ERC-20 transfers over a past period
Token transfers for a wallet between two dates. Change since and till. Needs the historical data add-on — see the comment at the top of the query.
▶️ ERC-20 transfers over a past period
Array_intersect example for 2 addresses
Find addresses that have interacted with multiple addresses from a given list. This query uses the array_intersect function to identify addresses that have sent or received funds to/from every address in your list.
▶️ Array_intersect example for 2 addresses
Binance:hot wallet transfers with transaction fees
Track wallet token transfers and get the fees paid for each by the address. SenderFee and SenderFeeInUSD fields in query are the transaction fees in ETH and transaction fees in USD respectively.
▶️ Binance:hot wallet transfers with transaction fees
Find earliest transfer to an account
Find the first transfer ever received by a specific wallet address. This is useful for wallet age analysis, first transaction tracking, and onboarding analytics.
▶️ Find earliest transfer to an account
Get Contract Type in v2
To determine the type of a contract and its details, we can use the Transfer API. By fetching the earliest transfer to the contract, we can get relevant details that indicate the contract type.
Get Minted Address of the ICO Token
In most of the ICOs, the token is minted to a smart contract that contains various methods for distributing the token whenever the conditions set by project owners are satisfied.
▶️ Get Minted Address of the ICO Token
Number of Purchasers in ICO
Number of Purchasers in ICO. Uses the Transfers cube. Change the token address in the where clause to use it. Needs the historical data add-on — see the comment at the top of the query.
▶️ Number of Purchasers in ICO
Transfers sent OR received by an address
Both sides of an address's transfer history in one result, using an OR filter. Needs the historical data add-on — see the comment at the top of the query.
▶️ Transfers sent OR received by an address
Total txn fees paid by binance hot wallet in a day
Get the total fees (in Eth and USD) paid by a specific EVM account across all transfers. SenderFee and SenderFeeInUSD fields in query are the transaction fees in ETH and transaction fees in USD respectively.
▶️ Total txn fees paid by binance hot wallet in a day
Balances & Holders
Current balance of an address
Every token balance held by one wallet, with USD value. Balances are cumulative, so this reads the full history. Needs the historical data add-on — see the comment at the top of the query.
▶️ Current balance of an address
Token holder count
How many addresses hold a token right now. Needs the historical data add-on — see the comment at the top of the query.
Balance of an address at a past date
What a wallet held on a given day. Change the date argument. Needs the historical data add-on — see the comment at the top of the query.
▶️ Balance of an address at a past date
Token holders on a specific date
A holder snapshot for any past day, with per-holder stats. Needs the historical data add-on — see the comment at the top of the query.
▶️ Token holders on a specific date
Token Holders of Multiple Tokens until last month
This API provides a list of top holders along with relevant statistics for a given token liston a specific date using BalanceUpdates API.
▶️ Token Holders of Multiple Tokens until last month
Average Tip in terms of avg gas Fee
Compares average user tip to average total gas fee per block across the last 10 blocks.
▶️ Average Tip in terms of avg gas Fee
Balance Updates for multiple addresses transfer in last 24 hours
Balance Updates for multiple addresses transfer in last 24 hours. Uses the TransactionBalances cube.
▶️ Balance Updates for multiple addresses transfer in last 24 hours
Balance Updates for transfer in last 24 hours
Balance Updates for transfer in last 24 hours. Uses the TransactionBalances cube. Replace the address in the where clause to use it.
▶️ Balance Updates for transfer in last 24 hours
Balance update after transfer received from multiple addresses
Balance update after transfer received from multiple addresses. Uses the TransactionBalances cube.
▶️ Balance update after transfer received from multiple addresses
Balance update after transfer sent from multiple addresses
Balance update after transfer sent from multiple addresses. Uses the TransactionBalances cube.
▶️ Balance update after transfer sent from multiple addresses
Price & OHLC
Token price from top market (rank 1)
Prices WETH from its single top market rather than blending every pool — the recommended way to price one specific token. Replace token in the Variables pane, lowercase.
▶️ Token price from top market (rank 1)
Ohlc of a token pair 1 hour interval
Fetches the Open, High, Low, and Close (OHLC) price data (USD-quoted) for a given token pair across DEXs, using a specified quote token and time interval (in seconds). Trading cube — real-time and roughly the last 30 days. For anything older, use the DEXTradeByTokens entries at the bottom of this section.
▶️ Ohlc of a token pair 1 hour interval
Historical Price and Volume Data for a Token Pair beyond 30 days
Use this API to get historical price and volume for a specific token pair address on a specific network for the time window beyond the 30 days. Trading cube — real-time and roughly the last 30 days. For anything older, use the DEXTradeByTokens entries at the bottom of this section.
▶️ Historical Price and Volume Data for a Token Pair beyond 30 days
Pepe historical ohlcv 30days
Fetch hourly OHLCV candles for the past 30 days. Change Duration for different intervals, such as 60 (1 minute) or 300 (5 minutes). Trading cube — real-time and roughly the last 30 days. For anything older, use the DEXTradeByTokens entries at the bottom of this section.
▶️ Pepe historical ohlcv 30days
Prices for multiple tokens at once — historical (beyond 30 days)
Latest USD price for a list of tokens in a single request. Add addresses to the in filter. Built from raw DEX trades, so it reaches back further than the Trading cube's ~30 days. For live prices prefer the Trading cube entries at the top of this section.
▶️ Prices for multiple tokens at once — historical (beyond 30 days)
Price of a token in realtime — historical (beyond 30 days)
Will give the latest Price of a specified token using DEXTrades API. Here we have calculated the price of a token in USD and also against the sell currency. Here is the. Built from raw DEX trades, so it reaches back further than the Trading cube's ~30 days. For live prices prefer the Trading cube entries at the top of this section.
▶️ Price of a token in realtime — historical (beyond 30 days)
All-time high price of a token — historical (beyond 30 days)
Highest price a token has ever traded at, with the date it happened. Needs the historical data add-on — see the comment at the top of the query. Built from raw DEX trades, so it reaches back further than the Trading cube's ~30 days. For live prices prefer the Trading cube entries at the top of this section.
▶️ All-time high price of a token — historical (beyond 30 days)
OHLCV by pair address — historical (beyond 30 days)
Open, high, low, close and volume candles for one pair. Change the interval to re-bucket the candles. Built from raw DEX trades, so it reaches back further than the Trading cube's ~30 days. For live prices prefer the Trading cube entries at the top of this section.
▶️ OHLCV by pair address — historical (beyond 30 days)
Price change over 5m, 1h, 6h and 24h — historical (beyond 30 days)
Percentage moves across four windows for one token in one query. Built from raw DEX trades, so it reaches back further than the Trading cube's ~30 days. For live prices prefer the Trading cube entries at the top of this section.
▶️ Price change over 5m, 1h, 6h and 24h — historical (beyond 30 days)
Top 10 tokens by price change, last hour — historical (beyond 30 days)
Biggest movers on Ethereum over the past hour, ranked. Built from raw DEX trades, so it reaches back further than the Trading cube's ~30 days. For live prices prefer the Trading cube entries at the top of this section.
▶️ Top 10 tokens by price change, last hour — historical (beyond 30 days)
Price change 5min, 1hr, 6hr precentage of a specific token — historical (beyond 30 days)
Price change 5min, 1hr, 6hr precentage of a specific token. Uses the DEXTradeByTokens cube. Change the token address in the where clause to use it. Needs the historical data add-on — see the comment at the top of the query. Built from raw DEX trades, so it reaches back further than the Trading cube's ~30 days. For live prices prefer the Trading cube entries at the top of this section.
▶️ Price change 5min, 1hr, 6hr precentage of a specific token — historical (beyond 30 days)
Supply & Market Cap
Pepe volume marketcap
Provides the latest trade volume for the past one hour along with the latest market cap.
Top tokens by market cap
Ethereum tokens ranked by market capitalisation.
Total supply and market cap of a token
Current circulating supply and market cap for one token.
▶️ Total supply and market cap of a token
Latest supply of USDT and USDC
Live supply for the two largest stablecoins; swap the addresses for any other tokens.
▶️ Latest supply of USDT and USDC
Get Token Total Supply and Market Cap
Retrieve the total supply and market capitalization of a specific ERC-20 token. This query provides on-chain market cap data.
▶️ Get Token Total Supply and Market Cap
Latest token supply on USDT and USDC on ethereum chain
Get the current total supply for specific tokens like USDC and USDT on Ethereum or any EVM network. This is ideal for stablecoin tracking and portfolio applications.
▶️ Latest token supply on USDT and USDC on ethereum chain
Total Supply and onchain Marketcap of a specific token
This API gives you latest Supply and Marketcap of a token on EVM (here as example we have taken BITGET Token 0x54D2252757e1672EEaD234D27B1270728fF90581 ). Try it out.
▶️ Total Supply and onchain Marketcap of a specific token
Liquidity & Pools
Latest liquidity of a pool
Current reserves on both sides of one pool. Replace the pool address.
Liquidity across all pools of a token
Total liquidity for a token summed across every pool it trades in.
▶️ Liquidity across all pools of a token
Top liquidity pools for a token
The deepest pools holding a token, ranked by liquidity.
▶️ Top liquidity pools for a token
Decoded arguments of a specific function call
Every call to one function with its arguments decoded. Change the method name to track a different function. Needs the historical data add-on — see the comment at the top of the query.
▶️ Decoded arguments of a specific function call
BlackRock USD Institutional Digital Liquidity Fund Latest Issuance
You can use the same as a subscription to monitor issuances in real-time.
▶️ BlackRock USD Institutional Digital Liquidity Fund Latest Issuance
Liquidiy of all token pools
Returns current liquidity across all pools where a token appears as either CurrencyA or CurrencyB. It is useful when you want a token-wide liquidity view across multiple pools and DEXes.
▶️ Liquidiy of all token pools
Top liquidity pools of atoken on ethereum
This query separates results by whether shiba inu is listed as the first token (CurrencyA) or the second token (CurrencyB) in the DEX pool, returning the 10 pools with the highest liquidity for each category.
▶️ Top liquidity pools of atoken on ethereum
Top liquidity pools on Ethereum
You can run and modify this query in the.
▶️ Top liquidity pools on Ethereum
Latest Liquidity Changes of a Specific Pool
Retrieves the latest liquidity events for a specific DEX pool on Ethereum. Use this to check current pool reserves, spot prices, and recent liquidity changes for a particular token pair.
▶️ Latest Liquidity Changes of a Specific Pool
Transactions
Transactions by wallet
Recent transactions sent from or to an address.
Look up a transaction by hash
Full detail for a single transaction. Paste the hash into the where clause.
▶️ Look up a transaction by hash
Transaction value in USD
Converts transaction value to USD at the time it was mined.
Debug traceTransaction
To trace a transaction using the debug_traceTransaction we need the transaction hash. We are using.
Eth getBlockReceipt
In this section we will build an API that serves as an alternative to the eth_getBlockReceipts JSON RPC method that takes Block Number as an input and returns all transaction receipts for the given block.
Eth getTransactionByHash
Eth getTransactionByHash. Uses the Transactions cube.
Eth getTransactionReceipt
In this section, we will build an alternative to the eth_getTransactionReceipt JSON RPC method using the Bitquery APIs. The method is used to provide the receipt of a transaction given transaction hash.
Internal transactions of a transaction
The internal calls a transaction produced — what a block explorer shows as internal txns.
▶️ Internal transactions of a transaction
Events & Calls
Latest smart contract calls
Decoded contract calls with their arguments.
▶️ Latest smart contract calls
Latest events and logs
Decoded event logs as they land. Filter by contract or by event name.
All aave v3 events latest
Shows latest 10 events emitted by the AAVE V3 contract. The Log field in the results will contain information about the event, including its signature, smart contract address, and transaction hash.
ByteCode of A Token
Will return the most recent transaction that created the token contract. The Output field of the Call object in the transaction contains the encoded bytecode of the contract.
Find the deployer of a contract
Returns which address created a given contract, and when. Needs the historical data add-on — see the comment at the top of the query.
▶️ Find the deployer of a contract
Debug_traceCall
In this section, we will discuss how we can use Bitquery APIs as an alternative to the debug_traceCall JSON RPC method, which runs an eth_call within the context of the given block execution using the final state of parent block as the base.
ETH/BSC SC creates count over date
This query below, will return the number of new smart contracts created on the Ethereum and Binance Smart Chain networks since a particular date. It will also return the date of each day on which new smart contracts were created.
▶️ ETH/BSC SC creates count over date
Eth getLogs with filters
Now, just like the orignal eth_getLogs method, Bitquery APIs provides the option to filter out the Logs based on the following parameeters.
Mempool
Get next available nonce
The following query helps you determine the next available nonce for an Ethereum account by getting the latest transaction in the mempool (broadcasted transactions). The returned nonce is the highest nonce used by the account in the mempool.
Simulating Pending Transactions
Retrieves information about in-flight transactions, helping you simulate the most recent state. It is a way to see if they will succeed without sending them on-chain.
▶️ Simulating Pending Transactions
Blocks & Validators
Aggregate Self-Destruct Statistics
Calculate total ETH destroyed or received from self-destructs using aggregation functions.
▶️ Aggregate Self-Destruct Statistics
QuasarBuilder MEV Payout Transaction Balance
This query focuses on a block builder address and returns the most recent payouts, including the token metadata, pre/post balances, and USD valuations, so you can quickly see how large each MEV reward was.
▶️ QuasarBuilder MEV Payout Transaction Balance
Self-Destruct Balance Decrease API
Monitor contract balance decrease when contracts are self-destructing.
▶️ Self-Destruct Balance Decrease API
Self-Destruct Balance Increase API
Monitor contract balance increase when contracts are self-destructing.
▶️ Self-Destruct Balance Increase API
Top validators by total tips in last 24 hrs
Ranks validators by cumulative priority fees (reason code 5) received in the last 24 hours.
▶️ Top validators by total tips in last 24 hrs
Total tips received by a validator in last 24 hrs
Returns the total priority fees (native and USD) earned by a specific validator over the last 24 hours.
▶️ Total tips received by a validator in last 24 hrs
Uniswap
Latest slippage on a Uniswap v3 pool
Per-trade slippage for one v3 pool, to size orders before sending them.
▶️ Latest slippage on a Uniswap v3 pool
All Pool_Ids for currency
These swaps use the chain-specific DEXTrades cube via EVM { DEXTrades }: Trade.PoolId, pool-relative Buy/Sell (DEXTrades cube). USD can be thin on small pools—use live swaps above when you want the Trading row shape.
Fee collection on Uniswap v3 Positions
It returns decoded arguments—including the Uniswap position tokenId, the recipient address, and the collected amount0 and amount1 values (raw integer amounts).
▶️ Fee collection on Uniswap v3 Positions
Latest ModifyLiquidity Events on Uniswap v4
Track the most recent liquidity modifications on Uniswap V4 by querying ModifyLiquidity events from the PoolManager contract.
▶️ Latest ModifyLiquidity Events on Uniswap v4
Latest trades of a Uniswap pair
Trades for one Uniswap pair. Replace the pair address.
▶️ Latest trades of a Uniswap pair
Latest liquidity for a currency pair across all v4 pools
This API endpoint provides latest liquidity event for every Uniswap V4 pool for a given currency pair. This info includes the Price of currencies in terms of other, Price of currencies in USD, Currency Details and PoolIDs.
▶️ Latest liquidity for a currency pair across all v4 pools
Latest liquidity for an individual pool on uniswap v4
Returns the most recent liquidity event for a single Uniswap v4 pool. Replace $poolId with your target PoolId (from trades UI, subgraph, or a prior DEXTradeByTokens / DEXPoolEvents discovery query).
▶️ Latest liquidity for an individual pool on uniswap v4
Latest slippage of a pool on Uniswap v3 Ethereum
Retrieves the latest slippage data for a specific DEX pool on Ethereum. Use it to calculate slippage and check Uniswap V3 price impact slippage for a particular token pair before trading.
▶️ Latest slippage of a pool on Uniswap v3 Ethereum
Latest trade price of uniswap pair
Here's an example of tracking Uniswap token pair trading price.
▶️ Latest trade price of uniswap pair
Latest trades for a Pool Id on uniswap v4
Latest trades for a Pool Id on uniswap v4. Uses the DEXTrades cube.
▶️ Latest trades for a Pool Id on uniswap v4
PancakeSwap
Latest Trades on PancakeSwap V3 ETH
The PancakSwap DEX Data is also available for view as a dashboard at DEXRABBIT.
▶️ Latest Trades on PancakeSwap V3 ETH
Top Traders of a token on PancakeSwap on ETH
Top Traders of a token on PancakeSwap on ETH. Uses the DEXTradeByTokens cube. Change the token address in the where clause to use it.
▶️ Top Traders of a token on PancakeSwap on ETH
Top token pairs on PancakeSwap v3
Top token pairs on PancakeSwap v3. Uses the DEXTradeByTokens cube. Change the token address in the where clause to use it.
▶️ Top token pairs on PancakeSwap v3
BSC
Trades
BSC DEX Trades
This query returns the latest trades on the BSC network from a trader perspective and returns useful metrics such as marketcap and pool ranking. Trading cube — real-time and roughly the last 30 days. For anything older, use the DEXTradeByTokens entries at the bottom of this section.
BSC Dex Trade By Tokens
This query returns the latest trades on the BSC network. This is useful when looking for trades of a token. Trading cube — real-time and roughly the last 30 days. For anything older, use the DEXTradeByTokens entries at the bottom of this section.
Get Trades by a Trader
Get all trades by a particular trader. Trading cube — real-time and roughly the last 30 days. For anything older, use the DEXTradeByTokens entries at the bottom of this section.
First 500 buyers of a specific BSC chain token — historical (beyond 30 days)
Below API gets you the first 500 buyers of a specific BSC token, here as example we have taken this token 0x031b41e504677879370e9DBcF937283A8691Fa7f. Built from raw DEX trades, so it reaches back further than the Trading cube's ~30 days. For live prices prefer the Trading cube entries at the top of this section.
▶️ First 500 buyers of a specific BSC chain token — historical (beyond 30 days)
Get all the DEXs on BSC network — historical (beyond 30 days)
Retrieves all the DEXes operating on BSC network and gives info such as ProtocolName , ProtocolVersion and ProtocolFamily. Built from raw DEX trades, so it reaches back further than the Trading cube's ~30 days. For live prices prefer the Trading cube entries at the top of this section.
▶️ Get all the DEXs on BSC network — historical (beyond 30 days)
Latest Flap.sh trades using DEXTrades API — historical (beyond 30 days)
Monitor all recent trades across Flap.sh tokens using the DEXTrades API. Built from raw DEX trades, so it reaches back further than the Trading cube's ~30 days. For live prices prefer the Trading cube entries at the top of this section.
▶️ Latest Flap.sh trades using DEXTrades API — historical (beyond 30 days)
Top Gainers on BSC — historical (beyond 30 days)
Get Top Gainers for the BSC network. Built from raw DEX trades, so it reaches back further than the Trading cube's ~30 days. For live prices prefer the Trading cube entries at the top of this section.
▶️ Top Gainers on BSC — historical (beyond 30 days)
All dexs info on bsc — historical (beyond 30 days)
Will fetch all the DEXs info for the BSC network. Built from raw DEX trades, so it reaches back further than the Trading cube's ~30 days. For live prices prefer the Trading cube entries at the top of this section.
▶️ All dexs info on bsc — historical (beyond 30 days)
Get all dex markets for a token — historical (beyond 30 days)
Will fetch all the DEXs where a token is listed for the BSC network. Built from raw DEX trades, so it reaches back further than the Trading cube's ~30 days. For live prices prefer the Trading cube entries at the top of this section.
▶️ Get all dex markets for a token — historical (beyond 30 days)
Latest Flap.sh trades for a specific token — historical (beyond 30 days)
Get trading activity for a specific Flap.sh token using DEXTradeByTokens API. Built from raw DEX trades, so it reaches back further than the Trading cube's ~30 days. For live prices prefer the Trading cube entries at the top of this section.
▶️ Latest Flap.sh trades for a specific token — historical (beyond 30 days)
Settlements
Gra fun redeem transactions
Gra fun redeem transactions. Uses the Events cube. Replace the address in the where clause to use it.
▶️ Gra fun redeem transactions
Transfers
Get Historical ERC20 token transfers by wallet
Get ERC20 token transfers for an address in a given historical time window
▶️ Get Historical ERC20 token transfers by wallet
Get token transfers by wallet
Get token transactions ordered by block number in descending order.
▶️ Get token transfers by wallet
Check if an address interacted with predict.fun ever
Predict.fun flows on BSC often show up as USDT (0x55d398326f99059fF775485246999027B3197955) transfers from the user's wallet to one of the protocol contract addresses listed below.
▶️ Check if an address interacted with predict.fun ever
Check who created this meme rush token
Fetches the developer address that created a specific Meme Rush token on BSC by tracing the minting transfer (from the zero address) of that token’s smart contract.
▶️ Check who created this meme rush token
Check who created this token
Fetches the developer address that created a specific Four.Meme token on BSC by tracing the minting transfer (from the zero address) of that token’s smart contract.
▶️ Check who created this token
First transfers of a token
Retrieves the first transfer of a token to each address, providing the timestamp when each address first received the token.
Meme rush tokens created by specific dev
This API fetches Binance Meme Rush tokens created by a specific dev on BSC by tracking token minting transfers signed by a particular dev. Dev Address here in example is 0xF4f3eb591c47d14614D3A54aCBA28019e2041066.
▶️ Meme rush tokens created by specific dev
New Flap.sh Tokens Created Using Transfers API
Track newly created Flap.sh tokens by monitoring transfers from the zero address with token addresses ending in the vanity suffix.
▶️ New Flap.sh Tokens Created Using Transfers API
Sender OR Receiver Transfer Example BSC
Sender OR Receiver Transfer Example BSC. Uses the Transfers cube. Replace the address in the where clause to use it. Needs the historical data add-on — see the comment at the top of the query.
▶️ Sender OR Receiver Transfer Example BSC
Token created by specific dev
This API fetches Four.Meme tokens created by a specific dev on BSC by tracking token minting transfers signed by a particular dev. Dev Address here in example is 0x9c75588640605d46b42f2d64c5c2e993de251210.
▶️ Token created by specific dev
Balances & Holders
Get latest BNB balance of an wallet
Get latest BNB balance of an wallet.
▶️ Get latest BNB balance of an wallet
Average Tip in terms of avg gas Fee bsc
Compares average user tip to average total gas fee per block across the last 10 blocks.
▶️ Average Tip in terms of avg gas Fee bsc
Latest balance of an address for a specific token bsc
This API gives you latest balance of a specific address (here in example 0x238a358808379702088667322f80ac48bad5e6c4) for a specific token (here we have taken example of USDC 0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48). Try it out.
▶️ Latest balance of an address for a specific token bsc
Top 10 holders percentage
Calculates the percentage of total supply held by the top 10 holders of a specific Four Meme token on BSC.
Track recent ephemeral contract patterns bsc
Many MEV bots and arbitrage executors create contracts that are destroyed within the same transaction. These short-lived contracts are used for.
▶️ Track recent ephemeral contract patterns bsc
Balance Updates for multiple addresses transfer in last 24 hours bsc
Balance Updates for multiple addresses transfer in last 24 hours bsc. Uses the TransactionBalances cube.
▶️ Balance Updates for multiple addresses transfer in last 24 hours bsc
Balance Updates for transfer in last 24 hours bsc
Balance Updates for transfer in last 24 hours bsc. Uses the TransactionBalances cube. Replace the address in the where clause to use it.
▶️ Balance Updates for transfer in last 24 hours bsc
Balance update after transfer received bsc
Balance update after transfer received bsc. Uses the TransactionBalances cube. Replace the address in the where clause to use it.
▶️ Balance update after transfer received bsc
Balance update after transfer received from multiple addresses bsc
Balance update after transfer received from multiple addresses bsc. Uses the TransactionBalances cube.
▶️ Balance update after transfer received from multiple addresses bsc
Balance update after transfer sent bsc
Balance update after transfer sent bsc. Uses the TransactionBalances cube. Replace the address in the where clause to use it.
▶️ Balance update after transfer sent bsc
Price & OHLC
Token price from top market (rank 1)
Prices WBNB from its single top market rather than blending every pool — the recommended way to price one specific token. Replace token in the Variables pane, lowercase.
▶️ Token price from top market (rank 1)
OHLCV data for specific Flap.sh token against BNB
Get OHLCV data for Flap.sh tokens paired with BNB. Trading cube — real-time and roughly the last 30 days. For anything older, use the DEXTradeByTokens entries at the bottom of this section.
▶️ OHLCV data for specific Flap.sh token against BNB
OHLCV data for specific Flap.sh token in USD
Get OHLCV (Open, High, Low, Close, Volume) data for Flap.sh tokens quoted in USD. Trading cube — real-time and roughly the last 30 days. For anything older, use the DEXTradeByTokens entries at the bottom of this section.
▶️ OHLCV data for specific Flap.sh token in USD
BEP-20 Token Price — historical (beyond 30 days)
Get the latest price of a BEP-20 token on BSC network. Built from raw DEX trades, so it reaches back further than the Trading cube's ~30 days. For live prices prefer the Trading cube entries at the top of this section.
▶️ BEP-20 Token Price — historical (beyond 30 days)
Get Price Change 5min, 1h, 6h and 24h of a specific BSC token — historical (beyond 30 days)
This query gets you Price Change 5min, 1h, 6h and 24h of a specific token on the BSC network. Built from raw DEX trades, so it reaches back further than the Trading cube's ~30 days. For live prices prefer the Trading cube entries at the top of this section.
▶️ Get Price Change 5min, 1h, 6h and 24h of a specific BSC token — historical (beyond 30 days)
OHLC for a BEP-20 Token — historical (beyond 30 days)
Get OHLC statistics for a BEP-20 token on BSC network. Built from raw DEX trades, so it reaches back further than the Trading cube's ~30 days. For live prices prefer the Trading cube entries at the top of this section.
▶️ OHLC for a BEP-20 Token — historical (beyond 30 days)
Top 10 BSC Tokens by Price Change in last 1h — historical (beyond 30 days)
This query gets you top 10 BSC Tokens by Price Change in last 1h. Built from raw DEX trades, so it reaches back further than the Trading cube's ~30 days. For live prices prefer the Trading cube entries at the top of this section.
▶️ Top 10 BSC Tokens by Price Change in last 1h — historical (beyond 30 days)
BSC OHLC API For Token Pair — historical (beyond 30 days)
Will fetch the OHLC of a token pair for the BSC network. Built from raw DEX trades, so it reaches back further than the Trading cube's ~30 days. For live prices prefer the Trading cube entries at the top of this section.
▶️ BSC OHLC API For Token Pair — historical (beyond 30 days)
Meme rush token ATH price — historical (beyond 30 days)
Fetches the All-Time High (ATH) price of a specific Meme Rush token on BSC, using the DEXTradeByTokens dataset to calculate the 98th percentile of trade prices (approximate ATH). Built from raw DEX trades, so it reaches back further than the Trading cube's ~30 days. For live prices prefer the Trading cube entries at the top of this section.
▶️ Meme rush token ATH price — historical (beyond 30 days)
Latest price of a token on bsc — historical (beyond 30 days)
Will fetch latest trades for a token pair for the BSC network. Built from raw DEX trades, so it reaches back further than the Trading cube's ~30 days. For live prices prefer the Trading cube entries at the top of this section.
▶️ Latest price of a token on bsc — historical (beyond 30 days)
Percentage price change for a meme rush token — historical (beyond 30 days)
Use the below query to get the price change in percentage for various time fields including 24 hours, 1 hour and 5 minutes. Try it. Built from raw DEX trades, so it reaches back further than the Trading cube's ~30 days. For live prices prefer the Trading cube entries at the top of this section.
▶️ Percentage price change for a meme rush token — historical (beyond 30 days)
Supply & Market Cap
Top Tokens by Market Cap on bsc
Ranks tokens on BNB Smart Chain by Supply.MarketCap, with 24h window, 1s interval, $1,000+ USD volume, limitBy per Token_Id, up to 50 rows. Token.Network is Binance Smart Chain.
▶️ Top Tokens by Market Cap on bsc
Get Total Supply and Marketcap of an ERC20 token
Get Total Supply and Marketcap of an ERC20 token.
▶️ Get Total Supply and Marketcap of an ERC20 token
Total Supply and onchain Marketcap of a specific token bsc
This API gives you latest Supply and Marketcap of a token on BSC (here as example we have taken a BEP-20 token 0x55d398326f99059ff775485246999027b3197955). Try it out.
▶️ Total Supply and onchain Marketcap of a specific token bsc
Liquidity & Pools
Latest Slippage for a Specific Pool
This query retrieves the latest slippage data for a specific DEX pool on BSC. Use this to check current liquidity depth and price impact for a particular token pair.
▶️ Latest Slippage for a Specific Pool
Latest Liquidity Changes of a Specific Pool
Retrieves the latest liquidity events for a specific DEX pool on BSC. Use this to check current pool reserves, spot prices, and recent liquidity changes for a particular token pair.
▶️ Latest Liquidity Changes of a Specific Pool
Transactions
Get transactions by wallet
Get transactions ordered by block number in descending order.
Gra fun buy transactions
Retrieve all buy transactions from GRA.fun using.
Gra fun sell transactions
Retrieve all sell transactions on GRA fun using.
Events & Calls
Latest Calls on BSC network
Retrieves the latest successful smart contract calls on the BNB Smart Chain (BSC). It fetches details about contract interactions, transaction metadata, and associated block information.
▶️ Latest Calls on BSC network
Latest flap.sh token created using events data
Monitor token creation events directly from the Flap.sh portal contract for more detailed information.
▶️ Latest flap.sh token created using events data
Blocks & Validators
Aggregate Self-Destruct Statistics bsc
Calculate total ETH destroyed or received from self-destructs using aggregation functions.
▶️ Aggregate Self-Destruct Statistics bsc
Self-Destruct Balance Decrease API bsc
Monitor contract balance decrease when contracts are self-destructing.
▶️ Self-Destruct Balance Decrease API bsc
Self-Destruct Balance Increase API bsc
Monitor contract balance increase when contracts are self-destructing.
▶️ Self-Destruct Balance Increase API bsc
Top validators by total tips in last 24 hrs bsc
Ranks validators by cumulative priority fees (reason code 5) received in the last 24 hours.
▶️ Top validators by total tips in last 24 hrs bsc
Historical Miner Balance Data bsc
Historical Miner Balance Data bsc. Uses the TransactionBalances cube.
▶️ Historical Miner Balance Data bsc
Total tips received by a validator in last 24 hrs bsc
Returns the total priority fees (native and USD) earned by a specific validator over the last 24 hours.
▶️ Total tips received by a validator in last 24 hrs bsc
PancakeSwap
OHLC of a Token on PancakeSwap
Get the OHLC stats of a token traded on Pancakeswap.
▶️ OHLC of a Token on PancakeSwap
Price of a Token on PancakeSwap
Get the latest price of a token traded on Pancakeswap.
▶️ Price of a Token on PancakeSwap
Trades on Pancakeswap
Get the latest trades on Pancakeswap.
All pools of a token on pancake swap
All pools of a token on pancake swap. Uses the DEXTradeByTokens cube. Change the token address in the where clause to use it.
▶️ All pools of a token on pancake swap
Bsc pancakeswap ohlc using trading api
Bsc pancakeswap ohlc using trading api. Uses the Pairs cube.
▶️ Bsc pancakeswap ohlc using trading api
Get Latest Price of a token on PancakeSwap Infinity
Below query will get you Latest Price of a token on PancakeSwap Infinity.
▶️ Get Latest Price of a token on PancakeSwap Infinity
Get metadata for bsc pancakeswap infnity token
Use the below query to get Token's metadata like Name, symbol, SmartContract Address, Decimals.
▶️ Get metadata for bsc pancakeswap infnity token
Get metadata pancakeswap
Use the below query to get Token's metadata like Name, symbol, SmartContract Address, Decimals.
Four Meme
Get Dev and Age of Four Meme Token
Below query retrieves the Dev address and time when a Four Meme Token was created.
▶️ Get Dev and Age of Four Meme Token
Get Newly Created Tokens on Four Meme
This query retrieves newly created tokens on Four Meme by listening to the TokenCreate event. The response provides token information including creator address, token contract address, name, symbol, total supply, and launch details.
▶️ Get Newly Created Tokens on Four Meme
Liquidity Addition for Four Meme Token
Get the liquidity addition events for a specific token on the Four Meme Exchange.
▶️ Liquidity Addition for Four Meme Token
Four meme - token ATH price
Fetches the All-Time High (ATH) price of a specific Four.Meme token on BSC, using the DEXTradeByTokens dataset to calculate the 98th percentile of trade prices (approximate ATH).
▶️ Four meme - token ATH price
Get first buys of an address list of a specific token
This query checks if the addresses from Query 1 ever bought the token and when. Pass the address array from Query 1 as a variable to this query.
▶️ Get first buys of an address list of a specific token
If meme rush token migrated from four meme or not
Below query will only show response if a the mentioned meme rush tokens have migrated to Pancakeswap. Note: Please use a Block{Date} filter to minimize the data processing and hence the query processing time and get fast responses.
▶️ If meme rush token migrated from four meme or not
If token migrated from four meme or not
Below query will only show response if a the mentioned four meme tokens have migrated to Pancakeswap. Note: Please use a Block{Date} filter to minimize the data processing and hence the query processing time and get fast responses.
▶️ If token migrated from four meme or not
Top buyers of a four meme token
Top buyers of a four meme token. Uses the DEXTrades cube. Change the token address in the where clause to use it. Needs the historical data add-on — see the comment at the top of the query.
▶️ Top buyers of a four meme token
Top buyers of a meme rush token
Top buyers of a meme rush token. Uses the DEXTrades cube. Change the token address in the where clause to use it. Needs the historical data add-on — see the comment at the top of the query.
▶️ Top buyers of a meme rush token
Top tokens by launch marketcap on fourmeme
Below API can be used to get top four meme tokens by launch marketcap (marketcap at the time of launching). You can get all the data through us and create a min and max marketcap filter in your application.
▶️ Top tokens by launch marketcap on fourmeme
Uniswap
Trading Pairs on a BSC DEX
Get all trading pairs present on a BSC network DEX.
Get metadata
Use the below query to get Token's metadata like Name, symbol, SmartContract Address, Decimals.
▶️ Get metadata
Latest Trades for a currency pair on bsc
Latest Trades for a currency pair on bsc. Uses the DEXTrades cube.
▶️ Latest Trades for a currency pair on bsc
OHLC on BSC Uniswap v3
Retrieves the Open, High, Low, and Close (OHLC) prices in USD for a specific token traded on Uniswap v3 over a defined time period and interval.
Top bought tokens on bsc uniswap v3
Will fetch the top bought tokens on uniswap v3.
▶️ Top bought tokens on bsc uniswap v3
Top buyers of a currency on uniswap v4 bsc
Top buyers of a currency on uniswap v4 bsc. Uses the DEXTrades cube. Change the token address in the where clause to use it.
▶️ Top buyers of a currency on uniswap v4 bsc
Top sellers of a token on uniswap v4 pool bsc
Top sellers of a token on uniswap v4 pool bsc. Uses the DEXTrades cube. Change the token address in the where clause to use it.
▶️ Top sellers of a token on uniswap v4 pool bsc
Top sold tokens on bsc uniswap v3
Will fetch the top bought tokens on uniswap v3.
▶️ Top sold tokens on bsc uniswap v3
Top traders of a token on uniswapv3 bsc
Will fetch top traders of a token for the selected network.
▶️ Top traders of a token on uniswapv3 bsc
Trade stats for a token pair on uniswap v4 bsc
Trade stats for a token pair on uniswap v4 bsc. Uses the DEXTradeByTokens cube.
▶️ Trade stats for a token pair on uniswap v4 bsc
Base
Trades
Base DEX Trades
This query returns the latest trades on the Base network from a trader perspective and returns useful metrics such as marketcap and pool ranking. Trading cube — real-time and roughly the last 30 days. For anything older, use the DEXTradeByTokens entries at the bottom of this section.
Base Dex Trade By Tokens
This query returns the latest trades on the Base network. This is useful when looking for trades of a token. Trading cube — real-time and roughly the last 30 days. For anything older, use the DEXTradeByTokens entries at the bottom of this section.
Get Trades by a Trader
Get all trades by a particular trader. Trading cube — real-time and roughly the last 30 days. For anything older, use the DEXTradeByTokens entries at the bottom of this section.
Top Traders by PnL of a specific base pool
Rank traders by PnL on one pool: filter Pair.Market.Address, last 30 minutes, limit: 10, and orderBy PnL descending. Useful for leaderboards, smart-money screens, and pool-specific trader analytics. Trading cube — real-time and roughly the last 30 days. For anything older, use the DEXTradeByTokens entries at the bottom of this section.
▶️ Top Traders by PnL of a specific base pool
Ape store token trades
Ape store token trades. Uses the Calls cube. Replace the address in the where clause to use it.
First 500 buyers of a specific base token — historical (beyond 30 days)
Below API gets you the first 500 buyers of a specific Base chain token, here as example we have taken this token 0x58538e6A46E07434d7E7375Bc268D3cb839C0133. Built from raw DEX trades, so it reaches back further than the Trading cube's ~30 days. For live prices prefer the Trading cube entries at the top of this section.
▶️ First 500 buyers of a specific base token — historical (beyond 30 days)
Latest Trades of a Token on Zora Base — historical (beyond 30 days)
Latest Trades of a Token on Zora Base. Uses the DEXTrades cube. Change the token address in the where clause to use it. Built from raw DEX trades, so it reaches back further than the Trading cube's ~30 days. For live prices prefer the Trading cube entries at the top of this section.
▶️ Latest Trades of a Token on Zora Base — historical (beyond 30 days)
Latest Zora Trades on Base — historical (beyond 30 days)
Fetches the latest DEX trades on the Zora protocol (zora_v4) on Base blockchain. Built from raw DEX trades, so it reaches back further than the Trading cube's ~30 days. For live prices prefer the Trading cube entries at the top of this section.
▶️ Latest Zora Trades on Base — historical (beyond 30 days)
Most Traded Tokens on Aerodome Last Month — historical (beyond 30 days)
Discover the most actively traded tokens on Aerodrome Finance over any time period. This query analyzes all DEX trades within a specified timeframe and ranks tokens by trade count, helping you identify trending tokens and market activity patterns. Built from raw DEX trades, so it reaches back further than the Trading cube's ~30 days. For live prices prefer the Trading cube entries at the top of this section.
▶️ Most Traded Tokens on Aerodome Last Month — historical (beyond 30 days)
Transfers
Get Historical ERC20 token transfers by wallet
Get ERC20 token transfers for an address in a given historical time window
▶️ Get Historical ERC20 token transfers by wallet
Get token transfers by wallet
Get token transactions ordered by block number in descending order.
▶️ Get token transfers by wallet
Newly created zora tokens
Retrieves the list of newly created tokens on Zora Launchpad by monitoring transfers where new tokens are minted (sender is the zero address) with a specific amount.
Tx from to base address
We use the any filter [ OR condition] to get transactions from or to a wallet.
Balances & Holders
Current balance of an address
Every token balance held by one Base address. Balances are cumulative, so this reads the whole history — replace the address to use it.
▶️ Current balance of an address
Real-Time Holders of Multiple Tokens
This API leverages the balanceUpdate endpoint to deliver real-time holder data for multiple tokens.
▶️ Real-Time Holders of Multiple Tokens
Token Holder Count on a Specific Date
This API returns the total number of holders for a specific token on a given date.
▶️ Token Holder Count on a Specific Date
Token Holders and Stats on a Specific Date - TokenHolders API
This API provides a list of all holders along with relevant statistics for a given token on a specific date.
▶️ Token Holders and Stats on a Specific Date - TokenHolders API
Token Holders of Multiple Tokens on a speicifc date
This API provides a list of top holders along with relevant statistics for a given token liston a specific date using Holders API.
▶️ Token Holders of Multiple Tokens on a speicifc date
Get All Token Balances for an Address
Retrieve all token balances held by a specific address. This query returns balances for all tokens the address holds.
▶️ Get All Token Balances for an Address
Get latest token balance of a wallet
Get latest token balance of a wallet.
▶️ Get latest token balance of a wallet
Base balances address
Returns token balances for a wallet address. Use Amount(selectWhere: { gt: "0" }) to exclude zero balances.
Base native balances address
Returns the native ETH balance for a wallet on Base (not ERC-20 tokens). Filter with Currency: { Native: true } instead of a token contract address.
▶️ Base native balances address
Latest balance of an address for a specific token base
This API gives you latest balance of a specific address (here in example 0x238a358808379702088667322f80ac48bad5e6c4) for a specific token (here we have taken example of USDC 0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48). Try it out.
▶️ Latest balance of an address for a specific token base
Token holder snapshot base
The number of unique holders, token supply, and Gini coefficient for the balance amount before a specific timestamp can be derived using the query below. These stats provide a useful holder snapshot for any given time.
Price & OHLC
Token price from top market (rank 1)
Prices WETH from its single top market rather than blending every pool — the recommended way to price one specific token. Replace token in the Variables pane, lowercase.
▶️ Token price from top market (rank 1)
Get Multiple Token Prices — historical (beyond 30 days)
Returns an array of token prices denominated in the blockchain's native token and USD for a given token contract address. Built from raw DEX trades, so it reaches back further than the Trading cube's ~30 days. For live prices prefer the Trading cube entries at the top of this section.
▶️ Get Multiple Token Prices — historical (beyond 30 days)
Get ATH Price of a token — historical (beyond 30 days)
Retrieves the all-time high (ATH) price in USD for a specified token contract. Built from raw DEX trades, so it reaches back further than the Trading cube's ~30 days. For live prices prefer the Trading cube entries at the top of this section.
▶️ Get ATH Price of a token — historical (beyond 30 days)
Get OHLCV by Pair Address — historical (beyond 30 days)
Get the OHLCV candle stick by using pair address. Built from raw DEX trades, so it reaches back further than the Trading cube's ~30 days. For live prices prefer the Trading cube entries at the top of this section.
▶️ Get OHLCV by Pair Address — historical (beyond 30 days)
Get Price Change 5min, 1h, 6h and 24h of a specific token — historical (beyond 30 days)
This query gets you Price Change 5min, 1h, 6h and 24h of a specific token on the Base network. Built from raw DEX trades, so it reaches back further than the Trading cube's ~30 days. For live prices prefer the Trading cube entries at the top of this section.
▶️ Get Price Change 5min, 1h, 6h and 24h of a specific token — historical (beyond 30 days)
Top 10 Base Tokens by Price Change in last 1h — historical (beyond 30 days)
This query gets you top 10 Base Tokens by Price Change in last 1h. Built from raw DEX trades, so it reaches back further than the Trading cube's ~30 days. For live prices prefer the Trading cube entries at the top of this section.
▶️ Top 10 Base Tokens by Price Change in last 1h — historical (beyond 30 days)
OHLC-of-AERO-Coin — historical (beyond 30 days)
OHLC-of-AERO-Coin. Uses the DEXTradeByTokens cube. Change the token address in the where clause to use it. Needs the historical data add-on — see the comment at the top of the query. Built from raw DEX trades, so it reaches back further than the Trading cube's ~30 days. For live prices prefer the Trading cube entries at the top of this section.
▶️ OHLC-of-AERO-Coin — historical (beyond 30 days)
Price change 5min, 1hr, 6hr, 24h precentage of a specific token — historical (beyond 30 days)
Price change 5min, 1hr, 6hr, 24h precentage of a specific token. Uses the DEXTradeByTokens cube. Change the token address in the where clause to use it. Needs the historical data add-on — see the comment at the top of the query. Built from raw DEX trades, so it reaches back further than the Trading cube's ~30 days. For live prices prefer the Trading cube entries at the top of this section.
▶️ Price change 5min, 1hr, 6hr, 24h precentage of a specific token — historical (beyond 30 days)
Top 10 base tokens by price change in last 1 hr — historical (beyond 30 days)
Top 10 base tokens by price change in last 1 hr. Uses the DEXTradeByTokens cube. Needs the historical data add-on — see the comment at the top of the query. Built from raw DEX trades, so it reaches back further than the Trading cube's ~30 days. For live prices prefer the Trading cube entries at the top of this section.
▶️ Top 10 base tokens by price change in last 1 hr — historical (beyond 30 days)
Supply & Market Cap
Top Tokens by Market Cap on Base
This query ranks Base tokens by Supply.MarketCap. It uses roughly the last 24 hours (since_relative: { hours_ago: 24 }), 1-second intervals, at least $1,000 USD volume, limitBy one row per Token_Id, and up to 50 tokens.
▶️ Top Tokens by Market Cap on Base
Bankr token latest marketcap OHLC
Bankr token latest marketcap OHLC. Uses the Tokens cube.
▶️ Bankr token latest marketcap OHLC
Get Token Total Supply and Market Cap
Retrieve the total supply and market capitalization of a specific token. This query provides on-chain market cap data.
▶️ Get Token Total Supply and Market Cap
Total supply of a AERO on Base
Total supply of a AERO on Base. Uses the Transfers cube. Change the token address in the where clause to use it. Needs the historical data add-on — see the comment at the top of the query.
▶️ Total supply of a AERO on Base
Total Supply and onchain Marketcap of a specific token base
This API gives you latest Supply and Marketcap of a token on Base. Try it out.
▶️ Total Supply and onchain Marketcap of a specific token base
Liquidity & Pools
Latest Liquidity of Base Pool
Get the latest liquidity of an Base DEX pool (e.g., Uniswap v3 pool).
▶️ Latest Liquidity of Base Pool
Latest Slippage for a Specific Pool
This query retrieves the latest slippage data for a specific DEX pool on Base. Use this to check current liquidity depth and price impact for a particular token pair.
▶️ Latest Slippage for a Specific Pool
Latest Liquidity Changes of a Specific Pool
Retrieves the latest liquidity events for a specific DEX pool on Base. Use this to check current pool reserves, spot prices, and recent liquidity changes for a particular token pair.
▶️ Latest Liquidity Changes of a Specific Pool
Latest Liquidity Pools on Aerodome
Track newly created liquidity pools on Aerodrome Finance in real-time. Discover fresh trading pairs and potential liquidity provision opportunities as pools are created.
▶️ Latest Liquidity Pools on Aerodome
Top liquidity pools of cbBTC
This query separates results by whether cbBTC is listed as the first token (CurrencyA) or the second token (CurrencyB) in the DEX pool, returning the 10 pools with the highest liquidity for each category.
▶️ Top liquidity pools of cbBTC
Transactions
Get transactions by wallet
Get transactions ordered by block number in descending order.
Latest gauge vaults claimRewards transactions
Track when stakers claim accumulated AERO emissions from gauges. Use this to measure realized rewards and active participation across gauge vaults. 0xf5601f95708256a118ef5971820327f362442d2d is the Aerodrome : Gauge Implementation contract.
▶️ Latest gauge vaults claimRewards transactions
Latest gauge vaults deposits transactions
Monitor LP staking into gauge vaults. This shows recent Deposit events to a gauge contract, helping you track which pools are attracting liquidity ahead of weekly emissions.
▶️ Latest gauge vaults deposits transactions
Latest gauge vaults withdraw transactions
Observe LP exits from gauge vaults via Withdraw events. This helps you detect liquidity outflows and shifts in staking positions across pools. 0xf5601f95708256a118ef5971820327f362442d2d is the Aerodrome : Gauge Implementation contract.
▶️ Latest gauge vaults withdraw transactions
Events & Calls
Get Latest Calls
Get Latest Calls. Uses the Calls cube.
Get Latest Events
Get Latest Events. Uses the Events cube.
Latest Bankr launches Doppler Airlock Base
Every Bankr launch emits a Create(address,address,address,address) event on the Airlock contract. This query returns the most recent launches with the new token address and deployer.
▶️ Latest Bankr launches Doppler Airlock Base
All bankers tokens created by a deployer
Filter Create events on the Airlock by Transaction.From to list every Bankr token launched by a specific wallet. Replace the deployer address with the wallet you want to track.
▶️ All bankers tokens created by a deployer
Ape store buys from a wallet
Ape store buys from a wallet. Uses the Calls cube. Replace the address in the where clause to use it.
▶️ Ape store buys from a wallet
Ape store token event
Firstly, we can find the smart contract address of the APE Store using.
Ape-store-buys
Ape-store-buys. Uses the Calls cube. Replace the address in the where clause to use it.
Base jump token event
Firstly, we can find the smart contract address of the Base Jump using.
Base-jump-buys
Base-jump-buys. Uses the Calls cube. Replace the address in the where clause to use it.
Latest Coin on Base Coin
In the recent times, base network has seen rise of many Memecoins and token based ecosystems. In this guide, we will see some queries that could provide beneficial information about these coins, for people to take informed investment decisions.
Blocks & Validators
Aggregate Self Destruct Statistics base
Calculate total ETH destroyed or received from self-destructs using aggregation functions.
▶️ Aggregate Self Destruct Statistics base
Self Destruct Balance Decrease API base
Monitor contract balance decrease when contracts are self-destructing.
▶️ Self Destruct Balance Decrease API base
Self Destruct Balance Increase API base
Monitor contract balance increase when contracts are self-destructing.
▶️ Self Destruct Balance Increase API base
Uniswap
Uniswap Trades Stream
This subscription returns the real-time trades happening on Uniswap. You can modify the stream to get real-time trades for a particular token, a particular token pair and even a particular trader.
Get metadata for base uniswap token
Use the below query to get Token's metadata like Name, symbol, SmartContract Address, Decimals.
▶️ Get metadata for base uniswap token
Latest slippage of a pool on Uniswap v3
Latest slippage of a pool on Uniswap v3. Change the token address in the where clause to use it.
▶️ Latest slippage of a pool on Uniswap v3
OHLC on BASE Uniswap v3
Retrieves the Open, High, Low, and Close (OHLC) prices in USD for a specific token traded on Uniswap v3 over a defined time period and interval.
Top bought tokens on uniswap v3
Will fetch the top bought tokens on uniswap v3.
▶️ Top bought tokens on uniswap v3
Top sold tokens on uniswap v3
Will fetch the top bought tokens on uniswap v3.
▶️ Top sold tokens on uniswap v3
Top traders of a token on uniswapv3
Will fetch top traders of a token for the selected network.
▶️ Top traders of a token on uniswapv3
Trade volume base uniswapv3
Fetches the traded volume, buy volume and sell volume of a token 0x22af33fe49fd1fa80c7149773dde5890d3c76f3b.
▶️ Trade volume base uniswapv3
Uniswap v3 trades
Below query will subscribe you to the latest DEX Trades on Uniswap v3.
Virtual pool addresses for a token on uniswap v4 base
Virtual pool addresses for a token on uniswap v4 base. Uses the DEXTradeByTokens cube. Change the token address in the where clause to use it.
▶️ Virtual pool addresses for a token on uniswap v4 base
PancakeSwap
Get Latest Price of a token on PancakeSwap Infinity
Below query will get you Latest Price of a token on PancakeSwap Infinity.
▶️ Get Latest Price of a token on PancakeSwap Infinity
Pancakeswap infinity trades
Below query will subscribe you to the latest DEX Trades on PancakeSwap Infinity.
▶️ Pancakeswap infinity trades
Top bought tokens on pancakeswap_infinity
Will fetch the top bought tokens on PancakeSwap Infinity.
▶️ Top bought tokens on pancakeswap_infinity
Top sold tokens on pancake infinty
Will fetch the top bought tokens on PancakeSwap Infinity.
▶️ Top sold tokens on pancake infinty
Get metadata for base pancakeswap infnity token
Use the below query to get Token's metadata like Name, symbol, SmartContract Address, Decimals.
▶️ Get metadata for base pancakeswap infnity token
OHLC on BASE pancakeswap infinity
Retrieves the Open, High, Low, and Close (OHLC) prices in USD for a specific token traded on PancakeSwap Infinity over a defined time period and interval.
▶️ OHLC on BASE pancakeswap infinity
Top traders of a token on pancakeswap
Will fetch top traders of a token on PancakeSwap Infinity for the selected network.
▶️ Top traders of a token on pancakeswap
Trade volume base pancakeswap infinity
Fetches the traded volume, buy volume and sell volume of a token 0x22af33fe49fd1fa80c7149773dde5890d3c76f3b on PancakeSwap Infinity.
▶️ Trade volume base pancakeswap infinity
Aerodrome
Latest Aerodrome Finance: CL100-WETH/VVV Pool Gauge claimRewards Transactions
See reward claims for a particular gauge pool to quantify realized emissions by its stakers over time. 0x5d05ef25a5f933271e1f0fdc02dc3eab6a4ea687 is the Aerodrome Finance CL100 WETHVVV Pool Gauge contract.
▶️ Latest Aerodrome Finance: CL100-WETH/VVV Pool Gauge claimRewards Transactions
Latest Aerodrome Finance: CL100-WETH/VVV Pool Gauge deposits
View deposit activity for a specific gauge pool to understand where LPs are allocating capital and how staking momentum evolves. 0x5d05ef25a5f933271e1f0fdc02dc3eab6a4ea687 is the Aerodrome Finance CL100 WETHVVV Pool Gauge contract.
▶️ Latest Aerodrome Finance: CL100-WETH/VVV Pool Gauge deposits
Latest Aerodrome Finance: CL100-WETH/VVV Pool Gauge withdraw transactions
Filter withdraw activity for a single gauge pool. Useful for monitoring liquidity changes and unstaking patterns of a targeted pool. 0x5d05ef25a5f933271e1f0fdc02dc3eab6a4ea687 is the Aerodrome Finance CL100 WETHVVV Pool Gauge contract.
▶️ Latest Aerodrome Finance: CL100-WETH/VVV Pool Gauge withdraw transactions
Arbitrum
Trades
Swap Events Arbitrum
Returns the 10 most recent swap events on the Arbitrum network. We get this by using the signature hash c42079f94a6350d7e6235f29174924f928cc2ac818eb64fed8004e115fbcca67 for the swap event.
Pair last trades
Retrieves all DEX trades on the arbitrum where the Arbitrum currency is ArbitrumCurrency and the quote currency is quoteCurrency that occurred between the specified dates. Built from raw DEX trades, so it reaches back further than the Trading cube's ~30 days. For live prices prefer the Trading cube entries at the top of this section.
Top Sold Tokens on Arbitrum
Top Sold Tokens on Arbitrum. Uses the DEXTradeByTokens cube. Adjust the date range in the where clause. Built from raw DEX trades, so it reaches back further than the Trading cube's ~30 days. For live prices prefer the Trading cube entries at the top of this section.
▶️ Top Sold Tokens on Arbitrum
Top bought tokens on Arbitrum
Top bought tokens on Arbitrum. Uses the DEXTradeByTokens cube. Adjust the date range in the where clause. Built from raw DEX trades, so it reaches back further than the Trading cube's ~30 days. For live prices prefer the Trading cube entries at the top of this section.
▶️ Top bought tokens on Arbitrum
Top traders for a token on Arbitrum
Top traders for a token on Arbitrum. Uses the DEXTradeByTokens cube. Change the token address in the where clause to use it. Built from raw DEX trades, so it reaches back further than the Trading cube's ~30 days. For live prices prefer the Trading cube entries at the top of this section.
▶️ Top traders for a token on Arbitrum
Trending token pairs on Arbitrum
Crypto Trades API: one row per swap, with USD and supply. Filter Pair.Market.Network: Arbitrum. When to use this vs chain DEX APIs. Built from raw DEX trades, so it reaches back further than the Trading cube's ~30 days. For live prices prefer the Trading cube entries at the top of this section.
▶️ Trending token pairs on Arbitrum
Balances & Holders
Current balance of an address
Every token balance held by one Arbitrum address. Balances are cumulative, so this reads the whole history — replace the address to use it.
▶️ Current balance of an address
Arbitrum Balance of an Address
Returns token balances for a wallet address. Use Amount(selectWhere: { gt: "0" }) to exclude zero balances.
▶️ Arbitrum Balance of an Address
Arbitrum balances by date
Use Block.Date.till for a point-in-time snapshot. Use dataset: archive for historical dates and addresses not recently active.
Arbitrum balances history
Returns balance snapshots over time for an address. Use dataset: archive. Order by Block_Date descending and use limit to paginate. Add Currency.SmartContract under Currency to filter by a specific token.
Arbitrum balances specific token
Add a Currency.SmartContract filter. Always use the contract address, not the token name. Use 0x for native ETH on Arbitrum, or the ERC-20 contract address for a token.
▶️ Arbitrum balances specific token
Arbitrum native balances address
Returns the native ETH balance for a wallet on Arbitrum (not ERC-20 tokens). Filter with Currency: { Native: true } instead of a token contract address.
▶️ Arbitrum native balances address
Token holder snapshot arbitrum
The number of unique holders, token supply, and Gini coefficient for the balance amount before a specific timestamp can be derived using the query below. These stats provide a useful holder snapshot for any given time.
▶️ Token holder snapshot arbitrum
Price & OHLC
Token price from top market (rank 1)
Prices WETH from its single top market rather than blending every pool — the recommended way to price one specific token. Replace token in the Variables pane, lowercase.
▶️ Token price from top market (rank 1)
Ohlc for a pair on Arbitrum — historical (beyond 30 days)
Ohlc for a pair on Arbitrum. Uses the DEXTradeByTokens cube. Change the token address in the where clause to use it. Built from raw DEX trades, so it reaches back further than the Trading cube's ~30 days. For live prices prefer the Trading cube entries at the top of this section.
▶️ Ohlc for a pair on Arbitrum — historical (beyond 30 days)
Price change 5min, 1hr, 6hr, 24hr precentage of a specific token — historical (beyond 30 days)
Price change 5min, 1hr, 6hr, 24hr precentage of a specific token. Uses the DEXTradeByTokens cube. Change the token address in the where clause to use it. Needs the historical data add-on — see the comment at the top of the query. Built from raw DEX trades, so it reaches back further than the Trading cube's ~30 days. For live prices prefer the Trading cube entries at the top of this section.
▶️ Price change 5min, 1hr, 6hr, 24hr precentage of a specific token — historical (beyond 30 days)
Top 10 arb tokens by price change in last 1 hr — historical (beyond 30 days)
Top 10 arb tokens by price change in last 1 hr. Uses the DEXTradeByTokens cube. Needs the historical data add-on — see the comment at the top of the query. Built from raw DEX trades, so it reaches back further than the Trading cube's ~30 days. For live prices prefer the Trading cube entries at the top of this section.
▶️ Top 10 arb tokens by price change in last 1 hr — historical (beyond 30 days)
Supply & Market Cap
Top Tokens by Market Cap on Arbitrum
This query ranks Arbitrum tokens by Supply.MarketCap. It uses roughly the last 24 hours (since_relative: { hours_ago: 24 }), 1-second intervals, at least $1,000 USD volume, limitBy one row per Token_Id, and up to 50 tokens.
▶️ Top Tokens by Market Cap on Arbitrum
Liquidity & Pools
Latest liquidity changes of a specific pool
Retrieves the latest liquidity events for a specific DEX pool on Arbitrum. Use this to check current pool reserves, spot prices, and recent liquidity changes for a particular token pair.
▶️ Latest liquidity changes of a specific pool
Transactions
Latest Transactions
Retrieves the latest 10 transactions on the Arbitrum network.
Transaction Call Trace Arbitrum
This query gets the transaction call trace for an Arbitrum transaction. The Calls API in the query returns a list of all calls made by the transaction.
▶️ Transaction Call Trace Arbitrum
Events & Calls
Latest GMX Events
The following query retrieves the latest liquidated positions on the GMX DEX, providing information on the account, collateral token, index token, position, reserve amount, realised PnL, and mark price.
Latest vGLP Withdraw Events
The following query retrieves the latest vGLP withdrawals on the Arbitrum network.
▶️ Latest vGLP Withdraw Events
Latest deposits on Across Bridge
SpokePool events in Across Protocol can be used to monitor the status of bridge transfers effectively. Below are queries that retrieve the latest deposits and transfers related to the Arbitrum SpokePool.
▶️ Latest deposits on Across Bridge
Latest vGLP Deposit Events
The following query retrieves the latest vGLP deposits on the Arbitrum network.
Blocks & Validators
Latest Arbitrum blocks
Retrieves the latest 10 blocks on the Arbitrum network.
Uniswap
Get virtual pool address for a token on uniswap v4 arbitrum
Get virtual pool address for a token on uniswap v4 arbitrum. Uses the DEXTradeByTokens cube. Change the token address in the where clause to use it.
▶️ Get virtual pool address for a token on uniswap v4 arbitrum
Latest Trades for a currency pair on arbitrum
Latest Trades for a currency pair on arbitrum. Uses the DEXTrades cube.
▶️ Latest Trades for a currency pair on arbitrum
Top buyers of a currency on uniswap v4 arbitrum
Top buyers of a currency on uniswap v4 arbitrum. Uses the DEXTrades cube. Change the token address in the where clause to use it.
▶️ Top buyers of a currency on uniswap v4 arbitrum
Top sellers of a token on uniswap v4 arbitrum
Top sellers of a token on uniswap v4 arbitrum. Uses the DEXTrades cube. Change the token address in the where clause to use it.
▶️ Top sellers of a token on uniswap v4 arbitrum
Trade stats for a token pair on uniswap v4 arbitrum
Trade stats for a token pair on uniswap v4 arbitrum. Uses the DEXTradeByTokens cube.
▶️ Trade stats for a token pair on uniswap v4 arbitrum
Optimism
Trades
Top tokens on optimism
Top tokens on optimism. Uses the DEXTradeByTokens cube. Adjust the date range in the where clause. Built from raw DEX trades, so it reaches back further than the Trading cube's ~30 days. For live prices prefer the Trading cube entries at the top of this section.
Top traders for wld usdc pair
You can checkout a completed product using this info on DEXRabbit. Built from raw DEX trades, so it reaches back further than the Trading cube's ~30 days. For live prices prefer the Trading cube entries at the top of this section.
▶️ Top traders for wld usdc pair
Top traders on optimism
Top traders on optimism. Uses the DEXTradeByTokens cube. Adjust the date range in the where clause. Built from raw DEX trades, so it reaches back further than the Trading cube's ~30 days. For live prices prefer the Trading cube entries at the top of this section.
Balances & Holders
Current balance of an address
Every token balance held by one Optimism address. Balances are cumulative, so this reads the whole history — replace the address to use it.
▶️ Current balance of an address
Optimism Balance of an Address
Returns token balances for a wallet address. Use Amount(selectWhere: { gt: "0" }) to exclude zero balances.
▶️ Optimism Balance of an Address
Optimism balances by date
Use Block.Date.till for a point-in-time snapshot. Use dataset: archive for historical dates and addresses not recently active.
Optimism balances history address
Returns balance snapshots over time for an address. Use dataset: archive. Order by Block_Date descending and use limit to paginate. Add Currency.SmartContract under Currency to filter by a specific token.
▶️ Optimism balances history address
Optimism balances specific token
Add a Currency.SmartContract filter. Always use the contract address, not the token name. Use 0x for native ETH on Optimism, or the ERC-20 contract address for a token.
▶️ Optimism balances specific token
Optimism native balances address
Returns the native ETH balance for a wallet on Optimism (not ERC-20 tokens). Filter with Currency: { Native: true } instead of a token contract address.
▶️ Optimism native balances address
Token holder snapshot optimism
The number of unique holders, token supply, and Gini coefficient for the balance amount before a specific timestamp can be derived using the query below. These stats provide a useful holder snapshot for any given time.
▶️ Token holder snapshot optimism
Uniswap
Latest Trades for a currency pair on optimism
Latest Trades for a currency pair on optimism. Uses the DEXTrades cube.
▶️ Latest Trades for a currency pair on optimism
Top buyers of a currency on uniswap v4 optimism
Top buyers of a currency on uniswap v4 optimism. Uses the DEXTrades cube. Change the token address in the where clause to use it.
▶️ Top buyers of a currency on uniswap v4 optimism
Top sellers of a token on uniswap v4 pool optimism
Top sellers of a token on uniswap v4 pool optimism. Uses the DEXTrades cube. Change the token address in the where clause to use it.
▶️ Top sellers of a token on uniswap v4 pool optimism
Trade stats for a token pair on uniswap v4 optimism
Trade stats for a token pair on uniswap v4 optimism. Uses the DEXTradeByTokens cube.
▶️ Trade stats for a token pair on uniswap v4 optimism
Price & OHLC
Token price from top market (rank 1)
Prices WETH from its single top market rather than blending every pool — the recommended way to price one specific token. Replace token in the Variables pane, lowercase.
▶️ Token price from top market (rank 1)
Polygon
Trades
Top Traders by PnL of a specific polygon pool
Rank traders by PnL on one pool: filter Pair.Market.Address, last 30 minutes, limit: 10, and orderBy PnL descending. Useful for leaderboards, smart-money screens, and pool-specific trader analytics. Trading cube — real-time and roughly the last 30 days. For anything older, use the DEXTradeByTokens entries at the bottom of this section.
▶️ Top Traders by PnL of a specific polygon pool
Top traders of a token on matic — historical (beyond 30 days)
This query ranks traders of one token by volume, splitting bought and sold amounts and totalling volume in native and USD terms. since_relative keeps the window rolling. Built from raw DEX trades, so it reaches back further than the Trading cube's ~30 days. For live prices prefer the Trading cube entries at the top of this section.
▶️ Top traders of a token on matic — historical (beyond 30 days)
Transfers
Check if an address interacted with polymarket ever
This is cheaper than scanning all PredictionTrades when you only need a yes/no signal. Narrow the pattern (e.g. also filter by counterparties) if you need stronger guarantees.
▶️ Check if an address interacted with polymarket ever
Balances & Holders
Current balance of an address
Every token balance held by one Polygon address. Balances are cumulative, so this reads the whole history — replace the address to use it.
▶️ Current balance of an address
Balance of an address
Returns all token balances for a wallet on Polygon using EVM.Balances with network: matic and dataset: combined. See Polygon Address Balance API.
Matic historical balances address
Returns all token balances for a wallet on Polygon using EVM.Balances with network: matic and dataset: combined until a particular period. For this example we will find the Balnce of the address one month ago.
▶️ Matic historical balances address
Matic balances address
Returns token balances for a wallet address. Use Amount(selectWhere: { gt: "0" }) to exclude zero balances.
Matic balances history
Returns balance snapshots over time for an address. Use dataset: archive. Order by Block_Date descending and use limit to paginate. Add Currency.SmartContract under Currency to filter by a specific token.
Matic balances specific token
Add a Currency.SmartContract filter. Always use the contract address, not the token name. Use 0x for native MATIC on Polygon, or the ERC-20 contract address for a token.
▶️ Matic balances specific token
Matic native balances address
Returns the native MATIC balance for a wallet (not ERC-20 tokens). Filter with Currency: { Native: true } instead of a token contract address.
▶️ Matic native balances address
Matic wallet balance token at date
Get a wallet's balance for a specific token with Balance.Address and Currency.SmartContract. This example uses native MATIC (SmartContract: "0x") with dataset: combined.
▶️ Matic wallet balance token at date
Token holder snapshot matic
The number of unique holders, token supply, and Gini coefficient for the balance amount before a specific timestamp can be derived using the query below. These stats provide a useful holder snapshot for any given time.
▶️ Token holder snapshot matic
Supply & Market Cap
Top Tokens by Market Cap on Polygon
This query ranks Polygon tokens by Supply.MarketCap. Set Token.Network to Matic (Polygon’s label in the Trading API). It uses roughly the last 24 hours, 1-second intervals, at least $1,000 USD volume, limitBy one row per Token_Id, and up to 50 tokens.
▶️ Top Tokens by Market Cap on Polygon
Liquidity & Pools
Latest Liquidity Changes of a Specific Pool
Retrieves the latest liquidity events for a specific DEX pool on Matic. Use this to check current pool reserves, spot prices, and recent liquidity changes for a particular token pair.
▶️ Latest Liquidity Changes of a Specific Pool
Uniswap
Get virtual pool address for a token on uniswap v4 matic
Get virtual pool address for a token on uniswap v4 matic. Uses the DEXTradeByTokens cube. Change the token address in the where clause to use it.
▶️ Get virtual pool address for a token on uniswap v4 matic
OHLCV on MATIC uniswap v3
Retrieves the Open, High, Low, and Close (OHLC) prices in USD for a specific token traded on Uniswap v3 over a defined time period and interval.
Top bought tokens on matic uniswap v3
Will fetch the top bought tokens on uniswap v3.
▶️ Top bought tokens on matic uniswap v3
Top sold tokens on matic uniswap v3
Will fetch the top bought tokens on uniswap v3.
▶️ Top sold tokens on matic uniswap v3
Top traders of a token on uniswapv3 matic
Will fetch top traders of a token for the selected network.
▶️ Top traders of a token on uniswapv3 matic
Trade volume matic uniswapv3
Fetches the traded volume, buy volume and sell volume of a token 0x0d500b1d8e8ef31e21c99d1db9a6444d3adf1270.
▶️ Trade volume matic uniswapv3
Uniswap v3 trades matic
Below query will subscribe you to the latest DEX Trades on MATIC Uniswap v3.
Latest Trades for a currency pair on matic
Latest Trades for a currency pair on matic. Uses the DEXTrades cube.
▶️ Latest Trades for a currency pair on matic
Top buyers of a currency on uniswap v4 matic
Top buyers of a currency on uniswap v4 matic. Uses the DEXTrades cube. Change the token address in the where clause to use it.
▶️ Top buyers of a currency on uniswap v4 matic
Top sellers of a token on uniswap v4 pool matic
Top sellers of a token on uniswap v4 pool matic. Uses the DEXTrades cube. Change the token address in the where clause to use it.
▶️ Top sellers of a token on uniswap v4 pool matic
Avalanche
Trades
Latest DEX trades
The most recent DEX trades on Avalanche, with both sides of the pair, the venue and USD value. Add a baseCurrency filter to scope it to one token.
Top DEXs by trade count
Ranks the DEXs on Avalanche by number of trades, so you can see which venues actually carry volume.
Transfers
Latest token transfers
Recent token transfers on Avalanche. Add a currency filter to follow one token, or a sender/receiver filter to follow one wallet.
Balances & Holders
Balance of an address at a past date
What one Avalanche address held as of a chosen date. Move the date in the Variables pane.
▶️ Balance of an address at a past date
Balances of an address
Native and token balances held by one Avalanche address. Replace the address to use it.
Transactions
Latest transactions
Recent Avalanche transactions with value, gas and sender/receiver. Move since in the Variables pane to change the window — a wide window on a busy chain will exceed the query memory limit.
Events & Calls
Latest smart contract events
Decoded event logs on Avalanche. Filter by smartContractAddress to watch a single contract.
▶️ Latest smart contract events
Blocks & Validators
Latest blocks
The most recent blocks on Avalanche, with height, time, gas used and transaction count.
Celo
Transfers
Latest token transfers
Recent token transfers on Celo. Add a currency filter to follow one token, or a sender/receiver filter to follow one wallet.
Balances & Holders
Balance of an address at a past date
What one Celo address held as of a chosen date. Move the date in the Variables pane.
▶️ Balance of an address at a past date
Balances of an address
Native and token balances held by one Celo address. Replace the address to use it.
Transactions
Latest transactions
Recent Celo transactions with value, gas and sender/receiver. Move since in the Variables pane to change the window — a wide window on a busy chain will exceed the query memory limit.
Events & Calls
Latest smart contract events
Decoded event logs on Celo. Filter by smartContractAddress to watch a single contract.
▶️ Latest smart contract events
Blocks & Validators
Latest blocks
The most recent blocks on Celo, with height, time, gas used and transaction count.
Cronos
Transfers
Latest token transfers
Recent token transfers on Cronos. Add a currency filter to follow one token, or a sender/receiver filter to follow one wallet.
Balances & Holders
Balance of an address at a past date
What one Cronos address held as of a chosen date. Move the date in the Variables pane.
▶️ Balance of an address at a past date
Balances of an address
Native and token balances held by one Cronos address. Replace the address to use it.
Transactions
Latest transactions
Recent Cronos transactions with value, gas and sender/receiver. Move since in the Variables pane to change the window — a wide window on a busy chain will exceed the query memory limit.
Events & Calls
Latest smart contract events
Decoded event logs on Cronos. Filter by smartContractAddress to watch a single contract.
▶️ Latest smart contract events
Blocks & Validators
Latest blocks
The most recent Cronos blocks, with gas used and transaction count. Move since in the Variables pane.
Klaytn
Trades
Latest DEX trades
The most recent DEX trades on Klaytn, with both sides of the pair, the venue and USD value. Add a baseCurrency filter to scope it to one token.
Top DEXs by trade count
Ranks the DEXs on Klaytn by number of trades, so you can see which venues actually carry volume.
Transfers
Latest token transfers
Recent token transfers on Klaytn. Add a currency filter to follow one token, or a sender/receiver filter to follow one wallet.
Balances & Holders
Balance of an address at a past date
What one Klaytn address held as of a chosen date. Move the date in the Variables pane.
▶️ Balance of an address at a past date
Balances of an address
Native and token balances held by one Klaytn address. Replace the address to use it.
Transactions
Latest transactions
Recent Klaytn transactions with value, gas and sender/receiver. Move since in the Variables pane to change the window — a wide window on a busy chain will exceed the query memory limit.
Events & Calls
Latest smart contract events
Decoded event logs on Klaytn. Filter by smartContractAddress to watch a single contract.
▶️ Latest smart contract events
Blocks & Validators
Latest blocks
The most recent blocks on Klaytn, with height, time, gas used and transaction count.
Litecoin
Transfers
Largest transfers in the last 24 hours
The biggest Litecoin outputs of the past day, ranked by value — a quick way to spot whale movement. Change the since date to widen the window.
▶️ Largest transfers in the last 24 hours
Balances & Holders
Balance of an address at a past date
What one Litecoin address held as of a chosen date. Move the date in the Variables pane.
▶️ Balance of an address at a past date
Total received by an address
Sums everything an address has ever received on Litecoin, with a first-and-last-seen window. Replace the address to use it.
▶️ Total received by an address
Total sent from an address
Sums everything an address has ever spent on Litecoin. Subtract this from total received to get the current balance.
Address activity summary
First seen, last seen, and lifetime in/out totals for one Litecoin address in a single request.
Transactions
Latest transactions
The most recent transactions on Litecoin, with value, fee and input/output counts. Raise the limit to page further back.
Blocks & Validators
Latest blocks
The most recent blocks on Litecoin, with height, time, transaction count and size.
Bitcoin Cash
Transfers
Largest transfers in the last 24 hours
The biggest Bitcoin Cash outputs of the past day, ranked by value — a quick way to spot whale movement. Change the since date to widen the window.
▶️ Largest transfers in the last 24 hours
Balances & Holders
Balance of an address at a past date
What one Bitcoin Cash address held as of a chosen date. Move the date in the Variables pane.
▶️ Balance of an address at a past date
Total received by an address
Sums everything an address has ever received on Bitcoin Cash, with a first-and-last-seen window. Replace the address to use it.
▶️ Total received by an address
Total sent from an address
Sums everything an address has ever spent on Bitcoin Cash. Subtract this from total received to get the current balance.
Address activity summary
First seen, last seen, and lifetime in/out totals for one Bitcoin Cash address in a single request.
Transactions
Latest transactions
The most recent transactions on Bitcoin Cash, with value, fee and input/output counts. Raise the limit to page further back.
Blocks & Validators
Latest blocks
The most recent blocks on Bitcoin Cash, with height, time, transaction count and size.
Dogecoin
Transfers
Largest transfers in the last 24 hours
The biggest Dogecoin outputs of the past day, ranked by value — a quick way to spot whale movement. Change the since date to widen the window.
▶️ Largest transfers in the last 24 hours
Balances & Holders
Balance of an address at a past date
What one Dogecoin address held as of a chosen date. Move the date in the Variables pane.
▶️ Balance of an address at a past date
Total received by an address
Sums everything an address has ever received on Dogecoin, with a first-and-last-seen window. Replace the address to use it.
▶️ Total received by an address
Total sent from an address
Sums everything an address has ever spent on Dogecoin. Subtract this from total received to get the current balance.
Address activity summary
First seen, last seen, and lifetime in/out totals for one Dogecoin address in a single request.
Transactions
Latest transactions
The most recent transactions on Dogecoin, with value, fee and input/output counts. Raise the limit to page further back.
Blocks & Validators
Latest blocks
The most recent blocks on Dogecoin, with height, time, transaction count and size.
Dash
Transfers
Largest transfers in the last 24 hours
The biggest Dash outputs of the past day, ranked by value — a quick way to spot whale movement. Change the since date to widen the window.
▶️ Largest transfers in the last 24 hours
Balances & Holders
Balance of an address at a past date
What one Dash address held as of a chosen date. Move the date in the Variables pane.
▶️ Balance of an address at a past date
Total received by an address
Sums everything an address has ever received on Dash, with a first-and-last-seen window. Replace the address to use it.
▶️ Total received by an address
Total sent from an address
Sums everything an address has ever spent on Dash. Subtract this from total received to get the current balance.
Address activity summary
First seen, last seen, and lifetime in/out totals for one Dash address in a single request.
Transactions
Latest transactions
The most recent transactions on Dash, with value, fee and input/output counts. Raise the limit to page further back.
Blocks & Validators
Latest blocks
The most recent blocks on Dash, with height, time, transaction count and size.
Zcash
Transfers
Largest transfers in the last 24 hours
The biggest Zcash outputs of the past day, ranked by value — a quick way to spot whale movement. Change the since date to widen the window.
▶️ Largest transfers in the last 24 hours
Balances & Holders
Balance of an address at a past date
What one Zcash address held as of a chosen date. Move the date in the Variables pane.
▶️ Balance of an address at a past date
Total received by an address
Sums everything an address has ever received on Zcash, with a first-and-last-seen window. Replace the address to use it.
▶️ Total received by an address
Total sent from an address
Sums everything an address has ever spent on Zcash. Subtract this from total received to get the current balance.
Address activity summary
First seen, last seen, and lifetime in/out totals for one Zcash address in a single request.
Transactions
Latest transactions
The most recent transactions on Zcash, with value, fee and input/output counts. Raise the limit to page further back.
Blocks & Validators
Latest blocks
The most recent blocks on Zcash, with height, time, transaction count and size.
Cardano
Trades
Cardano Price
This query returns the latest price of Cardano on Cardano Network.
Transfers
Cardano User Transfers
This query returns the latest transfers for a useron Cardano network.
Balances & Holders
Cardano Balance
This query returns the current balance of a user on Cardano network.
Ripple
Trades
Ripple Token DEX Trades
This query returns the latest trades of a currency on the Ripple network.
Ripple Payments
This query returns the latest payments on Ripple network.
Transfers
Ripple Historical Transfers
This query returns all the historical transfers done by a specific address on the Ripple network.
▶️ Ripple Historical Transfers
Balances & Holders
Ripple Historical Balance
This query returns all historical balance of an address on Ripple network.
Transactions
Transaction Details using Hash
This query uses transaction hash and date range as filter to fetch tx details.
▶️ Transaction Details using Hash
Stellar
Trades
Latest DEX trades
Trades on the Stellar decentralised exchange, with both sides of the pair and the amounts.
Transfers
Latest payments
Stellar payment operations — who paid whom, in which asset, and how much.
Balances & Holders
Balance of an address at a past date
What one Stellar address held as of a chosen date. Move the date in the Variables pane.
▶️ Balance of an address at a past date
Balances of an address
Every asset balance held by one Stellar account. Replace the address to use it.
Liquidity & Pools
Liquidity pool trades
Swaps routed through Stellar liquidity pools, with the pool id and both legs.
Transactions
Latest transactions
Recent Stellar transactions with sender, fee and success flag. Move since in the Variables pane to change the window.
Blocks & Validators
Latest ledgers
The most recent Stellar ledgers with close time, transaction count and fee pool.
Algorand
Transfers
All the transfers of an asset on Algorand Mainnet in a specific timeframe
Returns transfers for asset ID 31566704 between two dates, ordered by block height descending. Swap the currency filter for any ASA ID or ALGO.
▶️ All the transfers of an asset on Algorand Mainnet in a specific timeframe
Traansfers where a currency is sent from or sent to a particular address
Uses the any filter to match transfers where the address appears as either sender or receiver.
▶️ Traansfers where a currency is sent from or sent to a particular address
Price & OHLC
Get Count of Smart Contract Calls in Latest Block
Returns the count of unique smart contract calls in the most recent block after a given date.
▶️ Get Count of Smart Contract Calls in Latest Block
Transactions
All Transactions on Algorand
Paginated query for all transactions in a specific window.
▶️ All Transactions on Algorand
Daily Transaction Count for last 10 days
Returns the number of transactions per day over the last 10 days, ordered by date descending.
▶️ Daily Transaction Count for last 10 days
Daily Unique Txn Senders on algorand
Counts distinct transaction senders on a specific date.
▶️ Daily Unique Txn Senders on algorand
Filecoin
Transfers
Latest transfers
FIL value moving between addresses. Add a sender or receiver filter to follow one account.
Balances & Holders
Balance of an address at a past date
What one Filecoin address held as of a chosen date. Move the date in the Variables pane.
▶️ Balance of an address at a past date
Balance of an address
The FIL balance held by one Filecoin address. Replace the address to use it.
Transactions
Latest messages
Filecoin messages — the chain's transactions — with sender, receiver, value and method.
Blocks & Validators
Latest tipsets
The most recent Filecoin tipsets with height and time.
Trading API
Trades
Average fee per trade, Total fees, total volume, trades count per DEX program
Average fee per trade, Total fees, total volume, trades count per DEX program. Uses the Trades cube.
▶️ Average fee per trade, Total fees, total volume, trades count per DEX program
Last 10 WSOL USDC Token pair trades
Last 10 WSOL USDC Token pair trades. Uses the Trades cube.
▶️ Last 10 WSOL USDC Token pair trades
Most active market pools by trades
Most active market pools by trades. Uses the Trades cube.
▶️ Most active market pools by trades
Most active traders by trade count
Most active traders by trade count. Uses the Trades cube.
▶️ Most active traders by trade count
Most traded token in last 1 hour on solana and it's average trade amount and total volume
Most traded token in last 1 hour on solana and it's average trade amount and total volume. Uses the Trades cube.
▶️ Most traded token in last 1 hour on solana and it's average trade amount and total volume
Net flow (buys - sells) per token symbol
Net flow (buys - sells) per token symbol. Uses the Trades cube.
▶️ Net flow (buys - sells) per token symbol
Tokens with highest trade frequency
Tokens with highest trade frequency. Uses the Trades cube.
▶️ Tokens with highest trade frequency
Tokens with most unique buyers
Tokens with most unique buyers. Uses the Trades cube.
▶️ Tokens with most unique buyers
Top Traders on Solana
Top Traders on Solana. Uses the Trades cube.
Total SOL fees, Total Volume, Total count trades
Total SOL fees, Total Volume, Total count trades. Uses the Trades cube.
▶️ Total SOL fees, Total Volume, Total count trades
Price & OHLC
Token price from top market (rank 1)
The recommended way to price one token: takes the single highest-ranked market for it rather than blending every pool. Prices the token from its single top market rather than blending every pool, which is what you want for one specific token.
▶️ Token price from top market (rank 1)
Multi-token watchlist, top market each
Prices a list of tokens, each from its own top market. Add or remove addresses in the Token.Address.in filter.
▶️ Multi-token watchlist, top market each
Historical Bitcoin OHLC data for the last 7 days
Recent Bitcoin OHLC using the Crypto Price API (time range in the query matches what the Price Index supports).
▶️ Historical Bitcoin OHLC data for the last 7 days
OHLC of a currency on multiple blockchains
Stream real-time Bitcoin OHLC data aggregated from all supported blockchains (Bitcoin, Ethereum WBTC, Solana, etc.) with 60-second intervals.
▶️ OHLC of a currency on multiple blockchains
Supply & Market Cap
Marketcap of pump token
Set token address and read Supply.MarketCap from the query below. See the Supply fields reference for related supply fields. You can also stream this in real-time by adding the keyword "subscription" at the top.
Tokens ranked by market cap
Tokens ranked by market cap. Uses the Trades cube.
▶️ Tokens ranked by market cap
Stablecoins
Trades
Solana USDT trades query
Solana trades quoted in USDT. USDT is the quote side on Solana, so it is filtered with Pair.QuoteToken, not Pair.Token, which would return nothing. The Trading cube reaches back about 30 days; Solana.DEXTrades keeps about 12 hours.
Transfers
Latest Tron USDT Transfers
Listen to stablecoin payments across all major blockchains. The Mempool option lets you detect a payment before it is confirmed — useful for instant merchant UX.
Latest USDT/USDC Transfer api on base
Listen to stablecoin payments across all major blockchains. The Mempool option lets you detect a payment before it is confirmed — useful for instant merchant UX.
▶️ Latest USDT/USDC Transfer api on base
Latest USDT/USDC Transfer api on ethereum
Listen to stablecoin payments across all major blockchains. The Mempool option lets you detect a payment before it is confirmed — useful for instant merchant UX.
▶️ Latest USDT/USDC Transfer api on ethereum
Stablecoin Transfers from/to an address
Stablecoin Transfers from/to an address. Uses the Transfers cube. Change the token address in the where clause to use it.
▶️ Stablecoin Transfers from/to an address
Stablecoin recieved and sent by an address
Stablecoin recieved and sent by an address. Uses the Transfers cube. Change the token address in the where clause to use it. Needs the historical data add-on — see the comment at the top of the query.
▶️ Stablecoin recieved and sent by an address
USDT Stablecoin reserves on Ethereum
USDT Stablecoin reserves on Ethereum. Uses the Transfers cube. Change the token address in the where clause to use it. Needs the historical data add-on — see the comment at the top of the query.
▶️ USDT Stablecoin reserves on Ethereum
USDT and USDC token Transfers api on solana
USDT and USDC token Transfers api on solana. Uses the Transfers cube.
▶️ USDT and USDC token Transfers api on solana
USDT token Transfers api on solana
Track live USDT stablecoin transfers. USDT is ideal for payments, settlements, etc and you can track those in real-time using this API/Stream -.
▶️ USDT token Transfers api on solana
Price & OHLC
5 minute price change stablecoin API
5 minute price change stablecoin API. Uses the Tokens cube.
▶️ 5 minute price change stablecoin API
Stablecoin price query of USDT
Get real-time and historical USDT prices, OHLCV, and moving averages across supported networks and markets.
▶️ Stablecoin price query of USDT
Usdt latest price arbitrage
This query compares USDT prices across different blockchain networks in real-time. It fetches the latest price data for USDT from different networks, showing you where the same stablecoin trades at different prices.
▶️ Usdt latest price arbitrage
Supply & Market Cap
USDC Stablecoin reserves on Solana
USDC Stablecoin reserves on Solana. Uses the TokenSupplyUpdates cube. Change the token address in the where clause to use it.
▶️ USDC Stablecoin reserves on Solana
USDT Stablecoin reserves on Solana query
USDT Stablecoin reserves on Solana query. Uses the TokenSupplyUpdates cube. Change the token address in the where clause to use it.
▶️ USDT Stablecoin reserves on Solana query
NFTs
Trades
New Uniswap v3 liquidity positions
Position NFTs as they are minted — who is adding liquidity to v3 pools, and to which pair.
▶️ New Uniswap v3 liquidity positions
Get NFT trades for a specific NFT contract on specific marketplace
Get trades of NFTs for a given contract and marketplace. Built from raw DEX trades, so it reaches back further than the Trading cube's ~30 days. For live prices prefer the Trading cube entries at the top of this section.
▶️ Get NFT trades for a specific NFT contract on specific marketplace
Get NFT trades for a specific NFT contract and token ID
Get trades of NFTs for a given contract and token ID. Built from raw DEX trades, so it reaches back further than the Trading cube's ~30 days. For live prices prefer the Trading cube entries at the top of this section.
▶️ Get NFT trades for a specific NFT contract and token ID
Get NFT trades by wallet
Get trades of NFTs for a given wallet. Built from raw DEX trades, so it reaches back further than the Trading cube's ~30 days. For live prices prefer the Trading cube entries at the top of this section.
Latest NFT Trades
Latest NFT Trades. Built from raw DEX trades, so it reaches back further than the Trading cube's ~30 days. For live prices prefer the Trading cube entries at the top of this section.
Top Traded NFTs in a Period
This query gets the top 10 traded NFTs based on the number of trades within a specified date range. You can change the filters such as the date range and limit. Built from raw DEX trades, so it reaches back further than the Trading cube's ~30 days. For live prices prefer the Trading cube entries at the top of this section.