permaryAsset Transfer Volume
    Updated 2025-02-18
    WITH asset_transfers AS (
    SELECT
    DATE(CLOSED_AT) AS date,
    COALESCE(ASSET_CODE, 'XLM') AS asset_code,
    ASSET_ISSUER,
    SUM(AMOUNT) / 10000000 AS total_transferred, -- Convert to standard units
    COUNT(*) AS transfer_count,
    l.label AS issuer_label
    FROM stellar.core.fact_operations f
    LEFT JOIN stellar.core.dim_labels l
    ON f.asset_issuer = l.address
    WHERE
    TYPE_STRING = 'payment'
    AND CLOSED_AT >= DATEADD('day', -30, CURRENT_DATE())
    GROUP BY
    date,
    asset_code,
    ASSET_ISSUER,
    l.label
    ),
    asset_totals AS (
    SELECT
    asset_code,
    COALESCE(issuer_label, asset_issuer) AS issuer,
    SUM(total_transferred) AS total_volume,
    SUM(transfer_count) AS total_transactions
    FROM asset_transfers
    GROUP BY
    asset_code,
    COALESCE(issuer_label, asset_issuer)
    )

    SELECT
    asset_code,
    issuer,
    ROUND(total_volume, 2) AS total_volume, -- Rounded to 2 decimal places
    Last run: 27 days ago
    ASSET_CODE
    ISSUER
    TOTAL_VOLUME
    TOTAL_TRANSACTIONS
    AVG_TRANSFER_SIZE
    1
    WSHIBGAV7UORZO2UGQIS67DAC2G3EKCPOYE6DFA5R3IL2U4RE4T6VPVMG3QR226702913.38184381448.25
    2
    BHPGCFHLZ2Y7DELLTEYS64U3IHI2XYDQVHGU5S3ZZWPA7O5O5JTVCNIFWVX9720466.7314988464.85
    3
    WOWGCFHLZ2Y7DELLTEYS64U3IHI2XYDQVHGU5S3ZZWPA7O5O5JTVCNIFWVX9372138.4425977736.08
    4
    WDSGCFHLZ2Y7DELLTEYS64U3IHI2XYDQVHGU5S3ZZWPA7O5O5JTVCNIFWVX9360564.8325767136.33
    5
    PNRGCFHLZ2Y7DELLTEYS64U3IHI2XYDQVHGU5S3ZZWPA7O5O5JTVCNIFWVX9356337.8215018962.3
    6
    GALGCFHLZ2Y7DELLTEYS64U3IHI2XYDQVHGU5S3ZZWPA7O5O5JTVCNIFWVX9243530.128236532.74
    7
    GMGGCFHLZ2Y7DELLTEYS64U3IHI2XYDQVHGU5S3ZZWPA7O5O5JTVCNIFWVX9023070.3628279831.91
    8
    WESGCFHLZ2Y7DELLTEYS64U3IHI2XYDQVHGU5S3ZZWPA7O5O5JTVCNIFWVX9022389.4528087432.12
    9
    MDTGCFHLZ2Y7DELLTEYS64U3IHI2XYDQVHGU5S3ZZWPA7O5O5JTVCNIFWVX8904449.7314462661.57
    10
    FMGGCFHLZ2Y7DELLTEYS64U3IHI2XYDQVHGU5S3ZZWPA7O5O5JTVCNIFWVX8894921.7415053459.09
    10
    913B
    4s