LBI subscription - Jan 1 to Jan 21st . DATA and CHARTS with Code inside.

Good morning to all . First of all , LeoFinance is faster and smoother now because of the Lightning DB.

More - https://twitter.com/financeleo/status/1352816970744389633?s=21

Coming to the main point of this post - LBI . I have always been on a dual mind after the airdrop announcement whether to buy more LBI or stake the LEO , finally I decided to split it in half and buy 50% LBI and 50% LEO . Now let us take a look at how much LBI was subscribed from Jan 1st to Jan 21st .

First things first - For those who isn't interested in codes - This is the amount of LBI subscribed everyday from Jan 1st to Jan 21st

Date	Amount of LBI subscribed
2021-01-01	839.21
2021-01-02	326.846
2021-01-03	1205.034
2021-01-04	7.611
2021-01-05	1921.615
2021-01-06	316.585
2021-01-07	31.483
2021-01-08	600.41
2021-01-09	3421.695
2021-01-11	233.135
2021-01-12	1552.322
2021-01-13	35.578
2021-01-14	74.237
2021-01-15	41.956
2021-01-16	808.33
2021-01-17	354.832
2021-01-18	17.742
2021-01-19	2104.872
2021-01-20	709.805
2021-01-21	195.864

Constant raise and drop . Somedays it is less than 100 and somedays more than 1k . So to get better picture let's see Mean LBI sent by @lbi-token .

Date	Mean LBI sent from @lbi-token
2021-01-01	64.555
2021-01-02	108.949
2021-01-03	48.201
2021-01-04	7.611
2021-01-05	91.505
2021-01-06	31.659
2021-01-07	7.871
2021-01-08	120.082
2021-01-09	213.856
2021-01-11	15.542
2021-01-12	81.701
2021-01-13	11.859
2021-01-14	6.186
2021-01-15	8.391
2021-01-16	44.907
2021-01-17	25.345
2021-01-18	4.436
2021-01-19	87.703
2021-01-20	78.867
2021-01-21	19.586

It is safe to say by looking at above charts that NO LBI SUBSCRIPTION HASN'T STOPPED . Nowhere near stopping the subscription , users are actively subscribing.

Coming to the code - I have downloaded all the Hive-Engine Data using Hive-Engine API and kept it in a shelve ( key,value pair )

import shelve 
import pandas as pd
import json
from datetime import datetime as dt

s=shelve.open('Blocks\Blockchain')# This is where I have kept the data .

df=pd.DataFrame.from_dict(s.items()) # Transferring it into Dataframe 
df.columns=['Blocks','Transactions'] # Changing the column names

The above is of less importance , we will get into the main part in the following section , anyway the table looks like this -

lbi_transfer_list=[]
for i in range(0,len(df)):
    if(df['Transactions'][i]['Transaction']['action']=='transfer'): # Taking only transfer data
        json_lbi_data=json.loads(df['Transactions'][i]['Transaction']['logs']) # Taking logs of that particular transaction
        if 'events' in json_lbi_data:
            if(json_lbi_data['events'][0]['data']['from']=='lbi-token' and json_lbi_data['events'][0]['data']['symbol']=='LBI'): # Two conditions must be met - 1. It must be transferred from @lbi-token account and 2. Symbol must be LBI
                print(json_lbi_data['events'][0]['data']['from'],json_lbi_data['events'][0]['data']['to'],json_lbi_data['events'][0]['data']['quantity'],pd.to_datetime(df['Transactions'][i]['Date']).date()) # Printing the result
                lbi_transfer_list.append([json_lbi_data['events'][0]['data']['from'],json_lbi_data['events'][0]['data']['to'],json_lbi_data['events'][0]['data']['quantity'],pd.to_datetime(df['Transactions'][i]['Date']).date()]) # Storing it in the list

The output looks something like this -

Now to get a better picture let us put it in DataFrame -

df_lbi = pd.DataFrame(lbi_transfer_list)
df_lbi.columns=['From','To','Quantity','Date']
df_lbi

The table looks like -

df_sum=df_lbi.groupby(by=['Date']).sum() # Groupby function on Date column.

Then I just put this in chart using matplotlib in python .

Now I can gather info for particular user too like this -

df_lbi[df_lbi['To']=='taskmaster4450le']

This is for @taskmaster4450le . To get sum -

df_lbi[df_lbi['To']=='taskmaster4450le']['Quantity'].sum()

Output - 2500 LBI .

If you want LBI data from Jan 1 to Jan 21 for your account , just comment here I will get it for you :)

---

Regards,
MR.

Posted Using LeoFinance ^Beta