PREVIEW / stock_1min / 2011-07-20

all stock 1-min files

  file:    by_date/stock_1min/2011/2011-07-20.parquet
  size:    12.6 MB
  rows:    944,720
  symbols: 2,857

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-07-20 04:00:00	AAPL	Stock	14.0579	14.0579	13.9682	13.9682	13300.0
2011-07-20 04:02:00	AAPL	Stock	13.9646	13.9761	13.9646	13.9761	8400.0
2011-07-20 04:03:00	AAPL	Stock	13.9832	13.9932	13.9825	13.9825	19600.0
2011-07-20 04:04:00	AAPL	Stock	13.9971	14.0	13.9971	14.0	5600.0
2011-07-20 04:05:00	AAPL	Stock	14.0	14.0	13.9943	13.9943	14000.0
2011-07-20 04:06:00	AAPL	Stock	14.025	14.025	14.0179	14.0179	14000.0
2011-07-20 04:11:00	AAPL	Stock	14.0046	14.0046	13.9857	13.9857	14000.0
2011-07-20 04:12:00	AAPL	Stock	13.9921	13.9946	13.9921	13.9946	5600.0
2011-07-20 04:14:00	AAPL	Stock	13.9943	13.9964	13.9943	13.9964	7000.0
2011-07-20 04:15:00	AAPL	Stock	13.9964	13.9964	13.9964	13.9964	8400.0
2011-07-20 04:19:00	AAPL	Stock	13.9964	13.9964	13.9964	13.9964	5600.0
2011-07-20 04:22:00	AAPL	Stock	13.9911	13.9911	13.9911	13.9911	14000.0
2011-07-20 04:23:00	AAPL	Stock	13.9911	13.9911	13.9911	13.9911	2800.0
2011-07-20 04:25:00	AAPL	Stock	13.9911	13.9911	13.9911	13.9911	5600.0
2011-07-20 04:26:00	AAPL	Stock	13.9911	13.9911	13.9911	13.9911	5600.0
2011-07-20 04:27:00	AAPL	Stock	13.9911	13.9911	13.9911	13.9911	5600.0
2011-07-20 04:28:00	AAPL	Stock	13.9857	13.9857	13.9857	13.9857	5600.0
2011-07-20 04:29:00	AAPL	Stock	13.9893	13.9893	13.9893	13.9893	5600.0
2011-07-20 04:30:00	AAPL	Stock	13.9821	13.9821	13.9821	13.9821	8400.0
2011-07-20 04:35:00	AAPL	Stock	13.9843	13.9843	13.9804	13.9804	11200.0
2011-07-20 04:36:00	AAPL	Stock	13.9714	13.9818	13.9714	13.9818	14000.0
2011-07-20 04:38:00	AAPL	Stock	13.9714	13.9714	13.9714	13.9714	14000.0
2011-07-20 04:46:00	AAPL	Stock	13.9725	13.9725	13.9725	13.9725	2800.0
2011-07-20 04:47:00	AAPL	Stock	13.9654	13.9771	13.9654	13.9768	27720.0
2011-07-20 04:50:00	AAPL	Stock	13.9739	13.9739	13.9661	13.9661	8400.0
2011-07-20 04:52:00	AAPL	Stock	13.9646	13.9646	13.9643	13.9643	15400.0
2011-07-20 04:53:00	AAPL	Stock	13.9643	13.9643	13.9643	13.9643	2800.0
2011-07-20 04:54:00	AAPL	Stock	13.9643	13.9643	13.9643	13.9643	9772.0
2011-07-20 04:55:00	AAPL	Stock	13.95	13.95	13.95	13.95	2800.0
2011-07-20 04:59:00	AAPL	Stock	13.9643	13.9643	13.9639	13.9639	8400.0
2011-07-20 05:00:00	AAPL	Stock	13.9643	13.9643	13.9643	13.9643	2800.0
2011-07-20 05:01:00	AAPL	Stock	13.9643	13.9643	13.9643	13.9643	5600.0
2011-07-20 05:03:00	AAPL	Stock	13.9643	13.9643	13.9643	13.9643	8400.0
2011-07-20 05:04:00	AAPL	Stock	13.9571	13.9571	13.9571	13.9571	2800.0
2011-07-20 05:07:00	AAPL	Stock	13.9643	13.9643	13.9643	13.9643	2800.0
2011-07-20 05:08:00	AAPL	Stock	13.9646	13.9646	13.9646	13.9646	28000.0
2011-07-20 05:12:00	AAPL	Stock	13.9643	13.9643	13.9643	13.9643	2800.0
2011-07-20 05:13:00	AAPL	Stock	13.9486	13.9486	13.9486	13.9486	5600.0
2011-07-20 05:14:00	AAPL	Stock	13.9464	13.9464	13.9464	13.9464	2800.0
2011-07-20 05:15:00	AAPL	Stock	13.9361	13.9361	13.9361	13.9361	2800.0
2011-07-20 05:24:00	AAPL	Stock	13.9575	13.9575	13.9382	13.9382	5600.0
2011-07-20 05:25:00	AAPL	Stock	13.9579	13.9654	13.9579	13.9654	14000.0
2011-07-20 05:26:00	AAPL	Stock	13.9621	13.9621	13.9621	13.9621	8400.0
2011-07-20 05:27:00	AAPL	Stock	13.9639	13.9639	13.9639	13.9639	2800.0
2011-07-20 05:28:00	AAPL	Stock	13.9521	13.9521	13.9521	13.9521	2800.0
2011-07-20 05:29:00	AAPL	Stock	13.9714	13.9714	13.9714	13.9714	8400.0
2011-07-20 05:31:00	AAPL	Stock	13.9786	13.9786	13.9786	13.9786	13888.0
2011-07-20 05:35:00	AAPL	Stock	13.9889	13.9889	13.9889	13.9889	2800.0
2011-07-20 05:37:00	AAPL	Stock	13.9889	13.9893	13.9786	13.9786	14000.0
2011-07-20 05:38:00	AAPL	Stock	13.9786	13.9786	13.9786	13.9786	9912.0

> showing 50 of 944,720 rows — these rows as CSV

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