Sleepyoverall stablecoins transfers by blockchain
    Updated 2025-04-23
    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: 3 months ago
    DAY
    BLOCKCHAIN
    TOTAL_TRANSFERS
    TOTAL_TRANSFERRED_VOLUME
    1
    2023-08-10 00:00:00.000Bsc940770957999672.289544
    2
    2023-08-10 00:00:00.000Polygon284149418611569.038579
    3
    2023-08-10 00:00:00.000Ethereum14450810294367947.4258
    4
    2023-08-11 00:00:00.000Bsc9689211000316933.18078
    5
    2023-08-11 00:00:00.000Polygon277310349119994.029745
    6
    2023-08-11 00:00:00.000Ethereum13479210869573208.4902
    7
    2023-08-12 00:00:00.000Bsc963171756732926.282734
    8
    2023-08-12 00:00:00.000Polygon235603274542622.637673
    9
    2023-08-12 00:00:00.000Ethereum1013413912998536.23915
    10
    2023-08-13 00:00:00.000Bsc933951810532768.628181
    11
    2023-08-13 00:00:00.000Polygon247385267948019.667966
    12
    2023-08-13 00:00:00.000Ethereum990454516535561.14041
    13
    2023-08-14 00:00:00.000Bsc10968021377443745.22814
    14
    2023-08-14 00:00:00.000Polygon274236422205965.234591
    15
    2023-08-14 00:00:00.000Ethereum13743213984870493.3287
    16
    2023-08-15 00:00:00.000Bsc10488161285551975.38824
    17
    2023-08-15 00:00:00.000Polygon297728556418377.565646
    18
    2023-08-15 00:00:00.000Ethereum1451589212873550.05709
    19
    2023-08-16 00:00:00.000Bsc10819632127458783.51967
    20
    2023-08-16 00:00:00.000Polygon306322458220652.625696
    33
    2KB
    26s