Your node has this info already
Has anyone used nostr:npub1tayp5jjjfqx4ufukxqamsl28wd5pggvteqe6u9n3svjn62lfr0hsp89l42 ?
I need to create a data base which pulls the data from every single Bitcoin block 0 to present.
I need block height, difficulty, block size (bytes) and block time (seconds).
I’ve never worked with a data set this large, how do you work with it efficiently? How would you go about building graphs which could live update with new blocks found? There’s so much more block explorers could be providing, specifically joules per satoshi.
Before I release the blueprint as to how you price bitcoin in joules, I need to check it vs the data itself, but the theory is done.
Any help would be great nostr, data is not my realm.
Discussion
My node is currently dead (ras pi), nor do I know enough command line to access the data. Has anyone built an interface for manipulating chain data?