TOP_SEIYAN_MINTERS | NUMBER_OF_MINTS | COLLECTION | |
---|---|---|---|
1 | 0x5b389ef5ae5b2b50bf7e6823c74fd172b5a2ad68 | 3 | Seiyans |
2 | 0x0d51e1dfd0485a0d5268de117621c85dd071fd0b | 3 | Seiyans |
3 | 0x11fc243494b73ceded7b42f3de1e61f1bafbe3e6 | 3 | Seiyans |
4 | 0x351266474391090072e60cc9310530575bf4842a | 3 | Seiyans |
5 | 0xf5b5ed1b710709878ed3a41ab5896b9e5cc6f509 | 4 | Seiyans |
6 | 0xd1e18505d969a6043a3f828cf313eb23cd2284e7 | 3 | Seiyans |
7 | 0x2d874115a7304abce00da4501344cee534c1a1ee | 3 | Seiyans |
8 | 0xcb76cf6ee8dbc7b4fcd6b133882c08d271b24e37 | 3 | Seiyans |
9 | 0x4a28c3b3bf7caa66413347849b6e209a20c97e3a | 3 | Seiyans |
10 | 0x6b8e0ac52e0b7c696022ea28b72b05afbf2d8ab6 | 3 | Seiyans |
bobby_danielTop Seiyans Minters
Updated 2025-04-02
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
›
⌄
SELECT -- Number of mints -- Number of minters
ORIGIN_FROM_ADDRESS as top_seiyan_minters,
count (*) as number_of_mints,
--'Seiyans' as nft_category,
case when origin_to_address = lower('{{Seiyans}}') then 'Seiyans'
when origin_to_address = '{{Drill_Club}}' then 'Drill Club'
end as Collection
-- concat('nft 1: ', Collection ) as Collection
FROM sei.core_evm.fact_event_logs
WHERE block_timestamp >= '2025-01-01'
AND origin_to_address= lower('{{Seiyans}}') and tx_status='SUCCESS'
group by all
qualify row_number() over (order by number_of_mints desc) <= 10
Last run: about 2 months ago
10
591B
3s