Bitcoin Forum
March 04, 2015, 08:34:18 AM *
News: Latest stable version of Bitcoin Core: 0.10.0 [Torrent] (New!)
 
   Home   Help Search Donate Login Register  
Pages: [1]
  Print  
Author Topic: Bitcoin Watch: historical trade data  (Read 8227 times)
jgarzik
Legendary
*
Offline Offline

Activity: 1442


View Profile

Ignore
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
1425458058
Hero Member
*
Offline Offline

Posts: 1425458058

View Profile Personal Message (Offline)

Ignore
1425458058
Reply with quote  #2

1425458058
Report to moderator
1425458058
Hero Member
*
Offline Offline

Posts: 1425458058

View Profile Personal Message (Offline)

Ignore
1425458058
Reply with quote  #2

1425458058
Report to moderator
1425458058
Hero Member
*
Offline Offline

Posts: 1425458058

View Profile Personal Message (Offline)

Ignore
1425458058
Reply with quote  #2

1425458058
Report to moderator
HASHNEST.COM The Largest Cloud Mining
Contract In The World

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

Posts: 1425458058

View Profile Personal Message (Offline)

Ignore
1425458058
Reply with quote  #2

1425458058
Report to moderator
1425458058
Hero Member
*
Offline Offline

Posts: 1425458058

View Profile Personal Message (Offline)

Ignore
1425458058
Reply with quote  #2

1425458058
Report to moderator
1425458058
Hero Member
*
Offline Offline

Posts: 1425458058

View Profile Personal Message (Offline)

Ignore
1425458058
Reply with quote  #2

1425458058
Report to moderator
1425458058
Hero Member
*
Offline Offline

Posts: 1425458058

View Profile Personal Message (Offline)

Ignore
1425458058
Reply with quote  #2

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

Activity: 337


View Profile

Ignore
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

Ignore
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

Ignore
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

Ignore
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: 1582


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


View Profile WWW

Ignore
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

Ignore
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

Ignore
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: 665


View Profile WWW

Ignore
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

Ignore
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: 665


View Profile WWW

Ignore
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!