CREATORS_RANGE | TOTAL_CREATOR | |
|---|---|---|
1 | 10-50 token Created | 1139 |
2 | >50 token Created | 62 |
3 | 1-5token Created | 48090 |
4 | 5-10 token Created | 3058 |
5 | 1 token Created | 224088 |
Monad Metrics GuildCreators Range
Updated 2025-02-26
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;
),
names as (
select
block_timestamp,
tx_hash,
created_interval,
Last run: 1 day ago
5
137B
15s