BLOCK_TIMESTAMP | TX_HASH | CREATED_INTERVAL | CREATOR | TOKEN_ADDRESS | SYMBOL | TOKEN_NAME | |
|---|---|---|---|---|---|---|---|
1 | 2025-02-09 04:12:02.000 | 0xb10a3b3bd4b3bcf87e40c82e0d14ad32611093f4da9d667645602c561aa89167 | 42 | 0x7fe0bce62b95b22eb6335b2dac3b4e5a2f6f034e | 0x129bbb99a409e52d5018fbf33044b90efde4793c | TEST | TEST |
2 | 2025-02-09 07:43:58.000 | 0x4e43d0d4c7f41abe1f3dcb4ed032c5dcfc5220c63480723dd5233ad1bfc17244 | 42 | 0x7fe0bce62b95b22eb6335b2dac3b4e5a2f6f034e | 0xb0cd80162efafa127aa40a3138d6c381733c47d3 | TEST2 | TEST2 |
3 | 2025-02-09 15:30:43.000 | 0x24d1d7f4edee848c3cc2e9f9512cdafffc1c15d0f4db6f3d848c928cd47c53f5 | 42 | 0x7fe0bce62b95b22eb6335b2dac3b4e5a2f6f034e | 0x8b0f4a27bd8cf4d0ca4a5b494678b7dc7ad093bb | TEST4 | TEST4 |
4 | 2025-02-10 07:44:51.000 | 0xbb57952e8ed6217dffb607badd46f3c0b00a7fa7dbe5d47e4f430f1183ebfdc1 | 41 | 0x026d161501cde95ee129acba1caf20eccc64440a | 0x0bd0c0dd62c59c255a8d0b33a18ec911d7905dc5 | BENAD | BENAD |
5 | 2025-02-10 08:39:12.000 | 0x93ef0c0998ca160353a7b8905a00d252a5cb039a091dd8e15775cd2edb2ca29a | 41 | 0x026d161501cde95ee129acba1caf20eccc64440a | 0x96154033ce799d27c14ed43b62ef308aef16ee9f | HAT | HAT |
6 | 2025-02-10 12:37:48.000 | 0x9e1affebdbff8b5416a391d20c7cd8ea7d142a8ebba003557972ad6dfd538913 | 41 | 0x7fe0bce62b95b22eb6335b2dac3b4e5a2f6f034e | 0xbe5e268588a54983968a5e17b6641e81eaa1de4a | TEST5 | TEST5 |
7 | 2025-02-10 13:38:21.000 | 0x43cff8c99f96736ec48923ebf6d5af306d6cb101a1b4938242f81e4d73cb2b9f | 41 | 0x7fe0bce62b95b22eb6335b2dac3b4e5a2f6f034e | 0xef4ef6585a7682a094955631675667fa85f92b9f | KARINA | KARINA |
8 | 2025-02-10 13:59:19.000 | 0x4401b4b7bffac43d18fe2392468e2104e221f0bb800952b829b3f845a28f76cf | 41 | 0x7fe0bce62b95b22eb6335b2dac3b4e5a2f6f034e | 0x077f1ea1b3cb2af3dbcd3ad4e3c96d368c9d1aea | WINT | WINT |
9 | 2025-02-10 13:20:02.000 | 0xad0c9659091fc809148f7ffc4250c7f71fb3c7e4d29774361259230a10da44c2 | 41 | 0x7fe0bce62b95b22eb6335b2dac3b4e5a2f6f034e | 0xfc65375d12bc463438faf9cf6e0f207f44dbddbf | TTT | TTT |
10 | 2025-02-10 13:22:03.000 | 0x62c60a83fa2797cae5900950413f193b883ba2ed2639d10bd43c79ffcc70b233 | 41 | 0x7fe0bce62b95b22eb6335b2dac3b4e5a2f6f034e | 0x6d0ea8a08fb1785053e0682e23590314d9dafe9a | TT1 | TT1 |
11 | 2025-02-10 13:49:59.000 | 0x4cefb664fc6fe0787e78218e676babf06e3ca75d343fbdc390cd28d8eaf027c1 | 41 | 0x7fe0bce62b95b22eb6335b2dac3b4e5a2f6f034e | 0x4b5d7d066a705ecfed23cb647875fa236675a0ab | KARIN | KARIN |
12 | 2025-02-10 13:55:18.000 | 0xedd39ababdc35ec26d8650e600334f5cb5ed209f79d2acfa73adb61e468ab46c | 41 | 0x7fe0bce62b95b22eb6335b2dac3b4e5a2f6f034e | 0xe6425bb1362a650ce5a054ddce1d58ed7ae4f7fb | WINTER | WINTER |
13 | 2025-02-10 13:44:24.000 | 0x8553de65c86305a934457db7e7eaaf883adeba3aed5d6c9dc8ea979c5abf7d0a | 41 | 0x026d161501cde95ee129acba1caf20eccc64440a | 0x573791e2450039d0504087a19745c4408e94e118 | SATORU | satoru |
14 | 2025-02-10 13:50:35.000 | 0xe461cf917c1e96443f439452e9f2cdc9c619ede8b93d097306ba8455531517b2 | 41 | 0x7fe0bce62b95b22eb6335b2dac3b4e5a2f6f034e | 0x42d401a11ddbfa9e0a2f3d00c02d3a26c21840c6 | KAKA | KAKA |
15 | 2025-02-10 14:31:12.000 | 0x9a331fc7b92b972773df711409b8e12fb38bb359c9366bce8183fccdfbd98e80 | 41 | 0x7fe0bce62b95b22eb6335b2dac3b4e5a2f6f034e | 0x7124a47df84e2e474e5e3e8cbe14996008bbc1b3 | 1111 | 111 |
16 | 2025-02-20 03:42:14.000 | 0x7a8bbb59f42c71416ebcf9b4f16888e1b21f34804282635759ab50814a2474b9 | 31 | 0x42f988bfbe67cf4d19880101836bc5bce872b9b4 | 0xb6212226f5ca146b09abdd36ac7b976fbae268ec | ODEN | ODEN |
17 | 2025-02-20 03:31:41.000 | 0x056db4ad988b1876269aeaa9eee3b7a9e49950ece123effa14f97c3ed97cd23e | 31 | 0x679112ab7230a5e119e57ce6c8213ac6f288f2f0 | 0x54aa27fe8f901b0adb6526551ceded4e1d55884d | DEAI | island boy |
18 | 2025-02-20 03:08:40.000 | 0xabac03ab7e23032ffdba1e3c5a0e17ee65b3ad459a6eb9c20cbb5ac4d121d15c | 31 | 0xd304ec0b8a6312f1c12e3799ecb7bace8aecc9bb | 0x1851a0762382a0013fca1abb1dd7c1e7e4c92169 | Mmusk | monad musk |
19 | 2025-02-20 04:02:13.000 | 0x2219324f7466a62026e97e1b652f73c6b7f85c9f69dbb041a5c3de9a43ce6cf3 | 31 | 0xb17a3cf0db9818e4e6c67da95afcc643b5bc2352 | 0x4ed4ab5103fa576873c5579e2713b3b9633b4343 | Milk | Milkmonad |
20 | 2025-02-20 03:29:49.000 | 0xb71acefee7346976c394adb26466287f7714177653b4de5603272b058a5b4d92 | 31 | 0xdd80e8d7c239ace32cc8f44ecaefff64df7571f4 | 0x648c7e2159a7eae99ea90e221dff54600067d371 | MOCHI | Mochi |
pepperatziTotal Tokens Created on Nad.Fun
Updated 24 minutes 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 raw AS (
SELECT
block_timestamp,
tx_hash,
topic_1,
topic_3,
regexp_substr_all(SUBSTR(data, 3), '.{64}') AS segmented
FROM monad.testnet.fact_event_logs
WHERE contract_address = '0x60216fb3285595f4643f9f7cddab842e799bd642'
AND topic_0 = '0x962c5f466b5c14a23d5aa7d7f1cd96153b1fd74124062d77ef00352a9812daf5'
),
almost as (
SELECT
block_timestamp,
tx_hash,
segmented,
'0x' || SUBSTR(topic_1, 27) AS creator,
DATEDIFF('day', block_timestamp, CURRENT_DATE()) AS created_interval,
'0x' || SUBSTR(topic_3, 27) AS Token_address,
CASE
WHEN livequery.utils.udf_hex_to_int(segmented[9]) <= POWER(10, 38) THEN livequery.utils.udf_hex_to_int(segmented[9]) * 2
ELSE NULL
END AS array_two,
CASE
WHEN livequery.utils.udf_hex_to_int(segmented[11]) <= POWER(10, 38) THEN livequery.utils.udf_hex_to_int(segmented[11]) * 2
ELSE NULL
END AS array_three
FROM raw;
)
select
block_timestamp,
tx_hash,
created_interval,
Last run: 24 minutes ago
...
5000
1015KB
10s