TOP_DRILLHOUSE_MINTERS | NUMBER_OF_MINTS | COLLECTION | |
|---|---|---|---|
1 | 0x2a0543ecbb096a05746337d49b22ebd80caea0ce | 6970 | Drill Club |
2 | 0xfcd44a168d80ba62cd91dcc3e01ae35e4d5d253b | 9 | Drill Club |
3 | 0x7a21cd5ddabf43fabda13ec185383adfd4af0aee | 7 | Drill Club |
4 | 0x7952ddb4157e8d86ab9dfcf0af3a7a4543e91e2d | 5 | Drill Club |
5 | 0xe90c913bb1491ba0257ca62a7e8e805fd9e2d534 | 3 | Drill Club |
6 | 0xc35e07d4969052d57791efb786e4669c68cc305c | 2 | Drill Club |
7 | 0x9668c1d326b838fd8f9870f28ac83dcbd252e508 | 2 | Drill Club |
8 | 0xcb1331129b6f8fba6e77bbdca04502482bba9446 | 2 | Drill Club |
9 | 0x008c91798aac71fe3d529fdca1f3a085b76324c4 | 2 | Drill Club |
10 | 0x4076dc714ba8036974610f077a7a604989202e8e | 3 | Drill Club |
bobby_danielTop DrillHouse Minters
Updated 2025-04-02
99
1
2
3
4
5
6
7
8
9
10
11
12
13
›
⌄
SELECT
ORIGIN_FROM_ADDRESS as top_drillhouse_minters,
count (*) as number_of_mints,
-- 'Drill_Club' as nft_category,
case when origin_to_address = '{{Seiyans}}' then 'Seiyans'
when origin_to_address = '{{Drill_Club}}' then 'Drill Club'
end as Collection
-- concat('nft 2: ', Collection ) as Collection
FROM sei.core_evm.fact_event_logs
WHERE block_timestamp >= '2025-01-01'
AND origin_to_address='{{Drill_Club}}' and tx_status='SUCCESS'
group by all
qualify row_number() over (order by number_of_mints desc) <= 10
Last run: 2 months ago
10
624B
3s