Querying All Swaps within a timestamp interval (first: 1000>) about v3-subgraph HOT 5 CLOSED

Hello,
you can fetch the next 1000 by using the skip: 1000 parameter and continue like that until you have everything.

from v3-subgraph.

Hello, you could sort the data by timestamp and then instead of skip use the last timestamp as the min timestamp.

from v3-subgraph.

Thanks @benesjan . This did help out.
But in addition I found that even skip has a maximum permitted value of up to 5000.

Unfortunately, my use case involves a monthly-data analysis, which might involve up to 100,000 items as well.
If TheGraph is not possible to achieve it, can you point at other resources?

from v3-subgraph.

Thanks @benesjan . Working with the proposed technique.

from v3-subgraph.

@benesjan How would you recommend loading a lot of historical pool hour data? Filtering by a Unix Time stamp or using the skip function?

from v3-subgraph.