PREVIEW / stock_1min / 2011-06-09

all stock 1-min files

  file:    by_date/stock_1min/2011/2011-06-09.parquet
  size:    13.1 MB
  rows:    993,590
  symbols: 2,874

schema

  timestamp    TIMESTAMP
  symbol       VARCHAR
  asset_type   VARCHAR
  open         DOUBLE
  high         DOUBLE
  low          DOUBLE
  close        DOUBLE
  volume       DOUBLE

sample rows

timestamp	symbol	asset_type	open	high	low	close	volume
2011-06-09 04:05:00	AAPL	Stock	11.9054	11.9054	11.9054	11.9054	2800.0
2011-06-09 04:06:00	AAPL	Stock	11.9125	11.9125	11.9125	11.9125	8400.0
2011-06-09 04:58:00	AAPL	Stock	11.91	11.91	11.91	11.91	2800.0
2011-06-09 06:43:00	AAPL	Stock	11.9054	11.9054	11.9054	11.9054	5600.0
2011-06-09 07:03:00	AAPL	Stock	11.8929	11.8929	11.8929	11.8929	2800.0
2011-06-09 07:43:00	AAPL	Stock	11.8896	11.8929	11.8896	11.8929	8400.0
2011-06-09 07:58:00	AAPL	Stock	11.8929	11.8929	11.8929	11.8929	19600.0
2011-06-09 08:00:00	AAPL	Stock	11.8911	11.8911	11.8911	11.8911	10780.0
2011-06-09 08:01:00	AAPL	Stock	11.8964	11.8964	11.8964	11.8964	2800.0
2011-06-09 08:02:00	AAPL	Stock	11.8968	11.8996	11.8968	11.8996	31920.0
2011-06-09 08:03:00	AAPL	Stock	11.8982	11.8982	11.8964	11.8964	28000.0
2011-06-09 08:05:00	AAPL	Stock	11.8989	11.8989	11.8989	11.8989	2800.0
2011-06-09 08:06:00	AAPL	Stock	11.8993	11.8993	11.8993	11.8993	2800.0
2011-06-09 08:07:00	AAPL	Stock	11.8929	11.8929	11.8929	11.8929	12376.0
2011-06-09 08:08:00	AAPL	Stock	11.8929	11.8929	11.8929	11.8929	16800.0
2011-06-09 08:09:00	AAPL	Stock	11.8893	11.8893	11.8893	11.8893	2800.0
2011-06-09 08:11:00	AAPL	Stock	11.8893	11.8893	11.8893	11.8893	4200.0
2011-06-09 08:17:00	AAPL	Stock	11.8871	11.8871	11.875	11.875	49084.0
2011-06-09 08:20:00	AAPL	Stock	11.8761	11.8761	11.8761	11.8761	5600.0
2011-06-09 08:21:00	AAPL	Stock	11.8761	11.8761	11.8761	11.8761	8400.0
2011-06-09 08:23:00	AAPL	Stock	11.8889	11.8893	11.8889	11.8893	19600.0
2011-06-09 08:24:00	AAPL	Stock	11.8893	11.8911	11.8771	11.8911	38360.0
2011-06-09 08:28:00	AAPL	Stock	11.8793	11.8793	11.8786	11.8786	16800.0
2011-06-09 08:29:00	AAPL	Stock	11.8807	11.8807	11.88	11.88	28000.0
2011-06-09 08:30:00	AAPL	Stock	11.8793	11.8804	11.8571	11.8575	73780.0
2011-06-09 08:31:00	AAPL	Stock	11.8679	11.8679	11.8679	11.8679	2800.0
2011-06-09 08:32:00	AAPL	Stock	11.875	11.8875	11.875	11.8875	18760.0
2011-06-09 08:33:00	AAPL	Stock	11.8886	11.8964	11.8886	11.8932	52920.0
2011-06-09 08:34:00	AAPL	Stock	11.8971	11.9054	11.8957	11.9011	127428.0
2011-06-09 08:35:00	AAPL	Stock	11.9011	11.9025	11.8943	11.8961	103600.0
2011-06-09 08:36:00	AAPL	Stock	11.8968	11.8979	11.8832	11.8832	66444.0
2011-06-09 08:37:00	AAPL	Stock	11.8868	11.8929	11.8839	11.8911	63000.0
2011-06-09 08:38:00	AAPL	Stock	11.8929	11.8929	11.8857	11.8893	68880.0
2011-06-09 08:41:00	AAPL	Stock	11.8871	11.8875	11.8871	11.8875	11200.0
2011-06-09 08:42:00	AAPL	Stock	11.8929	11.8929	11.8921	11.8921	9380.0
2011-06-09 08:43:00	AAPL	Stock	11.885	11.8918	11.875	11.8807	82936.0
2011-06-09 08:44:00	AAPL	Stock	11.8864	11.8864	11.8839	11.8846	8400.0
2011-06-09 08:45:00	AAPL	Stock	11.8857	11.8889	11.8693	11.8693	79184.0
2011-06-09 08:46:00	AAPL	Stock	11.8643	11.875	11.8607	11.875	86268.0
2011-06-09 08:47:00	AAPL	Stock	11.8768	11.8768	11.8768	11.8768	14000.0
2011-06-09 08:49:00	AAPL	Stock	11.875	11.875	11.875	11.875	5600.0
2011-06-09 08:51:00	AAPL	Stock	11.8725	11.8793	11.8725	11.8793	12600.0
2011-06-09 08:52:00	AAPL	Stock	11.8768	11.8814	11.8725	11.8814	127540.0
2011-06-09 08:53:00	AAPL	Stock	11.8729	11.8825	11.8729	11.8821	30800.0
2011-06-09 08:54:00	AAPL	Stock	11.8757	11.8757	11.8757	11.8757	3248.0
2011-06-09 08:55:00	AAPL	Stock	11.8814	11.8814	11.8814	11.8814	2800.0
2011-06-09 08:56:00	AAPL	Stock	11.8825	11.8825	11.8825	11.8825	2800.0
2011-06-09 08:57:00	AAPL	Stock	11.8825	11.8825	11.8825	11.8825	2800.0
2011-06-09 08:58:00	AAPL	Stock	11.8825	11.8857	11.8825	11.8825	18200.0
2011-06-09 09:00:00	AAPL	Stock	11.8893	11.8893	11.8893	11.8893	2800.0

> showing 50 of 993,590 rows — these rows as CSV

> unlock the full archive -- $79 one-time