getTokensScreener

Returns DEX trades by token on Ethereum, where block time since 2024-09-23 and block time till 2024-09-30, sorted by volume24 h, highest first: currency symbol, currency name, smart contract, decimals, protocol name, pair symbol, trade price and 5 more fields.

By Jose · saved 30 September 2024 · Bitquery API v2

What it returns

Filters

The query

query getTokensScreener(
	$dataset: dataset_arg_enum!
  $network: evm_network!
  $timeFrom1w: DateTime!
  $timeFrom24h: DateTime!
  $timeFrom6h: DateTime!
  $timeFrom1h: DateTime!
  $timeFrom5m: DateTime!
  $timeTo: DateTime!
) {
 EVM(dataset: $dataset, network: $network) {
   DEXTradeByTokens(
     orderBy: {descendingByField: "volume24h"}
     where: {
       Block: {Time: {since: $timeFrom1w, till: $timeTo}}
     }
   ) {
     Trade {
       Currency {
         Symbol
         Name
         SmartContract
         Decimals
       }
       Dex {
         ProtocolName
         Pair {
           SmartContract
           Decimals
           Symbol

         }
       }
       open: Price(minimum: Block_Number)
       close: Price(maximum: Block_Number)
       high: Price(maximum: Trade_Price)
       low: Price(minimum: Trade_Price)
       AmountInUSD
       Amount
       PriceInUSD

     }
     volume1w: sum(of: Trade_AmountInUSD)
     volume24h: sum(of: Trade_AmountInUSD, if: {Block: {Time: {since: $timeFrom24h}}})
     volume6h: sum(of: Trade_AmountInUSD, if: {Block: {Time: {since: $timeFrom6h}}})
     volume1h: sum(of: Trade_AmountInUSD, if: {Block: {Time: {since: $timeFrom1h}}})
     volume5m: sum(of: Trade_AmountInUSD, if: {Block: {Time: {since: $timeFrom5m}}})
     tradeCount1w: count
     tradeCount24h: count(if: {Block: {Time: {since: $timeFrom24h}}})
     tradeCount6h: count(if: {Block: {Time: {since: $timeFrom6h}}})
     tradeCount1h: count(if: {Block: {Time: {since: $timeFrom1h}}})
     tradeCount5m: count(if: {Block: {Time: {since: $timeFrom5m}}})
     buys1w: count(if: {Trade: {Side: {Type: {is: sell}}}})
     sells1w: count(if: {Trade: {Side: {Type: {is: buy}}}})
     buys24h: count(if: {Trade: {Side: {Type: {is: sell}}}, Block: {Time: {since: $timeFrom24h}}})
     sells24h: count(if: {Trade: {Side: {Type: {is: buy}}}, Block: {Time: {since: $timeFrom24h}}})
     buys6h: count(if: {Trade: {Side: {Type: {is: sell}}}, Block: {Time: {since: $timeFrom6h}}})
     sells6h: count(if: {Trade: {Side: {Type: {is: buy}}}, Block: {Time: {since: $timeFrom6h}}})
     buys1h: count(if: {Trade: {Side: {Type: {is: sell}}}, Block: {Time: {since: $timeFrom1h}}})
     sells1h: count(if: {Trade: {Side: {Type: {is: buy}}}, Block: {Time: {since: $timeFrom1h}}})
     buys5m: count(if: {Trade: {Side: {Type: {is: sell}}}, Block: {Time: {since: $timeFrom5m}}})
     sells5m: count(if: {Trade: {Side: {Type: {is: buy}}}, Block: {Time: {since: $timeFrom5m}}})
     uniqueTraders1w: count(distinct: Trade_Buyer)
   }
 }
}

Variables

{
  "dataset": "combined",
  "network": "eth",
  "timeFrom1w": "2024-09-23T11:18:10.032Z",
  "timeFrom24h": "2024-09-29T11:18:35.132Z",
  "timeFrom6h": "2024-09-30T05:19:21.512Z",
  "timeFrom1h": "2024-09-30T10:19:35.032Z",
  "timeFrom5m": "2024-09-30T11:14:50.312Z",
  "timeTo": "2024-09-30T11:20:08.730Z"
}

Similar queries