Can we get Latest pools/ recently Arrived Pools with timelines in a Network?
This is an example to get the latest pools created by getting PairCreated Event from Pancake, Using similar you can get for any DEX.
Hey… thank you Mr. Gaurav! But I want arrived Timeline too… Is it possible to retreive? and
sorting the date in desc order… in above query which was given by you, will return the latest pools with correct timeline ?
You can add the date or time filter in the query
Example
{
ethereum(network: bsc) {
arguments(
options: {desc: ["block.height","index"], limit: 10}
smartContractAddress: {in: "0xbcfccbde45ce874adcb698cc183debcf17952812", }
smartContractEvent: {is: "PairCreated"}
time: {since: "2021-07-17T35:04+00:00"}
) {
block {
height
}
index
pair: any(of: argument_value, argument: {is: "pair"})
token0: any(of: argument_value, argument: {is: "token0"})
token0Name: any(of: argument_value, argument: {is: "token0"}, as: token_name)
token1: any(of: argument_value, argument: {is: "token1"})
token1Name: any(of: argument_value, argument: {is: "token1"}, as: token_name)
}
}
}