Open Analytics Bounty: ETH (October 30)

    ==Introduction==

    Dogecoin (DOGE) is a peer-to-peer, open-source cryptocurrency. It is considered an altcoin and was launched in December 2013 with the image of a Shiba Inu dog as its logo. Dogecoin's blockchain has merit with its underlying technology derived from Litecoin. Notable features of Dogecoin, which uses a scrypt algorithm, are its low price and unlimited supply.

    Billionaire Elon Musk has been Dogecoin’s biggest supporter, and he has not been shy to say it. It was indeed the SpaceX CEO’s tweets that triggered the bull rally that saw the meme coin hit a high of $0.7 last year before starting its slow downtrend. However, even with the fact that Dogecoin has seemingly lost most of its gained value, Elon Musk has not relented on his support for Dogecoin and explained why he loves it in a recent podcast.

    According to Musk, he mainly likes Dogecoin due to the theme behind it. It is no secret that the meme culture around the cryptocurrency had played an important role in its meteoric rise back in 2021. It also happens to be Musk’s favorite thing about the cryptocurrency, explaining that it has “memes and dogs.” The dog part of this is just as prominent, given that Elon Musk himself has a Shiba Inu pet, which is the famous dog associated with the coin.

    ==Methodology==

    On Thursday, April 14th, Elon Musk announced an offer to buy Twitter for $54.20 a share. On April 25th, Twitter accepted the deal. By July 8th, Musk wanted out. Now, as of October 27th, the new owner of Twitter is Elon Musk. Dogecoin, the cryptocurrency branded after a viral dog meme from 2013, is up 35% since Monday as Elon Musk’s deal to buy Twitter approaches a close.

    Then, the main metrics to be analyzed are:

    • DOGE transfers and transferers by period
    • Transfered volume and average trasnfered volume over time
    • Distribution of transactions by size
    • Distribution of volume by size
    • Which are the most common UNI pools?
    • DOGE pools swap distribution by period
    • DOGE volume swapped by pool and period
    • DOGE price before and after event

    In the first graph we can see the transfers ver time of Doge. After Elon Mask buy we see that the transfers went up a lot.

    Secondly, we see the transfers volume and average transfer size by period. We can see that after the event, the transfers volume spiked radically but after a few days they returned to the initial values.

    Finally, we can see the number of users transfering by period. We can see that during August there were almost 160 users transfering. After that, it has been decreasing progressively but with some specific peaks. However, after the Elon Mask buy, the number of users spiked to all time high above 400 transfers in a day.

    In the first graph we can see the distribution of transactions by volume size per period. We can see that before the Elon Mask buy, the range where there were more transactions was between 1k and 10k. After the Elon Mask buy, the values have become more distributed. There are more transactions in the < $100 range. It increased considerably.

    We can see that the volume distribution of Doge by size and period has decreased after Elon Mask buy in the >$100k range. In contrast, the range between $10k and $100k has increased.

    In the last two graphs we can see the distribution of transactions by volume size over time. We can clearly see that after the event, transactions of >$100k plummeted, specifically on October 16, two days after the event. Consequently, the range between 10k and 100k increased quite a lot. Even so, after a few days, the values were quite similar to those before the event.

    ==Key insights==

    • After Elon Mask buy the transfers went up a lot.
    • the transfers volume spiked radically but after a few days they returned to the initial values.
    • after the Elon Mask buy, the number of users spiked to all time high above 400 transfers in a day.
    • the range between 10k and 100k increased quite a lot. After a few days, the values were quite similar to those before the event.
    • after Elon Musk buy, swaps are rising dramatically.
    • There are more transactions in the < $100 range. It increased considerably.
    • There are two pools that stand out above the others. They have gone from approximately 300 swaps to between 800 and 900 swaps.
    • the range between 10k and 100k increased quite a lot.
    Loading...
    Loading...
    Loading...
    Loading...
    Loading...
    Loading...
    Loading...
    Loading...
    Loading...
    Loading...
    Loading...
    db_img

    In the first graphs we can see the distribution of swaps by pool and period and their distribution. We see two pools that stand out above the others. We can see that after Elon Musk buy, swaps are rising dramatically. The two pools increase considerably. They have gone from approximately 300 swaps to between 800 and 900 swaps.