PREVIEW / stock_1min / 2017-11-21

all stock 1-min files

  file:    by_date/stock_1min/2017/2017-11-21.parquet
  size:    15.5 MB
  rows:    1,099,823
  symbols: 2,471

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-11-21 04:02:00	AAPL	Stock	42.58	42.58	42.58	42.58	500.0
2017-11-21 04:07:00	AAPL	Stock	42.4775	42.4775	42.4775	42.4775	400.0
2017-11-21 05:26:00	AAPL	Stock	42.6	42.6	42.6	42.6	400.0
2017-11-21 05:27:00	AAPL	Stock	42.595	42.5975	42.595	42.5975	5200.0
2017-11-21 05:28:00	AAPL	Stock	42.6225	42.6225	42.6225	42.6225	400.0
2017-11-21 06:02:00	AAPL	Stock	42.6225	42.6225	42.6225	42.6225	2800.0
2017-11-21 06:22:00	AAPL	Stock	42.625	42.625	42.625	42.625	1080.0
2017-11-21 06:29:00	AAPL	Stock	42.57	42.57	42.57	42.57	1052.0
2017-11-21 06:31:00	AAPL	Stock	42.5875	42.5875	42.5875	42.5875	1344.0
2017-11-21 06:32:00	AAPL	Stock	42.5875	42.5875	42.5875	42.5875	1600.0
2017-11-21 06:44:00	AAPL	Stock	42.6125	42.625	42.6125	42.625	2452.0
2017-11-21 06:45:00	AAPL	Stock	42.6	42.6	42.6	42.6	2000.0
2017-11-21 06:46:00	AAPL	Stock	42.5875	42.5875	42.5875	42.5875	400.0
2017-11-21 06:49:00	AAPL	Stock	42.605	42.605	42.605	42.605	1200.0
2017-11-21 06:50:00	AAPL	Stock	42.605	42.62	42.605	42.62	992.0
2017-11-21 06:58:00	AAPL	Stock	42.6125	42.6125	42.6125	42.6125	572.0
2017-11-21 07:00:00	AAPL	Stock	42.6225	42.6225	42.58	42.58	10092.0
2017-11-21 07:01:00	AAPL	Stock	42.62	42.62	42.62	42.62	1600.0
2017-11-21 07:02:00	AAPL	Stock	42.6225	42.6325	42.6125	42.6125	19408.0
2017-11-21 07:03:00	AAPL	Stock	42.615	42.615	42.615	42.615	13600.0
2017-11-21 07:06:00	AAPL	Stock	42.625	42.625	42.625	42.625	404.0
2017-11-21 07:10:00	AAPL	Stock	42.6	42.6	42.6	42.6	1600.0
2017-11-21 07:11:00	AAPL	Stock	42.6125	42.6125	42.6125	42.6125	2000.0
2017-11-21 07:13:00	AAPL	Stock	42.625	42.625	42.625	42.625	2884.0
2017-11-21 07:15:00	AAPL	Stock	42.6475	42.65	42.6475	42.6475	1700.0
2017-11-21 07:17:00	AAPL	Stock	42.65	42.65	42.65	42.65	800.0
2017-11-21 07:19:00	AAPL	Stock	42.65	42.65	42.65	42.65	1300.0
2017-11-21 07:20:00	AAPL	Stock	42.65	42.65	42.65	42.65	800.0
2017-11-21 07:23:00	AAPL	Stock	42.6675	42.6675	42.6675	42.6675	2000.0
2017-11-21 07:24:00	AAPL	Stock	42.6675	42.6675	42.6625	42.6625	800.0
2017-11-21 07:25:00	AAPL	Stock	42.65	42.65	42.65	42.65	400.0
2017-11-21 07:30:00	AAPL	Stock	42.63	42.63	42.63	42.63	424.0
2017-11-21 07:31:00	AAPL	Stock	42.63	42.63	42.625	42.625	4200.0
2017-11-21 07:36:00	AAPL	Stock	42.6375	42.6375	42.6375	42.6375	400.0
2017-11-21 07:40:00	AAPL	Stock	42.645	42.645	42.645	42.645	1924.0
2017-11-21 07:44:00	AAPL	Stock	42.6425	42.6425	42.6425	42.6425	4004.0
2017-11-21 07:47:00	AAPL	Stock	42.645	42.6475	42.645	42.6475	2504.0
2017-11-21 07:50:00	AAPL	Stock	42.6575	42.6575	42.6575	42.6575	400.0
2017-11-21 07:53:00	AAPL	Stock	42.6575	42.6575	42.65	42.65	2800.0
2017-11-21 07:54:00	AAPL	Stock	42.65	42.65	42.65	42.65	480.0
2017-11-21 08:00:00	AAPL	Stock	42.6375	42.67	42.62	42.66	30564.0
2017-11-21 08:01:00	AAPL	Stock	42.65	42.66	42.65	42.66	5692.0
2017-11-21 08:02:00	AAPL	Stock	42.66	42.66	42.66	42.66	2600.0
2017-11-21 08:03:00	AAPL	Stock	42.6425	42.6425	42.6425	42.6425	800.0
2017-11-21 08:04:00	AAPL	Stock	42.655	42.655	42.655	42.655	800.0
2017-11-21 08:05:00	AAPL	Stock	42.6625	42.6625	42.6625	42.6625	4000.0
2017-11-21 08:07:00	AAPL	Stock	42.6625	42.6625	42.6625	42.6625	2400.0
2017-11-21 08:08:00	AAPL	Stock	42.6625	42.6625	42.6625	42.6625	11816.0
2017-11-21 08:09:00	AAPL	Stock	42.6625	42.675	42.6625	42.675	17704.0
2017-11-21 08:10:00	AAPL	Stock	42.675	42.675	42.6575	42.6575	2452.0

> showing 50 of 1,099,823 rows — these rows as CSV

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