POOL_CONTRACT | SYMBOL0 | SYMBOL1 | PAIR | TOKEN_CONTRACT0 | TOKEN_CONTRACT1 | DECIMAL0 | DECIMAL1 | EXID | |
|---|---|---|---|---|---|---|---|---|---|
1 | 0xc0ce32eee0eb8bf24fa2b00923a78abc5002f91e | WMON | CHOG | WMON/CHOG | 0x760afe86e5de5fa0ee542fc7b7b713e1c5425701 | 0xe0590015a873bf326bd645c3e1266d4db41c4e6b | 18 | 18 | 9 |
2 | 0x34e3de28efaaceea3b21a2f9e0cb6a6e62908540 | WETH | 0x369cd1e20fa7ea1f8e6dc0759709ba0bd978abe7 | 0xb5a30b0fdc5ea94a52fdc42e3e9760cb8449fb37 | 18 | 475 | |||
3 | 0x5faaebc96b6fde932a735a218ada47de31eb304a | DEER | WMON | DEER/WMON | 0x700c25b191528bbf1dabb2647f073493b4175461 | 0x760afe86e5de5fa0ee542fc7b7b713e1c5425701 | 18 | 18 | 11 |
4 | 0x6f05b9e3d3ff81ac8e1a0872f66360cdd1bc3b12 | WMON | 0x1c0d72a330f2768daf718def8a19bab019eead09 | 0x760afe86e5de5fa0ee542fc7b7b713e1c5425701 | 18 | 114 | |||
5 | 0x8d0f95d425c69b0298b9753800d6b50014771258 | WMON | 0x760afe86e5de5fa0ee542fc7b7b713e1c5425701 | 0x8082f7867b21c11f8d8a15010294c12a811530f6 | 18 | 439 | |||
6 | 0x5323821de342c56b80c99fbc7cd725f2da8eb87b | WMON | USDC | WMON/USDC | 0x760afe86e5de5fa0ee542fc7b7b713e1c5425701 | 0xf817257fed379853cde0fa4f97ab987181b1e5ea | 18 | 6 | 5 |
7 | 0x6e4b7be5ef7f8950c76baa0bd90125bc9b33c8db | DAK | WMON | DAK/WMON | 0x0f0bdebf0f83cd1ee3974779bcb7315f9808c714 | 0x760afe86e5de5fa0ee542fc7b7b713e1c5425701 | 18 | 18 | 7 |
8 | 0x0f987ad073d6fef6928e67d6a718a072c71945b9 | WMON | 0x369cd1e20fa7ea1f8e6dc0759709ba0bd978abe7 | 0x760afe86e5de5fa0ee542fc7b7b713e1c5425701 | 18 | 476 | |||
9 | 0xd4470ab4b40aa12ff407a7adf83d0de8d9e6a215 | WMON | USDT | WMON/USDT | 0x760afe86e5de5fa0ee542fc7b7b713e1c5425701 | 0x88b8e2161dedc77ef4ab7585569d2415a1c1055d | 18 | 6 | 6 |
10 | 0x76a61e9953de35ccbcb383f82f42fb1b1f256079 | WMON | WBTC | WMON/WBTC | 0x760afe86e5de5fa0ee542fc7b7b713e1c5425701 | 0xcf5a6076cfa32686c0df13abada2b40dec133f1d | 18 | 8 | 12 |
11 | 0x8e5eb959e44941a22a9ab6795b45eb5b0aa19d37 | WMON | 0x5387c85a4965769f6b0df430638a1388493486f1 | 0x760afe86e5de5fa0ee542fc7b7b713e1c5425701 | 18 | 179 | |||
12 | 0x132cb626be0dd6eb3b53fbeb392838c7a7b93621 | WMON | WETH | WMON/WETH | 0x760afe86e5de5fa0ee542fc7b7b713e1c5425701 | 0xb5a30b0fdc5ea94a52fdc42e3e9760cb8449fb37 | 18 | 18 | 13 |
13 | 0x2d4489ff26317206706b1356d6501d90f81ad076 | DAK | 0x0f0bdebf0f83cd1ee3974779bcb7315f9808c714 | 0x5d876d73f4441d5f2438b1a3e2a51771b337f27a | 18 | 511 | |||
14 | 0x212fde77a42d55f980d0a0304e7eebe1e999c60f | WMON | YAKI | WMON/YAKI | 0x760afe86e5de5fa0ee542fc7b7b713e1c5425701 | 0xfe140e1dce99be9f4f15d657cd9b7bf622270c50 | 18 | 18 | 8 |
15 | 0x12520d4a5f2855a96a7cb50f4f9694834e0ea064 | USDT | 0x369cd1e20fa7ea1f8e6dc0759709ba0bd978abe7 | 0x88b8e2161dedc77ef4ab7585569d2415a1c1055d | 6 | 474 |
SajjadiiiToken Metadata
Updated 2025-04-13
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 decimal_tab AS (
SELECT * FROM(values
('0x88b8e2161dedc77ef4ab7585569d2415a1c1055d' , '6' , 'USDT' , 'Tether USD') -- Tether USD(USDT)
,('0xf817257fed379853cde0fa4f97ab987181b1e5ea' , '6' , 'USDC' , 'USD Coin') -- USD Coin(USDC)
,('0xcf5a6076cfa32686c0df13abada2b40dec133f1d' , '8' , 'WBTC' , 'Wrapped BTC') -- Wrapped BTC(WBTC)
,('0x0f0bdebf0f83cd1ee3974779bcb7315f9808c714' , '18' , 'DAK' , 'Molandak') -- Molandak(DAK)
,('0x760afe86e5de5fa0ee542fc7b7b713e1c5425701' , '18' , 'WMON' , 'Wrapped Monad') -- Wrapped Monad(WMON)
,('0x700c25b191528bbf1dabb2647f073493b4175461' , '18' , 'DEER' , 'Deercoin') -- Deercoin(DEER)
,('0xcaf9244a9d4a79c3229cb354a1919961fa0122b4' , '18' , 'TCHOG' , 'TestChog') -- TestChog(TCHOG)
,('0xe0590015a873bf326bd645c3e1266d4db41c4e6b' , '18' , 'CHOG' , 'Chog') -- Chog(CHOG)
,('0xfe140e1dce99be9f4f15d657cd9b7bf622270c50' , '18' , 'YAKI' , 'Moyaki') -- Moyaki(YAKI)
,('0xa5020ecbe21d6ef4bf5ab1455bc7f1ad280711c6' , '18' , 'TMOL' , 'TestMolandak') -- TestMolandak(TMOL)
,('0xa6afcddcd245f902effbf679983ec7f89af4de4d' , '18' , 'TMOY' , 'TestMoyaki') -- TestMoyaki(TMOY)
,('0xb5a30b0fdc5ea94a52fdc42e3e9760cb8449fb37' , '18' , 'WETH' , 'Wrapped ETH') -- Wrapped ETH(WETH)
) AS a (token , decimal ,symbol , name)
),
tab_1 AS (
SELECT
concat('0x', substr(topics[1], 24 + 3, 32 + 8)) AS token_contract0
,concat('0x', substr(topics[2], 24 + 3, 32 + 8)) AS token_contract1
,concat('0x', substr(data, 24 + 3, 32 + 8)) AS Pool_contract
,ethereum.public.udf_hex_to_int(substr(data,(64)+ 24 + 3, 32 + 8)) AS exid
,b.symbol as symbol0
,c.symbol as symbol1
,b.decimal AS decimal0
,c.decimal AS decimal1
FROM monad.testnet.fact_event_logs a
LEFT JOIN decimal_tab b on concat('0x', substr(a.topics[1], 24 + 3, 32 + 8)) = b.token
LEFT JOIN decimal_tab c on concat('0x', substr(a.topics[2], 24 + 3, 32 + 8)) = c.token
WHERE topics[0] = '0x0d3648bd0f6ba80134a33ba9275ac585d9d315f0ad8355cddefde31afa28d0e9' -- PairCreated(address,address,address,uint256)
AND origin_function_signature = '0xc9c65396' -- createPair
AND contract_address = '0x733e88f248b742db6c14c0b1713af5ad7fdd59d0' -- poolFactory
--tx_hash = '0x3d5bf3b388a45a29dbf1cd019b0c9c5e11e21b15b7ae01f66ca37c4e195004e9'
and token_contract0 not in (
Last run: 12 days agoAuto-refreshes every 24 hours
15
3KB
107s