Uniswap Data Dashboards: See The Best of The Bunch

Uniswap Data Dashboards: See The Best of The Bunch

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 a total of three Uniswap bounties to show off. That includes queries on liquidity frequency, average liquidity, and WETH-USDT pools. 

Let’s get started.
 

LPs increase positions as markets fall

We’ll kick it off with a bounty from @BrianMe32966537, who examined liquidity frequency. Specifically, this submission looked at the total number of times distinct wallets increased and decreased liquidity over the past seven days. 

As we can see in the graphs below, there were some significant changes on June 15. These changes saw LPs increase their positions as the effects of tumbling crypto markets began to be felt. Overall, however, liquidity frequency remains fairly consistent, @BrianMe32966537 said.

Uniswap liquidity peaks

Next up is @visavishesh, who took a look at average liquidity between WETH and USDT on the Uniswap network.

As we can see in the submission, roughly $3-85 million liquidity was added to the WETH-USDT pools per day from June 15 to June 21, while roughly $5-83 million was removed. Once again, activity peaked on June 17, with more than $80 million was added and removed as markets began their downward spiral. 

As the submission showed a near net-zero amount of liquidity was added and removed. A net negative amount, meanwhile, was removed from the .05% pool, while a net positive amount of 1% was added to the 1% pool

The biggest WETH-USDT position

Finally, we have @danmdoherty with a look at the most WETH owed to a given position in the WETH-USDT pool.

Dan’s submission found that, as of June 18, 2021, there is one position in the main WETH-USDT pool that’s owed more WETH than any other. According to the findings, NFT ID21520, at more than 2.5 WETH, is owed more than the next four positions combined, as can be seen below.

@danmdoherty also provided a great step-by-step tutorial for completing SQL queries in submission. Check it out here!
 

Get involved

That does it for this week. Thanks to everyone who submitted such great Uniswap data dashboards

Want to get more involved with Flipside’s incredible 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.

Unsubscribe
207 South Street, 5th Floor, Boston, MA 02111