precision problem with USDC

Returns DEX trades by token on Ethereum, where currency smart contract is 0xA0b8…eB48 and block time since 2024-10-31: count and sum of trade side amount in USD.

By Akshat · saved 1 November 2024 · 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}}}
          ) {
            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": "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