PREVIEW / stock_1min / 2017-09-18

all stock 1-min files

  file:    by_date/stock_1min/2017/2017-09-18.parquet
  size:    14.8 MB
  rows:    1,066,413
  symbols: 2,457

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
2017-09-18 04:24:00	AAPL	Stock	40.055	40.055	40.05	40.05	2164.0
2017-09-18 04:38:00	AAPL	Stock	40.1125	40.1125	40.1125	40.1125	4400.0
2017-09-18 04:39:00	AAPL	Stock	40.15	40.15	40.15	40.15	800.0
2017-09-18 04:42:00	AAPL	Stock	40.15	40.15	40.15	40.15	400.0
2017-09-18 05:22:00	AAPL	Stock	40.125	40.125	40.125	40.125	1200.0
2017-09-18 05:31:00	AAPL	Stock	40.1225	40.1575	40.1225	40.1575	996.0
2017-09-18 05:44:00	AAPL	Stock	40.1225	40.1225	40.1225	40.1225	400.0
2017-09-18 05:45:00	AAPL	Stock	40.125	40.125	40.125	40.125	800.0
2017-09-18 05:52:00	AAPL	Stock	40.15	40.15	40.15	40.15	400.0
2017-09-18 05:57:00	AAPL	Stock	40.15	40.15	40.15	40.15	400.0
2017-09-18 05:58:00	AAPL	Stock	40.1475	40.1475	40.1375	40.1375	2704.0
2017-09-18 06:00:00	AAPL	Stock	40.16	40.1625	40.16	40.1625	3600.0
2017-09-18 06:03:00	AAPL	Stock	40.14	40.14	40.14	40.14	400.0
2017-09-18 06:06:00	AAPL	Stock	40.1425	40.1425	40.1425	40.1425	400.0
2017-09-18 06:07:00	AAPL	Stock	40.1425	40.1425	40.1425	40.1425	800.0
2017-09-18 06:14:00	AAPL	Stock	40.145	40.145	40.145	40.145	400.0
2017-09-18 06:15:00	AAPL	Stock	40.1425	40.15	40.1375	40.1475	4664.0
2017-09-18 06:17:00	AAPL	Stock	40.1425	40.1425	40.1425	40.1425	400.0
2017-09-18 06:21:00	AAPL	Stock	40.1475	40.1475	40.1375	40.1375	1600.0
2017-09-18 06:22:00	AAPL	Stock	40.1375	40.145	40.1375	40.145	2000.0
2017-09-18 06:25:00	AAPL	Stock	40.145	40.145	40.1375	40.1375	1600.0
2017-09-18 06:26:00	AAPL	Stock	40.1425	40.1425	40.1425	40.1425	400.0
2017-09-18 06:37:00	AAPL	Stock	40.1375	40.1375	40.1375	40.1375	400.0
2017-09-18 06:44:00	AAPL	Stock	40.15	40.15	40.15	40.15	1200.0
2017-09-18 06:46:00	AAPL	Stock	40.1375	40.1375	40.125	40.125	1788.0
2017-09-18 06:49:00	AAPL	Stock	40.1125	40.1125	40.1125	40.1125	9200.0
2017-09-18 06:50:00	AAPL	Stock	40.1125	40.1125	40.1125	40.1125	400.0
2017-09-18 06:54:00	AAPL	Stock	40.15	40.15	40.15	40.15	400.0
2017-09-18 07:00:00	AAPL	Stock	40.1425	40.1425	40.1425	40.1425	400.0
2017-09-18 07:02:00	AAPL	Stock	40.13	40.13	40.13	40.13	4000.0
2017-09-18 07:04:00	AAPL	Stock	40.1225	40.1225	40.1225	40.1225	2000.0
2017-09-18 07:05:00	AAPL	Stock	40.125	40.14	40.125	40.14	1200.0
2017-09-18 07:13:00	AAPL	Stock	40.135	40.135	40.135	40.135	400.0
2017-09-18 07:14:00	AAPL	Stock	40.125	40.125	40.1175	40.1175	4400.0
2017-09-18 07:15:00	AAPL	Stock	40.1175	40.1175	40.1175	40.1175	400.0
2017-09-18 07:17:00	AAPL	Stock	40.1075	40.1075	40.1075	40.1075	400.0
2017-09-18 07:19:00	AAPL	Stock	40.1075	40.12	40.1075	40.12	1212.0
2017-09-18 07:20:00	AAPL	Stock	40.13	40.13	40.1125	40.115	6404.0
2017-09-18 07:23:00	AAPL	Stock	40.1125	40.1125	40.1	40.1	2400.0
2017-09-18 07:25:00	AAPL	Stock	40.12	40.12	40.12	40.12	400.0
2017-09-18 07:27:00	AAPL	Stock	40.09	40.0925	40.09	40.0925	10000.0
2017-09-18 07:28:00	AAPL	Stock	40.09	40.09	40.09	40.09	4000.0
2017-09-18 07:29:00	AAPL	Stock	40.09	40.09	40.09	40.09	2836.0
2017-09-18 07:30:00	AAPL	Stock	40.09	40.09	40.0875	40.0875	2400.0
2017-09-18 07:34:00	AAPL	Stock	40.1	40.1	40.1	40.1	400.0
2017-09-18 07:35:00	AAPL	Stock	40.1	40.1	40.0825	40.0825	9532.0
2017-09-18 07:36:00	AAPL	Stock	40.0825	40.0825	40.075	40.075	18084.0
2017-09-18 07:38:00	AAPL	Stock	40.0775	40.0775	40.0775	40.0775	1200.0
2017-09-18 07:42:00	AAPL	Stock	40.0975	40.1	40.0975	40.1	4780.0
2017-09-18 07:44:00	AAPL	Stock	40.1	40.1	40.0925	40.0925	2400.0

> showing 50 of 1,066,413 rows — these rows as CSV

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