🔴Average Optimism Portfolio

In new reviews, we have calculated the average portfolio of each user. First, the number of tokens in the wallets is obtained, and then we find the price of each token on the desired day and calculate the value of the tokens based on dollars. After that, we average this amount for each day to determine the average value of each user's portfolio each day.

🔴Methodology

Using the fact_token_transfers table to get the number of tokens sent and received in wallets.

fact_hourly_token_prices table to get the price of each token per day.

PastDays parameter to get statistics based on the past ==7, 30, 60, 90, 180 and 365 days==.

Using the ez_nft_sales table to get the amount of NFTs bought and sold and its average per day.

fact_event_logs table to get Stake, Unstake and Liquidity Pools/Farms transactions.

🔴Average Optimism User’s Tokens

In a recent month, the most ==ETH== token transfer was on ==September 19, 2022==.

🔴User’s Activity in NFTs

The highest average price of buying and selling ==NFTs== is on ==September 14== with the amount of ==$307==.

🔴Stake & Unstake & Liquidity Pools/Farms

In the above diagram, the number of transactions related to Stake and Unstake and Liquidity Pools/Farms are specified. On some days, the number of transactions was high and on some days, it was low. The number of transactions related to Unstake is very low.

🔴Conclusion

As you can see, in the current bear market, the stake conditions on the Optimism network have increased.

In addition, the number of Unstakes has decreased in the last month.

A famous platform like QX, whose old name is Quixotic, has been doing well on the NFT market on the Optimism network.

They have a well-concentrated market for buying and selling NFTs on the Optimism network.

On September 19, the token transfer on the network with the ETH token was very high.

The popularity of Optimism network after Arbitrum network shows the popularity of both layer two networks.

Author: Amir

Twitter: @amir007_eth