m3jiTop Performing Jassets
    Updated 2025-01-23
    WITH jAsset_transfers AS (
    SELECT
    BLOCK_TIMESTAMP,
    SYMBOL,
    FROM_ADDRESS,
    TO_ADDRESS,
    SUM(AMOUNT) AS TOTAL_AMOUNT,
    COUNT(DISTINCT TX_HASH) AS TX_COUNT,
    COUNT(DISTINCT FROM_ADDRESS) AS UNIQUE_SENDERS,
    COUNT(DISTINCT TO_ADDRESS) AS UNIQUE_RECEIVERS
    FROM
    sei.core_evm.ez_token_transfers
    WHERE
    SYMBOL IN (
    'JellyToken',
    'jUSD',
    'jAAPL',
    'jTSLA',
    'jMSTR',
    'jNVDA',
    'jMETA',
    'jTRUMP'
    ) -- Filter for jAssets
    GROUP BY
    BLOCK_TIMESTAMP,
    SYMBOL,
    FROM_ADDRESS,
    TO_ADDRESS
    )
    SELECT
    SYMBOL,
    SUM(TOTAL_AMOUNT) AS TOTAL_VOLUME,
    SUM(TX_COUNT) AS TOTAL_TRANSACTIONS,
    SUM(UNIQUE_SENDERS) AS TOTAL_SENDERS,
    SUM(UNIQUE_RECEIVERS) AS TOTAL_RECEIVERS
    FROM
    Last run: about 2 months ago
    SYMBOL
    TOTAL_VOLUME
    TOTAL_TRANSACTIONS
    TOTAL_SENDERS
    TOTAL_RECEIVERS
    1
    jUSD240243.087385781117211711171
    2
    jTRUMP314.58075314808080
    3
    jNVDA64.201270309272727
    4
    jMSTR40.467587091888888
    5
    jAAPL27.04450802373737
    6
    jTSLA26.312606777686868
    7
    jMETA10.330411347333333
    7
    234B
    4s