Hey All,
I contiue to explore and learn while querying HiveSQL which is a publicly available Microsoft SQL database containing all the Hive blockchain data. This time around, I happened to explore - DynamicGlobalProperties table that contains the data returned by the get_dynamic_global_properties API. This API call is used to get the state of the Hive blockchain and its global parameters. It is updated every time a block is processed. My GOAL here was to query this table to get me the following information.
current_supply → Liquid HIVE
total_vesting_fund_hive → HIVE in Hive Power (staked)
current_hbd_supply → HBD in existence
Here is the query that I triggered and its a running query which you can trigger at any point to get the records from the DynamicGlobalProperties table
SELECT
current_supply,
total_vesting_fund_hive,
current_hbd_supply
FROM DynamicGlobalProperties;
And here is the Output of the query::
| Metric | Value (Full) | Value (Millions) |
|---|---|---|
| Current Supply (HIVE) | 484,490,925.868 | 484.49 M |
| Staked HIVE (Vesting Fund) | 188,622,438.662 | 188.62 M |
| Current HBD Supply | 34,961,069.018 | 34.96 M |
I got the numbers but then, I did not stop here and went to leverage my Phython skills to plotting - "Hive Token Supply Distribution" pie chart. Also note the pie char is themed with Hive logo colors. Ist it cool. What do you say? Here is the chart that was plotted using Python’s pandas and matplotlib libraries.
| Category | Amount in Millions | Percentage of Total Supply |
|---|---|---|
| Liquid HIVE | 484.49 M | 67% |
| Staked HIVE (HP) | 188.62 M | 26% |
| HBD Supply* | 34.96 M | 5% |
Overall it was a great learning expereince for me to pull records and plot the pie chart. And now if we infer the numbers there is 26% of the HIVE tokens staked as Hive Power and 67% is liquid. It would be good to see the Hive stake number increase over a period of time. I guess this should be it for todays post on - "HiveSQL - Current - Hive Token Supply Distribution Numbers..." I hope I was able to explain it clearly. If there are any follow up questions/doubts - Please feel free to reach out on the comment box below. Happy Learning - HiveSQL - Current - Hive Token Supply Distribution Numbers... Liquid HIVE, HIVE POWER & HBD Supply......cheers
Have Your Say on Hive Token economics - #HIVE POWER - #HBD - HODL Vs SELL? HP GOAL?
Hive Token economics. Selling Vs HOLD #HIVE? Are you building your stake here on the HIVE platform? What are your thoughts in general for HIVE Power and HBD in savings? Are you stacking up HBD or converting HBD to HIVE? What's your overall strategy for HBD looking like? What are your general thought around the platform #HIVE? Please let me know in the comment section below...
HiveSQL - Hive Token Supply Distribution Numbers...
#hive #stake #hbd #hivepowerup #hodl #build #stakehive #crypto #hp #staking #goal #hodl #investment #hivepower
Best Regards
Paras
Image Courtesy:: pro canva license, phython matplotli, pandas
PS:- None of the above is a FINANCIAL Advice. Please DYOR; Do your own research. I've have an interest in BlockChain & Cryptos and have been investing in many emerging projects.
Posted Using INLEO
Hey, nice one.
Just a few notes. The number for the liquid HIVE is actualy the total HIVE supply. So to get the liquid you need to subtract the staked HIVE.
Furthermore, HBD is not equal one HIVE, so if you want to chart them on the same chart you need to put the HBD as virtual HIVE supply, that is HBD/HIVE price.
thank you @dalz for pointing out the right calculations. Appreciate it. cheers
This post has been manually curated by @bhattg from Indiaunited community. Join us on our Discord Server.
Do you know that you can earn a passive income by delegating your Leo power to @india-leo account? We share 100 % of the curation rewards with the delegators.
100% of the rewards from this comment goes to the curator for their manual curation efforts. Please encourage the curator @bhattg by upvoting this comment and support the community by voting the posts made by @indiaunited.
This post has been manually curated by @steemflow from Indiaunited community. Join us on our Discord Server.
Do you know that you can earn a passive income by delegating to @indiaunited. We share more than 100 % of the curation rewards with the delegators in the form of IUC tokens. HP delegators and IUC token holders also get upto 20% additional vote weight.
Here are some handy links for delegations: 100HP, 250HP, 500HP, 1000HP.
100% of the rewards from this comment goes to the curator for their manual curation efforts. Please encourage the curator @steemflow by upvoting this comment and support the community by voting the posts made by @indiaunited..
This post received an extra 10.00% vote for delegating HP / holding IUC tokens.