Open Analytics Bounty: Solana (December 3)

    Introductions

    Bitfinex

    Bitfinex is a large cryptocurrency exchange supporting a large ecosystem of cryptocurrency products and trading options, including spot trading, margin accounts, derivatives, paper trading, and more. With a mix of features suitable for both beginner and expert crypto users, Bitfinex likely offers everything you need to manage your cryptocurrency in one place.

    However, before you get started, it’s important to know that Bitfinex has a history of regulatory challenges, including multiple fines from the Commodity Futures Trading Commission.12 The most severe charge, from the New York Attorney General’s Office, includes misleading investors. Bittfinex indicated that the Tether stablecoin was fully backed by reserves when that wasn’t the case.3 The exchange’s history and allegations of continued wrongdoing may be concerning for investors.

    *Resource: *

    Solana

    Solana is a blockchain platform designed to host decentralized, scalable applications. Founded in 2017, it is an open-source project currently run by Solana Foundation based in Geneva, while the blockchain was built by San Francisco-based Solana Labs.1

    Solana is much faster in terms of the number of transactions it can process and has significantly lower transaction fees than rival blockchains like Ethereum. The cryptocurrency that runs on the Solana blockchain—also named Solana (SOLUSD) and using the ticker symbol SOL—soared almost 12,000% in 2021 and at one point had a market capitalization of over $66 billion, making it the fifth-largest cryptocurrency by this measure at the time.2

    Despite its popularity, SOL did not escape the cryptocurrency bloodbath of 2022. By Oct. 3, 2022, SOL had dropped to about $11.71 billion in market capitalization. It also fell to ninth place in market capitalization.3 Learn more about Solana and what makes it unique among thousands of imitators.

    *Resource: *

    db_img
    db_img

    Methodology

    As it is clear from the introduction, our goal is to review Bitfinex and its transactions with Solana. For this purpose, to get an overview of the Bitfinex situation, we have first obtained the Total Bitfinex Wallets in the Solana network, its value is 6160. Then we will consider the following for it.

    Total, daily, weekly, and cumulative transfers

    Total, daily, weekly and cumulative number of users

    Total, daily, weekly, and cumulative volume

    Total, daily, weekly and cumulative Tokens

    And at the end, we will review the top 10 transfers in different situations.

    The selected period is the last 90 days.

    The most important tables used are as follows: fact_transfers table from the core subcategory related to the Solana database dim_labels table from the core subcategory related to the Solana database

    Loading...

    Transactions

    Loading...
    Loading...
    Loading...
    Loading...

    Result: Transactions

    In order to better understand and compare transfers in Solana TO Bitfinex and Bitfinex TO Solana, we have compared transfers in four charts.

    In the daily chart, the number of transfers from Bitfinex to Solana and Solana to Bitfinex is almost balanced, and sometimes the transfer from Bitfinex to Solana is more and sometimes from Solana to Bitfinex until November 9, when the difference from Bitfinex to Solana And Solana TO Bitfinex has reached 179 units. In contrast, on November 13 and November 25, this time Solana TO Bitfinex was 74 and 185 units more than Bitfinex TO Solana, respectively. After that, no strong fluctuation was seen and the trend has been balanced. In the weekly chart, most transfers are related to the fourth week, followed by the fifth week. If you look at the cumulative chart, you will notice a sudden change in the slope of the chart, after that the normal trend in Bitfinex TO Solana and Solana TO Bitfinex We are seeing a sudden increase in the slope of the graph from November 7 to 14. However, the overall result between the number of transfers from Bitfinex TO Solana and Solana TO Bitfinex is very close and the difference is only 5 units.

    Users

    Loading...
    Loading...
    Loading...
    Loading...

    Result: Users

    In the analysis of the number of users from Solana to Bitfinex and Bitfinex to Solana, there is no significant difference except for November 26 and 30. In fact, on November 26, the number of users suddenly decreased in Bitfinex TO Solana, and the short three-day time span from Solana TO Bitfinex reached the maximum difference on November 30.

    Since November 8, we can see that the users in Bitfinex TO Solana and Solana TO Bitfinex are equal and at their maximum. In the weekly chart, we can see that each week is almost equal, the only important thing is related to November 7th to November 14th, which has the highest value. In the graph of the sum total, the similarity of the number of users in Bitfinex TO Solana and Solana TO Bitfinex can be easily understood, so the percentage difference is less than 0.2.

    Volume

    Loading...
    Loading...
    Loading...
    Loading...

    Result: Volume

    tokens

    Loading...
    Loading...
    Loading...
    Loading...

    Result: tokens

    In the fourth step, we examined Tokens in Bitfinex TO Solana and Solana TO Bitfinex. The interesting point was equality on many days, such as September 9, 10, and 11.

    In the weekly chart, we can see that the values of Bitfinex TO Solana and Solana TO Bitfinex have started their upward trend since October 23 and are increasing.

    In the cumulative graph, the competition between Bitfinex TO Solana and Solana TO Bitfinex can be seen well, so that until October 7, the value of Bitfinex TO Solana was higher, than the value of Solana TO Bitfinex was higher until October 31, and after that, the cumulative value of Bitfinex TO Solana again More than Solana TO Bitfinex.

    But in the sum graphs where we can see the final difference, we can see that Bitfinex TO Solana is 9% more than Solana TO Bitfinex with 53.5 percent.

    Top 10 Transfers based on the number of transfers

    Loading...
    Loading...

    Result: Top 10 Transfers based on the number of transfers

    #In this section, we want to review the top 10 transfers from Bitfinex to Solana and from Solana to Bitfinex. What was seen as a result of transfers from Bitfinex to Solana ==FxteHmLwG9nk1eL4pjNve3Eub2goGkkz6g6TbvdmW46a== has the largest share with 99.7% with great power and plays the main role in transfers from Bitfinex to Solana. But in the investigation of transfers from Solana to Bitfinex, the situation is different and the power is not concentrated in one place so that the highest value is related to ==FxteHmLwG9nk1eL4pjNve3Eub2goGkkz6g6TbvdmW46a== It is with a share of 61.6%, it is seen after the shares of 12 and 9.6%. And the percentage distribution is fairer than transfers from Bitfinex to Solana

    Top 10 Transfers based on the Volume

    Loading...
    Loading...

    Result: Top 10 Transfers based on the Volume

    In the review of the top 10 transfers based on volume in the left chart, we have reviewed Bitfinex TO Solana, in which ==GwsHHFEVarroa9GYeMkzQWZnbtBpReUbN3CkSZQrihTg== has the largest share with a 73.9 percent share. After that, the percentages are 8.3% and 8.11%, but on the other side, in Solana TO Bitfinex, we see the same address as before, ==GwsHHFEVarroa9GYeMkzQWZnbtBpReUbN3CkSZQrihTg==, this time also with a smaller share, i.e. 65%, and after that, ==FxteHmLwG9nk1eL4pjNve3Eub2goGkkz6g6TbvdmW46a==, with a 37% share. It has been assigned the second rank. This is despite the fact that it was ranked first in transfers.

    Loading...
    Loading...
    Loading...
    Loading...

    In the last step, we will review the top 10 transferred tokens based on volume in Bitfinex TO Solana and Solana TO Bitfinex.

    What is common in both the graphs related to Bitfinex TO Solana and Solana TO Bitfinex is the Star atlas token, which has the first share in both cases, it has a 72% share in Bitfinex TO Solana, and in Solana TO Bitfinex has a 74.5% stake. The next ranks are related to the wrapped sol and oxygen protocol.

    Conclusion

    We tried to examine various parameters such as transfers, users, volume, and tokens in order to find out the status of Bitfinex TO Solana and Solana TO Bitfinex. What can be referred to as the final result is as follows:

    In the review of transfers between Bitfinex TO Solana and Solana TO Bitfinex, the general trend is decreasing, but Solana TO Bitfinex has a higher amount than Bitfinex TO Solana. In the review of Solana TO Bitfinex and Bitfinex TO Solana users, they are almost similar and no significant difference was observed. But the number of users is growing In the volume review on November 25, we have suddenly seen an increase in volume and it can be concluded that the volume is also increasing. In checking tokens, Bitfinex TO Solana is more than Solana TO Bitfinex In checking the addresses, the most power in Bitfinex TO Solana transfer is in the hands of one user, and in Solana, TO Bitfinex the most power is in the hands of one or two users.