Definitions

Before we begin, we have to define two concepts: 'a new user' and what it means to interact with a protocol.

• New users

We define a 'new user' as a wallet that made its first transaction in the last 90 days.

• Interaction

A user has made interaction with a protocol if the user has made at least one transaction using one of the smart contracts of the protocol.

Methodology

To produce the graphs below, the following methodology was used. First, we had to find all the wallets that made their first transaction in the last 90 days. For this, the terra.transactions table was used. This table has a separate column for the transaction initiator, which makes it easy to find all the transactions by users. Then, min(block_timestamp) was used to get the first transaction. In combination with a where that limits the first transaction to the last 90 days, we were able to find all wallets whose first transaction was 90 days ago or less.

Next, we need to find out how many of these new used made at least one transaction with the following protocols: Anchor, Mirror, Pylon, Astroport, Terraswap, Prism and Mars. To find this, we look at the receiving address of transactions in the terra.transactions table. Each protocol has multiple smart contracts associated with it. To find all contracts, the Extraterrastrial Finder was used. (For example, this is the list for Anchor) Then, a web scraper was used to extract all smart contracts for each of the seven platforms. If a user has a transaction where the receiving address is one of the smart contracts of the platform, the user has interacted with the platform.

Conclusion

• About 323k wallets made their first transaction in the last 90 days. These are the 'new users'.
• Of the new users, about 19% has not made a transaction with the following protocols: Anchor, Mirror, Pylon, Astroport, Terraswap, Prism and Mars.
• The new protocols, Prism and Mars, has not been interacted with by many new users. Only 1.47% and 2.17% respectively. Interestingly, Mars has been interacted with slightly than Prism even though Mars is newer.
• Anchor is the protocol where the most new users made at least one transaction, followed by Terraswap. New users had the least interaction with the Pylon protocol.