PREVIEW / stock_1min / 2014-04-24

all stock 1-min files

  file:    by_date/stock_1min/2014/2014-04-24.parquet
  size:    14.2 MB
  rows:    1,050,554
  symbols: 2,870

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-04-24 04:00:00	AAPL	Stock	20.1411	20.1429	20.1357	20.1357	25144.0
2014-04-24 04:01:00	AAPL	Stock	20.1629	20.1629	20.1629	20.1629	22400.0
2014-04-24 04:02:00	AAPL	Stock	20.1629	20.1629	20.1629	20.1629	11200.0
2014-04-24 04:03:00	AAPL	Stock	20.1629	20.1629	20.1518	20.1518	21588.0
2014-04-24 04:04:00	AAPL	Stock	20.1454	20.15	20.1454	20.15	16800.0
2014-04-24 04:08:00	AAPL	Stock	20.1518	20.1607	20.1518	20.1607	30912.0
2014-04-24 04:10:00	AAPL	Stock	20.1511	20.1536	20.1511	20.1536	5600.0
2014-04-24 04:11:00	AAPL	Stock	20.1571	20.1571	20.1521	20.1521	8400.0
2014-04-24 04:18:00	AAPL	Stock	20.1446	20.1446	20.1357	20.1357	60592.0
2014-04-24 04:20:00	AAPL	Stock	20.1304	20.1304	20.1254	20.1254	19600.0
2014-04-24 04:25:00	AAPL	Stock	20.1071	20.1071	20.1071	20.1071	2800.0
2014-04-24 04:29:00	AAPL	Stock	20.1143	20.1143	20.1143	20.1143	2800.0
2014-04-24 04:34:00	AAPL	Stock	20.1121	20.1121	20.1121	20.1121	5600.0
2014-04-24 04:36:00	AAPL	Stock	20.1071	20.1071	20.1071	20.1071	2800.0
2014-04-24 04:43:00	AAPL	Stock	20.1036	20.1036	20.1036	20.1036	2800.0
2014-04-24 04:44:00	AAPL	Stock	20.115	20.115	20.115	20.115	5600.0
2014-04-24 04:45:00	AAPL	Stock	20.1143	20.1143	20.1143	20.1143	2800.0
2014-04-24 04:47:00	AAPL	Stock	20.1161	20.1179	20.1157	20.1179	8400.0
2014-04-24 04:50:00	AAPL	Stock	20.1018	20.1018	20.1007	20.1007	11200.0
2014-04-24 04:52:00	AAPL	Stock	20.1143	20.1143	20.1143	20.1143	2800.0
2014-04-24 04:53:00	AAPL	Stock	20.1179	20.125	20.1179	20.125	16800.0
2014-04-24 04:54:00	AAPL	Stock	20.1239	20.125	20.1239	20.125	8400.0
2014-04-24 04:59:00	AAPL	Stock	20.095	20.095	20.095	20.095	2884.0
2014-04-24 05:08:00	AAPL	Stock	20.1143	20.1207	20.1143	20.1143	8400.0
2014-04-24 05:10:00	AAPL	Stock	20.1218	20.1218	20.1218	20.1218	2800.0
2014-04-24 05:39:00	AAPL	Stock	20.1071	20.1071	20.1071	20.1071	2800.0
2014-04-24 05:40:00	AAPL	Stock	20.1132	20.1132	20.1132	20.1132	2800.0
2014-04-24 05:42:00	AAPL	Stock	20.1132	20.1429	20.1132	20.1429	62272.0
2014-04-24 05:45:00	AAPL	Stock	20.1268	20.1268	20.1268	20.1268	2800.0
2014-04-24 05:47:00	AAPL	Stock	20.1236	20.1236	20.1236	20.1236	14000.0
2014-04-24 05:50:00	AAPL	Stock	20.1182	20.1236	20.1182	20.1236	19600.0
2014-04-24 05:51:00	AAPL	Stock	20.1236	20.1314	20.1236	20.1236	14196.0
2014-04-24 05:52:00	AAPL	Stock	20.1329	20.1343	20.1307	20.1343	14000.0
2014-04-24 05:53:00	AAPL	Stock	20.1439	20.1439	20.1439	20.1439	2800.0
2014-04-24 05:55:00	AAPL	Stock	20.1325	20.1325	20.1325	20.1325	2800.0
2014-04-24 06:00:00	AAPL	Stock	20.1325	20.1325	20.1325	20.1325	16884.0
2014-04-24 06:01:00	AAPL	Stock	20.1429	20.1429	20.1429	20.1429	19600.0
2014-04-24 06:02:00	AAPL	Stock	20.1471	20.1504	20.1471	20.1504	16716.0
2014-04-24 06:06:00	AAPL	Stock	20.1643	20.1643	20.1643	20.1643	2800.0
2014-04-24 06:07:00	AAPL	Stock	20.1679	20.1679	20.1679	20.1679	6580.0
2014-04-24 06:08:00	AAPL	Stock	20.1607	20.1607	20.1536	20.1536	8596.0
2014-04-24 06:11:00	AAPL	Stock	20.1386	20.1714	20.1386	20.1714	68432.0
2014-04-24 06:12:00	AAPL	Stock	20.1643	20.1643	20.1643	20.1643	2800.0
2014-04-24 06:14:00	AAPL	Stock	20.1571	20.1571	20.1571	20.1571	28000.0
2014-04-24 06:17:00	AAPL	Stock	20.1446	20.1446	20.1429	20.1429	12404.0
2014-04-24 06:26:00	AAPL	Stock	20.1332	20.1429	20.1332	20.1429	30016.0
2014-04-24 06:29:00	AAPL	Stock	20.16	20.1607	20.16	20.1607	9240.0
2014-04-24 06:33:00	AAPL	Stock	20.1568	20.1568	20.1568	20.1568	2800.0
2014-04-24 06:35:00	AAPL	Stock	20.1607	20.17	20.1607	20.17	19600.0
2014-04-24 06:36:00	AAPL	Stock	20.17	20.1707	20.17	20.1707	26460.0

> showing 50 of 1,050,554 rows — these rows as CSV

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