PREVIEW / stock_1min / 2014-02-11

all stock 1-min files

  file:    by_date/stock_1min/2014/2014-02-11.parquet
  size:    14.9 MB
  rows:    1,069,383
  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
2014-02-11 04:00:00	AAPL	Stock	18.975	19.0	18.975	19.0	5600.0
2014-02-11 04:28:00	AAPL	Stock	18.9843	18.9843	18.9843	18.9843	2800.0
2014-02-11 05:03:00	AAPL	Stock	18.9893	18.9893	18.9893	18.9893	2800.0
2014-02-11 05:39:00	AAPL	Stock	18.9914	18.9914	18.9914	18.9914	2800.0
2014-02-11 05:48:00	AAPL	Stock	18.9893	18.9893	18.9821	18.9821	30800.0
2014-02-11 06:15:00	AAPL	Stock	18.9611	18.9611	18.9611	18.9611	2800.0
2014-02-11 06:19:00	AAPL	Stock	18.9546	18.9546	18.9546	18.9546	12152.0
2014-02-11 06:23:00	AAPL	Stock	18.9493	18.9493	18.9493	18.9493	2800.0
2014-02-11 06:30:00	AAPL	Stock	18.9493	18.9493	18.9493	18.9493	8400.0
2014-02-11 06:41:00	AAPL	Stock	18.9546	18.9546	18.9546	18.9546	2800.0
2014-02-11 06:44:00	AAPL	Stock	18.9546	18.9546	18.9529	18.9529	8400.0
2014-02-11 06:46:00	AAPL	Stock	18.9525	18.9546	18.9525	18.9546	8120.0
2014-02-11 07:02:00	AAPL	Stock	18.9607	18.9607	18.9607	18.9607	5600.0
2014-02-11 07:07:00	AAPL	Stock	18.9464	18.9464	18.9464	18.9464	2800.0
2014-02-11 07:08:00	AAPL	Stock	18.9471	18.9521	18.9471	18.9521	5600.0
2014-02-11 07:25:00	AAPL	Stock	18.9604	18.9604	18.9604	18.9604	2800.0
2014-02-11 07:27:00	AAPL	Stock	18.9582	18.9639	18.9557	18.9639	22820.0
2014-02-11 07:28:00	AAPL	Stock	18.9643	18.9643	18.9643	18.9643	22400.0
2014-02-11 07:29:00	AAPL	Stock	18.9643	18.9643	18.9643	18.9643	5600.0
2014-02-11 07:30:00	AAPL	Stock	18.9536	18.9536	18.9536	18.9536	2800.0
2014-02-11 07:31:00	AAPL	Stock	18.9518	18.9518	18.9518	18.9518	19600.0
2014-02-11 07:32:00	AAPL	Stock	18.9518	18.9518	18.9518	18.9518	8400.0
2014-02-11 07:34:00	AAPL	Stock	18.9464	18.9464	18.9464	18.9464	19600.0
2014-02-11 07:42:00	AAPL	Stock	18.95	18.95	18.95	18.95	5600.0
2014-02-11 07:43:00	AAPL	Stock	18.9496	18.9496	18.9496	18.9496	2800.0
2014-02-11 07:44:00	AAPL	Stock	18.95	18.95	18.95	18.95	8400.0
2014-02-11 07:45:00	AAPL	Stock	18.9464	18.9464	18.9329	18.9329	14364.0
2014-02-11 07:47:00	AAPL	Stock	18.9393	18.9393	18.9393	18.9393	2800.0
2014-02-11 07:50:00	AAPL	Stock	18.9461	18.9464	18.9461	18.9464	19096.0
2014-02-11 07:52:00	AAPL	Stock	18.9354	18.9354	18.9354	18.9354	11200.0
2014-02-11 07:53:00	AAPL	Stock	18.9393	18.9393	18.9393	18.9393	2800.0
2014-02-11 07:57:00	AAPL	Stock	18.9393	18.9446	18.9393	18.9446	24500.0
2014-02-11 07:58:00	AAPL	Stock	18.9393	18.9393	18.9393	18.9393	8400.0
2014-02-11 08:00:00	AAPL	Stock	18.9329	18.9607	18.9314	18.9325	126560.0
2014-02-11 08:02:00	AAPL	Stock	18.9393	18.9393	18.9357	18.9357	14028.0
2014-02-11 08:03:00	AAPL	Stock	18.9393	18.9393	18.9325	18.9339	8400.0
2014-02-11 08:04:00	AAPL	Stock	18.9332	18.9393	18.9329	18.9329	14000.0
2014-02-11 08:05:00	AAPL	Stock	18.9325	18.9325	18.9321	18.9321	14000.0
2014-02-11 08:06:00	AAPL	Stock	18.9286	18.9286	18.9286	18.9286	49140.0
2014-02-11 08:09:00	AAPL	Stock	18.9279	18.9279	18.9279	18.9279	2800.0
2014-02-11 08:12:00	AAPL	Stock	18.9214	18.9214	18.9214	18.9214	2800.0
2014-02-11 08:13:00	AAPL	Stock	18.9246	18.9246	18.9246	18.9246	5600.0
2014-02-11 08:14:00	AAPL	Stock	18.9271	18.9286	18.9221	18.9286	22344.0
2014-02-11 08:15:00	AAPL	Stock	18.9286	18.9318	18.9286	18.9318	68852.0
2014-02-11 08:16:00	AAPL	Stock	18.9321	18.9321	18.9321	18.9321	2800.0
2014-02-11 08:17:00	AAPL	Stock	18.9321	18.9321	18.9321	18.9321	2800.0
2014-02-11 08:18:00	AAPL	Stock	18.9318	18.9357	18.9318	18.9357	42000.0
2014-02-11 08:20:00	AAPL	Stock	18.9389	18.9389	18.9357	18.9375	11200.0
2014-02-11 08:21:00	AAPL	Stock	18.9357	18.9357	18.9357	18.9357	2800.0
2014-02-11 08:23:00	AAPL	Stock	18.9393	18.9393	18.9393	18.9393	19768.0

> showing 50 of 1,069,383 rows — these rows as CSV

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