PREVIEW / stock_1min / 2017-10-27

all stock 1-min files

  file:    by_date/stock_1min/2017/2017-10-27.parquet
  size:    15.0 MB
  rows:    1,075,249
  symbols: 2,425

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-10-27 04:21:00	AAPL	Stock	39.5325	39.5325	39.5325	39.5325	400.0
2017-10-27 04:22:00	AAPL	Stock	39.53	39.53	39.53	39.53	1492.0
2017-10-27 04:44:00	AAPL	Stock	39.505	39.505	39.505	39.505	400.0
2017-10-27 05:10:00	AAPL	Stock	39.55	39.555	39.55	39.555	3600.0
2017-10-27 05:12:00	AAPL	Stock	39.555	39.555	39.555	39.555	4000.0
2017-10-27 05:13:00	AAPL	Stock	39.555	39.575	39.555	39.575	20576.0
2017-10-27 05:14:00	AAPL	Stock	39.5725	39.585	39.5725	39.585	5900.0
2017-10-27 05:15:00	AAPL	Stock	39.59	39.59	39.5875	39.5875	2000.0
2017-10-27 05:31:00	AAPL	Stock	39.5975	39.5975	39.5975	39.5975	400.0
2017-10-27 05:34:00	AAPL	Stock	39.595	39.595	39.595	39.595	1200.0
2017-10-27 05:36:00	AAPL	Stock	39.5975	39.6	39.595	39.595	8540.0
2017-10-27 05:40:00	AAPL	Stock	39.5925	39.6	39.5925	39.6	9692.0
2017-10-27 05:53:00	AAPL	Stock	39.6	39.6	39.6	39.6	800.0
2017-10-27 06:01:00	AAPL	Stock	39.6225	39.6225	39.6225	39.6225	3968.0
2017-10-27 06:06:00	AAPL	Stock	39.6725	39.6725	39.6725	39.6725	644.0
2017-10-27 06:07:00	AAPL	Stock	39.6025	39.6025	39.6025	39.6025	724.0
2017-10-27 06:08:00	AAPL	Stock	39.625	39.625	39.625	39.625	400.0
2017-10-27 06:11:00	AAPL	Stock	39.6725	39.6725	39.6725	39.6725	2180.0
2017-10-27 06:12:00	AAPL	Stock	39.6775	39.6775	39.6775	39.6775	2248.0
2017-10-27 06:24:00	AAPL	Stock	39.67	39.67	39.67	39.67	400.0
2017-10-27 06:39:00	AAPL	Stock	39.64	39.64	39.64	39.64	400.0
2017-10-27 06:43:00	AAPL	Stock	39.64	39.64	39.64	39.64	4000.0
2017-10-27 06:44:00	AAPL	Stock	39.64	39.64	39.64	39.64	2400.0
2017-10-27 06:45:00	AAPL	Stock	39.66	39.66	39.625	39.625	4512.0
2017-10-27 06:49:00	AAPL	Stock	39.625	39.625	39.625	39.625	5600.0
2017-10-27 06:50:00	AAPL	Stock	39.6375	39.6375	39.6375	39.6375	400.0
2017-10-27 06:52:00	AAPL	Stock	39.66	39.6625	39.66	39.6625	3320.0
2017-10-27 06:55:00	AAPL	Stock	39.6725	39.6875	39.6725	39.6875	57236.0
2017-10-27 06:56:00	AAPL	Stock	39.6875	39.7125	39.6875	39.6875	4820.0
2017-10-27 06:57:00	AAPL	Stock	39.6875	39.6875	39.6875	39.6875	3060.0
2017-10-27 06:58:00	AAPL	Stock	39.7125	39.7125	39.7125	39.7125	4020.0
2017-10-27 06:59:00	AAPL	Stock	39.7125	39.7125	39.7125	39.7125	4000.0
2017-10-27 07:00:00	AAPL	Stock	39.6875	39.7175	39.6875	39.69	5044.0
2017-10-27 07:01:00	AAPL	Stock	39.72	39.72	39.6875	39.6875	19712.0
2017-10-27 07:02:00	AAPL	Stock	39.69	39.725	39.69	39.7	27120.0
2017-10-27 07:03:00	AAPL	Stock	39.725	39.725	39.725	39.725	400.0
2017-10-27 07:04:00	AAPL	Stock	39.7125	39.7125	39.7125	39.7125	4000.0
2017-10-27 07:06:00	AAPL	Stock	39.6875	39.6875	39.6875	39.6875	1292.0
2017-10-27 07:08:00	AAPL	Stock	39.6875	39.6875	39.6875	39.6875	1988.0
2017-10-27 07:09:00	AAPL	Stock	39.6875	39.6975	39.6625	39.6975	13668.0
2017-10-27 07:12:00	AAPL	Stock	39.675	39.68	39.675	39.6775	2400.0
2017-10-27 07:13:00	AAPL	Stock	39.6625	39.6625	39.6625	39.6625	4000.0
2017-10-27 07:16:00	AAPL	Stock	39.6525	39.6525	39.6525	39.6525	3028.0
2017-10-27 07:17:00	AAPL	Stock	39.675	39.675	39.675	39.675	1980.0
2017-10-27 07:18:00	AAPL	Stock	39.675	39.675	39.6625	39.6625	4000.0
2017-10-27 07:20:00	AAPL	Stock	39.6625	39.6625	39.6625	39.6625	400.0
2017-10-27 07:21:00	AAPL	Stock	39.665	39.675	39.665	39.675	2300.0
2017-10-27 07:26:00	AAPL	Stock	39.6625	39.6625	39.6625	39.6625	800.0
2017-10-27 07:29:00	AAPL	Stock	39.6875	39.6875	39.665	39.665	12180.0
2017-10-27 07:31:00	AAPL	Stock	39.67	39.67	39.67	39.67	400.0

> showing 50 of 1,075,249 rows — these rows as CSV

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