crypto_gostgreat-plum
    Updated 2024-11-29
    SELECT
    AVG(amount / 1e8) AS average_sent_amount,
    COUNT(DISTINCT tx_hash) AS total_transfers,
    COUNT(DISTINCT account_address) AS total_senders,
    SUM(amount / 1e8) AS total_volume_sent,
    SUM(amount / 1e8) / COUNT(DISTINCT DATE_TRUNC('day', block_timestamp)) AS average_daily_volume,
    FROM
    aptos.core.fact_transfers
    WHERE
    token_address = '0xf22bede237a07e121b56d91a491eb7bcdfd1f5907926a9e58338f964a01b17fa::asset::USDC';


    Last run: 3 months ago
    AVERAGE_SENT_AMOUNT
    TOTAL_TRANSFERS
    TOTAL_SENDERS
    TOTAL_VOLUME_SENT
    AVERAGE_DAILY_VOLUME
    1
    6.310365706311227476201403254192428973.36775248937.8698159767
    1
    69B
    17s