Skip to content

Instantly share code, notes, and snippets.

@marshluca

marshluca/prices.sql Secret

Last active January 20, 2016 04:39
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save marshluca/1d3a6aaedfe166f28d99 to your computer and use it in GitHub Desktop.
Save marshluca/1d3a6aaedfe166f28d99 to your computer and use it in GitHub Desktop.
Download ZIP
bitcoin order book
Raw
prices.sql
mysql> select * from pricings where source='btcchina_ob' order by pricing_id desc limit 10;
+------------+-------------+---------------------+---------------------+--------------------+--------------------+--------------------+----------+-------+
| pricing_id | source | remote_ts | local_ts | price_last | price_bid1 | price_ask1 | currency | notes |
+------------+-------------+---------------------+---------------------+--------------------+--------------------+--------------------+----------+-------+
| 1025024 | btcchina_ob | 2015-08-12 09:45:31 | 2015-08-12 09:39:11 | 1700.6033527913733 | 1699.0876049494914 | 1702.1191006332551 | CNY | NULL |
| 1025014 | btcchina_ob | 2015-08-12 09:45:00 | 2015-08-12 09:38:41 | 1700.461464680406 | 1698.8038287275567 | 1702.1191006332551 | CNY | NULL |
| 1025007 | btcchina_ob | 2015-08-12 09:44:28 | 2015-08-12 09:38:11 | 1700.5463038790892 | 1698.8860604081324 | 1702.206547350046 | CNY | NULL |
| 1024997 | btcchina_ob | 2015-08-12 09:44:01 | 2015-08-12 09:37:41 | 1700.4095699731608 | 1698.8171872535102 | 1702.0019526928115 | CNY | NULL |
| 1024988 | btcchina_ob | 2015-08-12 09:43:23 | 2015-08-12 09:37:11 | 1700.1756807429629 | 1698.3661723630466 | 1701.985189122879 | CNY | NULL |
| 1024984 | btcchina_ob | 2015-08-12 09:42:52 | 2015-08-12 09:36:41 | 1700.1378143144386 | 1698.2571365585964 | 1702.018492070281 | CNY | NULL |
| 1024975 | btcchina_ob | 2015-08-12 09:42:22 | 2015-08-12 09:36:11 | 1699.6758455703325 | 1697.6579436866234 | 1701.6937474540416 | CNY | NULL |
| 1024967 | btcchina_ob | 2015-08-12 09:42:01 | 2015-08-12 09:35:40 | 1700.033466725469 | 1698.1704980482662 | 1701.8964354026718 | CNY | NULL |
| 1024959 | btcchina_ob | 2015-08-12 09:41:31 | 2015-08-12 09:35:11 | 1699.8741300960182 | 1698.0913672230074 | 1701.656892969029 | CNY | NULL |
| 1024950 | btcchina_ob | 2015-08-12 09:40:52 | 2015-08-12 09:34:40 | 1700.0817983718312 | 1698.4508164555712 | 1701.712780288091 | CNY | NULL |
+------------+-------------+---------------------+---------------------+--------------------+--------------------+--------------------+----------+-------+
10 rows in set (0.00 sec)
mysql> select * from pricings where source='bitfinex_ob' order by pricing_id desc limit 10;
+------------+-------------+---------------------+---------------------+--------------------+--------------------+--------------------+----------+-------+
| pricing_id | source | remote_ts | local_ts | price_last | price_bid1 | price_ask1 | currency | notes |
+------------+-------------+---------------------+---------------------+--------------------+--------------------+--------------------+----------+-------+
| 1025016 | bitfinex_ob | 1970-01-01 00:00:00 | 2015-08-12 09:38:41 | 269.165 | 269.16 | 269.17 | USD | NULL |
| 1025008 | bitfinex_ob | 1970-01-01 00:00:00 | 2015-08-12 09:38:12 | 269.1757644831075 | 269.16 | 269.19152896621495 | USD | NULL |
| 1024999 | bitfinex_ob | 1970-01-01 00:00:00 | 2015-08-12 09:37:41 | 269.165 | 269.16 | 269.17 | USD | NULL |
| 1024990 | bitfinex_ob | 1970-01-01 00:00:00 | 2015-08-12 09:37:11 | 269.1698192146015 | 269.16 | 269.17963842920295 | USD | NULL |
| 1024970 | bitfinex_ob | 1970-01-01 00:00:00 | 2015-08-12 09:35:41 | 269.165 | 269.16 | 269.17 | USD | NULL |
| 1024961 | bitfinex_ob | 1970-01-01 00:00:00 | 2015-08-12 09:35:12 | 269.18254089571496 | 269.16 | 269.20508179142996 | USD | NULL |
| 1024952 | bitfinex_ob | 1970-01-01 00:00:00 | 2015-08-12 09:34:41 | 269.190613671459 | 269.16 | 269.2212273429179 | USD | NULL |
| 1024942 | bitfinex_ob | 1970-01-01 00:00:00 | 2015-08-12 09:34:11 | 269.195516516918 | 269.15500760866155 | 269.2360254251745 | USD | NULL |
| 1024935 | bitfinex_ob | 1970-01-01 00:00:00 | 2015-08-12 09:33:41 | 269.07320539549994 | 268.94361753005785 | 269.202793260942 | USD | NULL |
| 1024928 | bitfinex_ob | 1970-01-01 00:00:00 | 2015-08-12 09:33:12 | 269.05415865110973 | 268.94472567548013 | 269.16359162673933 | USD | NULL |
+------------+-------------+---------------------+---------------------+--------------------+--------------------+--------------------+----------+-------+
10 rows in set (0.00 sec)
mysql> select pricing_id,source,remote_ts,local_ts,price_last,price_bid1,price_ask1, currency from pricings where source='btcchina_bitfinex_ob' order by pricing_id desc limit 10;
+------------+----------------------+---------------------+---------------------+-------------------+-------------------+-------------------+----------+
| pricing_id | source | remote_ts | local_ts | price_last | price_bid1 | price_ask1 | currency |
+------------+----------------------+---------------------+---------------------+-------------------+-------------------+-------------------+----------+
| 1025108 | btcchina_bitfinex_ob | 1970-01-01 00:00:00 | 2015-08-12 09:43:43 | 8642.450509717957 | 8638.96 | 8645.941019435915 | TWD |
| 1025101 | btcchina_bitfinex_ob | 1970-01-01 00:00:00 | 2015-08-12 09:43:13 | 8645.10758179352 | 8643.355163587037 | 8646.86 | TWD |
| 1025092 | btcchina_bitfinex_ob | 1970-01-01 00:00:00 | 2015-08-12 09:42:42 | 8642.489037071035 | 8639.93 | 8645.048074142067 | TWD |
| 1025082 | btcchina_bitfinex_ob | 1970-01-01 00:00:00 | 2015-08-12 09:42:13 | 8646.320065488233 | 8645.74 | 8646.900130976466 | TWD |
| 1025071 | btcchina_bitfinex_ob | 1970-01-01 00:00:00 | 2015-08-12 09:41:42 | 8655.709473957482 | 8646.158655199888 | 8665.260292715077 | TWD |
| 1025063 | btcchina_bitfinex_ob | 1970-01-01 00:00:00 | 2015-08-12 09:41:12 | 8657.359386115524 | 8649.29 | 8665.428772231046 | TWD |
| 1025047 | btcchina_bitfinex_ob | 1970-01-01 00:00:00 | 2015-08-12 09:40:12 | 8658.834417266873 | 8652.2 | 8665.468834533745 | TWD |
| 1025036 | btcchina_bitfinex_ob | 1970-01-01 00:00:00 | 2015-08-12 09:39:42 | 8662.256328916335 | 8657.69 | 8666.82265783267 | TWD |
| 1025027 | btcchina_bitfinex_ob | 1970-01-01 00:00:00 | 2015-08-12 09:39:12 | 8659.965455030404 | 8653.17 | 8666.760910060806 | TWD |
| 1025018 | btcchina_bitfinex_ob | 1970-01-01 00:00:00 | 2015-08-12 09:38:42 | 8658.834417266873 | 8652.2 | 8665.468834533745 | TWD |
+------------+----------------------+---------------------+---------------------+-------------------+-------------------+-------------------+----------+
10 rows in set (0.00 sec)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment