TOTAL_TRANSACTIONS | UNIQUE_USERS | TOTAL_VOLUME_WMON | |
|---|---|---|---|
1 | 801367 | 284131 | 60895.660342922 |
yasminTOTAL
Updated 1 day ago
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 token_info AS (
SELECT '0x760afe86e5de5fa0ee542fc7b7b713e1c5425701' as address, 'WMON' as symbol, 18 as decimals
UNION ALL SELECT '0xf817257fed379853cde0fa4f97ab987181b1e5ea', 'USDC', 6
UNION ALL SELECT '0x62FeEb2132d9AC97d7f32D3a896F9aaa9078F8d3', 'BENDS', 18
UNION ALL SELECT '0xE0590015A873bF326bd645c3E1266d4db41C4E6B', 'CHOG', 18
UNION ALL SELECT '0x0F0BDEbF0F83cD1EE3974779Bcb7315f9808c714', 'DAK', 18
UNION ALL SELECT '0x3B428Df09c3508D884C30266Ac1577f099313CF6', 'MAMABTC', 18
UNION ALL SELECT '0xD8C603A0Fe45c77f13FAF626C04fE69EEB628196', 'MDX', 18
UNION ALL SELECT '0xe9f4c0093B4e94800487cad93FBBF7C3729ccf5c', 'MLDC', 18
UNION ALL SELECT '0x59897686b2Dd2059b09642797EBeA3d21E6cE2d1', 'MYK', 18
UNION ALL SELECT '0xab1fA5cc0a7dB885BC691b60eBeEbDF59354434b', 'PEPE', 18
UNION ALL SELECT '0xc60A9A0E7F3cBea1852B945EdB35Be52c2c8954e', 'PYRO', 18
UNION ALL SELECT '0xF42498F419EC9D5b074E675db713bC12B1E274e2', 'SHARKBAN', 18
UNION ALL SELECT '0x3a98250F98Dd388C211206983453837C8365BDc1', 'SHMON', 18
UNION ALL SELECT '0x951832502F0667CD00E1d1dAF1b42d163D3f17Ac', 'TRUMP', 18
UNION ALL SELECT '0x88b8E2161DEDC77EF4ab7585569D2415a1C1055D', 'USDT', 6
UNION ALL SELECT '0xcf5a6076cfa32686c0Df13aBaDa2b40dec133F1d', 'WBTC', 8
UNION ALL SELECT '0xB5a30b0FDc5EA94A52fDc42e3E9760Cb8449Fb37', 'WETH', 18
UNION ALL SELECT '0xfe140e1dCe99Be9F4F15d657CD9b7BF622270C50', 'YAKI', 18
)
SELECT
COUNT(DISTINCT t.TX_HASH) AS total_transactions,
COUNT(DISTINCT t.user_address) AS unique_users,
SUM(CASE
WHEN LOWER(t.token_in_address) = '0x760afe86e5de5fa0ee542fc7b7b713e1c5425701' THEN t.VALUE
ELSE 0
END) AS total_volume_wmon
FROM (
SELECT
TX_HASH,
LOWER('0x' || SUBSTR(input, 11+2*64+24, 40)) AS user_address,
LOWER('0x' || SUBSTR(input, 11+9*64+24, 40)) AS token_in_address,
VALUE
FROM monad.testnet.fact_traces
WHERE TO_ADDRESS = '0xcbcd292c9dae11875e090bb963aa4c74ccce6a23'
AND TYPE = 'CALL'
Last run: 1 day ago
1
33B
17s