LittlerDataRonin RO monster world Eggs distribution
    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
    mob_name
    ,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 (
    select
    Last run: about 1 month ago
    MOB_NAME
    RARITY
    EGGS
    1
    Holden
    Epic
    56
    2
    Zherlthsh
    Legendary
    61
    3
    Sohee
    Epic
    2
    4
    Dracula
    Epic
    2
    5
    Greatest General
    Rare
    12
    6
    Poring
    Common
    18
    7
    Kiel-D-01
    Mythic
    4
    8
    King Alligator
    Legendary
    4
    9
    Deviruchi
    Epic
    1
    10
    Banshee
    Epic
    8
    11
    Steam Goblin
    Epic
    6
    12
    Stainer
    Common
    3
    13
    Leaf Cat
    Epic
    2
    14
    Orc Baby
    Rare
    4
    15
    Savage Babe
    Rare
    70
    16
    Yoyo
    Common
    16
    17
    Zenobia
    Mythic
    11
    18
    Whisper
    Epic
    1
    19
    Creamy
    Common
    1
    20
    Spore
    Common
    7
    31
    750B
    1s