MDAO 301 S3 Assignment

    Last assignment for the Web Analytics 301. This is regarding gas guzzlers and somewhat of an address profiler.

    Create a dashboard with the following content:

    1. Recreate the gas guzzlers dashboard on a 1 month time period. Essentially answering: which protocols did users spent the most tx fee on in the past 1 month?
    2. Trends about a specific user subset
      • define a user subset - e.g. recent buyers on opensea / high gas payers , etc
      • analyze behavior from those user subset - could be nfts bought or minted / tokens bought or sold
    Questions:
    Gas Guzzlers
    Loading...
    Loading...
    Loading...
    Loading...
    Loading...

    After recreating the Gas Guzzlers data from Ehterscan Gas Tracker, we found that uniswap: universal router and uniswap: router are the top 2 contracts users spends most transaction fees on in the last month. We can dig deeper by looking at what tokens were mostly swaped by users in uniswap and to further that by looking into the daily inflow and outflow of tokens by users in uniswap.

    User Trends
    Loading...
    Loading...
    Loading...

    We see the highest swap volume for the Sponge token followed by Wrapped Eth (WETH) and USDT in uniswap last month for the top 10 users by transaction fee spent. We can further our analysis by looking into their inflows and outflows and see what days they made the swap is it something significant or just regular swaps.