AMLBotTRX USDС DEX volume
Updated 2024-12-19Copy Reference Fork
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
with raw_dex_swaps_usdt as(
SELECT
bitquery.graphql({
'query' : '{
tron {
buy:dexTrades(
date: {since: "{{since_date}}", till: "{{current_date}}"}
buyCurrency: {is: "TEkxiTehnzSmSe2XqrBj4w32RUN966rdz8"}
) {
date {
date(format: "%Y-%m-%d")
}
Volume: buyAmount(calculate: sum)
medianSwap: buyAmount(calculate: median)
avgSwap: buyAmount(calculate: average)
countBigInt
}
sell:dexTrades(
date: {since: "{{since_date}}", till: "{{current_date}}"}
sellCurrency: {is: "TEkxiTehnzSmSe2XqrBj4w32RUN966rdz8"}
) {
date {
date(format: "%Y-%m-%d")
}
Volume: sellAmount(calculate: sum)
medianSwap: sellAmount(calculate: median)
avgSwap: sellAmount(calculate: average)
countBigInt
}
}
}'
}) as resp
)
,
buys_usdt as(
SELECT
QueryRunArchived: QueryRun has been archived