Q1. Show the number of new unique users (wallets) per day that transacted with ParaSwap over the past two months.

Goal:

discussion about the number of unique users transacted with ParaSwap.

Solution:

To answer this question, I used ethereum_core.fact_transactions table.

we need to find all transaction related to ParaSwap. the ParaSwap contract address is 0xdef171fe48cf0115b1d80b88dc8eab59176fee57 so to_address = '0xdef171fe48cf0115b1d80b88dc8eab59176fee57' and count distinct from_address.

According to the above chart, the number of active users that transacted with ParaSwap is growing over the past two months. The peak of that is on May 9th with 423 unique users.

It looks like this amount is low. I think it is related to this issue that the crypto community is hostile to them because of the way they share their airdrop.