What's All The Hubbub for Hubble Protocol ?

    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)

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

    ❓What's All The Hubbub for 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

    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?

    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?

    πŸ“ Introduction

    What is Hubble Protocol?

    Hubble is a decentralized finance (DeFi) protocol built on the Solana blockchain. In Phase 1 of development, Hubble enables you to borrow USDH against multiple assets. Borrowing USDH allows users to access the liquidity (cash on hand) in their long-term holding tokens.

    What can I do on Hubble?

    With Hubble’s borrowing platform, you can:

    • Borrow USDH for as long as you’d like
    • Deposit multiple cryptos to mint USDH: SOL, BTC, ETH, mSOL, stSOL, daoSOL, RAY, SRM, FTT, cTokens from Solend, and kTokens from Kamino
    • Yield positive interest on collateral deposits (earn while you borrow)
    • Earn protocol rewards by staking HBB
    • Earn from liquidations by depositing USDH in the Stability Vault (formerly Stability Pool).

    Why should I borrow through Hubble?

    Hubble combines several features into one borrowing platform that increases capital efficiency in multiple ways.

    If you want to go long on SOL, Hubble lets you hold onto your SOL as it appreciates in value while borrowing USDH to deploy in DeFi.

    Borrow USDH while you yield. You can earn interest from liquid staking tokens like mSOL, stSOL, and daoSOL or from lending with Solend cTokens while borrowing USDH at the same time.

    With kTokens, you can earn yield from Kamino vaults while leveraging your position up to 20x with USDH.

    db_img

    ✍🏻 Methodology

    • In this dashboard, i use 3 table:
      • solana.core.fact_transactions β†’ used for checking transactions on Hubble protocol and solana chain.
      • solana.core.fact_events β†’ used for filtering transaction type on Hubble protocol and solana chain.
      • solana.core.fact_swaps β†’ used for checking swappers activity on Hubble protocol and solana chain.

    program_id = 'HubbLeXBb7qyLHt3x7gvYaRrxQmmgExb7fCJgDqFuB6T'

    mint = 'USDH1SM1ojwWUga67PGrgFWUHibbjqMvuMaDkRJTgkX'

    πŸ“ƒ Purposes of dashboard

    In this dashboard, Hubble protocol is analyzed :

    • Total and Daily / weekly / monthly count of transactions at Hubble protocol .

    • Total and Daily / weekly / monthly count of mints at Hubble protocol .

    • Total and Daily / weekly / monthly count of burns at Hubble protocol .

    • Total and Daily / weekly / monthly count of users at Hubble protocol .

    • Total and Daily mint / burn rate at Hubble protocol .

    • Total count of transactions at each type of transactions.

    • Total and Daily / weekly / monthly count of transactions at USDH on solana chain.

    • Total and Daily / weekly / monthly count of users at USDH on solana chain.

    • Total and Daily / weekly / monthly volume of transactions at USDH on solana chain.

    • Total and Daily / weekly / monthly count of transactions at USDH on Hubble protocol.

    • Total and Daily / weekly / monthly count of users at USDH on Hubble protocol.

    • Total and Daily / weekly / monthly volume of transactions at USDH on Hubble protocol.

    • Total and Daily / weekly / monthly count of swaps at USDH on solana chain.

    • Total and Daily / weekly / monthly count of swappers at USDH on solana chain.

    • Total and Daily / weekly / monthly volume of swaps at USDH on solana chain.

    • count of swaps at each market.

    • count of swappers at each market.

    • volume of swaps at each market.

    🟑 Part(1).Total and Daily / weekly / monthly count of transactions at Hubble protocol .

    🟑 Part(2).Total and Daily / weekly / monthly count of mints at Hubble protocol .

    🟑 Part(3).Total and Daily / weekly / monthly count of burns at Hubble protocol .

    🟑 Part(4).Total and Daily / weekly / monthly count of users at Hubble protocol .

    🟑 Part(5).Total and Daily mint / burn rate at Hubble protocol .

    🟑 Part(6).Total count of transactions at each type of transactions.

    🟑 Part(7).Total and Daily / weekly / monthly count of transactions at USDH on solana chain.

    🟑 Part(8).Total and Daily / weekly / monthly count of users at USDH on solana chain.

    🟑 Part(9).Total and Daily / weekly / monthly volume of transactions at USDH on solana chain.

    🟑 Part(10).Total and Daily / weekly / monthly count of transactions at USDH on Hubble protocol.

    🟑 Part(11).Total and Daily / weekly / monthly count of users at USDH on Hubble protocol.

    🟑 Part(12).Total and Daily / weekly / monthly volume of transactions at USDH on Hubble protocol.

    🟑 Part(13).Total and Daily / weekly / monthly count of swaps at USDH on solana chain.

    🟑 Part(14).Total and Daily / weekly / monthly count of swappers at USDH on solana chain

    🟑 Part(15).Total and Daily / weekly / monthly volume of swaps at USDH on solana chain.

    🟑 Part(16).count of swaps at each market.

    🟑 Part(17).count of swappers at each market.

    🟑 Part(18).volume of swaps at each market.

    πŸ‘€ Observation ( part(1) , part(2) , part(3) , part(4), part(5), part(6))

    • The count of sales was in ==May==, ==Feb== and ==Mar== 2022 was more than other months.

    • The maximum count of sales was ==6407== in one day is related to ==1 Feb== of 2022.

    • The maximum count of sales was in one week is related to ==first week== of Feb 2022. (==57.023 K== in Feb and ==27.57 K== at first week of Feb).

    • Total count of sales was ==141.8 K== .

    • The count of mints was in ==Mar==, ==Feb== and ==Apr== 2022 was more than other months.

    • The maximum count of mints was ==660.81 K== in one day is related to ==1 Feb== of 2022.

    • The maximum count of mints was in one week is related to ==first week== of Feb 2022. (==2.49 M== in Feb and ==1.89 M== at first week of Feb).

    • Total count of mints was ==3.73 M== .

    • The count of burns was in ==May==, ==Feb== and ==Jun== 2022 was more than other months.

    • The maximum count of burns was ==44.53 K== in one day is related to ==1 Feb== of 2022.

    • The maximum count of burns was in one week is related to ==second week== of May 2022. (==79.41 K== in May and ==71.66 K== at second week of May).

    • Total count of burns was ==115.7 K== .

      \

    • The count of users was in ==Mar==, ==Feb== and ==Apr== 2022 was more than other months.

    • The maximum count of users was ==745== in one day is related to ==1 Feb== of 2022.

    • The maximum count of users was in one week is related to ==first week== of Feb 2022. (==10.14 K== in Feb and ==3553== at first week of Feb).

    • Total count of users was ==4.57 K== .

      \

    • Total mint rate was ==26.3%== and total burn rate was ==0.816%==.

    • count of transaction at each type of transactions was:

      • Transfer ==103.407 K== (==75.4%==)

      • Mint to ==22.38 K== (==16.3%==)

      • Create account ==10.99 K== (==8.02%==)

      • Burn ==422== (==0.308%==)

      • Set authority ==5== (==0.0035%==)

    πŸ‘€ Observation ( part(7) , part(8) , part(9))

    • The count of USDH transactions at solana chain was in ==Sep==, ==Feb== and ==Aug== 2022 was more than other months.

    • The maximum count of USDH transactions at solana chain was ==349== in one day is related to ==1 Feb== of 2022.

    • The maximum count of USDH transactions at solana chain was in one week is related to ==first week== of Sep 2022. (==6500== in Sep and ==1630==at first week of Sep).

    • Total count of USDH transactions at solana chain was ==18.4 K== .

      \

    • The count of users at solana chain was in ==Sep==, ==Feb== and ==Aug== 2022 was more than other months.

    • The maximum count of users at solana chain was ==208== in one day is related to ==31 Aug== of 2022.

    • The maximum count of users at solana chain was in one week is related to ==forth week== of Aug 2022. (==2779== in Aug and ==1224== at forth week of Aug).

    • Total count of users at solana chain was ==7.13 K== .

    • The volume of USDH transactions at solana chain was in ==Sep==, ==Feb== and ==Apr== 2022 was more than other months.

    • The maximum volume of USDH transactions at solana chain was ==801.69 K== in one day is related to ==22 Sep== of 2022.

    • The maximum volume of USDH transactions at solana chain was in one week is related to ==third week== of Sep 2022. (==3.19 M== in Sep and ==1.15 M== at third week of Sep).

    • Total volume of USDH transactions at solana chain was ==8.93 M== .

      \

    πŸ‘€ Observation ( part(10) , part(11) , part(12))

    • The count of USDH transactions at Hubble platform was in ==Sep==, ==Feb== and ==Mar== 2022 was more than other months.

    • The maximum count of USDH transactions at Hubble platform was ==349== in one day is related to ==1 Feb== of 2022.

    • The maximum count of USDH transactions at Hubble platform was in one week is related to ==first week== of Feb 2022. (==2346== in Feb and ==1327== at first week of Feb).

    • Total count of USDH transactions at Hubble platform was ==10.74 K== .

      \

    • The count of users Hubble platform was in ==Sep==, ==Feb== and ==Mar== 2022 was more than other months.

    • The maximum count of users at Hubble platform was ==179== in one day is related to ==1 Feb== of 2022.

    • The maximum count of users at Hubble platform was in one week is related to ==first week== of Feb 2022. (==1421== in Feb and ==742== at first week of Feb).

    • Total count of users Hubble platform was ==1411== .

    • The volume of USDH transactions Hubble platform was in ==Sep==, ==Feb== and ==Apr== 2022 was more than other months.

    • The maximum volume of USDH transactions at Hubble platform was ==794.65 K== in one day is related to ==22 Sep== of 2022.

    • The maximum volume of USDH transactions at Hubble platform was in one week is related to ==third week== of Sep 2022. (==2.94 M== in Sep and ==1.05 M== at third week of Sep).

    • Total volume of USDH transactions at Hubble platform was ==8.13 M== .

    πŸ‘€ Observation ( part(13) , part(14) , part(15) , part(16) , part(17) , part(18))

    • The count of USDH swaps at solana chain was in ==Jun==, ==Apr== and ==May== 2022 was more than other months.

    • The maximum count of USDH swaps at solana chain was ==18.88 K== in one day is related to ==21 Jun== of 2022.

    • The maximum count of USDH swaps at solana chain was in one week is related to ==third week== of Jun 2022. (==77.18 K== in Jun and ==33.66 K== at third week of Jun).

    • Total count of USDH swaps at solana chain was :

      • swap in ==79.105 K== (==52.4%==)
      • swap out ==71.926 K== (==47.6%==)

      \

    • The count of swappers at solana chain was in ==Feb==, ==Apr== and ==May== 2022 was more than other months.

    • The maximum count of swappers at solana chain was ==547== in one day is related to ==20 Apr== of 2022.

    • The maximum count of swappers at solana chain was in one week is related to ==third week== of Apr 2022. (==5359== in Apr and ==2336== at third week of Apr).

    • Total count of swappers at solana chain was :

      • swap in ==14.573 K== (==55.4%==)
      • swap out ==11.715 K== (==44.6%==)
    • The volume of USDH swaps at solana chain was in ==Sep==, ==Feb== and ==Apr== 2022 was more than other months.

    • The maximum volume of USDH swaps at solana chain was ==2.33 M== in one day is related to ==10 May== of 2022.

    • The maximum volume of USDH swaps at solana chain was in one week is related to ==second week== of May 2022. (==24.44 M== in May and ==8.87 M== at second week of May).

    • Total volume of USDH swaps at solana chain was :

      • swap in ==47.53 M== (==50.7%==)
      • swap out ==46.13 M== (==49.3%==)
    • count of USDH swaps at each market:

      • saber ==4.45 K== (==2.95%==)
      • raydium v4 ==8.4 K== (==5.56%==)
      • orca ==2.9 K== (==1.93%==)
      • jupiter aggregator v2 ==135.25 K== (==89.6%==)
    • count of USDH swappers at each market:

      • saber ==3.09 K== (==2.95%==)
      • raydium v4 ==4.8 K== (==5.56%==)
      • orca ==1.25 K== (==1.93%==)
      • jupiter aggregator v2 ==17.13 K== (==89.6%==)

    πŸ“ƒContact Data

    Discord : Abolfazl#2441

    Email : Abolfazl.yeganeh77@gmail.com

    Twitter : profile

    Twite of this analyze : Link

    thanks for Flipsidecrypto team