decimal_wrong

Returns DEX trades by token on Ethereum, where currency smart contract is 0xA0b8…eB48 and block time since 2024-10-31, sorted by volume sell at24 hour, highest first: count, sum of trade side amount in USD, currency name, decimals, protocol name, smart contract, side currency name and 3 more fields.

By Omkar_BQ · saved 2 November 2024 · run 41 times · Bitquery API v2

What it returns

Filters

The query

query getTradingActivity($network: evm_network, $token: String, $since: DateTime!, $min5After: DateTime!, $hour1After: DateTime!, $hour6After: DateTime!, $hour24After: DateTime!) {
  EVM(dataset: realtime, network: $network) {
    DEXTradeByTokens(
      where: {TransactionStatus: {Success: true}, Trade: {Currency: {SmartContract: {is: $token}}}, Block: {Time: {since: $since}}}
      orderBy: {descendingByField: "volumeSellAt24Hour"}
    ) {
      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}}}
      )
      Trade {
        Currency {
          Name
          Decimals
          ProtocolName
          SmartContract
        }
        Side {
          Currency {
            Name
            ProtocolName
            Decimals
            SmartContract
          }
        }
      }
    }
  }
}

Variables

{
  "network":"eth",
  "token": "0xA0b86991c6218b36c1d19D4a2e9Eb0cE3606eB48",
  "since":"2024-10-31T19:18:00Z",
  "min5After":"2024-11-01T19:13:00Z",
  "hour1After":"2024-11-01T18:18:00Z",
  "hour6After":"2024-11-01T13:18:00Z",
  "hour24After":"2024-10-31T19:18:00Z"
}

Similar queries