AMLBotseparate overall stablecoins transfers by blockchain copy
    Updated 2024-02-01
    -- forked from overall stablecoins transfers by blockchain @ https://flipsidecrypto.xyz/edit/queries/88da4613-7850-4db9-9ba7-b23adc306757

    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
    }
    Last run: 11 months ago
    DAY
    BLOCKCHAIN
    TOTAL_TRANSFERS
    TOTAL_TRANSFERRED_VOLUME
    1
    2023-01-01 00:00:00.000TRX16526854209195653.4146
    2
    2023-01-01 00:00:00.000Bsc536194607066355.33932
    3
    2023-01-01 00:00:00.000Polygon205728181024987.269733
    4
    2023-01-01 00:00:00.000Ethereum9464211655518464.5013
    5
    2023-01-02 00:00:00.000TRX19983317698874501.90949
    6
    2023-01-02 00:00:00.000Bsc5957821171506752.78987
    7
    2023-01-02 00:00:00.000Polygon263042267629476.685051
    8
    2023-01-02 00:00:00.000Ethereum13057813196749025.4108
    9
    2023-01-03 00:00:00.000TRX20814468248402613.8633
    10
    2023-01-03 00:00:00.000Bsc612123707503566.941733
    11
    2023-01-03 00:00:00.000Polygon282874367509221.868111
    12
    2023-01-03 00:00:00.000Ethereum14881422895381789.0803
    13
    2023-01-04 00:00:00.000TRX22184478406609937.4967
    14
    2023-01-04 00:00:00.000Bsc6458251003398282.81967
    15
    2023-01-04 00:00:00.000Polygon303103329640005.679402
    16
    2023-01-04 00:00:00.000Ethereum16994831126778975.1065
    17
    2023-01-05 00:00:00.000TRX22224308494959876.57144
    18
    2023-01-05 00:00:00.000Bsc6139921370790203.4028
    19
    2023-01-05 00:00:00.000Polygon280236276381766.660113
    20
    2023-01-05 00:00:00.000Ethereum16035124162712466.1983
    ...
    1460
    86KB
    87s