crypto_gostarrogant-rose
    Updated 2024-11-29
    SELECT
    'USDC' AS stablecoin,
    COUNT(DISTINCT tx_hash) AS "Transfers",
    COUNT(DISTINCT ACCOUNT_ADDRESS) AS "Senders",
    SUM(AMOUNT / 1e6) AS volume_sent,
    SUM(AMOUNT / 1e6) / COUNT(DISTINCT date_trunc('day', BLOCK_TIMESTAMP)) AS avg_per_day,
    FROM
    aptos.core.fact_transfers
    WHERE
    TOKEN_ADDRESS = '0xf22bede237a07e121b56d91a491eb7bcdfd1f5907926a9e58338f964a01b17fa::asset::USDC'-----usdc (layer zero)

    UNION ALL

    SELECT
    'USDT' AS stablecoin,
    COUNT(DISTINCT tx_hash) AS "Transfers",
    COUNT(DISTINCT ACCOUNT_ADDRESS) AS "Senders",
    SUM(AMOUNT / 1e6) AS volume_sent,
    SUM(AMOUNT / 1e6) / COUNT(DISTINCT date_trunc('day', BLOCK_TIMESTAMP)) AS avg_per_day,
    FROM
    aptos.core.fact_transfers
    WHERE
    TOKEN_ADDRESS = '0xa2eda21a58856fda86451436513b867c97eecb4ba099da5775520e0f7492e852::coin::T';----Tether USD (Wormhole)

    UNION all

    SELECT
    'ceUSDC' AS stablecoin,
    COUNT(DISTINCT tx_hash) AS "Transfers",
    COUNT(DISTINCT ACCOUNT_ADDRESS) AS "Senders",
    SUM(AMOUNT / 1e6) AS volume_sent,
    SUM(AMOUNT / 1e6) / COUNT(DISTINCT date_trunc('day', BLOCK_TIMESTAMP)) AS avg_per_day,
    FROM
    aptos.core.fact_transfers
    WHERE
    TOKEN_ADDRESS = '0x8d87a65ba30e09357fa2edea2c80dbac296e5dec2b18287113500b902942929d::celer_coin_manager::UsdcCoin';
    Last run: 3 months ago
    STABLECOIN
    Transfers
    Senders
    VOLUME_SENT
    AVG_PER_DAY
    1
    USDC22747620140325419242897334.61775224893786.978806924
    2
    USDT58721298002122098182.938211157953.66486185123
    3
    ceUSDC3350412750274409676.55009496510.60512333852
    3
    181B
    24s