DIAMOND_HAND_ADDRESS | FIRST_MINT_TIME | TOTAL_MINTED | STATUS | |
|---|---|---|---|---|
1 | 0x003dcddfbe9a2efb3221cc5df649ca733bf381d5 | 2025-02-20 13:00:52.000 | 1 | Never transferred or sold |
2 | 0x450f9660bfdbc8f759a70dd36416ba324fa8d9cb | 2025-02-20 13:01:02.000 | 1 | Never transferred or sold |
3 | 0x3f884d5e794672a1f38fac4bfb771d309453ceb6 | 2025-02-20 13:01:28.000 | 1 | Never transferred or sold |
4 | 0xa67c88823ff68946c9cfb090e7dd2dbc9a44ac88 | 2025-02-20 13:01:34.000 | 1 | Never transferred or sold |
5 | 0xb63813f1fc109922e1e3eb71bcaa0a19464ed0c2 | 2025-02-20 13:01:40.000 | 1 | Never transferred or sold |
6 | 0x3b701f7be10475b2844ce869f8bf4b797a8a20c2 | 2025-02-20 13:01:41.000 | 1 | Never transferred or sold |
7 | 0x858817885f4dd1de034d2cc7b9fcf1e87899d109 | 2025-02-20 13:01:45.000 | 1 | Never transferred or sold |
8 | 0x5abddab6631e8fe70f41887d3322a26605c7afd3 | 2025-02-20 13:01:50.000 | 1 | Never transferred or sold |
9 | 0x5cf5ffd9f025e952dba66e9b8058999a0c1fa592 | 2025-02-20 13:01:50.000 | 1 | Never transferred or sold |
10 | 0x6dac46648f7c2e75f373e1fcb0b50c7268ac55ad | 2025-02-20 13:01:52.000 | 1 | Never transferred or sold |
11 | 0xabfd11af14cad1f6f50e5a17ba64cf2b0d50359e | 2025-02-20 13:02:13.000 | 1 | Never transferred or sold |
12 | 0xa5ed9ba79bb481fad4a6361a3bf98dcdf5daa9f5 | 2025-02-20 13:02:22.000 | 1 | Never transferred or sold |
13 | 0x9ab655081484dcf02b92a9214643d30b0bee04b8 | 2025-02-20 13:02:25.000 | 1 | Never transferred or sold |
14 | 0xd7ade327695d06a1d34f8eee0b7d0dd61d6741fe | 2025-02-20 13:02:27.000 | 1 | Never transferred or sold |
15 | 0x68f501d53b2afd52d21ac2dcc7aff561daba27d0 | 2025-02-20 13:02:36.000 | 1 | Never transferred or sold |
16 | 0x5f280ce86b55a3d5b76676f8df28109f3932350a | 2025-02-20 13:02:43.000 | 1 | Never transferred or sold |
17 | 0x0c2207ccd7a3cc54af31d9009bc29b9dba1b3bcd | 2025-02-20 13:02:54.000 | 1 | Never transferred or sold |
18 | 0x843e7e963f5d6928ee9730f2fa4bc2b16b7401a9 | 2025-02-20 13:03:22.000 | 1 | Never transferred or sold |
19 | 0x6addabf896fd9a622f3a6bd4d1f10d68393f8597 | 2025-02-20 13:03:24.000 | 1 | Never transferred or sold |
20 | 0x1d50a30b21fcf6c0d8bd800375ff263a9e1ea66a | 2025-02-20 13:03:26.000 | 1 | Never transferred or sold |
ravelslmnd
Updated 2025-03-07
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 MintEvents AS (
SELECT
el.block_timestamp,
el.tx_hash,
el.contract_address,
el.topic_0,
'0x' || SUBSTR(el.topics[1], 27) AS operator,
'0x' || SUBSTR(el.topics[2], 27) AS from_address,
'0x' || SUBSTR(el.topics[3], 27) AS to_address,
utils.udf_hex_to_int(SUBSTR(el.data, 3)) AS amount
FROM monad.testnet.fact_event_logs el
WHERE el.contract_address = LOWER('0xF7B984C089534Ff656097e8c6838b04C5652c947')
AND el.topic_0 IN (
'0xc3d58168c5ae7397731d063d5bbf3d657854427343f4c083240f7aacaa2d0f62', -- TransferSingle
'0x4a39dc06d4c0dbc64b70af90fd698a233a518aa5d07e595d983b8c0526c8f7fb' -- TransferBatch
)
),
-- Get all initial minters (to_address where from_address is zero address)
InitialMinters AS (
SELECT DISTINCT
to_address as holder,
MIN(block_timestamp) as first_mint_time,
SUM(amount) as total_minted
FROM MintEvents
WHERE from_address = '0x0000000000000000000000000000000000000000'
GROUP BY to_address
),
-- Get all addresses that have transferred tokens (excluding mints)
Sellers AS (
SELECT DISTINCT from_address
FROM MintEvents
WHERE from_address != '0x0000000000000000000000000000000000000000'
),
Last run: about 2 months ago
...
2983
300KB
11s