AMLBotstables on tron
    Updated 2024-12-30
    with raw_transfers_usdt as(
    SELECT
    bitquery.graphql({
    'query' : '{
    tron {
    transfers(
    currency: {is: "TR7NHqjeKQxGTCi8q8ZY4pL8otSzgjLj6t"}
    date: {since: "{{since_date}}", till: "{{current_date}}"}
    ) {
    date {
    date(format: "%Y-%m-%d")
    }
    amount(calculate: sum)
    countBigInt
    }
    }
    }'
    }) as resp
    ),
    raw_transfers_usdc as(
    SELECT
    bitquery.graphql({
    'query' : '{
    tron {
    transfers(
    currency: {is: "TEkxiTehnzSmSe2XqrBj4w32RUN966rdz8"}
    date: {since: "{{since_date}}", till: "{{current_date}}"}
    ) {
    date {
    date(format: "%Y-%m-%d")
    }
    amount(calculate: sum)
    countBigInt
    }
    }
    }'
    QueryRunArchived: QueryRun has been archived