PREVIEW / stock_1min / 2017-09-13

all stock 1-min files

  file:    by_date/stock_1min/2017/2017-09-13.parquet
  size:    14.4 MB
  rows:    1,047,073
  symbols: 2,460

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-13 04:00:00	AAPL	Stock	40.1025	40.125	40.0625	40.125	2384.0
2017-09-13 04:02:00	AAPL	Stock	40.07	40.07	40.07	40.07	716.0
2017-09-13 04:08:00	AAPL	Stock	40.0725	40.0725	40.0725	40.0725	400.0
2017-09-13 04:09:00	AAPL	Stock	40.0375	40.0375	40.025	40.025	2356.0
2017-09-13 04:10:00	AAPL	Stock	40.05	40.05	40.05	40.05	400.0
2017-09-13 04:12:00	AAPL	Stock	40.0475	40.0475	40.0475	40.0475	648.0
2017-09-13 04:14:00	AAPL	Stock	40.07	40.0725	40.07	40.0725	1200.0
2017-09-13 04:16:00	AAPL	Stock	40.0725	40.0725	40.0725	40.0725	1332.0
2017-09-13 04:17:00	AAPL	Stock	40.075	40.075	40.075	40.075	400.0
2017-09-13 04:18:00	AAPL	Stock	40.1175	40.1175	40.075	40.075	2400.0
2017-09-13 04:19:00	AAPL	Stock	40.1125	40.1125	40.1125	40.1125	3600.0
2017-09-13 04:22:00	AAPL	Stock	40.15	40.15	40.15	40.15	1236.0
2017-09-13 04:23:00	AAPL	Stock	40.125	40.125	40.125	40.125	4000.0
2017-09-13 04:24:00	AAPL	Stock	40.125	40.125	40.125	40.125	7200.0
2017-09-13 04:27:00	AAPL	Stock	40.125	40.125	40.125	40.125	400.0
2017-09-13 04:31:00	AAPL	Stock	40.15	40.15	40.125	40.125	1944.0
2017-09-13 04:34:00	AAPL	Stock	40.1325	40.1325	40.1325	40.1325	400.0
2017-09-13 04:35:00	AAPL	Stock	40.15	40.15	40.1325	40.1325	1200.0
2017-09-13 04:36:00	AAPL	Stock	40.125	40.125	40.125	40.125	1332.0
2017-09-13 04:39:00	AAPL	Stock	40.125	40.125	40.125	40.125	10396.0
2017-09-13 04:47:00	AAPL	Stock	40.025	40.03	40.025	40.0275	1900.0
2017-09-13 04:48:00	AAPL	Stock	40.075	40.075	40.075	40.075	4000.0
2017-09-13 04:50:00	AAPL	Stock	40.05	40.05	40.045	40.045	1960.0
2017-09-13 04:52:00	AAPL	Stock	40.045	40.045	40.045	40.045	1292.0
2017-09-13 05:00:00	AAPL	Stock	40.045	40.045	40.045	40.045	640.0
2017-09-13 05:08:00	AAPL	Stock	40.0875	40.1	40.0875	40.1	5724.0
2017-09-13 05:11:00	AAPL	Stock	40.12	40.125	40.12	40.125	4624.0
2017-09-13 05:12:00	AAPL	Stock	40.12	40.12	40.1	40.1	7064.0
2017-09-13 05:19:00	AAPL	Stock	40.1	40.1	40.1	40.1	2396.0
2017-09-13 05:21:00	AAPL	Stock	40.07	40.07	40.07	40.07	3196.0
2017-09-13 05:25:00	AAPL	Stock	40.0625	40.0625	40.0625	40.0625	800.0
2017-09-13 05:35:00	AAPL	Stock	40.07	40.07	40.07	40.07	400.0
2017-09-13 05:36:00	AAPL	Stock	40.07	40.07	40.07	40.07	800.0
2017-09-13 05:37:00	AAPL	Stock	40.07	40.07	40.07	40.07	1752.0
2017-09-13 05:39:00	AAPL	Stock	40.0625	40.0625	40.0625	40.0625	400.0
2017-09-13 05:40:00	AAPL	Stock	40.0625	40.0625	40.05	40.05	2656.0
2017-09-13 05:48:00	AAPL	Stock	40.04	40.04	40.04	40.04	400.0
2017-09-13 05:51:00	AAPL	Stock	40.03	40.03	40.025	40.025	2800.0
2017-09-13 05:52:00	AAPL	Stock	40.0125	40.025	40.0	40.0	7200.0
2017-09-13 05:57:00	AAPL	Stock	39.9975	40.0	39.9975	40.0	3268.0
2017-09-13 05:58:00	AAPL	Stock	40.0025	40.0025	40.0	40.0	3200.0
2017-09-13 05:59:00	AAPL	Stock	39.985	39.985	39.975	39.975	4356.0
2017-09-13 06:06:00	AAPL	Stock	39.9975	39.9975	39.97	39.97	2000.0
2017-09-13 06:08:00	AAPL	Stock	39.97	39.97	39.97	39.97	400.0
2017-09-13 06:10:00	AAPL	Stock	39.95	39.95	39.95	39.95	1280.0
2017-09-13 06:11:00	AAPL	Stock	39.9375	39.9375	39.925	39.925	3200.0
2017-09-13 06:13:00	AAPL	Stock	39.9375	39.9375	39.9375	39.9375	19956.0
2017-09-13 06:17:00	AAPL	Stock	39.935	39.935	39.935	39.935	1284.0
2017-09-13 06:18:00	AAPL	Stock	39.935	39.935	39.935	39.935	400.0
2017-09-13 06:19:00	AAPL	Stock	39.935	39.95	39.935	39.95	23684.0

> showing 50 of 1,047,073 rows — these rows as CSV

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