Open Analytics Bounty (October 29): Perpetual Protocol on Optimism
📑Background
What is Optimism?
- Optimism is a Layer 2 scaling solution for Ethereum. It helps reduce the transaction fee and transaction time on the Ethereum blockchain. Broadly speaking, Optimism helps solve Ethereum’s scalability dilemma. (Scalability refers to the rate of transactions per second (TPS) on a blockchain network.)
What is Perpetual Protocol?
-
Perpetual Protocol (PERP) is a software project that aims to create derivatives and financial tools to enable users to trade a variety of assets. The protocol is a decentralized exchange (DEX) that uses a derivative, which derives its value from another asset, called a perpetual contract.
\
-
Perpetual Protocol works similar to a centralized exchange. The main difference is instead of the exchange providing liquidity for the user's profits/losses, the money is collected in digital vaults that are ran by smart contracts and triggered every time a user wants to deposit and withdraw an asset.
👩💻Author
Gmail: ftmkhodabande@gmail.com
Tweeter: @busygirlcom
Discord: Jinx#6675
> Special thanks to my friend camp#4286

⚙️Method
In this dashboard, we are going to analyze the activity of Perpetual Protocol on Optimism.
Analysis date: 11/04/2022
Used tables:
optimism.core.fact_event_logs
optimism.core.fact_token_transfers
optimism.core.dim_contracts
Dashboard sections
- The overview of Perpetual Protocol contract
- Clearing house users and interactions
- Top Protocol Users
The clearing house protocol is not included in the first section of the dashboard.
The overview of Perpetual Protocol contract
-
The total interactions (events) of Perpetual protocol is 6.8M. Also, the average number of active users of Perpetual protocol per day is 373 users. Its total users are 50.1 thousand users. Also, the daily changes in the total interactions of the Perpetual protocol show that interactions have increased in the early days of May 2022, and May 11 is the best day of interactions, with 134,522k interactions. Also, since June 2022, interactions have decreased, and in October, these interactions had a sharp drop.
\
-
In the graph of the average daily active users, it can be seen that the number of active users has increased in the past few days, and the best day in terms of the number of users is November 2, with 1821 active users. In the graph, it can be seen that from September 20, 2022, the number of users is It has increased significantly. Also, in part of December 2021, the number of active users was high.
\
-
The graph of daily changes of new users has the same trend as the graph of the average active user, and it had its highest value on November 2, 2022, and the number of new users has increased since September 20.
\
-
In the donut chart "Top Perpetual Protocol Contracts by Active users." It can be seen that the following addresses are the top 3 addresses in order:
"0x82ac2ce43e33683c58be4cdc40975e73aa50f459" (15.7 percent)
"0xc84da6c8ec7a57cd10b939e79eaf9d2d17834e04" (15.7 percent)
"0xa7f3fc32043757039d5e13d790ee43edbcba8b7c" (15.6 percent) .
-
Also, Top Perpetual Protocol Contracts by Interactions are similar to the previous chart, and the top 3 addresses are in the same order.
Clearing house users and interactions
The chart "Daily changes: Perpetual Protocol Clearinghouse Interactions by Token" shows that on most days, most interactions of the clearinghouse are by the vUSD token. Also, the chart "Daily changes: Perpetual Protocol Clearinghouse users by Token" shows that the users of the clearinghouse were more active with vUSD and vETH tokens on a daily basis.
You can see the weekly changes in the area charts. As you can see, the largest area in both charts is related to vUSD, and it has the largest area in all weeks. The noteworthy point is the decrease in the area of vETH from the beginning of January onward in both charts. In the "Weekly changes: Perpetual Protocol Clearinghouse User by Token (Normalized)" graph, we see an increase in vETH in September.
In the donut chart, you can see the Top Perpetual Protocol Clearinghouse tokens (by Interactions). vUSD has 50% of the interactions among the top ones. vETH is next with 5.88%. In another donut, you can see Top Perpetual Protocol Clearinghouse tokens (by Users). vUSD has 41.5% in this chart, followed by vETH with 19.8%.
Top Protocol Users
The daily changes of top users (top 100 users) and normal users (other users) show that on most days, the interactions of top users are more than normal users. But on some days in December 2021 and the beginning of 2022, the number of interactions of normal users is more than that of top users. The most interactions between top users and Norma are on May 11, 2022.
The graph "Weekly changes: Perpetual Protocol Position Change Events by User Type (Normalized)" shows that the Position Change Events by User Type of top users were higher than normal users in most weeks. Only in the weeks of December 2021 were there more Position Change Events by User Type than normal users.
Also, the donut chart "Perpetual Protocol Position Change Events by User Type" shows that 83.6 percent of position change events are related to top users, and 16.4 percent are related to normal users.
All of the top 9 perpetual protocol users have over 160K position changes
The top 100 users make up 84.6% of all the activity on the platform
✍️Conclusion
- The total interactions (events) of Perpetual protocol is 6.8M. Also, the average number of active users of Perpetual protocol per day is 373 users. Its total users are 50.1 thousand users. May 11 is the best day for interactions, with 134,522k interactions. Also, since June 2022, interactions have decreased, and in October, these interactions had a sharp drop. The best day in terms of the number of users is November 2, with 1821 active users. The top 3 permanent protocol contracts by active users and interactions are the following contracts:
"0x82ac2ce43e33683c58be4cdc40975e73aa50f459"
"0xc84da6c8ec7a57cd10b939e79eaf9d2d17834e04"
"0xa7f3fc32043757039d5e13d790ee43edbcba8b7c"
- The Top Perpetual Protocol Clearinghouse chart (by Interactions) showed that vUSD had 50% of interactions among the top. VETH is next with 5.88%. The chart of Top Perpetual Protocol Clearinghouse tokens (by users) showed vUSD at 41.5%, followed by VETH at 19.8%.
- The top 100 users make up 84.6% of all the activity on the platform. All of the top 9 perpetual protocol users have over 160K position changes.