PREVIEW / stock_1min / 2017-12-27

all stock 1-min files

  file:    by_date/stock_1min/2017/2017-12-27.parquet
  size:    14.2 MB
  rows:    1,017,335
  symbols: 2,426

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-12-27 04:00:00	AAPL	Stock	42.7775	42.7775	42.7775	42.7775	2392.0
2017-12-27 04:02:00	AAPL	Stock	42.725	42.725	42.725	42.725	1388.0
2017-12-27 04:21:00	AAPL	Stock	42.725	42.725	42.725	42.725	596.0
2017-12-27 04:40:00	AAPL	Stock	42.725	42.725	42.725	42.725	3648.0
2017-12-27 04:56:00	AAPL	Stock	42.725	42.725	42.725	42.725	3440.0
2017-12-27 05:32:00	AAPL	Stock	42.6875	42.6875	42.6875	42.6875	2000.0
2017-12-27 05:33:00	AAPL	Stock	42.6875	42.6875	42.6875	42.6875	472.0
2017-12-27 05:36:00	AAPL	Stock	42.6875	42.6875	42.6875	42.6875	1200.0
2017-12-27 05:46:00	AAPL	Stock	42.7	42.7	42.6875	42.6875	1200.0
2017-12-27 05:55:00	AAPL	Stock	42.7	42.7	42.7	42.7	2000.0
2017-12-27 05:58:00	AAPL	Stock	42.7	42.7	42.7	42.7	400.0
2017-12-27 06:12:00	AAPL	Stock	42.7	42.7	42.7	42.7	400.0
2017-12-27 06:13:00	AAPL	Stock	42.7	42.7	42.7	42.7	400.0
2017-12-27 06:39:00	AAPL	Stock	42.675	42.675	42.675	42.675	2600.0
2017-12-27 06:50:00	AAPL	Stock	42.6375	42.6375	42.6375	42.6375	788.0
2017-12-27 07:00:00	AAPL	Stock	42.6625	42.6625	42.6625	42.6625	864.0
2017-12-27 07:01:00	AAPL	Stock	42.67	42.67	42.67	42.67	400.0
2017-12-27 07:02:00	AAPL	Stock	42.675	42.675	42.675	42.675	400.0
2017-12-27 07:04:00	AAPL	Stock	42.655	42.655	42.655	42.655	400.0
2017-12-27 07:05:00	AAPL	Stock	42.6525	42.6625	42.6525	42.6625	9556.0
2017-12-27 07:09:00	AAPL	Stock	42.7	42.7	42.6775	42.6775	4800.0
2017-12-27 07:10:00	AAPL	Stock	42.6775	42.6775	42.6775	42.6775	400.0
2017-12-27 07:12:00	AAPL	Stock	42.6875	42.6875	42.6775	42.6775	6800.0
2017-12-27 07:13:00	AAPL	Stock	42.675	42.675	42.675	42.675	3600.0
2017-12-27 07:19:00	AAPL	Stock	42.675	42.685	42.675	42.685	19700.0
2017-12-27 07:20:00	AAPL	Stock	42.6775	42.6775	42.6775	42.6775	800.0
2017-12-27 07:26:00	AAPL	Stock	42.6775	42.6775	42.6775	42.6775	400.0
2017-12-27 07:30:00	AAPL	Stock	42.675	42.675	42.675	42.675	20000.0
2017-12-27 07:32:00	AAPL	Stock	42.6625	42.6625	42.65	42.65	8000.0
2017-12-27 07:36:00	AAPL	Stock	42.6375	42.6375	42.6025	42.6025	20136.0
2017-12-27 07:38:00	AAPL	Stock	42.6025	42.6075	42.6025	42.6075	4324.0
2017-12-27 07:39:00	AAPL	Stock	42.6	42.6125	42.6	42.6125	2708.0
2017-12-27 07:40:00	AAPL	Stock	42.6025	42.6025	42.6025	42.6025	400.0
2017-12-27 07:41:00	AAPL	Stock	42.6	42.6	42.5975	42.5975	3600.0
2017-12-27 07:42:00	AAPL	Stock	42.6	42.6	42.6	42.6	492.0
2017-12-27 07:44:00	AAPL	Stock	42.6	42.6	42.6	42.6	400.0
2017-12-27 07:46:00	AAPL	Stock	42.6	42.615	42.6	42.615	4900.0
2017-12-27 07:47:00	AAPL	Stock	42.625	42.625	42.625	42.625	400.0
2017-12-27 07:48:00	AAPL	Stock	42.625	42.625	42.625	42.625	400.0
2017-12-27 07:49:00	AAPL	Stock	42.625	42.625	42.625	42.625	2132.0
2017-12-27 07:50:00	AAPL	Stock	42.6425	42.6425	42.6425	42.6425	400.0
2017-12-27 08:00:00	AAPL	Stock	42.6375	42.6975	42.59	42.6075	10820.0
2017-12-27 08:03:00	AAPL	Stock	42.6225	42.6225	42.6225	42.6225	1708.0
2017-12-27 08:05:00	AAPL	Stock	42.6025	42.6025	42.6025	42.6025	1640.0
2017-12-27 08:06:00	AAPL	Stock	42.6025	42.6025	42.6025	42.6025	800.0
2017-12-27 08:07:00	AAPL	Stock	42.6	42.6	42.59	42.59	2920.0
2017-12-27 08:08:00	AAPL	Stock	42.59	42.59	42.59	42.59	2320.0
2017-12-27 08:09:00	AAPL	Stock	42.575	42.575	42.5625	42.5625	17600.0
2017-12-27 08:10:00	AAPL	Stock	42.5625	42.565	42.545	42.545	4540.0
2017-12-27 08:11:00	AAPL	Stock	42.555	42.555	42.555	42.555	400.0

> showing 50 of 1,017,335 rows — these rows as CSV

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