Hello, I want to know the wallet address that bought some token (e.g. SAFEMOON) in the first 15 minutes. Could you please provide me some ideas to create query on bitquery.io?
First 10 Trades of Safemoon
{
ethereum (network: bsc) {
dexTrades(options: {limit: 10
asc: ["block.height","tradeIndex"]}
buyCurrency: {is: "0x8076c74c5e3f5852037f31ff0093eeb8c8add8d3"}
) {
transaction {
hash
}
tradeIndex
date{date}
block{
height
}
buyAmount
buyAmountInUsd:buyAmount(in: USD)
buyCurrency{symbol}
sellAmount
sellCurrency{symbol}
sellAmountInUsd:sellAmount(in: USD)
tradeAmount(in: USD)
}
}
}
First 10 transactions of Safemoon
{
ethereum(network: bsc) {
smartContractCalls(options: {asc: "block.timestamp.time",
limit: 10},
smartContractAddress: {is: "0x8076c74c5e3f5852037f31ff0093eeb8c8add8d3"}) {
block {
timestamp {
time(format: "%Y-%m-%d %H:%M:%S")
}
height
}
smartContractMethod {
name
signatureHash
}
address: caller {
address
annotation
}
transaction {
hash
}
gasValue
external
}
}
}
Thank you, Gaurav
Both queries are working!