Getting Your Feet Wet, Part 1

    Question 160: Make a table containing wallet addresses whose first transaction was 90 days ago or less. Analyze how active they have been since that first transaction, based on either 1) the number of transactions; 2) the number of protocols interacted with, or 3) the number of different types of transactions undertaken. (deposit, delegate, vote)

    Loading...

    Introduction

    There's 260k address that fall into this category and thus it'll be hard and nonsensical for a table to be presented :D. You can however, use the SQL that's present in this dashboard to extract these addresses if you really want to tho.

    Analysis

    • Number of Transactions Performed by this group of addresses
    • Number of Protocols these addresses interacted with
    • What did these addresses do?
    Loading...

    Distribution of Txs

    Newbies only contributed to 5% of all the transactions in the last 90 days. That's actually only a small group of transactions compared to the whole luna ecosystem.

    Protocol Interaction

    Visualized below, that 4.2m txs split into the different types of contracts that that interacted with. Anchor is the most popular follow by terraswap then astroport in third. This is not surprising they are the main protocols in the Luna Ecosystem. I've marked out some smart contracts as chainlink as they look like chainlink contracts, but am quite unsure myself.

    Loading...
    Loading...

    Conclusion

    Last but not least, we get a scatter chart of activity where you can see anchor (orange) activity on top followed by terrswap (purple) sort of in the middle. There's a bunch of arb_bot (red) transactions recently followed by 2 mints of Lottera Alpha cards (50k transaction on top of the chart).