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.