BLOCK_TIMESTAMP | TX_HASH | CREATED_INTERVAL | CREATOR | TOKEN_ADDRESS | SYMBOL | TOKEN_NAME | |
|---|---|---|---|---|---|---|---|
1 | 2025-02-20 03:13:03.000 | 0x5fe6f8934029a4840193e48ed7872a7a9da1f52b05dc6244b813f5a3f7a282c8 | 27 | 0xf2f5a52cb80f788bf9fac6b8259db1638383fae1 | 0x595baf29c34768c11ec306f11c6acdf7680a2176 | Dogesh | Dogesh |
2 | 2025-02-20 03:30:50.000 | 0x36bc6acdc0f84ecd931c87a5c8feb3eadcfd1dd26514d87195f2fe9305ebbd42 | 27 | 0x5bdd504d45136b2851a653e89be597c29e2c9921 | 0xaac93a7ec4a5d1c31c734c943c0480dec7346979 | BMO | BAMBOO |
3 | 2025-02-20 03:45:22.000 | 0x0be1729ed809bd155616c5e72fa5788b021437f4625f66ca2f5e5a1b3b9c4521 | 27 | 0x95acfaa595a402461cfce78b2e7d58dc62bea129 | 0xa408613aeb0f48a365e269c33cfbb0b0ec630fa2 | CRC | Crocodile |
4 | 2025-02-20 03:43:18.000 | 0x3b4167a216694c5a2ebec667b9ea775eac5cd7edbd908886db38f491b1e4ce52 | 27 | 0x4be049f5e64a82f17c5bcc34d7a0fc19ead53460 | 0x1dcfe2833fb0ea68d043d2c392977c2481b96d01 | SAN | SANTA01 |
5 | 2025-02-20 03:18:29.000 | 0xc717e103e364104fa4ee717be99d89953c8a500fbe674fbb022c716a7804f6ba | 27 | 0x9ce360b49c71a04c2eff87a683a8a490dee64339 | 0xe2f2192b92256fa370c97c6a67a9108c075544e3 | MikeWeb | MikeWeb |
6 | 2025-02-20 04:00:49.000 | 0xf5e2f0afc92cda1272fcbdb6c86c83ed6c13e87a20dc6835ac74064dd0a836c1 | 27 | 0xc770fa42897c87688fb9582908cf71d32cbf7a20 | 0xcf56d6b395f2c11f073583994a5bb10330cedb42 | Jdt | Jidatxl |
7 | 2025-02-20 03:40:54.000 | 0xdd113f015a6cf9c1a4b07e9533c508ad901612ae9b9df2064e93163686a4a665 | 27 | 0x82969cd3e1a9640ed0f23f2665a7aee6f632ce76 | 0xa8d1b350f4c0d0d43f1ef863d07db7f1e0227c6c | SAI | Saitama in MONAD |
8 | 2025-02-20 04:05:01.000 | 0x10a9a853b387f98f799523e65ca94137fe1e9bf9726b3deb1095f9292676b05f | 27 | 0x7eb49f0cb3bad0d627ab66e0ab6d2c2ea0958a14 | 0xf0e0793ee3ebe065128eabd63e572ea182ed52d9 | MONBALL | MONBALL |
9 | 2025-02-20 03:09:38.000 | 0x9be3e7a1c8f8faa66014c68fe2024d2fc41bd7d8fe8071c8ec1dc551a99b7d79 | 27 | 0xde3311c71cfaa8679478226641943c3346330de3 | 0xa3be9aa6fd49168c612707c974dea5d5ab382756 | ND | ND |
10 | 2025-02-20 03:52:29.000 | 0x098dac3d669d8f365c55e6124e7d6013feed7291c9617f0f7fbcd7b084f40db3 | 27 | 0x3f8bef4d96a4e080b8b37396c290c9d464b26985 | 0x9ad2c5fbff24ad53c33ba7c370f720ace7f90e6f | NoM | Nomad |
11 | 2025-02-20 03:52:33.000 | 0xdd93895cc58f3beccf5eceefb7d1b46d44095c96e485cfeb25cb5dd40ee4c9a4 | 27 | 0x3784e58976a011883e994e527554d5413aba0504 | 0x2f545359406175df784c0e6144a4b3d0cdb0104e | BNE | Bunne |
12 | 2025-02-20 03:16:44.000 | 0x54450d169a395a1ce0714d6c1764eb918bc9bc3482cdff83584bc60af5d7ed3b | 27 | 0x25e810496bd7a85ca7c35ed5456999196d7b1aac | 0xfdc6a20075bdbd5b6b395e13ef6f10620c82be5b | HU | WOW |
13 | 2025-02-20 03:30:56.000 | 0x4fa2475ee6da4478dee7743161fab27ac9bc947b6e06671fed24ad68f53bffb5 | 27 | 0x5441b9d3ac19cfd0ee63e73484f74190718bd4c5 | 0xba41c54efe6a26f9a690ca0fd873b537fd88ff2a | NotPepex | Not Pepex |
14 | 2025-02-20 03:26:35.000 | 0x543549a67b5ecbf62366d45ad8c34d47577f5b5d5a972c72e0e05682a77d42ff | 27 | 0xbe91272a81d4df40f5149fd3af4c35a6e9d1b2c4 | 0x79d2d330fee470ce5fedac8ad1acbdfac7215d3e | PHT | PIZZAHUT |
15 | 2025-02-20 04:03:56.000 | 0xdf532a54834fab92a07c467ecfad6d2e3e21e90a93ca46c6e48e20227484e14a | 27 | 0xf46e5f26925b4b1700c6b2c11498e7fc74bc7767 | 0xe68bcba200298525506472216153c83667d1bd2c | Sunset | Sunset |
16 | 2025-02-20 03:58:14.000 | 0x1094cd1a4195645fe9a657660fe10e351813d9d02ed25d2d9f858db0a4c17ff7 | 27 | 0x2afdd991c80f6c22c4d7ac5c1f8c65625b68f40b | 0xadbef9cf23f60a6e9464caccd76948f9f78518f7 | MNC | Monnadcoin |
17 | 2025-02-20 03:12:16.000 | 0x04ee7ca185e139fb76fa89b93abd01c4a0dd0d8b80a058876873b194627dacbd | 27 | 0x5edc811ab8929e56b376a1e411a30be8ab0db205 | 0x26b07a44c9996208b949763ff1753d0e3acafdc7 | NTH | NOTHING |
18 | 2025-02-20 04:05:13.000 | 0x280e1d169b084c5c4aa0cba17d0e8485696188db65e5c332275ccafb79c7efdc | 27 | 0x6ca546ce11883b5217386564409334ed2e1059f3 | 0x9e65c76e0598143557886a43378d5ed69bb422f3 | Brhn | Burhan |
19 | 2025-02-20 03:25:06.000 | 0x42516fef79a62e442bd31ec83448fcc2acec68640543c7111eefcdfd8fd5475d | 27 | 0xbea14789ca19b601a014724be4fc01b42d1755c8 | 0xa14726879266ed7e5df8f12e72de94f22bd8632e | BCal | BCal |
20 | 2025-02-20 03:20:16.000 | 0x0d24dd35f78fb57d106ab175230087a88b6b29c1375d4554001efee51039a984 | 27 | 0x571febf680a9fd637a9ae76587427bcef048f5e0 | 0x43c487667fda22fd500f9647db52c9b57fdf8009 | Cote | Coffee or tea |
pepperatziTotal Tokens Created on Nad.Fun
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 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: 1 day ago
...
5000
1016KB
20s