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: block time, currency symbol, currency name, smart contract, amount in USD, trade amount, side currency name and 4 more fields.

By Jose · saved 7 October 2024 · run 3 times · 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}}}
    ) {
      Block {
        Time
      }
      Trade {
        Currency {
          Symbol
          Name
          SmartContract
        }
        AmountInUSD
        Amount
        Side {
          Currency {
            Name
            Symbol
            SmartContract
          }
        }
        Dex {
          SmartContract
        }
      }
      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}}}
      )
      uniqueTraders: 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