tradingActivity

Returns DEX trades by token on Ethereum, where currency smart contract is 0x2260…c599: count and sum of trade side amount in USD.

By Maximiliano Malvido · saved 29 October 2024 · run 5 times · Bitquery API v2

What it returns

Filters

The query

query getTradingActivity($network: evm_network, $token: String, $min5After: DateTime!, $hour1After: DateTime!, $hour6After: DateTime!, $hour24After: DateTime!) {
  EVM(dataset: realtime, network: $network) {
    DEXTradeByTokens(
      where: {TransactionStatus: {Success: true}, Trade: {Currency: {SmartContract: {is: $token}}}}
    ) {
      makersAt5Min: count(
        distinct: Transaction_From
        if: {Block: {Time: {after: $min5After}}}
      )
      makersAt1Hour: count(
        distinct: Transaction_From
        if: {Block: {Time: {after: $hour1After}}}
      )
      makersAt6Hour: count(
        distinct: Transaction_From
        if: {Block: {Time: {after: $hour6After}}}
      )
      makersAt24Hour: count(
        distinct: Transaction_From
        if: {Block: {Time: {after: $hour24After}}}
      )
      uniqueBuyersAt5Min: count(
        distinct: Transaction_From
        if: {Trade: {Side: {Type: {is: sell}}}, Block: {Time: {after: $min5After}}}
      )
      uniqueBuyersAtHour1: count(
        distinct: Transaction_From
        if: {Trade: {Side: {Type: {is: sell}}}, Block: {Time: {after: $hour1After}}}
      )
      uniqueBuyersAtHour6: count(
        distinct: Transaction_From
        if: {Trade: {Side: {Type: {is: sell}}}, Block: {Time: {after: $hour6After}}}
      )
      uniqueBuyersAtHour24: count(
        distinct: Transaction_From
        if: {Trade: {Side: {Type: {is: sell}}}, Block: {Time: {after: $hour24After}}}
      )
      uniqueSellersAt5Min: count(
        distinct: Transaction_From
        if: {Trade: {Side: {Type: {is: buy}}}, Block: {Time: {after: $min5After}}}
      )
      uniqueSellersAt1Hour: count(
        distinct: Transaction_From
        if: {Trade: {Side: {Type: {is: buy}}}, Block: {Time: {after: $hour1After}}}
      )
      uniqueSellersAt6Hour: count(
        distinct: Transaction_From
        if: {Trade: {Side: {Type: {is: buy}}}, Block: {Time: {after: $hour6After}}}
      )
      uniqueSellersAt24Hour: count(
        distinct: Transaction_From
        if: {Trade: {Side: {Type: {is: buy}}}, Block: {Time: {after: $hour24After}}}
      )
      volumeBuyAt5Min: sum(
        of: Trade_Side_AmountInUSD
        if: {Trade: {Side: {Type: {is: sell}}}, Block: {Time: {after: $min5After}}}
      )
      volumeBuyAt1Hour: sum(
        of: Trade_Side_AmountInUSD
        if: {Trade: {Side: {Type: {is: sell}}}, Block: {Time: {after: $hour1After}}}
      )
      volumeBuyAt6Hour: sum(
        of: Trade_Side_AmountInUSD
        if: {Trade: {Side: {Type: {is: sell}}}, Block: {Time: {after: $hour6After}}}
      )
      volumeBuyAt24Hour: sum(
        of: Trade_Side_AmountInUSD
        if: {Trade: {Side: {Type: {is: sell}}}, Block: {Time: {after: $hour24After}}}
      )
      volumeSellAt5Min: sum(
        of: Trade_Side_AmountInUSD
        if: {Trade: {Side: {Type: {is: buy}}}, Block: {Time: {after: $min5After}}}
      )
      volumeSellAt1Hour: sum(
        of: Trade_Side_AmountInUSD
        if: {Trade: {Side: {Type: {is: buy}}}, Block: {Time: {after: $hour1After}}}
      )
      volumeSellAt6Hour: sum(
        of: Trade_Side_AmountInUSD
        if: {Trade: {Side: {Type: {is: buy}}}, Block: {Time: {after: $hour6After}}}
      )
      volumeSellAt24Hour: sum(
        of: Trade_Side_AmountInUSD
        if: {Trade: {Side: {Type: {is: buy}}}, Block: {Time: {after: $hour24After}}}
      )
      buysAt5Min: count(
        if: {Trade: {Side: {Type: {is: sell}}}, Block: {Time: {after: $min5After}}}
      )
      buysAt1Hour: count(
        if: {Trade: {Side: {Type: {is: sell}}}, Block: {Time: {after: $hour1After}}}
      )
      buysAt6Hour: count(
        if: {Trade: {Side: {Type: {is: sell}}}, Block: {Time: {after: $hour6After}}}
      )
      buysAt24Hour: count(
        if: {Trade: {Side: {Type: {is: sell}}}, Block: {Time: {after: $hour24After}}}
      )
      sellsAt5Min: count(
        if: {Trade: {Side: {Type: {is: buy}}}, Block: {Time: {after: $min5After}}}
      )
      sellsAt1Hour: count(
        if: {Trade: {Side: {Type: {is: buy}}}, Block: {Time: {after: $hour1After}}}
      )
      sellsAt6Hour: count(
        if: {Trade: {Side: {Type: {is: buy}}}, Block: {Time: {after: $hour6After}}}
      )
      sellsAt24Hour: count(
        if: {Trade: {Side: {Type: {is: buy}}}, Block: {Time: {after: $hour24After}}}
      )
    }
  }
}

Variables

{
  "network": "eth",
  "token": "0x2260fac5e5542a773aa44fbcfedf7c193bc2c599",
  "min5After": "2024-10-29T15:01:07.038Z",
  "hour1After": "2024-10-29T14:01:07.338Z",
  "hour6After": "2024-10-29T09:01:07.338Z",
  "hour24After": "2024-10-28T15:01:07.338Z"
}

Similar queries