Without token filter
Returns the latest DEX trades by token on Ethereum, where transaction from is 0x703a…68ab and block number is above 0: buyer, smart contract and log after call index.
What it returns
- buyer
- smart contract
- log after call index
Filters
- transaction from is 0x703a…68ab
- block number is above 0
The query
query MyQuery($dataset: dataset_arg_enum!, $network: evm_network!, $addresses: [String!], $start_block: String!) {
EVM(dataset: $dataset, network: $network) {
existing_pnl: DEXTradeByTokens(
where: {Transaction: {From: {in: $addresses}}, TransactionStatus: {Success: true}, Block: {Number: {gt: $start_block}}}
orderBy: {descending: Block_Number, descendingByField: "Log_LogAfterCallIndex"}
limitBy: {by: Transaction_From, count: 1}
) {
Trade {
Buyer
Dex {
Pair {
SmartContract
}
}
}
Log {
LogAfterCallIndex
}
}
}
}
Variables
{"dataset": "combined", "network": "eth", "token_address": "0xe9cdb1639bf18be40a231525c22844b3bd0eee66", "addresses": ["0x703a7bc77f797b7a87aa757b59687df81ef468ab"], "start_block": "0"}
Similar queries
- CRV hourly OHLC on Curve - Ethereum · Ethereum · DEXTradeByTokens
- Top Metric liquidity pools by 24h volume on Ethereum · Ethereum · DEXTradeByTokens
- ATH of eth token · Ethereum · DEXTradeByTokens
- historical price and historical volume · Ethereum · DEXTradeByTokens
- topTraders EVM · Ethereum · DEXTradeByTokens