Work Portfolio

Uniswap v3: Trading Usage, Growth, and Competitive Analysis

Uniswap v3: Trading Usage, Growth, and Competitive Analysis

This Dashboard was a finalist winner in a Uniswap Grants dashboard competition. I took my experience in customer research and competitive analysis in the ecommerce space, and applied it to the decentralized crypto exchange market. This dashboard explores overall market share, share by pair, and it was my first attempt at aggregating pairs into trader use cases (i.e. bundling ETH/USDC, ETH/USDT, ETH/DAI into a ETH/USD grouping).

Gamma Strategies: Uniswap v3 Volume and Fees Collected Dashboard

Gamma Strategies: Uniswap v3 Volume and Fees Collected Dashboard

This was the first analysis I created for Gamma Strategies, an organization researching active liquidity management. This dashboard helped monitor Uniswap v3 activity and discover trading pairs that might be worth investing in. This dashboard quickly became the the most "favorited" Uniswap v3 dashboard on Dune Analytics, and within a few weeks became the top Uniswap dashboard overall.

Gamma Strategies: Uniswap v3 - Last 2 Days Trading Pair and LP Position Discovery

Gamma Strategies: Uniswap v3 - Last 2 Days Trading Pair and LP Position Discovery

No items found.

This was the second dashboard I created for Gamma Strategies. This aimed to 1) Speed up time to reaction by shortening the analysis window from trailing 7 days to trailing 2 days, and 2) Discover the most profitable distinct liquidity positions by pair, fee tier, tick range, time active, etc. Note that these distinct position fees are approximated, since we're using historical data versus in the moment activity, and transactions had to be aggregated in time blocks for query performance.

Yearn Finance: WOOFY Token Dashboard

Yearn Finance: WOOFY Token Dashboard

The one where I took a dog token too seriously. I quote tweeted a Yearn team member's WOOFY launch announcement saying "Actually maybe this is my next dashboard to make. I’m curious how many $WOOFY holders are/were $YFI holders, and how many are in it for the memes." A few likes and follows later, I decided to build this out.

Uniswap v3: v2 to v3 Ramp-Up

Uniswap v3: v2 to v3 Ramp-Up

This is where it all started. Read my blog post for context on how I learned crypto data, Uniswap data, and Dune Analytics by building this dashboard, and how it was my first signal of traction in this field.