pool_creation_query
Returns 100 DEX trades on Ethereum, where buy currency smart contract is 0xdac1…1ec7, block date since 2018-08-03 and block date till 2020-08-03, sorted by block date: smart contract and block date.
What it returns
- smart contract
- block date
Filters
- buy currency smart contract is 0xdac1…1ec7
- block date since 2018-08-03
- block date till 2020-08-03
The query
query MyQuery {
EVM(network: eth, dataset: archive) {
DEXTrades(
where: {Trade: {Buy: {Currency: {SmartContract: {is: "0xdac17f958d2ee523a2206206994597c13d831ec7"}}}}, Block: {Date: {since: "2018-08-03", till: "2020-08-03"}}}
limitBy: {by: Trade_Dex_SmartContract, count: 1}
orderBy: {ascendingByField: "Block_Date"}
limit: {count: 100}
) {
Trade {
Dex {
SmartContract
}
}
Block {
Date
}
}
}
}
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