10-07-2022, 12:43 PM
Moon Metrics - Round 31 - All the Moon data collated and graphed
<table> <tr><td> <a href="https://www.reddit.com/r/CryptoCurrency/comments/xxipxu/moon_metrics_round_31_all_the_moon_data_collated/"> <img src="https://b.thumbs.redditmedia.com/dWisRUyWChV4W6wUcNhVAiiVWJAJJzbqsoJsVTzoNiA.jpg" alt="Moon Metrics - Round 31 - All the Moon data collated and graphed" title="Moon Metrics - Round 31 - 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/1eqkxls4j9s91.png?width=1413&format=png&auto=webp&s=7f749eb8523cc48d57167d458996e419c3c15d33">https://preview.redd.it/1eqkxls4j9s91.png?width=1413&format=png&auto=webp&s=7f749eb8523cc48d57167d458996e419c3c15d33</a></p> <p>The Sum of all the karma per round</p> <p>A 6% increase 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/j8ucbmhdj9s91.png?width=1413&format=png&auto=webp&s=937149ef8ee1a1e8966416a3c5e933392a3665ff">https://preview.redd.it/j8ucbmhdj9s91.png?width=1413&format=png&auto=webp&s=937149ef8ee1a1e8966416a3c5e933392a3665ff</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%.</p> <h1>Number of users on .CSV</h1> <p><a href="https://preview.redd.it/z6r7iokej9s91.png?width=1422&format=png&auto=webp&s=4c05077ecbdcabe79735de460f2f1fee196a8f55">https://preview.redd.it/z6r7iokej9s91.png?width=1422&format=png&auto=webp&s=4c05077ecbdcabe79735de460f2f1fee196a8f55</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 56%. This doesn't indicate that only 56% 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/mnt1yywlj9s91.png?width=1394&format=png&auto=webp&s=a97e7c6192c19bcf3c1791ee0f42142de56f0a74">https://preview.redd.it/mnt1yywlj9s91.png?width=1394&format=png&auto=webp&s=a97e7c6192c19bcf3c1791ee0f42142de56f0a74</a></p> <h1>Average Moons per user & Median Moons per user</h1> <p><a href="https://preview.redd.it/iau5xepxj9s91.png?width=1428&format=png&auto=webp&s=28edd7d713fafed378ab21d7395d43f9a39fab10">https://preview.redd.it/iau5xepxj9s91.png?width=1428&format=png&auto=webp&s=28edd7d713fafed378ab21d7395d43f9a39fab10</a></p> <p><a href="https://preview.redd.it/4la2njuyj9s91.png?width=1428&format=png&auto=webp&s=3050afbb23137becaacb939f67e9c64ddc8c98bc">https://preview.redd.it/4la2njuyj9s91.png?width=1428&format=png&auto=webp&s=3050afbb23137becaacb939f67e9c64ddc8c98bc</a></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/hieqfauak9s91.png?width=1764&format=png&auto=webp&s=8a1b8c38f529a44d378ba6133f3a8bd2b92edf35">https://preview.redd.it/hieqfauak9s91.png?width=1764&format=png&auto=webp&s=8a1b8c38f529a44d378ba6133f3a8bd2b92edf35</a></p> <h1>Enough graphs, show me the spreadsheet</h1> <p><a href="https://preview.redd.it/p2onilmhk9s91.png?width=1065&format=png&auto=webp&s=aa2fed13c3a19c0e4787e783ee832df4f92610eb">https://preview.redd.it/p2onilmhk9s91.png?width=1065&format=png&auto=webp&s=aa2fed13c3a19c0e4787e783ee832df4f92610eb</a></p> <p><a href="https://preview.redd.it/3unxj9flk9s91.png?width=1066&format=png&auto=webp&s=e2f0038538ce9d77a166d2d6c1a738e8c21e7344">https://preview.redd.it/3unxj9flk9s91.png?width=1066&format=png&auto=webp&s=e2f0038538ce9d77a166d2d6c1a738e8c21e7344</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 up, 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/xxipxu/moon_metrics_round_31_all_the_moon_data_collated/">[link]</a></span> <span><a href="https://www.reddit.com/r/CryptoCurrency/comments/xxipxu/moon_metrics_round_31_all_the_moon_data_collated/">[comments]</a></span> </td></tr></table>
<table> <tr><td> <a href="https://www.reddit.com/r/CryptoCurrency/comments/xxipxu/moon_metrics_round_31_all_the_moon_data_collated/"> <img src="https://b.thumbs.redditmedia.com/dWisRUyWChV4W6wUcNhVAiiVWJAJJzbqsoJsVTzoNiA.jpg" alt="Moon Metrics - Round 31 - All the Moon data collated and graphed" title="Moon Metrics - Round 31 - 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/1eqkxls4j9s91.png?width=1413&format=png&auto=webp&s=7f749eb8523cc48d57167d458996e419c3c15d33">https://preview.redd.it/1eqkxls4j9s91.png?width=1413&format=png&auto=webp&s=7f749eb8523cc48d57167d458996e419c3c15d33</a></p> <p>The Sum of all the karma per round</p> <p>A 6% increase 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/j8ucbmhdj9s91.png?width=1413&format=png&auto=webp&s=937149ef8ee1a1e8966416a3c5e933392a3665ff">https://preview.redd.it/j8ucbmhdj9s91.png?width=1413&format=png&auto=webp&s=937149ef8ee1a1e8966416a3c5e933392a3665ff</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%.</p> <h1>Number of users on .CSV</h1> <p><a href="https://preview.redd.it/z6r7iokej9s91.png?width=1422&format=png&auto=webp&s=4c05077ecbdcabe79735de460f2f1fee196a8f55">https://preview.redd.it/z6r7iokej9s91.png?width=1422&format=png&auto=webp&s=4c05077ecbdcabe79735de460f2f1fee196a8f55</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 56%. This doesn't indicate that only 56% 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/mnt1yywlj9s91.png?width=1394&format=png&auto=webp&s=a97e7c6192c19bcf3c1791ee0f42142de56f0a74">https://preview.redd.it/mnt1yywlj9s91.png?width=1394&format=png&auto=webp&s=a97e7c6192c19bcf3c1791ee0f42142de56f0a74</a></p> <h1>Average Moons per user & Median Moons per user</h1> <p><a href="https://preview.redd.it/iau5xepxj9s91.png?width=1428&format=png&auto=webp&s=28edd7d713fafed378ab21d7395d43f9a39fab10">https://preview.redd.it/iau5xepxj9s91.png?width=1428&format=png&auto=webp&s=28edd7d713fafed378ab21d7395d43f9a39fab10</a></p> <p><a href="https://preview.redd.it/4la2njuyj9s91.png?width=1428&format=png&auto=webp&s=3050afbb23137becaacb939f67e9c64ddc8c98bc">https://preview.redd.it/4la2njuyj9s91.png?width=1428&format=png&auto=webp&s=3050afbb23137becaacb939f67e9c64ddc8c98bc</a></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/hieqfauak9s91.png?width=1764&format=png&auto=webp&s=8a1b8c38f529a44d378ba6133f3a8bd2b92edf35">https://preview.redd.it/hieqfauak9s91.png?width=1764&format=png&auto=webp&s=8a1b8c38f529a44d378ba6133f3a8bd2b92edf35</a></p> <h1>Enough graphs, show me the spreadsheet</h1> <p><a href="https://preview.redd.it/p2onilmhk9s91.png?width=1065&format=png&auto=webp&s=aa2fed13c3a19c0e4787e783ee832df4f92610eb">https://preview.redd.it/p2onilmhk9s91.png?width=1065&format=png&auto=webp&s=aa2fed13c3a19c0e4787e783ee832df4f92610eb</a></p> <p><a href="https://preview.redd.it/3unxj9flk9s91.png?width=1066&format=png&auto=webp&s=e2f0038538ce9d77a166d2d6c1a738e8c21e7344">https://preview.redd.it/3unxj9flk9s91.png?width=1066&format=png&auto=webp&s=e2f0038538ce9d77a166d2d6c1a738e8c21e7344</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 up, 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/xxipxu/moon_metrics_round_31_all_the_moon_data_collated/">[link]</a></span> <span><a href="https://www.reddit.com/r/CryptoCurrency/comments/xxipxu/moon_metrics_round_31_all_the_moon_data_collated/">[comments]</a></span> </td></tr></table>