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.
What it returns
- block time
- transaction hash
- smart contract
- owner address
- protocol family
- protocol name
- amount in USD
- buyer
- seller
- side type
- side buyer
- side seller
- price in USD
- trade amount
- side currency symbol
- side smart contract
- side currency name
- side amount in USD
- side amount
- unique of transaction fee in USD
- theils corrected
- quantile of trade buy amount
- entropy of trade buy amount
- count
- array intersect
- transaction status
- skew of trade buy amount
Filters
- side currency smart contract is TR7NHq…Lj6t or TNUC9Q…jWFR
- currency smart contract is TNUC9Q…jWFR
- block time since 2024-12-23
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
- AfricaCryptoChainx · Ethereum · DEXTradeByTokens
- TLeVfrdym8RoJreJ23dAGyfJDygRtiWKBZ · Tron · DEXTradeByTokens
- UniversalSearch EVM · Ethereum · DEXTradeByTokens
- K2DhBqHBXEjBMwXm · Tron · DEXTradeByTokens
- Historical tron token trades beyond 30 days · Tron · DEXTradeByTokens