flipside

    Ronin RO monster world Eggs distribution per minter
    LittlerDataRonin RO monster world Eggs distribution per minter
    Updated 2025-02-13

    with egg_mints as (
    select
    token_id
    ,mob_name
    ,rarity
    ,to_address
    ,block_timestamp
    ,hatchable_at
    ,nft_metadata
    ,tx_hash
    from $query('a2765482-cb7a-48f4-9019-ff091d53d30b')
    )

    select
    to_address
    ,rarity
    ,count(token_id) as eggs
    from egg_mints
    group by all
    /* select
    tx_hash
    ,block_timestamp
    ,to_address
    ,token_id
    ,concat ('https://ronin.metadata.ragmon.gg/0x89b84f8dd9be7ba6aafba802c6e4a7fc8be242ca/', token_id) as nft_metadata
    from ronin.nft.ez_nft_transfers
    where 1=1
    and contract_address= '0x89b84f8dd9be7ba6aafba802c6e4a7fc8be242ca'
    and IS_MINT = 'TRUE'
    and from_address = '0x0000000000000000000000000000000000000000'
    ),
    flatten as (
    Last run: about 1 month ago
    TO_ADDRESS
    RARITY
    EGGS
    1
    		0x7030e94c58358919dc6bea081d0f0a38bb554351
    Epic
    		1
    2
    		0x972644429d7edf235edcaca66804f2261639dadf
    Legendary
    		1
    3
    		0x0842e8c992a1a159e66d275d0ad2f8211c126ae4
    Epic
    		1
    4
    		0xeef78e53223f15623090341cac1774f0a092df54
    Epic
    		1
    5
    		0xb694659489e7bf789b069290cca35b4a22d80519
    Epic
    		1
    6
    		0x6c57044214e3b5efeeea74fb6dadda1c2f278c2e
    Rare
    		3
    7
    		0x43645599cf28a7b109e9c97f41dcd98fdde46fc9
    Rare
    		1
    8
    		0x192b1b2957d9f849de4de5bea1172f499a849f52
    Common
    		2
    9
    		0x6c57044214e3b5efeeea74fb6dadda1c2f278c2e
    Epic
    		1
    10
    		0x66a479e7bbd6aa26edde3b28b13166d0952246c8
    Epic
    		1
    11
    		0x29a0b292d65e6449e24a1ce699878ea6309fe308
    Common
    		11
    12
    		0xa9b950cad4aa0e9d5a8b95e04d3c79c473e4a17a
    Mythic
    		1
    13
    		0x539108375f7b12a7a93ad364bbcba746888138cb
    Epic
    		6
    14
    		0x545d3a9dd99df48b941bc8d8ac94079717c0a6ec
    Rare
    		1
    15
    		0x272a0f390a38870b4ac449c6f66181b62f6a06d5
    Rare
    		1
    16
    		0xc18f40b980b85c4ccd26a8101ecac79d6224f64e
    Epic
    		2
    17
    		0xc145d4a37f80750df65b998c87f51645129ef819
    Epic
    		27
    18
    		0xa9d2ddf57617d3478d304fe2f8f7e760392edc12
    Epic
    		4
    19
    		0xa9d2ddf57617d3478d304fe2f8f7e760392edc12
    Rare
    		4
    20
    		0x2382af696381b6d6853a061e83f8f22ba6dd9eed
    Rare
    		2
    76
    4KB
    1s