SYMBOL | TOTAL_VOLUME | TOTAL_TRANSACTIONS | TOTAL_SENDERS | TOTAL_RECEIVERS | |
|---|---|---|---|---|---|
1 | jUSD | 240243.087385781 | 1172 | 1171 | 1171 |
2 | jTRUMP | 314.58075314 | 80 | 80 | 80 |
3 | jNVDA | 64.201270309 | 27 | 27 | 27 |
4 | jMSTR | 40.467587091 | 88 | 88 | 88 |
5 | jAAPL | 27.04450802 | 37 | 37 | 37 |
6 | jTSLA | 26.312606777 | 68 | 68 | 68 |
7 | jMETA | 10.330411347 | 33 | 33 | 33 |
m3jiTop Performing Jassets
Updated 2025-01-23
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
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
7
234B
4s