Hi Solana👋

Introduction

what is Solana? according coinmarketcap glossary Solana is a high-speed layer-1 blockchain created in 2017 that aims to scale throughput beyond what is commonly achieved by popular blockchains, like Ethereum and Bitcoin, while maintaining low costs. It boasts a unique consensus mechanism called Proof-of-History that allows Solana to process transactions almost instantly. Solana can theoretically process more than 50,000 transactions per second without scaling solutions, thanks to this lightning-fast timing mechanism, which is a version of proof-of-stake. The layer-1 chain has been many analysts’ favorite when it comes to challenging Ethereum, which has propelled it to a top-10 cryptocurrency. However, Solana has also faced an array of problems and criticism, which is why it is facing increasing competition from other up-and-coming L1s.

What are our achievements from this question?

Each question pursues a purpose, and this question is no exception to this rule. here is some of goal that can achieve after solving this question:

1. Familiarity with the block and votes_block_agg
2. Better understanding the dimensions of the project and the high number of transactions per second (and per block)
3. Find ratio Vote tx to Non-vote tx
4. Find a time frame that have noticeable fluctuations in ratio

2. __ What is the average ratio of votes to non-votes in a block?__ for this question again, I have Two time frame but this time different.in this time question is very clear but I want to show how this ratio I going on in each day. for calculating daily and all ratio I just sum all vote tx and non-vote tx in each day and dived them.

>> notice for creating daily chart I used data in table bellow but I like to share this table to saw how big is Solana. more than 230m tx in each day and Low cost(solve in Solana Fee 😉) and about 140k block each day. just WoooW!!

notice : if you see in the chart, in some of days between 7-9 of Feb we see lower ratio for Votes. reason for this as I know and according Solana Status we have some outage from 7 to 9 Feb in Solana network. so we see lower value. for better understanding I also upload image from this information at bellow.

2. this table shows average ratio of vote to non-vote in block from start of Feb

Defaults for this question

every question have some points that causes doubt or make some problem, so I decide to write some of my default for this question:

1. at first question, we should show vote tx and non-vote tx in chart but there more than 100k block in this period (2week) for drawing this chart it is impossible even load chart or interact to chart, so I choose two time time frames ( 5min and 1hour) and I say why I choose two time frame
2. for last question in some of blocks, all transactions are vote tx and if calc ratio for this we have ∞ ratio (actually if consider number/0 as ∞ ) so I decide to sum all vote and non-vote tx in given period and calculate ratio and avg instead calculate avg for each next calculate avg and ratio for given period

talk is cheap, go to the code 😉

Results

1. Create a visualization that compares the number of non-vote transactions to vote transactions per block since the start of February. for the first question we need a good time unit for grouping block together. at first I want to choose 1min for grouping but when calculate how many group I create for 14 days ( 142460 => 20,160) item and this isn't good at all soo I decide to a better time period to don't have lot's of group and don't loos much detail. balance for this action was hard work and I finally decide to have grouping block data into group 5minute long ( 20160/5 => 4032 ).please look at the code and see how beautifully I wrote create 5 min period group 😉😎. as you se 5 min charts not suitable for this size and article. so for better showing data, I create another chart that's grouping data in 1 hour time frame. result have lower detail than 5 minute chart but much cleaner and easy to read.to summarize my method of work ,first I join tables block and votes_block_agg together on the condition of equality of block_id. after that grouping them according time frame ( 5 min 😎) and them calculate average of vote and non-vote and all block tx.

3. Have there been any timeframes of noticeable fluctuations of this ratio? for this question I decide to create two time frame.

• Daily
• 5 minute

daily chart you have seen before. if you remember in question two I draw daily average and describe reason downfall. I show Rason with links. so it not new thing and wee have seen it before

3. this chart one one of main chart in this question and tell the truth. but before Conclusion I must define how this chart made. for creating this one I divide day into parts with 5 min long (for example first part is 00:00 to 00:05 , another part is 12:15 to 12:20 ) next calculate ratio for this part, next doing for all days in time period and calculate average for all of this days in same time.
   1. for example if we have station with 3 days and algorithm first start with calc ratio for 00:00 to 00:05 (R1) and then ratio for 00:05 to 00:10 and ... ,23:55 to 24:00
   2. for next day 00:00 to 00:05 (R2) and ... .
   3. for next day 00:00 to 00:05 (R3) and ... .
   4. finally for calculate avrage(R1,R2,R3) and put in 00:00 to 00:05 row
   5. same thing repeated for all part of day

after doing this job we made this chart if you look at chart in time 22:30 to 22:35 we find noticeable fluctuations in chart that this fluctuations occur in each day

as seeing in the chart for better showing data, some of data deleted by flipside (not me). so decide to showing table of this data (if you want to find more detail)