Bitcoin Forum
November 09, 2024, 06:06:45 PM *
News: Latest Bitcoin Core release: 28.0 [Torrent]
 
   Home   Help Search Login Register More  
Pages: « 1 [2]  All
  Print  
Author Topic: Blockdata Dashboard - Daily and Weekly data! 📊  (Read 542 times)
tranthidung
Legendary
*
Offline Offline

Activity: 2450
Merit: 4275


Farewell o_e_l_e_o


View Profile WWW
January 14, 2021, 05:33:55 AM
 #21

There are no miners in the bottom right side of the chart: Low Reward and High Adoption.
But you can see many miners in the bottom left side: Low Reward and low adoption.

All high reward miners are in the top right side: High Reward and High adoption.

if you want to work with the raw data:
https://loyce.club/bitmover/blockdata.lastweek.txt
https://loyce.club/blockdata/blockdata.lastday.txt
Thank you for the information (from your data extrapolation) and the given data pages. As you are familiar with it, would mind give me headers of columns that are separated by commas, please.

I don't know which column is for which variable/ parameter -- this info is necessary to run analyses, then I'll look at and play with it when I have time.

Quote
I have all that data in json format in the domain, which I prefer. I can help you access it if you need.
I don't need json file as I am not a coder.  Cheesy

▄▄███████▄▄
▄██████████████▄
▄██████████████████▄
▄████▀▀▀▀███▀▀▀▀█████▄
▄█████████████▄█▀████▄
███████████▄███████████
██████████▄█▀███████████
██████████▀████████████
▀█████▄█▀█████████████▀
▀████▄▄▄▄███▄▄▄▄████▀
▀██████████████████▀
▀███████████████▀
▀▀███████▀▀
.
 MΞTAWIN  THE FIRST WEB3 CASINO   
.
.. PLAY NOW ..
bitmover (OP)
Legendary
*
Offline Offline

Activity: 2478
Merit: 6316


bitcoindata.science


View Profile WWW
January 14, 2021, 02:31:34 PM
 #22

Thank you for the information (from your data extrapolation) and the given data pages. As you are familiar with it, would mind give me headers of columns that are separated by commas, please.

I don't know which column is for which variable/ parameter -- this info is necessary to run analyses, then I'll look at and play with it when I have time.

Here you go
Code:
id,hash,time,time,size,stripped_size,weight,version,version_hex,version_bits,merkle_root,nonce,bits,difficulty,chainwork,coinbase_data_hex,transaction_count,witness_count,input_count,output_count,input_total,input_total_usd,output_total,output_total_usd,fee_total,fee_total_usd,fee_per_kb,fee_per_kb_usd,fee_per_kwu,fee_per_kwu_usd,cdd_total,generation,generation_usd,reward,reward_usd,guessed_miner

You can find the description of each item here, in blockchair documentation:
https://blockchair.com/api/docs


How about a little modification to show results within certain blocks or dates?

I have skills and server limitations. I am not able to handle a huge amount of data. I believe 1 week data is already a lot (700kb file). One month data will be 2.8MB, which is huge for a webpage.

I will try to learn how to handle databases so I could process many gigabytes of data in the server, and just deliver the results to the client. But I don't have the skills (yet) neither the server for it .

For now, I will have to work with small amounts of data.

LoyceV
Legendary
*
Offline Offline

Activity: 3486
Merit: 17652


Thick-Skinned Gang Leader and Golden Feather 2021


View Profile WWW
January 14, 2021, 02:51:22 PM
Merited by bitmover (2)
 #23

I have skills and server limitations. I am not able to handle a huge amount of data. I believe 1 week data is already a lot (700kb file). One month data will be 2.8MB, which is huge for a webpage.

I will try to learn how to handle databases so I could process many gigabytes of data in the server, and just deliver the results to the client. But I don't have the skills (yet) neither the server for it .
Learning how to use a database has been on my if-only-I-had-the-time list for a while too, but processing data with a script is quite easy.

If it helps: I can quite easily make daily/weekly/monthly-versions of only certain columns. If you don't need all data that should make it a lot smaller.
If you can use it, I can gzip the file too: blockdata.lastweek.txt.gz (this sample file is scheduled to be deleted in 7 days).

▄▄███████████████████▄▄
▄█████████▀█████████████▄
███████████▄▐▀▄██████████
███████▀▀███████▀▀███████
██████▀███▄▄████████████
█████████▐█████████▐█████
█████████▐█████████▐█████
██████████▀███▀███▄██████
████████████████▄▄███████
███████████▄▄▄███████████
█████████████████████████
▀█████▄▄████████████████▀
▀▀███████████████████▀▀
Peach
BTC bitcoin
Buy and Sell
Bitcoin P2P
.
.
▄▄███████▄▄
▄████████
██████▄
▄██
█████████████████▄
▄███████
██████████████▄
███████████████████████
█████████████████████████
████████████████████████
█████████████████████████
▀███████████████████████▀
▀█████████████████████▀
▀██████████████████▀
▀███████████████▀
▀▀███████▀▀

▀▀▀▀███▀▀▀▀
EUROPE | AFRICA
LATIN AMERICA
▄▀▀▀











▀▄▄▄


███████▄█
███████▀
██▄▄▄▄▄░▄▄▄▄▄
████████████▀
▐███████████▌
▐███████████▌
████████████▄
██████████████
███▀███▀▀███▀
.
Download on the
App Store
▀▀▀▄











▄▄▄▀
▄▀▀▀











▀▄▄▄


▄██▄
██████▄
█████████▄
████████████▄
███████████████
████████████▀
█████████▀
██████▀
▀██▀
.
GET IT ON
Google Play
▀▀▀▄











▄▄▄▀
Vod
Legendary
*
Offline Offline

Activity: 3878
Merit: 3166


Licking my boob since 1970


View Profile WWW
January 14, 2021, 04:06:50 PM
 #24

Learning how to use a database has been on my if-only-I-had-the-time list for a while too, but processing data with a script is quite easy.

Learning a database is just as easy once you understand the concept of value pair.  Your hesitation may be caused by SQL - and the fact you can change large amounts of data at once.  (Like the SQL injection hack on BPIP)   If you have no need to edit your data once downloaded, you won't need to deal with that.  But a database is designed to index - both physically and logically.  No matter how fast you think your queries are - a database will make it fasterSmiley

I post for interest - not signature spam.
https://elon.report - new B.P.I.P. Reports!
https://vod.fan - fast/free image sharing - coming Nov
Pages: « 1 [2]  All
  Print  
 
Jump to:  

Powered by MySQL Powered by PHP Powered by SMF 1.1.19 | SMF © 2006-2009, Simple Machines Valid XHTML 1.0! Valid CSS!