TOTAL_TRANSACTIONS | UNIQUE_USERS | TOTAL_VOLUME_WMON | |
|---|---|---|---|
1 | 801367 | 284131 | 60895.660342922 |
yasminTOTAL
Updated 20 hours 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: about 20 hours ago
1
33B
17s