Data @viamirror
||
@DuneAnalytics 🧙 @KERNEL0x KB2 @OurNetwork__ Contributor
||
Follow me to learn how to work with Web3 data in SQL and Python 📊
1 added to My Authors
Mar 4 • 9 tweets • 6 min read
If you've been in defi for any amount of time, you should be familiar with two types of price oracles:
> off-chain aggregators like @chainlink
> on-chain like @Uniswap TWAP
It's time to compare them! 🧐
The repo and article on working with storage data are linked at the end.
On the surface level, ETH/USDC prices from storage look about the same across Chainlink, Uniswap V2, and Uniswap V3.
Feb 8 • 6 tweets • 5 min read
✨📊My inaugural guide to web3 data is here!
In it, I'll walk you through:
> how and why web3 vs web2 data thinking is different
> layers and players of the data landscape, and key communities
> 3 types of data roles with skills mapped out
ath.mirror.xyz/w2cxg5OP1OEcqv…
On thinking, you'll need to understand that open data now means "open data pipeline" rather than "here's some CSVs for u". This changes the flow of work and roles.
I walk through some technical examples of this flow, including a Uniswap proposal @alex_kroeger made last year!
Nov 24, 2021 • 17 tweets • 9 min read
1/17 You can learn a LOT about a community from just on-chain token data. I've split the data into three themes:
- trending user actions
- liquidity and inflation
- membership and inequality
Let's look at tokens from @blvkhvnd , @banklessDAO , @AxieInfinity , and @FWBtweets
2/17 Trending user actions: this tells us high-level how many people are entering/exiting a community, and how existing members act (accumulate or rotate/sell). Communities naturally go through cycles and turnover, below we'll see how each community has evolved.
Nov 17, 2021 • 8 tweets • 4 min read
🚨 DAO research op!
Question: How do we provide more context around tokens and their communities? Can this be represented by a "pulse"?
I dive into a framework for thinking about it and some research goals in the article, but here's a summary...
it tells me nothing about the token really, or the community around it. To really think deeply about this and what we should show, we need to examine web2 vs web3 communities again.