buys_and_sells
Returns DEX trades on Ethereum, where transaction from is 0x9d65…EFa0, buy currency smart contract is 0x7E74…FbBE and DEX smart contract is 0x8C13…aD76: transaction hash, sender, buy buyer, buy seller, buy currency name, buy smart contract, buy amount and 5 more fields.
What it returns
- transaction hash
- sender
- buy buyer
- buy seller
- buy currency name
- buy smart contract
- buy amount
- sell buyer
- sell seller
- sell currency name
- sell smart contract
- sell amount
Filters
- transaction from is 0x9d65…EFa0
- buy currency smart contract is 0x7E74…FbBE
- DEX smart contract is 0x8C13…aD76
- sell currency smart contract is 0x7E74…FbBE
The query
query MyQuery {
EVM(dataset: combined, network: eth) {
Sells: DEXTrades(
where: {Transaction: {From: {is: "0x9d6581468F04e5E55876a2660b5AeAbC12e3EFa0"}}, Trade: {Buy: {Currency: {SmartContract: {is: "0x7E744BBB1a49A44dfCC795014a4BA618E418FbBE"}}}, Dex: {SmartContract: {is: "0x8C13d5a6635216513EbFB4483397bE14D494aD76"}}}}
) {
Transaction {
Hash
}
Trade {
Sender
Buy {
Buyer
Seller
Currency {
Name
SmartContract
}
Amount
}
}
}
Buys: DEXTrades(
where: {Transaction: {From: {is: "0x9d6581468F04e5E55876a2660b5AeAbC12e3EFa0"}}, Trade: {Sell: {Currency: {SmartContract: {is: "0x7E744BBB1a49A44dfCC795014a4BA618E418FbBE"}}}, Dex: {SmartContract: {is: "0x8C13d5a6635216513EbFB4483397bE14D494aD76"}}}}
) {
Transaction {
Hash
}
Trade {
Sell {
Buyer
Seller
Currency {
Name
SmartContract
}
Amount
}
}
}
}
}
Similar queries
- Latest Curve DEX swaps on Ethereum · Ethereum · DEXTrades
- Top Curve liquidity pools by 24h volume on Ethereum · Ethereum · DEXTrades
- STRN_TOKEN_MULTIPLE_DECIMALS_DEX_TRADES · Ethereum · DEXTrades
- USDT DECIMAL SHOWING 0 · Ethereum · DEXTrades
- Trades - 0xEE61159E8A72A08371c52D62c19Efd0C7914f917 · Ethereum · DEXTrades