Hubble Protocol:

Hubble Protocol is a financial platform building sustainable Decentralized Finance services on Solana. Hubble's core service centers around a low-interest, stablecoin borrowing mechanism. Hubble's US Dollar-pegged stablecoin, USDH, can be borrowed against a variety of assets, including ETH, BTC, and SOL.

Kamino Finance:

Kamino is an automated liquidity solution that reshapes the entire decentralized exchange (DEX) landscape of the Solana ecosystem with an improved, actively managed, brand-new liquidity layer. This Kamino Finance review will provide you all the information regarding its working & services.

Questions:

Create a KPI dashboard that shows Hubble metrics such as: daily active users, new users, mint/burn rates, different rates of instructions etc. (anything you find relevant)

Show the flows of USDH, where it is being used in the Solana ecosystem, is it gaining adoption, and if so how? \n

Hubble also recently launched Kamino Finance: https://blog.hubbleprotocol.io/multicoin-raise-kamino-launch/

Provide metrics on its growth rate and adoption so far. How is it being used?

Active users

New users

Event type

USDH

USDH Uses:

Kamino Finance:

Conclusion:

• The trend of unique users and new users on the Hubble platform is descending.
• Most of the transactions type on the Hubble platform are ‘transfer’ (more than 60%).
• leat of the transactions type on the Hubble platform is ‘set authority‘ (~0.01%).
• ‘Mint’ transactions are more common than ‘burn’ transactions on the Hubble platform.
• After the drop in the number and volume of USDH transactions, we have recently seen their increase again.
• The most uses of USDH are on Kimino finance based on the number of transactions.
• There isn’t any notable trend for the number of transactions, unique users, and new users of Kamino finance. Also, same for number of USDH transactions on this platform.

Solution:

To answer this question, used core.fact_transactions and core.fact_events tables of Solana schema. Also, following filters apply to queries:

• for Hubble platform:

  instructions[0]:programId = 'HubbLeXBb7qyLHt3x7gvYaRrxQmmgExb7fCJgDqFuB6T'

• for USDH:

  inner_instructions[0]:instructions[0]:parsed:info:mint = 'USDH1SM1ojwWUga67PGrgFWUHibbjqMvuMaDkRJTgkX'

  inner_instructions[1]:instructions[0]:parsed:info:mint = 'USDH1SM1ojwWUga67PGrgFWUHibbjqMvuMaDkRJTgkX'

  pre_token_balances[0]:mint = 'USDH1SM1ojwWUga67PGrgFWUHibbjqMvuMaDkRJTgkX'

  pre_token_balances[1]:mint = 'USDH1SM1ojwWUga67PGrgFWUHibbjqMvuMaDkRJTgkX'

• for Kamino:

  instructions[0]:programId = '6LtLpnUFNByNXLyCoK9wA2MykKAmQNZKBdY8s47dehDc'

• succeeded = TRUE

• The trend of unique active users on the Hubble platform is descending. The peak of this amount was on Feb 1st with 745 unique users.
• The total number of unique users on Hubble from the first until now is 4560 wallets and on average ~142 unique wallets are active on it per day.

• The trend of unique new users on the Hubble platform is descending too. The peak of this amount was on Feb 1st with 510 users that had a transaction for the first time.

• On average ~19 new wallets used this platform for the first time per day.

• Most of the transactions type on the Hubble platform are ‘transfer’ (more than 60%).
• leat of the transactions type on the Hubble platform is ‘set authority‘ (~0.01%).
• ‘Mint’ transactions are more common than ‘burn’ transactions on the Hubble platform.

After the drop in the number and volume of USDH transactions, we have recently seen their increase again.

• The most uses of USDH is on Kimino finance based on the number of transactions.
• The most uses of USDH is for associated token account based on the number of user.
• The most uses of USDH is on Orca based on the volume of transactions.