Uniswap Monthly New Users
Methodology:
To perform this dashboard I have used Flipside ethereum.core.ez_dex_swaps
table from the Ethereum scheme.
Date of new users onboarding is defined by min(block_timestamp)
statement within the all swaps in the ethereum.core.ez_dex_swaps
table pre-filtered by platform like 'uniswap%'
.
For further analysis I've pulled up the months of new users registration for past year and in case activity month was equal to first registration month - such user will be defined as 'New user'. Based on that in the next month such 'New user' from the previous month turns out to be 'Old user'.
Introduction:
The Uniswap protocol is a peer-to-peer1 system designed for exchanging cryptocurrencies (ERC-20 Tokens) on the Ethereum blockchain. The protocol is implemented as a set of persistent, non-upgradable smart contracts; designed to prioritize censorship resistance, security, self-custody, and to function without any trusted intermediaries who may selectively restrict access. Learn more
This dashboard tracks the activity of new Uniswap users during the past year. It offers a bunch of metrics such as volume, transactions, unique users by user type, new user breakdown by total volume, transactions and month using the DEX. In addition I've compared growth of Uniswap with Sushiswap(Ethereum blockchain) and Jupiter(Solana blockchain)