New Active Users
Show the number of new unique users (wallets) per day that transacted with ParaSwap over the past two months.
the above chart shows the number of new unique users transacted with ParaSwap over the past two months.
I found this amount from the udm_events table of the Ethereum schema.
I consider all transactions that from_label or to_label is paraswap
and count them per day.
The results show in the above chart. As you can see the number of new unique users that transacted with this platform is low. I think this table isn't complete and there aren't all transactions that are related to ParaSwap in this table.
ParaSwap is a popular aggregator that is active on 5 blockchains currently. So my results doesn't make sence.
So i should use another table.
I used ethereum_core.fact_transactions with the same method. that is mean find the previous address from fact_transactions of Ethereum_core schema.
This result unlike previous results are make sense. In average ParaSwap has 14K unique users per day.