Introduction

In this dashboard, we first display the total amount of deposit and withdraw by days from the beginning of 2022. Also, based on these two values, we calculate and display the total locked value for each day.
Then we will examine the prices in these two and display it separately by day.
Finally, we display the total amount of deposit and withdraw in the Squeeth project and calculate and display the locked total value locked(TVL) based on these two.

Method

We have collected the data for this report from the ethereum.core.fact_event_logs table.
for getting prices we refered to ethereum.core.fact_hourly_token_prices table.
the contract addressed also collected from Squeeth site:
we user EVENT_NAME field for category the deposit and withdraw amounts in fact_event_logs table and amounts for these two is obtained from event_inputs field from fact_event_logs table**.**
To calculate TVL, we have subtracted the total withdraw amount from the total deposit amount.

total value locked in the Opyn Squeeth By Days

in the next chart its visualized the total value locked in the Opyn Squeeth By Days.

blue color shows the deposits.
orange color shows the withdraw amounts.
and red color shows the total value locked.

total price in the Opyn Squeeth By Days

in the next chart its visualized the total price in the Opyn Squeeth By Days.

the prices are separated based on the type of event.

the total value locked in the Opyn Squeeth

in the last chart we are visualized the the total value locked in the Opyn Squeeth.

Conclusion

An important difference to other perpetual protocols is that there is no leverage on long positions. This means that it is impossible to be liquidated on a long squeeth position, and allows the long position to be a standard fungible ERC-20 token that can be traded separately (in Uniswap pools, for example, or as collateral for loans). This composability is a major advantage to the design, making it it easy to integrate squeeth into other projects.

Thank you for reading.

flipside