PREVIEW / stock_1min / 2011-07-18

all stock 1-min files

  file:    by_date/stock_1min/2011/2011-07-18.parquet
  size:    13.1 MB
  rows:    980,670
  symbols: 2,863

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-18 04:00:00	AAPL	Stock	13.0571	13.0571	12.9961	12.9961	22400.0
2011-07-18 04:23:00	AAPL	Stock	12.9961	12.9961	12.9961	12.9961	2800.0
2011-07-18 04:26:00	AAPL	Stock	12.9857	12.9857	12.9857	12.9857	2800.0
2011-07-18 04:35:00	AAPL	Stock	12.9929	12.9929	12.9929	12.9929	2800.0
2011-07-18 04:41:00	AAPL	Stock	12.9929	12.9929	12.9929	12.9929	2800.0
2011-07-18 04:45:00	AAPL	Stock	12.9893	12.9893	12.9893	12.9893	2800.0
2011-07-18 04:46:00	AAPL	Stock	12.9643	12.9643	12.9643	12.9643	2800.0
2011-07-18 04:53:00	AAPL	Stock	12.9893	12.9893	12.9893	12.9893	5600.0
2011-07-18 05:21:00	AAPL	Stock	12.9893	12.9893	12.9893	12.9893	2800.0
2011-07-18 05:23:00	AAPL	Stock	12.9893	12.9893	12.9893	12.9893	2800.0
2011-07-18 05:24:00	AAPL	Stock	12.9893	12.9893	12.9893	12.9893	13972.0
2011-07-18 05:35:00	AAPL	Stock	12.9929	12.9929	12.9929	12.9929	2800.0
2011-07-18 05:37:00	AAPL	Stock	12.9982	12.9982	12.9982	12.9982	2800.0
2011-07-18 05:54:00	AAPL	Stock	12.9929	12.9929	12.9929	12.9929	2800.0
2011-07-18 05:55:00	AAPL	Stock	12.9929	12.9929	12.9929	12.9929	2800.0
2011-07-18 06:02:00	AAPL	Stock	12.9929	12.9929	12.9929	12.9929	5600.0
2011-07-18 06:40:00	AAPL	Stock	12.9829	12.9829	12.9829	12.9829	2800.0
2011-07-18 06:44:00	AAPL	Stock	12.9893	13.0	12.9893	12.9982	41020.0
2011-07-18 06:45:00	AAPL	Stock	12.9982	12.9982	12.9982	12.9982	2800.0
2011-07-18 06:46:00	AAPL	Stock	13.0043	13.0089	13.0043	13.0089	11200.0
2011-07-18 06:53:00	AAPL	Stock	13.0043	13.0043	13.0043	13.0043	19600.0
2011-07-18 06:59:00	AAPL	Stock	12.9736	12.9739	12.9736	12.9739	28000.0
2011-07-18 07:00:00	AAPL	Stock	13.0	13.0	13.0	13.0	8400.0
2011-07-18 07:01:00	AAPL	Stock	13.0143	13.0143	13.0143	13.0143	2940.0
2011-07-18 07:02:00	AAPL	Stock	13.0161	13.0175	13.0161	13.0175	5600.0
2011-07-18 07:03:00	AAPL	Stock	13.0179	13.0179	13.0179	13.0179	2800.0
2011-07-18 07:04:00	AAPL	Stock	13.0179	13.0179	13.0179	13.0179	3192.0
2011-07-18 07:05:00	AAPL	Stock	13.0268	13.0268	13.0268	13.0268	2800.0
2011-07-18 07:06:00	AAPL	Stock	13.0268	13.0268	13.0268	13.0268	5600.0
2011-07-18 07:07:00	AAPL	Stock	13.0268	13.0268	13.0268	13.0268	2800.0
2011-07-18 07:08:00	AAPL	Stock	13.0214	13.0289	13.0214	13.0286	13300.0
2011-07-18 07:09:00	AAPL	Stock	13.0286	13.0286	13.025	13.025	36400.0
2011-07-18 07:10:00	AAPL	Stock	13.0268	13.0268	13.025	13.025	28000.0
2011-07-18 07:11:00	AAPL	Stock	13.0246	13.0286	13.0246	13.0286	5600.0
2011-07-18 07:13:00	AAPL	Stock	13.02	13.02	13.02	13.02	2800.0
2011-07-18 07:14:00	AAPL	Stock	13.0204	13.0204	13.0186	13.0186	19600.0
2011-07-18 07:15:00	AAPL	Stock	13.0189	13.0189	13.0179	13.0179	78960.0
2011-07-18 07:16:00	AAPL	Stock	13.0204	13.0286	13.0204	13.0286	39200.0
2011-07-18 07:19:00	AAPL	Stock	13.0225	13.0225	13.0225	13.0225	12656.0
2011-07-18 07:20:00	AAPL	Stock	13.0221	13.0221	13.0214	13.0221	25200.0
2011-07-18 07:22:00	AAPL	Stock	13.0193	13.0193	13.0111	13.0111	13160.0
2011-07-18 07:23:00	AAPL	Stock	13.015	13.0193	13.015	13.0193	14000.0
2011-07-18 07:24:00	AAPL	Stock	13.0189	13.0189	13.0089	13.0089	16156.0
2011-07-18 07:25:00	AAPL	Stock	13.0071	13.0071	13.0	13.0	33600.0
2011-07-18 07:26:00	AAPL	Stock	13.0004	13.0004	12.9918	12.9918	14000.0
2011-07-18 07:27:00	AAPL	Stock	12.9918	12.9918	12.9896	12.9896	11200.0
2011-07-18 07:28:00	AAPL	Stock	12.9918	12.9918	12.9918	12.9918	11564.0
2011-07-18 07:29:00	AAPL	Stock	12.9843	12.995	12.9843	12.995	16800.0
2011-07-18 07:30:00	AAPL	Stock	12.9961	12.9964	12.9961	12.9964	14280.0
2011-07-18 07:31:00	AAPL	Stock	12.9964	12.9964	12.9861	12.9861	41720.0

> showing 50 of 980,670 rows — these rows as CSV

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