PREVIEW / stock_1min / 2017-03-09

all stock 1-min files

  file:    by_date/stock_1min/2017/2017-03-09.parquet
  size:    14.9 MB
  rows:    1,074,428
  symbols: 2,553

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-09 04:03:00	AAPL	Stock	34.81	34.81	34.81	34.81	1196.0
2017-03-09 04:16:00	AAPL	Stock	34.8275	34.8275	34.825	34.825	1500.0
2017-03-09 05:16:00	AAPL	Stock	34.7625	34.7625	34.7625	34.7625	1788.0
2017-03-09 05:17:00	AAPL	Stock	34.7575	34.7575	34.7575	34.7575	568.0
2017-03-09 06:09:00	AAPL	Stock	34.6775	34.6775	34.665	34.665	5860.0
2017-03-09 06:31:00	AAPL	Stock	34.675	34.675	34.675	34.675	4000.0
2017-03-09 06:35:00	AAPL	Stock	34.6425	34.6425	34.6425	34.6425	1656.0
2017-03-09 06:48:00	AAPL	Stock	34.675	34.675	34.675	34.675	4400.0
2017-03-09 06:50:00	AAPL	Stock	34.6475	34.6475	34.6475	34.6475	576.0
2017-03-09 07:00:00	AAPL	Stock	34.675	34.675	34.675	34.675	400.0
2017-03-09 07:05:00	AAPL	Stock	34.6625	34.6625	34.655	34.655	2400.0
2017-03-09 07:06:00	AAPL	Stock	34.6525	34.6525	34.6475	34.6475	15012.0
2017-03-09 07:10:00	AAPL	Stock	34.67	34.67	34.67	34.67	1200.0
2017-03-09 07:14:00	AAPL	Stock	34.6625	34.6625	34.6625	34.6625	400.0
2017-03-09 07:17:00	AAPL	Stock	34.67	34.67	34.6325	34.6325	21796.0
2017-03-09 07:20:00	AAPL	Stock	34.6375	34.6375	34.6375	34.6375	9340.0
2017-03-09 07:21:00	AAPL	Stock	34.6625	34.6625	34.6625	34.6625	400.0
2017-03-09 07:24:00	AAPL	Stock	34.6425	34.65	34.64	34.65	7800.0
2017-03-09 07:25:00	AAPL	Stock	34.65	34.65	34.65	34.65	1700.0
2017-03-09 07:28:00	AAPL	Stock	34.65	34.65	34.65	34.65	800.0
2017-03-09 07:29:00	AAPL	Stock	34.6625	34.6625	34.65	34.65	2656.0
2017-03-09 07:34:00	AAPL	Stock	34.65	34.6525	34.65	34.6525	1744.0
2017-03-09 07:35:00	AAPL	Stock	34.6525	34.6525	34.6525	34.6525	2944.0
2017-03-09 07:41:00	AAPL	Stock	34.665	34.665	34.665	34.665	2000.0
2017-03-09 07:44:00	AAPL	Stock	34.67	34.6725	34.67	34.6725	1800.0
2017-03-09 07:48:00	AAPL	Stock	34.6625	34.6625	34.6625	34.6625	400.0
2017-03-09 07:52:00	AAPL	Stock	34.65	34.65	34.65	34.65	4000.0
2017-03-09 07:54:00	AAPL	Stock	34.6675	34.6675	34.6675	34.6675	1600.0
2017-03-09 07:57:00	AAPL	Stock	34.6525	34.6525	34.6525	34.6525	1000.0
2017-03-09 08:00:00	AAPL	Stock	34.65	34.6725	34.65	34.6625	36516.0
2017-03-09 08:01:00	AAPL	Stock	34.65	34.66	34.65	34.66	2800.0
2017-03-09 08:03:00	AAPL	Stock	34.645	34.645	34.64	34.64	7300.0
2017-03-09 08:04:00	AAPL	Stock	34.64	34.64	34.6125	34.62	18600.0
2017-03-09 08:06:00	AAPL	Stock	34.62	34.62	34.6125	34.6125	9188.0
2017-03-09 08:07:00	AAPL	Stock	34.6375	34.6475	34.6375	34.6475	14336.0
2017-03-09 08:09:00	AAPL	Stock	34.6375	34.6375	34.6325	34.6375	2796.0
2017-03-09 08:10:00	AAPL	Stock	34.6275	34.6275	34.6275	34.6275	400.0
2017-03-09 08:11:00	AAPL	Stock	34.6375	34.6375	34.6375	34.6375	400.0
2017-03-09 08:12:00	AAPL	Stock	34.645	34.645	34.625	34.6375	27200.0
2017-03-09 08:14:00	AAPL	Stock	34.6225	34.625	34.6125	34.6125	8360.0
2017-03-09 08:15:00	AAPL	Stock	34.615	34.62	34.6125	34.6175	20868.0
2017-03-09 08:16:00	AAPL	Stock	34.6175	34.6175	34.6125	34.6125	10800.0
2017-03-09 08:17:00	AAPL	Stock	34.6125	34.6125	34.6075	34.6075	7600.0
2017-03-09 08:18:00	AAPL	Stock	34.61	34.61	34.605	34.605	3012.0
2017-03-09 08:19:00	AAPL	Stock	34.6175	34.6175	34.6125	34.6125	8532.0
2017-03-09 08:20:00	AAPL	Stock	34.6225	34.6225	34.6225	34.6225	1600.0
2017-03-09 08:21:00	AAPL	Stock	34.6225	34.63	34.6225	34.63	8000.0
2017-03-09 08:22:00	AAPL	Stock	34.6125	34.615	34.6125	34.615	2000.0
2017-03-09 08:24:00	AAPL	Stock	34.6325	34.6375	34.6325	34.6375	6000.0
2017-03-09 08:25:00	AAPL	Stock	34.6375	34.6375	34.61	34.6325	6620.0

> showing 50 of 1,074,428 rows — these rows as CSV

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