Owentell | Flipside Analyst

    Owentell

    Joined Jun 16, 2021
    //
    47Upvotes
    1. CRV Token Uses

    1. CRV Token Uses

    Sep 20, 2021 - The CRV token is a token created by Curve Finance, which allows for users to swap between different ERC-20 tokens and stablecoins. While the CRV token was created with the purpose of governance, as it can be locked to vote on protocols and earn a staking reward, owners of the token do other things with it as well. The main other use of the token looked at in this dashboard is to supply liquidity to liquidity pools, which earn the depositor rewards over time. One pool that people with the CRV token supply liquidity to is Uniswap's WETH/CRV V2 pool, which converts wrapped Ethereum to CRV and vice versa. The visualization below looks at the difference in deposits and withdrawals of the CRV token from this pool daily. The amount of withdrawals and deposits to this pool were much more volatile from around February to May of 2021, and have somewhat stabilized since, with less days with a large difference in withdrawal and deposit amounts. A second thing CRV holders do with their CRV is deposit it into Uniswap's USDN/CRV pool, which the second visualization in this dashboard looks at. The discrepancy between withdrawals and deposits into this pool is much less than that of the previous pool, with almost all data points being less than 50,000 USD, compared to many being over 1,000,000 USD in the WETH/CRV pool. Methodology: Data for the following visualizations was extracted from the ethereum.udm_events table. To find which pools CRV was deposited into, and how much, I filtered for transactions that had a contract_address equal to the CRV token's address, and then filtered by specific pools from Uniswap that had a large number of transactions. I then looked at if the CRV was coming in or out of the pool, and subtracted the amount withdrawn in USD from the amount deposited in USD by day.

    Owentell
    17. [Hard] Pool Depth

    17. [Hard] Pool Depth

    Nov 17, 2021 - This dashboard looks at the pool depth of the top 4 liquidity pools on THORChain by volume. THORChain is a protocol that allows for the swapping of assets from different blockchains. It does so through its native token RUNE. A user swaps their asset for RUNE, and then swaps that RUNE for their desired asset, for example swap BTC to RUNE and then RUNE to ETH. In this dashboard, the term 'pool depth' refers to the number of users providing liquidity at any given time. In general, the number of users providing liquidity to the top four pools has increased over time, especially in the BTC, THOR and ETH pools. The BTC and ETH pools, two of the first ones on the platform, follow a similar evolution over time, with a steady increase of users from April to July 2021. There is a gap in data for both of these charts from the middle of July to the end of September, most likely due to the multiple audits THORChain underwent in that time period. The BTC pool continues to generally increase in depositors, with a slight downturn at the end of October. One of THORChains most recent pools, the THOR pool, has steadily increased in the number of user depositing since its inception in November. It has almost quadrupled from a starting number of around 1000 depositors to almost 4000 depositors currently. The XRUNE pool is a bit of an exception as it has not increased much over time but has instead remained relatively stable, hovering around 1200 depositors.

    Owentell
    0. Art Blocks Predictive Analytics

    0. Art Blocks Predictive Analytics

    Sep 8, 2021 - To estimate which art blocks would have a resale in August 2021, I decided to look at the change in average sale price of a collection from June to July. I first found the average sale price of art blocks collections created before August 2021. I then calculated the average sale price of each collection in the month of June and then the average sale price of each collection in the month of July. I found the growth between these different averages and selected for a growth of over 1000%. The collections that fit this criteria were "Fidenza by Tyler Hobbs", "The Blocks of Art by Shvembldr", and "Space Debris [maider] by WhaleStreet x pxlq". I then found individual pieces in each collection that had not yet sold in July, despite the inflation in their collection, and selected these as the pieces most likely to have a resale in August. Unfortunately this method did not have great accuracy in predicting which Art Blocks would have a resale. For the Fidenza collection, 12.29% of the pieces predicted had a resale in August, 6.15% of the pieces predicted had a resale for the Blocks of Art collection, and 3.66% for the Space Debris Collection. Although the accuracy for the projected pieces actually being resold in August was very low, looking at the growth in average sale price of the collection does indeed provide some insight into predicting resale probability. The collection with the highest growth rate looked at here, Fidenza, had the highest accuracy, and the collection with the lowest growth rate, Space Debris, had the lowest accuracy. More research has to be done on the topic, but it seems growth rate could still be a predicator of resale, at the very least comparatively to other collections.

    Owentell
    84. Governance Participation

    84. Governance Participation

    Oct 13, 2021 - This dashboard looks at different metrics of governance in the Terra ecosystem. Governance is a system whereby the community can propose and vote on amendments to the Terra protocol. I first looked at the proposal side of governance, where members of the community propose new ideas which other members vote on. The top proposer had 8 different proposals, and the number dropped off sharply after, with the next highest proposer having only 4, and 6 of the top 10 only having 2 proposals each. The next thing I looked at was the average balance that these addresses had, to see if there was a correlation between the balance of a wallet and their number of proposals. Interestingly enough, the top proposer only had an average balance of about $300, which I would have thought would be higher. Although the second highest proposer, with 4 proposals, had the highest average balance of about 41.5 million. I hypothesized that those with the most proposals would have the highest balances, although this does not seem to be the case, with a mix of high and low balances in the top proposers. I next looked at the top 10 voters over the past six months and their average voting power. I hypothesized that those with the highest voting power would have the highest number of votes. The average voting power over the past six months over all Terra addresses was about 4,300, and all but two addresses had well above that number, which suggests those who have more voting power are more likely to vote on Terra governance proposals.

    Owentell