AMLBotTRX USDС DEX volume
    Updated 2024-12-19
    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