Introduction

In this dashboard, we'll look at the daily new active users on the ParaSwap protocol. This protocol is a DeFi aggregator on Ethereum that finds the best exchange rates across a number of decentralized exchanges such as Curve, Uniswap, Sushiswap etc. "New active users" is defined as the number of users that made their first transaction using ParaSwap on a given day. In this dashboard, we'll look at the last 2 months.

Methodology

1. find all Paraswap transactions using the ethereum_core.fact_event_logs table using thethe contract address of ParaSwap: 0xDEF171Fe48CF0115B1d80b88dc8eAB59176FEe57. This is the contract address for the Paraswap v5 Augustus Swapper.
2. select the date of the first transaction for each user of ParaSwap
3. filter for the last 2 months and count the number of distinct address that made their first transactions of a given date

Results

In the graph above, we can see the daily number of new active users over the last 2 months. We can see that was a slight downtrend in the number of new active users up until May 1st. Since May 1 the number of new daily active users that increased quite substantially compared to the last 2 months.