chicmic_dex_query
Returns DEX trades on Ethereum, where pair smart contract is 0xc2ea…539d, block time since 2024-05-29 and block time till 2024-05-30: count, sum of trade buy amount in USD, sum of trade sell amount in USD, buy currency name, buy currency symbol, buy smart contract, sell currency symbol and 2 more fields.
What it returns
- count
- sum of trade buy amount in USD
- sum of trade sell amount in USD
- buy currency name
- buy currency symbol
- buy smart contract
- sell currency symbol
- sell currency name
- sell smart contract
Filters
- pair smart contract is 0xc2ea…539d
- block time since 2024-05-29
- block time till 2024-05-30
The query
query MyQuery($poolAddresses: [String!]) {
EVM(network: eth, dataset: combined) {
DEXTrades(
where: {Block: {Time: {since: "2024-05-29T09:15:00Z", till: "2024-05-30T09:15:00Z"}}, TransactionStatus: {Success: true}, Trade: {Dex: {Pair: {SmartContract: {is: "0xc2eaB7d33d3cB97692eCB231A5D0e4A649Cb539d"}}}}}
limitBy: {by: Trade_Buy_Currency_Symbol, count: 1}
) {
Makers: count(distinct: Transaction_From)
buys: count(
if: {Trade: {Sell: {Currency: {SmartContract: {is: "0xaaeE1A9723aaDB7afA2810263653A34bA2C21C7a"}}}}}
)
buy_vol: sum(
of: Trade_Buy_AmountInUSD
if: {Trade: {Buy: {Currency: {SmartContract: {in: $poolAddresses}}}}}
)
sells: count(
if: {Trade: {Buy: {Currency: {SmartContract: {is: "0xaaeE1A9723aaDB7afA2810263653A34bA2C21C7a"}}}}}
)
sell_vol: sum(
of: Trade_Sell_AmountInUSD
if: {Trade: {Sell: {Currency: {SmartContract: {in: $poolAddresses}}}}}
)
Trade {
Buy {
Currency {
Name
Symbol
SmartContract
}
}
Sell {
Currency {
Symbol
Name
SmartContract
}
}
}
}
}
}
Variables
{
"poolAddresses" : ["0x42619f1eb89b993f7f5193de6ab1423a703fc344","0x44cc738e692921e7ac967367b800b8e132e5c8e7"]
}
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