bobby_danielTop Seiyans Minters
    Updated 2025-04-02
    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
    TOP_SEIYAN_MINTERS
    NUMBER_OF_MINTS
    COLLECTION
    1
    0x5b389ef5ae5b2b50bf7e6823c74fd172b5a2ad683Seiyans
    2
    0x0d51e1dfd0485a0d5268de117621c85dd071fd0b3Seiyans
    3
    0x11fc243494b73ceded7b42f3de1e61f1bafbe3e63Seiyans
    4
    0x351266474391090072e60cc9310530575bf4842a3Seiyans
    5
    0xf5b5ed1b710709878ed3a41ab5896b9e5cc6f5094Seiyans
    6
    0xd1e18505d969a6043a3f828cf313eb23cd2284e73Seiyans
    7
    0x2d874115a7304abce00da4501344cee534c1a1ee3Seiyans
    8
    0xcb76cf6ee8dbc7b4fcd6b133882c08d271b24e373Seiyans
    9
    0x4a28c3b3bf7caa66413347849b6e209a20c97e3a3Seiyans
    10
    0x6b8e0ac52e0b7c696022ea28b72b05afbf2d8ab63Seiyans
    10
    591B
    3s