how t create a query that find all wallets that bought a token before x time
{
ethereum(network: ethereum) {
dexTrades(
options: {desc: ["block.height", "tradeIndex"], limit: 10}
baseCurrency:{is:"0x24dA31e7BB182cb2cABfEF1d88db19C2AE1f5572"}
quoteCurrency:{ is:"0xC02aaA39b223FE8D0A0e5C4F27eAD9083C756Cc2"}
date: {before: "2023-01-03"}
) {
quotePrice
block {
timestamp {
time(format: "%Y-%m-%d %H:%M:%S")
}
height
}
tradeIndex
protocol
exchange {
fullName
}
baseAmount
baseCurrency {
symbol
name
}
quotePrice
quoteAmount
quoteCurrency {
symbol
name
}
transaction {
hash
txFrom {
address
}
to {
address
}
}
}
}
}
Put the date in date: {before: “2023-01-03”} and token address in quoteCurrency.
Is this what you’re looking for?