myown

Returns the latest 50 DEX trades by token and DEX trades on Tron, where side currency smart contract is TR7NHq…Lj6t or TNUC9Q…jWFR, currency smart contract is TNUC9Q…jWFR and block time since 2024-12-23: block time, transaction hash, smart contract, owner address, protocol family, protocol name, amount in USD and 20 more fields.

By Lisa Wall · saved 26 December 2024 · Bitquery API v2

What it returns

Filters

The query

query LatestTrades($token: String, $usdt: String!, $wtrx: String!, $time_ago: DateTime) {
  Tron {
    DEXTradeByTokens(
      orderBy: {descending: Block_Time}
      limit: {count: 50}
      where: {Trade: {Side: {Currency: {SmartContract: {in: [$usdt, $wtrx]}}, OrderId: {}}, Currency: {SmartContract: {is: $token}}, URIs: {}}, Block: {Time: {since: $time_ago}}}
    ) {
      Block {
        allTime: Time
      }
      Transaction {
        Hash
      }
      Trade {
        Dex {
          SmartContract
          OwnerAddress
          ProtocolFamily
          ProtocolName
        }
        AmountInUSD
        Buyer
        Seller
        Side {
          Type
          Buyer
          Seller
        }
        PriceInUSD
        Amount
        Side {
          Currency {
            Symbol
            SmartContract
            Name
          }
          AmountInUSD
          Amount
        }
      }
    }
    DEXTrades {
      uniq(of: Transaction_FeeInUSD)
      theils_corrected
      quantile(of: Trade_Buy_Amount, selectWhere: {}, if: {})
      entropy(of: Trade_Buy_Amount)
      count
      array_intersect(side1: Log_Signature_Signature, side2: Log_Signature_Signature)
      TransactionStatus
      skew(of: Trade_Buy_Amount)
    }
    Events
  }
}

Variables

{
  "token": "TNUC9Qb1rRpS5CbWLmNMxXBjyFoydXjWFR",
  "wtrx": "TNUC9Qb1rRpS5CbWLmNMxXBjyFoydXjWFR",
  "usdt": "TR7NHqjeKQxGTCi8q8ZY4pL8otSzgjLj6t",
  "time_ago": "2024-12-23T06:32:48Z"
}

Similar queries