Bitcoin Forum
May 03, 2024, 10:42:01 AM *
News: Latest Bitcoin Core release: 27.0 [Torrent]
 
   Home   Help Search Login Register More  
Pages: « 1 [2]  All
  Print  
Author Topic: Blockdata Dashboard - Daily and Weekly data! 📊  (Read 496 times)
tranthidung
Legendary
*
Offline Offline

Activity: 2268
Merit: 4005


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 ..
1714732921
Hero Member
*
Offline Offline

Posts: 1714732921

View Profile Personal Message (Offline)

Ignore
1714732921
Reply with quote  #2

1714732921
Report to moderator
Every time a block is mined, a certain amount of BTC (called the subsidy) is created out of thin air and given to the miner. The subsidy halves every four years and will reach 0 in about 130 years.
Advertised sites are not endorsed by the Bitcoin Forum. They may be unsafe, untrustworthy, or illegal in your jurisdiction.
bitmover (OP)
Legendary
*
Offline Offline

Activity: 2296
Merit: 5917


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.

.
.BLACKJACK ♠ FUN.
█████████
██████████████
████████████
█████████████████
████████████████▄▄
░█████████████▀░▀▀
██████████████████
░██████████████
████████████████
░██████████████
████████████
███████████████░██
██████████
CRYPTO CASINO &
SPORTS BETTING
▄▄███████▄▄
▄███████████████▄
███████████████████
█████████████████████
███████████████████████
█████████████████████████
█████████████████████████
█████████████████████████
███████████████████████
█████████████████████
███████████████████
▀███████████████▀
█████████
.
LoyceV
Legendary
*
Offline Offline

Activity: 3304
Merit: 16586


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).

Vod
Legendary
*
Offline Offline

Activity: 3682
Merit: 3056


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

https://nastyscam.com - landing page up     https://vod.fan - advanced image hosting - coming soon!
OGNasty has early onset dementia; keep this in mind when discussing his past actions.
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!