Axis DeFi Prix

Moon Metrics - Round 32 - All the Moon data collated and graphed

<table> <tr><td> <a href="https://www.reddit.com/r/CryptoCurrency/comments/yku081/moon_metrics_round_32_all_the_moon_data_collated/"> <img src="https://b.thumbs.redditmedia.com/L3D9Bwr7VkjpMaFsv5d95IER7Roskcmu_LnK75Fxeis.jpg" alt="Moon Metrics - Round 32 - All the Moon data collated and graphed" title="Moon Metrics - Round 32 - All the Moon data collated and graphed" /> </a> </td><td> <!-- SC_OFF --><div class="md"><p>I love spreadsheets, graphs, data and crypto. So I've collected all the data posted in the Moon distribution .CSV files, made some sense of it all in a spreadsheet, then made us some graphs.</p> <h1>Total Karma</h1> <p><a href="https://preview.redd.it/6f9lfi9xeox91.png?width=1413&format=png&auto=webp&s=04c155e0eb4ecf8beac341372ddae622de505e0f">https://preview.redd.it/6f9lfi9xeox91.png?width=1413&format=png&auto=webp&s=04c155e0eb4ecf8beac341372ddae622de505e0f</a></p> <p>The Sum of all the karma per round</p> <p>An 8% decrease since the last round.<br/> I've added the average BTC price for the 28 day Moon round to this graph as the total karma has seemed to move up and down in line with its price.<br/> I've done other analysis posts that show we get activity spikes when BTC fluctuates, with the most happening during dips as it seems that misery likes company.</p> <p>Seems like this is the new normal for activity. Who knows what shit will go down this round though.</p> <h1>The ratio of Moons to karma</h1> <p><a href="https://preview.redd.it/nwf62a52fox91.png?width=1413&format=png&auto=webp&s=4124407c258a9bf1f41849fb9a24b8de4708c648">https://preview.redd.it/nwf62a52fox91.png?width=1413&format=png&auto=webp&s=4124407c258a9bf1f41849fb9a24b8de4708c648</a></p> <p>The all important Moon to karma ratio. Multiply this number by your karma score to determine how many Moons you receive for each round. (Round 12 - 0.88 <a href="https://www.reddit.com/r/CryptoCurrency/comments/mvzv9v/anyone_remember_that_time_last_week_when_the_moon/">Never Forget</a>)</p> <p>This number will naturally decline over time as the Moons released per round reduce by 2.5%.<br/> Had to change the axis to a log scale as the early rounds being over 10 make it look like a straight line since round 8.</p> <h1>Number of users on .CSV</h1> <p><a href="https://preview.redd.it/5ydgmu2bfox91.png?width=1422&format=png&auto=webp&s=c7c27f0096429213868aa9373777beeb0b5d881a">https://preview.redd.it/5ydgmu2bfox91.png?width=1422&format=png&auto=webp&s=c7c27f0096429213868aa9373777beeb0b5d881a</a></p> <p>This shows the number of users who earned karma for each round. The lower orange line is users with an active vault at the time the .CSV was published.</p> <p>The number of users with vaults at the time of publishing the data overall averages around 57%. This doesn't indicate that only 57% of the users claim their Moons though as you have 6 months from the distribution to open your vault and claim them.</p> <h1>% of users with a vault</h1> <p><a href="https://preview.redd.it/vrxb7xoffox91.png?width=1394&format=png&auto=webp&s=95361794f6befea5bae691db2da2c7da0dff8c10">https://preview.redd.it/vrxb7xoffox91.png?width=1394&format=png&auto=webp&s=95361794f6befea5bae691db2da2c7da0dff8c10</a></p> <p>The spike from round 28 to 29 was caused by the implementation of CCIP 031 which removed vaultless users with less than 10 karma from the .csv<br/> The reddit avatar hype has kept it up around 90% since then.</p> <h1>Average Moons per user & Median Moons per user</h1> <p><a href="https://preview.redd.it/u772dkkhfox91.png?width=1428&format=png&auto=webp&s=5e50ce071c5889394e3a6c4167e4cb25857932cc">https://preview.redd.it/u772dkkhfox91.png?width=1428&format=png&auto=webp&s=5e50ce071c5889394e3a6c4167e4cb25857932cc</a></p> <p><a href="https://preview.redd.it/urgdi9hifox91.png?width=1428&format=png&auto=webp&s=59eb731ef70934b2603c3d3d4a23ebeb604d54b2">https://preview.redd.it/urgdi9hifox91.png?width=1428&format=png&auto=webp&s=59eb731ef70934b2603c3d3d4a23ebeb604d54b2</a></p> <p>The increase in average and median from round 28 to 29 was also caused by the implementation of CCIP 031.</p> <p>The average Moons earnt per user takes into account a lot of factors: number of users, Moon to karma ratio, the reduction in Moons being released per round and the total karma.<br/> I've finally got round to splitting this up and adding the median amount. The median Moons number is how many Moons the user halfway down the distribution list earned.</p> <h1>Moons Market Cap Rank</h1> <p>CoinGecko sorted their shit out recently and added the circulating supply figure so we can get a rank. I've been tracking it since.</p> <p><a href="https://preview.redd.it/5hq1djwmfox91.png?width=1993&format=png&auto=webp&s=d68eac388927d211340746e2885d298903a0d410">https://preview.redd.it/5hq1djwmfox91.png?width=1993&format=png&auto=webp&s=d68eac388927d211340746e2885d298903a0d410</a></p> <h1>Enough graphs, show me the spreadsheet</h1> <p><a href="https://preview.redd.it/uqh9ottrfox91.png?width=1061&format=png&auto=webp&s=7473f1ff7f7efbc4739c00845cd421e29a0b246f">https://preview.redd.it/uqh9ottrfox91.png?width=1061&format=png&auto=webp&s=7473f1ff7f7efbc4739c00845cd421e29a0b246f</a></p> <p><a href="https://preview.redd.it/bhxjysytfox91.png?width=1065&format=png&auto=webp&s=38f92d027b93e4493bc5f2b9bdfe1661061376e3">https://preview.redd.it/bhxjysytfox91.png?width=1065&format=png&auto=webp&s=38f92d027b93e4493bc5f2b9bdfe1661061376e3</a></p> <p>(The dates are a day ahead than most of you as I live in the future in UTC+12)</p> <p>Previous rounds are here:</p> <p><a href="https://www.reddit.com/r/CryptoCurrency/search/?q=%22moon%20metrics%20-%20round%22&restrict_sr=1&sr_nsfw=&sort=new">I've been posting these since Round 14 - You can find them here if you're bothered.</a></p> <p><strong>TL;DR Karma goes down, ratio goes down, 1 Moon = 1 Moon, I fucking love spreadsheets.</strong></p> </div><!-- SC_ON -->   submitted by   <a href="https://www.reddit.com/user/IHaventEvenGotADog"> /u/IHaventEvenGotADog </a> <br/> <span><a href="https://www.reddit.com/r/CryptoCurrency/comments/yku081/moon_metrics_round_32_all_the_moon_data_collated/">[link]</a></span>   <span><a href="https://www.reddit.com/r/CryptoCurrency/comments/yku081/moon_metrics_round_32_all_the_moon_data_collated/">[comments]</a></span> </td></tr></table>