latest dex trades
Returns the latest DEX trades on Ethereum, where buy currency smart contract is 0x5283…8b44, sell currency smart contract is 0x5283…8b44 and block time after 2024-11-11: block time, from, transaction hash, buy amount, buy amount in USD, buy currency name, buy currency symbol and 8 more fields.
What it returns
- block time
- from
- transaction hash
- buy amount
- buy amount in USD
- buy currency name
- buy currency symbol
- buy smart contract
- buy price
- sell amount
- sell amount in USD
- sell currency name
- sell smart contract
- sell currency symbol
- sell price
Filters
- buy currency smart contract is 0x5283…8b44
- sell currency smart contract is 0x5283…8b44
- block time after 2024-11-11
- block time before 2024-12-13
- buy amount is above 1000
- sell amount is above 1000
The query
query MyQuery($token: String, $from_date_time: DateTime, $to_date_time: DateTime) {
EVM(dataset: combined, network: eth) {
buyside: DEXTrades(
orderBy: {descending: Block_Time}
where:
{
Trade: {Buy: {Currency: {SmartContract: {is: $token}}, Amount: {gt: "1000"}}},
Block: {Time: {after: $from_date_time, before: $to_date_time}}
}
) {
Block {
Time
}
Transaction {
From
Hash
}
Trade {
Buy {
Amount
AmountInUSD
Currency {
Name
Symbol
SmartContract
}
Price
}
Sell {
Amount
AmountInUSD
Currency {
Name
SmartContract
Symbol
}
Price
}
}
}
sellside: DEXTrades(
orderBy: {descending: Block_Time}
where:
{
Trade: {Sell: {Currency: {SmartContract: {is: $token}},Amount: {gt: "1000"}}},
Block: {Time: {after: $from_date_time, before: $to_date_time}}
}
) {
Block {
Time
}
Transaction {
From
Hash
}
Trade {
Buy {
Amount
AmountInUSD
Currency {
Name
Symbol
SmartContract
}
Price
}
Sell {
Amount
Amount
Currency {
Name
SmartContract
Symbol
}
Price
}
}
}
}
}
Variables
{
"token": "0x5283D291DBCF85356A21bA090E6db59121208b44",
"from_date_time": "2024-11-11T03:20:00Z", "to_date_time": "2024-12-13T14:25:23Z"
}
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