CryptoKitty Data Mining - Family Jewels Diamond Distribution
The recent addition of Family Jewels has gotten me super excited. I had some spare time so I decided to try my hand at data mining and to figure out what Jewels would be "rarest".
The first problem was actually getting the data. It's only available in the CryptoKitty API. I had to crawl the entire API and store the results in order to do my data analysis. For those developers; I used Docker Containers to spin up a MariaDB instance, RabbitMQ, and a php container. I created a Rabbit Queue and a Dead Letter Queue to hold the "kittyId" that I needed to fill my database. The API fails ... frequently so using The dead-letter Queue was an excellent solution so I could "retry" later.
Anyway I have a database with the entire contents of the API stored in JSON Format. The newer MySQL/MariaDB versions have wonderful JSON tools to extract data.
After countless hours of work I present to you the List of Diamond Cattribute Family Jewels as of Feb 15th.
Sorted by Most Common To Most Rare, these are the number of instances that a Diamond Family Jewel appears in the API.
| Cattribute | Count |
|---|---|
| gold | 19004 |
| tongue | 9569 |
| laperm | 8547 |
| raisedbrow | 7254 |
| ragdoll | 4973 |
| limegreen | 4510 |
| tigerpunk | 3506 |
| barkbrown | 3453 |
| sandalwood | 2185 |
| dali | 2153 |
| otaku | 2035 |
| cymric | 2007 |
| cottoncandy | 1550 |
| mauveover | 1512 |
| calicool | 1178 |
| gerbil | 1095 |
| fabulous | 596 |
| slyboots | 547 |
| bananacream | 442 |
| alien | 338 |
| hintomint | 295 |
| daffodil | 263 |
| whixtensions | 223 |
| belleblue | 223 |
| cloudwhite | 174 |
| hotrod | 171 |
| koala | 150 |
| nachocheez | 144 |
| emeraldgreen | 129 |
| verdigris | 126 |
| sapphire | 120 |
| thundergrey | 120 |
| wonky | 110 |
| scarlet | 104 |
| wasntme | 82 |
| mainecoon | 81 |
| bubblegum | 77 |
| sass | 72 |
| saycheese | 67 |
| violet | 66 |
| flamingo | 54 |
| apricot | 49 |
| birman | 49 |
| lilac | 48 |
| selkirk | 46 |
| ganado | 46 |
| bloodred | 46 |
| purplehaze | 44 |
| coralsunrise | 35 |
| seafoam | 35 |
| wingtips | 33 |
| skyblue | 31 |
| peach | 31 |
| morningglory | 25 |
| chartreux | 16 |
| wuvme | 13 |
| tiger | 13 |
| camo | 12 |
| grimace | 10 |
| spock | 8 |
| pumpkin | 8 |
| cerulian | 7 |
| royalblue | 6 |
| trioculus | 5 |
| savannah | 5 |
| googly | 5 |
| bobtail | 4 |
| wolfgrey | 4 |
| egyptiankohl | 4 |
| icy | 3 |
| starstruck | 3 |
| henna | 3 |
| manx | 2 |
| neckbeard | 2 |
| cheeky | 2 |
| norwegianforest | 1 |
| forgetmenot | 1 |
| twilightsparkle | 1 |
| yokel | 1 |
| elk | 1 |
| turtleback | 1 |
| onyx | 1 |
| chronic | 1 |
| azaleablush | 1 |
| spangled | 1 |
| stunned | 1 |
| grim | 1 |
| babypuke | 1 |
| serpent | 1 |
| amur | 1 |
| persian | 1 |
| oldlace | 1 |
| baddate | 1 |
Some of these results will likely come at no shock to you. However some are very very very interesting.
I have a ton of other data points to discover. If you have any suggestions please comment below! Also please follow me, upvote and resteem in order to support my work.
Here are some of my planned reports!
- Additional Tier Jewels (Gilded, Ama, Lapis)
- Broken down by Generation
- Generation Breakdown with Multiple Jewels
RarityScore based upon Rarity of Jewel
What really helps is ETH so I can test new theorys about how to make our kitties better!
Ethereum Address: 0xCECDDbE88359f6EcEBE90b42643B002543F27fE9
Nice work! If you wanted to profit using this, try to search for cats that have 3-4+ diamonds. There's probably a few shitcats priced at normal value right now that have it - buy them, advertise, and sell for higher =D
Yes! This would be a good strategy :) I need to do some more querying, I think there are a lot of kitties with multiple jewels but only time will tell!
You got a 20.29% upvote from @luckyvotes courtesy of @geggleto!