Bitcoin Forum
June 25, 2018, 08:14:04 PM *
News: Latest stable version of Bitcoin Core: 0.16.1  [Torrent]. (New!)
 
   Home   Help Search Donate Login Register  
Pages: [1]
  Print  
Author Topic: Bitcoin Watch: historical trade data  (Read 9942 times)
jgarzik
Legendary
*
Offline Offline

Activity: 1554
Merit: 1001


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, Bloq CEO, former bitcoin core dev team; opinions are my own.
Visit bloq.com / metronome.io
Donations / tip jar: 1BrufViLKnSWtuWGkryPsKsxonV2NQ7Tcj
1529957644
Hero Member
*
Offline Offline

Posts: 1529957644

View Profile Personal Message (Offline)

Ignore
1529957644
Reply with quote  #2

1529957644
Report to moderator
1529957644
Hero Member
*
Offline Offline

Posts: 1529957644

View Profile Personal Message (Offline)

Ignore
1529957644
Reply with quote  #2

1529957644
Report to moderator
The World's Betting Exchange

Bet with play money. Win real Bitcoin. 5BTC Prize Fund for World Cup 2018.

Advertised sites are not endorsed by the Bitcoin Forum. They may be unsafe, untrustworthy, or illegal in your jurisdiction. Advertise here.
1529957644
Hero Member
*
Offline Offline

Posts: 1529957644

View Profile Personal Message (Offline)

Ignore
1529957644
Reply with quote  #2

1529957644
Report to moderator
1529957644
Hero Member
*
Offline Offline

Posts: 1529957644

View Profile Personal Message (Offline)

Ignore
1529957644
Reply with quote  #2

1529957644
Report to moderator
1529957644
Hero Member
*
Offline Offline

Posts: 1529957644

View Profile Personal Message (Offline)

Ignore
1529957644
Reply with quote  #2

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

Activity: 337
Merit: 250


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
Merit: 1001


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
Merit: 1000


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
Merit: 250


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: 2100
Merit: 1000


View Profile
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.

tcatm
Sr. Member
****
Offline Offline

Activity: 337
Merit: 250


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: 588
Merit: 500



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!

3KzNGwzRZ6SimWuFAgh4TnXzHpruHMZmV8
Fireball
Hero Member
*****
Offline Offline

Activity: 673
Merit: 500


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
Merit: 250


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
Merit: 500


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!