steemmonstersdb.com Data
After launching steemmonstersdb.com I've been looking at all this data and I thought it would be fun to take a look at the drop rates of cards by rarity.
This data is all in my local MySQL database and is generated by parsing the custom_json operations on the @steemmonsters account. I still have a lot of work to do with the database, but I am pretty confident in the data I'm using for this report.
This looks at both starter decks and booster packs combined. I don't have an easy way to distiguish the type of pack because of how I've structured the tables but I'm considering completely refactoring this so I can get at this more easily.
I did a graph with all 4 rarities together, but the range is considerable so it's hard to see the changes so I'm posting each rarity separately.
There were a few transactions to start, but I'm starting from May 26, 2018 when the project was announced.
Common
The rate of commons has increased since launch, obviously because the others have become less common.
Rare
The rate of rares did drop on a pretty prounced line, which is to say the rares are more rare.
Epic
This was the most interesting thing I found. The rate of epics has actually gone up pretty considerably.
Legendary
And I realize there was a bonus for early adopters as the drop rate for legendaries was a bit higher, but I saw in Discord a few days that they were specifically planning to decrease the drop rate for legendaries, which we see here.
Lifetime Drop Rate
This data reflects the inital pulls from the packs, again both starters and boosters, and from all time, not just since the official launch. This does not reflect later combine actions, which is to say this is not a detailing of outstanding cards in the world. This data just reflects the cards as initially pulled from a pack to outline the drop rates by rarity.
| name | count | percent |
|---|---|---|
| Common | 159329 | 66.6% |
| Rare | 66921 | 28.0% |
| Epic | 10573 | 4.4% |
| Legendary | 2352 | 1.0% |
Summary
What do you think of this? Do you find data like this interesting? Can you think of anything else to look for in the data?
I can describe the world in SQL and I'm excited to keep building out this fun new datasource.