Welcome back to our Uniswap data dashboards of the week! Each week, we turn people’s data questions into crypto bounties for data analysts to solve.
In this edition, we’ve got two terrific Uniswap dashboards to show off. That includes a grand-prize winning submission from @njholman79 and @AD14367367.
See more Uniswap data
First up is a bounty from @njholman79. This submission sought to identify all active positions from all LPs for a given pool. To do so, @njholman79 created a recursive table that allowed him to view all available price ticks. There was a catch, however — the feature only allows up to 100 recursions. So, our bounty hunter focused on the USDC-WETH 1% pool, as 1% pools have wider price ticks.
So what did @njholman79 find? As we can see below, there are relatively few liquidity providers at the current price. Instead, these LPs tend to provide liquidity at lower price ticks. The submission also found that there seems to be a lag when it comes to LPs reacting to price movements, which could explain that pattern.
Uniswap TVL drops, then rises to new high
Next up is a look at Uniswap TVL and pools from @AD14367367. This submission looked to identify the week-over-week change in TVL for Uniswap in total and in the top 5 pools specifically. As we can see in the charts below, overall TVL dropped in late June, then again in early July. However, as July turned into August, TVL was on the rise, hitting a new high at the start of the new month.
Patterns were largely similar among the top pools on the platform. According to @AD14367367, TVL for the top five pools also dropped beginning in mid-June before beginning to rise roughly a month later. Overall, the USDC-ETH (0.5%) pool experienced the greatest percentage growth. In contrast, the BTC-ETH pool experienced some of the largest percentage decreases.
See more Uniswap data
That does it for this week. Thanks to everyone who submitted such great Uniswap data dashboards!Want to get more involved with Flipside’s community and see your own submissions on our blog? Then make sure to join us on Discord, follow on Twitter, and subscribe to our newsletter, the Bounty Brief.