Tron TokenOHLC + totalLiquidyty
Returns DEX trades by token and balance updates on Tron, where currency smart contract is TEzL3P…qx2C, balance update address is TTfvyr…7AAw and trade amount is above 0, sorted by block time: block time, buyer, seller, smart contract, protocol name, protocol family, currency symbol and 10 more fields.
What it returns
- block time
- buyer
- seller
- smart contract
- protocol name
- protocol family
- currency symbol
- currency name
- trade price
- trade amount
- side amount in USD
- side amount
- price in USD
- sum of trade side amount
- sum of trade side amount in USD
- sum of balance update amount
- decimals
Filters
- currency smart contract is TEzL3P…qx2C
- balance update address is TTfvyr…7AAw
- trade amount is above 0
The query
query TokenOHLC($token: String, $vault: String) {
Tron {
DEXTradeByTokens(
orderBy: {ascendingByField: "Block_Time"}
where: {Trade: {Amount: {gt: "0"}, Currency: {SmartContract: {is: $token}}}, Transaction: {Result: {Success: true}}}
) {
Block {
Time(interval: {count: 5, in: minutes})
allTime: Time
}
Trade {
Buyer
Seller
Dex {
SmartContract
ProtocolName
ProtocolFamily
}
Currency {
Symbol
Name
SmartContract
}
Price
Amount
Side {
AmountInUSD
Amount
}
open: Price(minimum: Block_Number)
close: Price(maximum: Block_Number)
min: Price(maximum: Trade_Price)
max: Price(minimum: Trade_Price)
closeUsd: PriceInUSD(maximum: Trade_PriceInUSD)
}
volume: sum(of: Trade_Side_Amount)
volumeUsd: sum(of: Trade_Side_AmountInUSD)
}
DexPools: BalanceUpdates(
where: {BalanceUpdate: {Address: {is: $vault}}, Currency: {SmartContract: {is: $token}}}
) {
totalLiquidity: sum(of: BalanceUpdate_Amount)
Currency {
SmartContract
Name
Symbol
Decimals
}
}
}
}
Variables
{
"token": "TEzL3PwyvHhBr33kudx2da27dxSZ6Lqx2C",
"vault": "TTfvyrAz86hbZk5iDpKD78pqLGgi8C7AAw"
}
Similar queries
- AfricaCryptoChainx · Ethereum · DEXTradeByTokens
- TLeVfrdym8RoJreJ23dAGyfJDygRtiWKBZ · Tron · DEXTradeByTokens
- UniversalSearch EVM · Ethereum · DEXTradeByTokens
- K2DhBqHBXEjBMwXm · Tron · DEXTradeByTokens
- Historical tron token trades beyond 30 days · Tron · DEXTradeByTokens