PREVIEW / stock_1min / 2017-03-27

all stock 1-min files

  file:    by_date/stock_1min/2017/2017-03-27.parquet
  size:    14.4 MB
  rows:    1,054,138
  symbols: 2,547

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-03-27 04:00:00	AAPL	Stock	34.9875	34.9875	34.9875	34.9875	1200.0
2017-03-27 04:22:00	AAPL	Stock	34.9275	34.9275	34.9275	34.9275	1200.0
2017-03-27 04:50:00	AAPL	Stock	34.9325	34.9325	34.9325	34.9325	1744.0
2017-03-27 05:08:00	AAPL	Stock	34.8925	34.8925	34.8925	34.8925	820.0
2017-03-27 05:26:00	AAPL	Stock	34.9225	34.9225	34.9225	34.9225	1548.0
2017-03-27 05:37:00	AAPL	Stock	34.885	34.885	34.885	34.885	420.0
2017-03-27 05:56:00	AAPL	Stock	34.875	34.875	34.875	34.875	508.0
2017-03-27 06:19:00	AAPL	Stock	34.91	34.9375	34.91	34.9375	14020.0
2017-03-27 06:21:00	AAPL	Stock	34.96	34.96	34.96	34.96	6400.0
2017-03-27 06:22:00	AAPL	Stock	34.96	34.96	34.9375	34.9375	2800.0
2017-03-27 06:23:00	AAPL	Stock	34.94	34.94	34.9375	34.9375	6000.0
2017-03-27 06:24:00	AAPL	Stock	34.925	34.925	34.925	34.925	2000.0
2017-03-27 06:25:00	AAPL	Stock	34.9225	34.9225	34.9125	34.9125	8920.0
2017-03-27 06:27:00	AAPL	Stock	34.9125	34.9125	34.9125	34.9125	400.0
2017-03-27 06:31:00	AAPL	Stock	34.9125	34.9125	34.9125	34.9125	2000.0
2017-03-27 06:32:00	AAPL	Stock	34.9125	34.9125	34.9125	34.9125	8600.0
2017-03-27 06:41:00	AAPL	Stock	34.905	34.905	34.8975	34.8975	3332.0
2017-03-27 06:42:00	AAPL	Stock	34.9	34.9	34.8975	34.8975	6468.0
2017-03-27 06:43:00	AAPL	Stock	34.9025	34.9025	34.9025	34.9025	4000.0
2017-03-27 06:47:00	AAPL	Stock	34.9	34.9	34.9	34.9	1480.0
2017-03-27 06:48:00	AAPL	Stock	34.8875	34.8875	34.885	34.885	1000.0
2017-03-27 06:49:00	AAPL	Stock	34.9	34.9	34.875	34.875	16600.0
2017-03-27 06:50:00	AAPL	Stock	34.875	34.875	34.87	34.875	9200.0
2017-03-27 06:51:00	AAPL	Stock	34.875	34.875	34.875	34.875	800.0
2017-03-27 06:52:00	AAPL	Stock	34.895	34.895	34.895	34.895	1600.0
2017-03-27 06:53:00	AAPL	Stock	34.895	34.895	34.895	34.895	2000.0
2017-03-27 06:54:00	AAPL	Stock	34.9075	34.9075	34.9075	34.9075	1200.0
2017-03-27 06:56:00	AAPL	Stock	34.9	34.9	34.9	34.9	2000.0
2017-03-27 06:59:00	AAPL	Stock	34.9125	34.9125	34.9125	34.9125	2280.0
2017-03-27 07:00:00	AAPL	Stock	34.9125	34.9175	34.9125	34.9175	1200.0
2017-03-27 07:01:00	AAPL	Stock	34.9	34.9175	34.9	34.9	15200.0
2017-03-27 07:02:00	AAPL	Stock	34.9	34.9	34.9	34.9	10000.0
2017-03-27 07:04:00	AAPL	Stock	34.9325	34.9325	34.9175	34.9175	1600.0
2017-03-27 07:05:00	AAPL	Stock	34.9325	34.9325	34.9325	34.9325	800.0
2017-03-27 07:06:00	AAPL	Stock	34.925	34.925	34.925	34.925	1000.0
2017-03-27 07:08:00	AAPL	Stock	34.9225	34.925	34.9225	34.925	2024.0
2017-03-27 07:09:00	AAPL	Stock	34.93	34.9325	34.93	34.9325	14956.0
2017-03-27 07:11:00	AAPL	Stock	34.9375	34.9375	34.9375	34.9375	5700.0
2017-03-27 07:12:00	AAPL	Stock	34.9375	34.9375	34.9375	34.9375	1352.0
2017-03-27 07:13:00	AAPL	Stock	34.9375	34.9375	34.9375	34.9375	400.0
2017-03-27 07:14:00	AAPL	Stock	34.9475	34.95	34.9475	34.95	2792.0
2017-03-27 07:16:00	AAPL	Stock	34.9375	34.9375	34.9375	34.9375	800.0
2017-03-27 07:17:00	AAPL	Stock	34.9375	34.9375	34.9375	34.9375	7136.0
2017-03-27 07:18:00	AAPL	Stock	34.925	34.925	34.925	34.925	7136.0
2017-03-27 07:19:00	AAPL	Stock	34.925	34.925	34.925	34.925	4400.0
2017-03-27 07:20:00	AAPL	Stock	34.925	34.925	34.925	34.925	6800.0
2017-03-27 07:21:00	AAPL	Stock	34.925	34.925	34.925	34.925	6000.0
2017-03-27 07:22:00	AAPL	Stock	34.925	34.925	34.925	34.925	3600.0
2017-03-27 07:24:00	AAPL	Stock	34.925	34.925	34.925	34.925	2936.0
2017-03-27 07:25:00	AAPL	Stock	34.9225	34.9225	34.9225	34.9225	400.0

> showing 50 of 1,054,138 rows — these rows as CSV

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