Comments (6)
Did you try to use first and skip
first: 1000 => 1000 first items
first: 1000 + skip: 1000 => 1001 to 2000 items and so on
with the same orderBy you should be able to get all the pools
from v3-subgraph.
I tried it and it worked only because there are less than 6000 pools in Uniswap V3.
If you try to use first and skip
first: 1000, skip: 6000 => it throws an error saying "The "skip" argument must be between 0 and 5000, but is 6000"
from v3-subgraph.
First query
{
pools(first: 1000, orderBy: createdAtTimestamp, orderDirection: asc)
{ id, createdAtBlockNumber, createdAtTimestamp }
}
Second query (use the where clause by providing the createdAtTimestamp from the last record of the previous query.
{
pools(first: 1000, orderBy: createdAtTimestamp, orderDirection: asc
where: {createdAtTimestamp_gt: 1621164209 })
{ id, createdAtBlockNumber, createdAtTimestamp }
}
Do that until you have no result
from v3-subgraph.
@fedecastelli mentionned this solution already in his question, but you didn't answer his related question "I could use the createdAtTimestamp_gt parameter inside the where clause but it may happen I'll exclude pools created at the same timestamp.".
For timestamps I'm guessing its unlikely to have two pools with the same timestamp (unless the timestamp is extremely discrete, like block number for eg.). But when ordering by other attributes (say liquidity, volume, etc.) there is a chance to skip out one of the pools.
from v3-subgraph.
How about ordering by id then, assuming it is unique and alphanumeric, so can be ordered and compared?
from v3-subgraph.
Hi @fedecastelli, were you able to solve this issue?
from v3-subgraph.
Related Issues (20)
- Position Liquidity HOT 1
- The data from thegraph and the etherscan are not equal
- Subgraph returns a lot of inactive ticks HOT 1
- No links/docs for subgraphs other than ETH? HOT 1
- BSC v3 graph returning no position data HOT 7
- Store error: database unavailable on Optimism
- arbitrum: Whitelist Native USDC
- Why is MINIMUM_ETH_LOCKED 60?
- Ticks incorrect
- Querying multiple tokens at a time in tokenHourDatas
- token0Price and token1Price are incorrect HOT 1
- [BUG] OP Mainnet Indexing Error HOT 2
- query surroundingTicks return wrong liquidityNet/liquidityGross value HOT 1
- Wrong TVL of a Pool: both DailySnaphots and general
- Subgraph on the testnets.
- `indexing_error` on networks HOT 5
- Token is null
- Overflow converting to i32 error HOT 2
- indexing error on mainnet (Last Synced Block 19473885) HOT 4
- Sepolia Support
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from v3-subgraph.