BLOCK_TIMESTAMP | TX_HASH | CREATED_INTERVAL | CREATOR | TOKEN_ADDRESS | SYMBOL | TOKEN_NAME | |
|---|---|---|---|---|---|---|---|
1 | 2025-02-20 02:38:40.000 | 0x640eb66934ab289e75f144db2f3c233a65b658a5f17a1931dcc8e83f2f1f9eeb | 33 | 0x7eddece55ecb3e70510c7be974bb0ecbfb77cefc | 0xe2b0632d1bf396fcb1dcd8efa14ced6078d603f4 | milei | LIBRA |
2 | 2025-02-20 02:49:23.000 | 0x807891402b17285a57adbea4e86f061ecfe1eab021e48a269d41633627d6f8ef | 33 | 0x917fa1d1da4934d1b70b4a15c4581c5bee097e55 | 0x0d2ba4cf389e2f9fde3ba832c4fe11b7cff44e25 | 2279087 | 721288 |
3 | 2025-02-20 02:08:46.000 | 0x2a05d3a44938d6154502bdef758bf779ba9be2e79449492f8f58ffee5bd67d11 | 33 | 0x0ef6cb38f2e3d82d820d886459588d6194f41326 | 0xb9a1e08b0fb86c469d234de01e22138b934d5414 | moon | nhutne99 |
4 | 2025-02-20 02:10:57.000 | 0x667f68da721b0766696ec7e24bf5563c6d7c63f720f82acfd544bb198589d47f | 33 | 0x150d38acd337b9e2ea51d25b8a09982a67372792 | 0x5652dcf7766e57f2e1018a93ec18ac6c74196382 | 123 | thienlong |
5 | 2025-02-20 02:51:48.000 | 0xc2b0c823c8374b0d1fd970f81aa3d9aca2807df17650b4b749914a794948b543 | 33 | 0x89ce434ddee8b44162537f3dba6afd749b755ae9 | 0x690805c9c5a1b6af38f8028dcbf40b58275096df | Bazz | Bazz |
6 | 2025-02-20 02:55:56.000 | 0x718fc4555fdd6482bd6e0f02ee79a5c8943a38e03e45a6b2d6f675a5cb1edb81 | 33 | 0x88d14eb9de4d6d2c6985cc72a202235f534f7415 | 0xe96fac628b32767601e22e77fb8bc49c31998054 | Hon | keone |
7 | 2025-02-20 02:58:04.000 | 0x121e9d04f24598fcf96dad8e422e012b8fbe7628a702425f8bca63bb8bf934e0 | 33 | 0xca2d1bd26e01a128f1a612689acda2155bdcda8f | 0x7fc07d4196c7a3e9642e39b4b52f576e4dd2a5d1 | MO | Man Old |
8 | 2025-02-20 02:25:45.000 | 0x072f20faa14ca597dd4b180edefe0030d4ce0c66338f20562a67edbff796a278 | 33 | 0x27a607908219881ec742bd3f80c7cb015ee6178e | 0xc9ef87d57550a5c95bd71f3ffda738ce6786b6ec | Grasicale | Grasicale |
9 | 2025-02-20 02:51:36.000 | 0x7a5d41d8dee91e944f53cbcf24595f37f382041ff76ceaa09b7229f89253c092 | 33 | 0xbddb27022379808ddfe70a3750f0017b91f529e1 | 0xc0701e036c532b84052f968cc44216b4692f92bf | W | Waiwa |
10 | 2025-02-20 02:37:07.000 | 0xeef2c68344b3453856af302ae5e6aa369fe5182608d0fefbe17faaec8a65a287 | 33 | 0xc84e7b106df1ee944887fa95e601cbdc11de91ac | 0xdd6b15eb959afecaae73ba437533209dd3b27465 | Meri | Teri |
11 | 2025-02-20 02:19:56.000 | 0xba019fbc5980fd828140d0f16568fedc0079459182a61daa69ec3d9f559a6c68 | 33 | 0x25369343846e3626ba2bfbc31073a65ea023b73a | 0x4e80e36ecac1a429477bac2240c85fc9e3f70f6d | MC | MeowCoin |
12 | 2025-02-20 02:42:02.000 | 0xc8db203247e48b41e05169477d85e8c17bc443b1bdeaef324b6ad4d89874addf | 33 | 0x6487c146c88e216a7d794ec8685bda5e04d9158b | 0x3808f06f0a4faa50db7993a359a54ed169dafa72 | pandagaul | pandagaul |
13 | 2025-02-20 02:15:57.000 | 0xec5ff8197227936a68ca98a10146d1df9d640a506786f7c588d2fb1fbfe30b84 | 33 | 0x47384d69f8ce440e4cbc2afb26f696059cb0c66b | 0xc743b7aa47f882053e74c759a6db683289dd8255 | Pawpaw | Mad Paws |
14 | 2025-02-20 02:14:19.000 | 0x760ac7427f0e8715d00e87cca04b1c673ab01969585d9b439f91de29486ed7ea | 33 | 0xe0b2a3ba907fdc8bfec3ce7fa4cac7651743cab9 | 0xcebe0480cd9706ed2f3821aad575119358031987 | JLY | Jelly |
15 | 2025-02-20 02:59:01.000 | 0x0a18cbeaf7ce8bd1c415a28aff4e64ea29e25aa9bb4f1c574edcd49ee3912f1d | 33 | 0xe725e84deefb9312f45776ee4edca645ef50f27e | 0x18a3506f386d7139142c98a3bcd1e937c6e0925c | SLS | sales |
16 | 2025-02-09 04:12:02.000 | 0xb10a3b3bd4b3bcf87e40c82e0d14ad32611093f4da9d667645602c561aa89167 | 44 | 0x7fe0bce62b95b22eb6335b2dac3b4e5a2f6f034e | 0x129bbb99a409e52d5018fbf33044b90efde4793c | TEST | TEST |
17 | 2025-02-09 07:43:58.000 | 0x4e43d0d4c7f41abe1f3dcb4ed032c5dcfc5220c63480723dd5233ad1bfc17244 | 44 | 0x7fe0bce62b95b22eb6335b2dac3b4e5a2f6f034e | 0xb0cd80162efafa127aa40a3138d6c381733c47d3 | TEST2 | TEST2 |
18 | 2025-02-09 15:30:43.000 | 0x24d1d7f4edee848c3cc2e9f9512cdafffc1c15d0f4db6f3d848c928cd47c53f5 | 44 | 0x7fe0bce62b95b22eb6335b2dac3b4e5a2f6f034e | 0x8b0f4a27bd8cf4d0ca4a5b494678b7dc7ad093bb | TEST4 | TEST4 |
19 | 2025-02-10 07:44:51.000 | 0xbb57952e8ed6217dffb607badd46f3c0b00a7fa7dbe5d47e4f430f1183ebfdc1 | 43 | 0x026d161501cde95ee129acba1caf20eccc64440a | 0x0bd0c0dd62c59c255a8d0b33a18ec911d7905dc5 | BENAD | BENAD |
20 | 2025-02-10 08:39:12.000 | 0x93ef0c0998ca160353a7b8905a00d252a5cb039a091dd8e15775cd2edb2ca29a | 43 | 0x026d161501cde95ee129acba1caf20eccc64440a | 0x96154033ce799d27c14ed43b62ef308aef16ee9f | HAT | HAT |
pepperatziTotal Tokens Created on Nad.Fun
Updated 3 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 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: about 3 hours ago
...
5000
1015KB
4s