m3jiDaily transfers
    Updated 2025-01-23

    SELECT
    date_trunc('day', BLOCK_TIMESTAMP) AS DAY,
    SYMBOL,
    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 1, 2






















    Last run: about 2 months ago
    DAY
    SYMBOL
    TOTAL_AMOUNT
    TX_COUNT
    UNIQUE_SENDERS
    UNIQUE_RECEIVERS
    1
    2025-01-21 00:00:00.000jTRUMP287.7557018751612
    2
    2025-01-21 00:00:00.000jMETA9.5070141961968
    3
    2025-01-22 00:00:00.000jTRUMP21.795896658955
    4
    2025-01-21 00:00:00.000jNVDA55.2507978931969
    5
    2025-01-18 00:00:00.000jUSD2565.92363690822106
    6
    2025-01-17 00:00:00.000jUSD2617.28100596937912
    7
    2025-01-20 00:00:00.000jTSLA0.004936905329111
    8
    2025-01-20 00:00:00.000jAAPL0.009158065833111
    9
    2025-01-22 00:00:00.000jUSD110112.816404832083036
    10
    2025-01-20 00:00:00.000jNVDA0.01526093211111
    11
    2025-01-22 00:00:00.000jMSTR12.61495177929810
    12
    2025-01-22 00:00:00.000jAAPL2.3240996631356
    13
    2025-01-22 00:00:00.000jNVDA8.935211484644
    14
    2025-01-23 00:00:00.000jTRUMP5.029154612333
    15
    2025-01-21 00:00:00.000jMSTR27.847324651451113
    16
    2025-01-23 00:00:00.000jUSD3784.234165474221112
    17
    2025-01-23 00:00:00.000jMETA0.0003155180724223
    18
    2025-01-22 00:00:00.000jTSLA0.4142732337634
    19
    2025-01-20 00:00:00.000jUSD15.541497453617
    20
    2025-01-20 00:00:00.000jMSTR0.005310661035111
    27
    1KB
    1s