Bitcoin Forum
September 27, 2016, 07:00:54 AM *
News: Latest stable version of Bitcoin Core: 0.13.0 (New!) [Torrent]. Make sure you verify it.
 
   Home   Help Search Donate Login Register  
Pages: [1]
  Print  
Author Topic: Bitcoin Watch: historical trade data  (Read 9361 times)
jgarzik
Legendary
*
Offline Offline

Activity: 1470


View Profile
October 27, 2010, 08:50:45 PM
 #1

Bitcoin Watch is now making available per-trade historical data for mtgox, bitcoinmarket PPUSD, bitcoinmarket LRUSD and bitcoinmarket PGAU.  It's in CSV text format, zipped:

     http://www.bitcoinwatch.com/trades.zip

Robot authors, please do not poll this more than once a day.  Do not consider this a real-time feed.  You do not need to download the entire history of bitcoin every 5 minutes!  If you need a real-time feed, please connect directly to the marketplace tickers themselves.

Jeff Garzik, bitcoin core dev team and BitPay engineer; opinions are my own, not my employer.
Donations / tip jar: 1BrufViLKnSWtuWGkryPsKsxonV2NQ7Tcj
1474959654
Hero Member
*
Offline Offline

Posts: 1474959654

View Profile Personal Message (Offline)

Ignore
1474959654
Reply with quote  #2

1474959654
Report to moderator
There are several different types of Bitcoin clients. EWallets are like banks -- a central organization has complete control over your money. You shouldn't put much money in EWallets.
Advertised sites are not endorsed by the Bitcoin Forum. They may be unsafe, untrustworthy, or illegal in your jurisdiction. Advertise here.
1474959654
Hero Member
*
Offline Offline

Posts: 1474959654

View Profile Personal Message (Offline)

Ignore
1474959654
Reply with quote  #2

1474959654
Report to moderator
tcatm
Sr. Member
****
Offline Offline

Activity: 337


View Profile
October 27, 2010, 09:45:22 PM
 #2

Thanks!

Here's a small python script to split the data into seperate files for each market:

Code:
import csv

trades = csv.reader(open('trades.csv'), delimiter=',', quotechar='"')

data = {}

for r in trades:
  if r[0] == "currency":
    continue

  if not r[0] in data:
    data[r[0]] = []

  data[r[0]].append([r[1], r[2], r[3]])

for m, d in data.iteritems():
  f = open(m + '.dat', 'w')
  for e in d:
    f.write(" ".join(e) + '\n')

  f.close()

Edit:

trades.csv plotted:

grondilu
Legendary
*
Offline Offline

Activity: 1134


View Profile
October 27, 2010, 10:09:22 PM
 #3

Bitcoin Watch is now making available per-trade historical data for mtgox, bitcoinmarket PPUSD, bitcoinmarket LRUSD and bitcoinmarket PGAU.  It's in CSV text format, zipped:

     http://www.bitcoinwatch.com/trades.zip

Robot authors, please do not poll this more than once a day.  Do not consider this a real-time feed.  You do not need to download the entire history of bitcoin every 5 minutes!  If you need a real-time feed, please connect directly to the marketplace tickers themselves.

Cool.  I'm going to have some fun writing a bash/gnuplot script in order to print a graph of that.

Edit.  I like the format of the datetime Wink

Edit bis.  Here is some code :
Code:
#!/bin/bash

cd /tmp
f=trades.csv

if ! [[ -f "$f" ]]  ||  (( $(stat -c %X "$f") < $(date +%s) - 3600*24 ))
then
    wget http://www.bitcoinwatch.com/trades.zip
    unzip trades.zip
fi

tail -n +2 "$f" |
cut -d, -f1 |
sort -u |
{
    declare -a currency

    while read c
    do
        currency+=("$c")
        grep "$c" $f |
        cut -d, -f 2,3 |
        sed -re 's/"//g; s/,/ /g' > "${c//\"/}"
    done

    [[ -z "$DISPLAY" ]] &&
        echo "set terminal png ; set output 'btc-graph.png'"
    IFS=,
    echo "
    set xtics 5e6
    set style data lines
    plot ${currency[*]}
    "
} |
gnuplot -p &&
[[ -z "$DISPLAY" ]] &&
fim  'btc-graph.png'


FreeMoney
Legendary
*
Offline Offline

Activity: 1246


Strength in numbers


View Profile WWW
October 28, 2010, 07:04:28 AM
 #4

Thanks for the graph, tcatm.

Play Bitcoin Poker at sealswithclubs.eu. We're active and open to everyone.
tcatm
Sr. Member
****
Offline Offline

Activity: 337


View Profile
November 03, 2010, 11:00:45 PM
 #5

I made a small webpage with interactive graphs for all markets provided by bitcoinwatch:
http://91.194.85.252/bitcoincharts/
S3052
Legendary
*
Offline Offline

Activity: 1918


BTC Up or Down? go to www.bullbearanalytics.com


View Profile WWW
November 03, 2010, 11:33:54 PM
 #6

fantastic!!!!!!!!!!!!!!
Now we see intraday volumes. I will use your charts probably in the next technical update.

>15years analysis experience

Always do your own due diligence & consult your financial advisor. Never invest unless you can afford to lose your entire investment.

http://twitter.com/BitcoinAnalyst

Subscribe here
tcatm
Sr. Member
****
Offline Offline

Activity: 337


View Profile
November 04, 2010, 03:42:32 AM
 #7

More graphs at http://91.194.85.252/cgi-bin/form.pl (data might be incorrect sometimes, still under development)
error
Hero Member
*****
Offline Offline

Activity: 574



View Profile
May 24, 2011, 05:12:04 AM
 #8

Bitcoin Watch is now making available per-trade historical data for mtgox, bitcoinmarket PPUSD, bitcoinmarket LRUSD and bitcoinmarket PGAU.  It's in CSV text format, zipped:

     http://www.bitcoinwatch.com/trades.zip

Robot authors, please do not poll this more than once a day.  Do not consider this a real-time feed.  You do not need to download the entire history of bitcoin every 5 minutes!  If you need a real-time feed, please connect directly to the marketplace tickers themselves.

404.

Whatever happened to this? I suddenly developed a need for old historical data. Thanks!

15UFyv6kfWgq83Pp3yhXPr8rknv9m6581W
Fireball
Hero Member
*****
Offline Offline

Activity: 673


View Profile WWW
August 13, 2011, 01:21:07 PM
 #9

So is exportable trade history data (ticker or 1 min or at least 5 min) available from anywhere?

Margin trading platform OrderBook.net (ICBIT): https://orderbook.net
Follow us in Twitter: https://twitter.com/orderbooknet
tcatm
Sr. Member
****
Offline Offline

Activity: 337


View Profile
August 13, 2011, 02:15:06 PM
 #10

So is exportable trade history data (ticker or 1 min or at least 5 min) available from anywhere?

Yes: http://bitcoincharts.com/about/markets-api/ (I re-enabled full history download last night)
Fireball
Hero Member
*****
Offline Offline

Activity: 673


View Profile WWW
August 17, 2011, 09:08:47 AM
 #11

Cool, thank you! Maybe I should provide a mirror to reduce load on your server.

Margin trading platform OrderBook.net (ICBIT): https://orderbook.net
Follow us in Twitter: https://twitter.com/orderbooknet
Pages: [1]
  Print  
 
Jump to:  

Sponsored by , a Bitcoin-accepting VPN.
Powered by MySQL Powered by PHP Powered by SMF 1.1.19 | SMF © 2006-2009, Simple Machines Valid XHTML 1.0! Valid CSS!