PREVIEW / stock_1min / 2014-08-14

all stock 1-min files

  file:    by_date/stock_1min/2014/2014-08-14.parquet
  size:    13.5 MB
  rows:    997,796
  symbols: 2,918

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-08-14 04:16:00	AAPL	Stock	24.3125	24.3125	24.3125	24.3125	1900.0
2014-08-14 04:35:00	AAPL	Stock	24.335	24.3375	24.335	24.3375	10160.0
2014-08-14 05:00:00	AAPL	Stock	24.33	24.3425	24.33	24.3425	2320.0
2014-08-14 05:16:00	AAPL	Stock	24.3425	24.3425	24.3425	24.3425	400.0
2014-08-14 05:26:00	AAPL	Stock	24.33	24.33	24.33	24.33	4568.0
2014-08-14 05:27:00	AAPL	Stock	24.33	24.33	24.33	24.33	2400.0
2014-08-14 05:32:00	AAPL	Stock	24.3425	24.3425	24.3425	24.3425	400.0
2014-08-14 05:37:00	AAPL	Stock	24.3425	24.3425	24.3425	24.3425	1200.0
2014-08-14 05:52:00	AAPL	Stock	24.3425	24.3425	24.3425	24.3425	800.0
2014-08-14 06:00:00	AAPL	Stock	24.3375	24.3375	24.3375	24.3375	896.0
2014-08-14 06:07:00	AAPL	Stock	24.3425	24.3425	24.3425	24.3425	1200.0
2014-08-14 06:09:00	AAPL	Stock	24.32	24.32	24.32	24.32	984.0
2014-08-14 06:19:00	AAPL	Stock	24.3325	24.3325	24.3325	24.3325	1200.0
2014-08-14 06:22:00	AAPL	Stock	24.3375	24.3425	24.3375	24.3425	5280.0
2014-08-14 06:26:00	AAPL	Stock	24.355	24.36	24.355	24.36	1716.0
2014-08-14 06:28:00	AAPL	Stock	24.3725	24.3725	24.3725	24.3725	800.0
2014-08-14 06:51:00	AAPL	Stock	24.355	24.355	24.355	24.355	400.0
2014-08-14 07:00:00	AAPL	Stock	24.3575	24.3575	24.3575	24.3575	900.0
2014-08-14 07:01:00	AAPL	Stock	24.3575	24.3575	24.3575	24.3575	800.0
2014-08-14 07:02:00	AAPL	Stock	24.365	24.365	24.365	24.365	400.0
2014-08-14 07:09:00	AAPL	Stock	24.37	24.37	24.37	24.37	1852.0
2014-08-14 07:10:00	AAPL	Stock	24.37	24.37	24.37	24.37	640.0
2014-08-14 07:11:00	AAPL	Stock	24.3525	24.3525	24.3525	24.3525	400.0
2014-08-14 07:12:00	AAPL	Stock	24.35	24.35	24.35	24.35	1380.0
2014-08-14 07:19:00	AAPL	Stock	24.35	24.3525	24.35	24.35	2400.0
2014-08-14 07:20:00	AAPL	Stock	24.35	24.35	24.35	24.35	400.0
2014-08-14 07:25:00	AAPL	Stock	24.3525	24.3525	24.3525	24.3525	400.0
2014-08-14 07:31:00	AAPL	Stock	24.345	24.345	24.345	24.345	1600.0
2014-08-14 07:41:00	AAPL	Stock	24.3375	24.3375	24.3375	24.3375	800.0
2014-08-14 07:50:00	AAPL	Stock	24.3375	24.3375	24.3375	24.3375	400.0
2014-08-14 07:51:00	AAPL	Stock	24.3375	24.3375	24.3375	24.3375	2000.0
2014-08-14 07:52:00	AAPL	Stock	24.35	24.35	24.3325	24.34	17728.0
2014-08-14 07:54:00	AAPL	Stock	24.33	24.33	24.32	24.32	5288.0
2014-08-14 07:55:00	AAPL	Stock	24.33	24.3375	24.33	24.3375	8708.0
2014-08-14 07:58:00	AAPL	Stock	24.335	24.3375	24.335	24.3375	4000.0
2014-08-14 07:59:00	AAPL	Stock	24.3275	24.3275	24.3275	24.3275	400.0
2014-08-14 08:00:00	AAPL	Stock	24.3325	24.37	24.31	24.325	53244.0
2014-08-14 08:01:00	AAPL	Stock	24.3325	24.3325	24.3275	24.3325	12384.0
2014-08-14 08:03:00	AAPL	Stock	24.335	24.3375	24.335	24.3375	6868.0
2014-08-14 08:05:00	AAPL	Stock	24.345	24.345	24.3375	24.3375	9600.0
2014-08-14 08:06:00	AAPL	Stock	24.3425	24.35	24.3375	24.35	51956.0
2014-08-14 08:07:00	AAPL	Stock	24.3475	24.35	24.3425	24.3425	9708.0
2014-08-14 08:08:00	AAPL	Stock	24.3425	24.3425	24.3425	24.3425	2180.0
2014-08-14 08:09:00	AAPL	Stock	24.345	24.355	24.345	24.355	20040.0
2014-08-14 08:10:00	AAPL	Stock	24.3575	24.36	24.3575	24.36	2400.0
2014-08-14 08:11:00	AAPL	Stock	24.36	24.365	24.36	24.36	24140.0
2014-08-14 08:12:00	AAPL	Stock	24.3625	24.3625	24.36	24.36	800.0
2014-08-14 08:13:00	AAPL	Stock	24.36	24.3625	24.36	24.3625	12728.0
2014-08-14 08:14:00	AAPL	Stock	24.365	24.3675	24.365	24.365	8400.0
2014-08-14 08:15:00	AAPL	Stock	24.3675	24.3675	24.365	24.3675	3476.0

> showing 50 of 997,796 rows — these rows as CSV

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