Method

The Solana.core.fact_transactions table was mostly used in this dashboard.  We were able to retrieve almost all the data by using the

instructions[0]:programId='HubbLeXBb7qyLHt3x7gvYaRrxQmmgExb7fCJgDqFuB6T'filter, and we also retrieved the swap data by using the solana.core.fact_swaps table.

4 different category studied in this dashboard:

• Hubble Transactions and users.
• USDH mint and burn.
• USDH utilize in other Solana platforms
• HUBBLE token (HBB).

The method will be explained in more detail in each part.

Hubble Protocol

A decentralized finance mechanism called Hubble is based on Solana. The main offering from Hubble is USDH, a decentralized stablecoin that you may borrow against your cryptocurrency holdings. To borrow USDH, users can deposit a variety of cryptocurrencies, including SOL, BTC, ETH, and others. In turn, USDH can be applied to a number of projects throughout Solana DeFi. Hubble will provide a number of USDH borrowing vaults, each with a different asset mix and vault-specific features, including stability fees and deposit caps. Hubble's USDH Vault and bots that enable market-based liquidations work together to guarantee USDH loans. Users deposit USDH into the USDH Vault, which is then utilized to pay off bad loans while giving depositors a net positive difference of 10% in liquidated assets. Aside from that,HBB, Hubble's native token, is given to users who deposit USDH in the USDH Vault. The protocol will introduce a number of goods and services in the ensuing stages of development to enhance the functionality of the platform and USDH.

• The number of transactions and the growth of the number of transactions(weekly)
• The number of unique wallets and the growth of the number of unique wallets(weekly)
• Volume and volume growth(weekly)
• The most transactions on September 19
• Most unique wallet contributions on September 19
• The largest volume was on September 19

Conclusion

• the most number of new users is on Feb 1st with 510 unique users.
• as of today, 4559 unique wallets transacted with the protocol, and the new user trend slowed down since May
• on average 60-70 wallets interact with protocol each day
• the highest number of mints per day occurred on Feb 1st with 887
• the minting increased since September to 30-40 percent on most of the days,
• burning transactions are too low
• Until May the highest number of transactions were transfer transactions, after May the number of swaps increased and could cross over the transfer transactions

And for the last thing we want to check here, in the above chart you can see the volume of these USDH flows in over time. if we look at the day with highest number of users (22nd Sep), we can see there is a huge amount of USD flows and that means there are more than 760k USDH flows in that day. in other days also there are some huge amount of flows but they are all less than 550k USDH total flows. in overall we can see that these amounts have been decreased and it was more flows for USDH in the first four months of the chart.

swap volume on average was above 3M $SOL per week before June 13th

after June 13th the swap volume declined to 200K $SOL per week

Kamino with 185.8K