You have two options here:
Check out one of the data providers online. Quandl offers (mostly) free historical data for a variety of pairs and exchanges. Alternatively, if you have bucks to spare, Coinigy offers high-quality data sets on a per-month pricing model.
Roll your own data crawler, using a programming language of your choice and the ...
This more of a question about excel than it is actually about Bitcoin. But the answer is actually pretty easy.
The first thing is that the data that you want to import from the web may not be easily isolated, so you might have to import much more data than you want into a second excel sheet, then link the cell with the data you are interested to a cell in ...
You can get complete and up-to-date price history here:
You can also get subsets of the data.
For details see: http://bitcoincharts.com/about/markets-api/
To find all the accounts that hold an asset, e.g. USD/gw1, you just need to use the account_lines API on the gw1 account and filter out the USD entries (or whatever currency code you are interested in).
Although you could recursively look up the account lines of each found account in turn, that doesn't tell you anything more about who "holds the IOUs from a ...
Blockchain.info definitely has a client installed on their servers, that's where they get all the block data from. I heard they're using a fork of BitcoinJ.
In the Bitcoin-qt daemon, you can get the difficulty of the latest block with the getdifficulty command, and you can get complete information about every block, including the difficulty, with getblock.
Unfunded orders obviously don't show up in the orderbook. I assume that mtgoxlive is based on the same data provided by the API so it is probably accurate.
If you really want to know, just compare the market depth from mtgoxlive with the ones shown at bitcoincharts and clarkmoody.
The standard bitcoind core daemon has no methods to query the UTXO set for reasons I don't know: it should be trivial to give access to it even on a pruned node since it needs to have the full UTXO set at any time to validate a new block.
Anyway a pull request seems in progress to add this capability:
There are ...
This information can be retrieved from a running node with the getutxosetinfo command.
$ bitcoin-cli gettxoutsetinfo
Yes, the information is public and in the ledger history.
you can find how inflation works in Stellar.org's mandate
in a nutshell: you can look at the inflation transaction that runs every week and look at its metadata. The metadata ...
You can download the historical data of coinmarketcap.com with my developed crawler: https://github.com/roNn23/coinmarketcap-historical-data-crawler. But it's only getting the snapshots of coinmarketcap.com, maybe it's to wide for your needs.
Just put up a website cryptoarchive.com.au with the data sets I use for my own modeling. One minute OHLVC data is available for free, tick-level data - very reasonably priced. Data from Binance for now.
You can use my website www.cryptodatasets.com which provides exactly what you need.
tick by tick historical BTC, ETH, and LTC prices and volume from Bitfinex and Hitbtc.
It's exactly what I use to backtest my strategies/bots.