\

/User Behavior (redux)\

\n

✍️ Description of Work

• Fee - day-week

• Number of wallet - Day-week

• Number of transaction -day-week

• Swap volume -day-week

• Number of new user

• Frist Top swapper

• second Top swapper

• Third Top swapper

• Fourth top swapprt

• Fifth Top swapper

• Sixth Top swapper

  \n

🧠 Methodology

Fee and number of wallet and number of transaction

from optimism.core.fact_transactions a
join table_1 b on a.block_timestamp::date = b.date

Swap

from ethereum.sushi.ez_swaps

New user \n from ethereum.core.fact_transactions where year(block_timestamp::date) =2022 and month (block_timestamp::date) > 4 group by 2

• according the fee chart we can see both of them op and ETH are decreasing the over time. jun15 until jun 20 the op fee fee reached its lowest level between these two dates, so that jul11 has reached its lowest level, which is 475.

• The number of wallet of ETH is very more then OP .the number of op wallet increasing until jun1 ,So that it reached its highest number on June 1 the number of wallet is 106.033k and after that decrease over time.

  the number ETH wallet increasing until jul26 which is this time the reach its highest number , the number is 961.1961k.

• the number of transaction of ETH is more than op .The number of transaction of ETH slowly decreasing over time But number op transactions are not decreasing in an almost constant range and it increases from time to time.

• The swap volume of ETH is more than op but the swap volume of ETH decreasing but op increasing over time

conclusion

According to the charts above, the number of transactions, fees, swap volume, number of users and in all fields, ETH is more than OP.

And in some graphs that we saw, some parameters were decreasing in ETH, but increasing in op