🐱‍👤 Methods

The approximate time to read this dashboard is 10 minutes.
During this dashboard, you will get to know the status of the ref platform during the last two weeks and you will learn good tips about this platform. The number of users, the number of transactions, and the amount of money transferred is one of the most important data of a platform or network, which is included in the analysis, and I used to get them from the table near.core.fact_transfers and the addresses of the ref platform, which include ' v2.ref-finance.near ' and ' ref-finance.near ' I have used it.
I have displayed the successful and failed transactions in the last two weeks in two different tables where you can see the number of transactions, the number of users and the volume between the two.
Another measure I checked is the amount of staking and nesting that has occurred on this platform over time, and I used the tables near.core.fact_receipts and near.core.fact_transfers and address ' xtoken.ref-finance.near ' to get it.
I divided the swaps done on the platform into two categories: near to stablecoin swaps and stablecoin to near conversion, and I checked the number of swaps and swappers as well as the volume of swaps between those two categories and for them from I used table near.core.ez_dex_swaps and address ' v2.ref-finance.near ' .
And finally, I checked the amount of liquidity that was added by users to this platform in the liquidity pools, which I used the table near.core.fact_receipts and the address ' v2.ref-finance.near '. All the analyzes performed were obtained from Flipside's data.

Insight of the Week (Ref Finance)