Copy of Markten voor Mark 2
Returns DEX trades on Ethereum, where DEX protocol name is uniswap_v2 and block time since 2024-10-01, sorted by trade buy amount in USD, highest first: buy currency symbol, buy price, buy amount in USD, sell currency symbol, sell price, sell amount in USD, smart contract and 6 more fields.
What it returns
- buy currency symbol
- buy price
- buy amount in USD
- sell currency symbol
- sell price
- sell amount in USD
- smart contract
- pair name
- protocol family
- protocol name
- protocol version
- sum of trade buy amount
- sum of trade sell amount
Filters
- DEX protocol name is uniswap_v2
- block time since 2024-10-01
The query
query MyQuery {
EVM(dataset: realtime, network: eth) {
DEXTrades(
where: {Trade: {Dex: {ProtocolName: {is: "uniswap_v2"}}}, Block: {Time: {since: "2024-10-01T10:51:31.046Z"}}}
orderBy: {descending: Trade_Buy_AmountInUSD}
) {
Trade {
Buy {
Currency {
Symbol
}
High: Price(maximum: Trade_Buy_Price)
AmountInUSD
}
Sell {
Currency {
Symbol
}
High: Price(maximum: Trade_Sell_Price)
Low: Price(minimum: Trade_Sell_Price)
Open: Price(minimum: Block_Number)
Close: Price(maximum: Block_Number)
AmountInUSD
}
Dex {
Pair {
SmartContract
Name
}
SmartContract
ProtocolFamily
ProtocolName
ProtocolVersion
}
}
volumeBuy: sum(of: Trade_Buy_Amount)
volumeSell: sum(of: Trade_Sell_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