PREVIEW / stock_1min / 2018-04-09

all stock 1-min files

  file:    by_date/stock_1min/2018/2018-04-09.parquet
  size:    14.7 MB
  rows:    1,068,591
  symbols: 2,380

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
2018-04-09 04:01:00	AAPL	Stock	42.535	42.535	42.535	42.535	400.0
2018-04-09 04:04:00	AAPL	Stock	42.6225	42.6225	42.6225	42.6225	400.0
2018-04-09 04:50:00	AAPL	Stock	42.6	42.6	42.6	42.6	400.0
2018-04-09 04:53:00	AAPL	Stock	42.6	42.6125	42.6	42.6125	1100.0
2018-04-09 05:28:00	AAPL	Stock	42.6075	42.61	42.6075	42.6075	2208.0
2018-04-09 05:46:00	AAPL	Stock	42.5625	42.5625	42.5625	42.5625	400.0
2018-04-09 05:58:00	AAPL	Stock	42.6075	42.6075	42.6075	42.6075	404.0
2018-04-09 06:17:00	AAPL	Stock	42.6025	42.6225	42.6025	42.6225	4972.0
2018-04-09 06:20:00	AAPL	Stock	42.685	42.6875	42.685	42.6875	1600.0
2018-04-09 06:24:00	AAPL	Stock	42.6225	42.6225	42.6225	42.6225	400.0
2018-04-09 06:39:00	AAPL	Stock	42.6725	42.6725	42.6725	42.6725	3200.0
2018-04-09 06:43:00	AAPL	Stock	42.6625	42.6625	42.6625	42.6625	800.0
2018-04-09 06:52:00	AAPL	Stock	42.63	42.63	42.5825	42.5825	32800.0
2018-04-09 06:53:00	AAPL	Stock	42.5825	42.5825	42.5725	42.5725	3200.0
2018-04-09 06:56:00	AAPL	Stock	42.57	42.575	42.57	42.575	4384.0
2018-04-09 06:57:00	AAPL	Stock	42.575	42.575	42.575	42.575	400.0
2018-04-09 06:58:00	AAPL	Stock	42.575	42.575	42.5625	42.5625	4400.0
2018-04-09 07:00:00	AAPL	Stock	42.575	42.6125	42.5525	42.5525	15888.0
2018-04-09 07:01:00	AAPL	Stock	42.575	42.575	42.525	42.5275	15228.0
2018-04-09 07:02:00	AAPL	Stock	42.5275	42.5275	42.525	42.525	2400.0
2018-04-09 07:03:00	AAPL	Stock	42.5325	42.535	42.525	42.525	10032.0
2018-04-09 07:04:00	AAPL	Stock	42.525	42.525	42.525	42.525	800.0
2018-04-09 07:05:00	AAPL	Stock	42.5275	42.5375	42.5275	42.5375	1200.0
2018-04-09 07:07:00	AAPL	Stock	42.53	42.5475	42.515	42.515	10768.0
2018-04-09 07:08:00	AAPL	Stock	42.53	42.5375	42.53	42.5375	5600.0
2018-04-09 07:09:00	AAPL	Stock	42.5475	42.55	42.5475	42.5475	1200.0
2018-04-09 07:10:00	AAPL	Stock	42.565	42.5675	42.5375	42.5375	23904.0
2018-04-09 07:12:00	AAPL	Stock	42.56	42.5675	42.5425	42.5675	10992.0
2018-04-09 07:13:00	AAPL	Stock	42.5475	42.5475	42.54	42.54	4800.0
2018-04-09 07:14:00	AAPL	Stock	42.55	42.55	42.55	42.55	2800.0
2018-04-09 07:15:00	AAPL	Stock	42.55	42.5525	42.5375	42.5375	8552.0
2018-04-09 07:17:00	AAPL	Stock	42.55	42.55	42.55	42.55	800.0
2018-04-09 07:18:00	AAPL	Stock	42.5375	42.5375	42.5325	42.5375	6400.0
2018-04-09 07:20:00	AAPL	Stock	42.5375	42.5375	42.5375	42.5375	1132.0
2018-04-09 07:22:00	AAPL	Stock	42.55	42.5625	42.55	42.5625	17488.0
2018-04-09 07:26:00	AAPL	Stock	42.5725	42.5725	42.5725	42.5725	400.0
2018-04-09 07:27:00	AAPL	Stock	42.55	42.55	42.55	42.55	1812.0
2018-04-09 07:28:00	AAPL	Stock	42.5625	42.575	42.5475	42.5625	8000.0
2018-04-09 07:32:00	AAPL	Stock	42.55	42.5625	42.55	42.55	5788.0
2018-04-09 07:33:00	AAPL	Stock	42.55	42.55	42.55	42.55	1040.0
2018-04-09 07:38:00	AAPL	Stock	42.5275	42.5275	42.5275	42.5275	1200.0
2018-04-09 07:40:00	AAPL	Stock	42.5275	42.5275	42.5275	42.5275	400.0
2018-04-09 07:41:00	AAPL	Stock	42.5425	42.5425	42.5125	42.5125	13600.0
2018-04-09 07:42:00	AAPL	Stock	42.5025	42.5025	42.5025	42.5025	400.0
2018-04-09 07:43:00	AAPL	Stock	42.5025	42.5225	42.5025	42.5225	2400.0
2018-04-09 07:44:00	AAPL	Stock	42.5025	42.505	42.5025	42.505	800.0
2018-04-09 07:45:00	AAPL	Stock	42.5125	42.5125	42.5	42.5	5560.0
2018-04-09 07:48:00	AAPL	Stock	42.5	42.5	42.5	42.5	800.0
2018-04-09 07:49:00	AAPL	Stock	42.505	42.505	42.505	42.505	800.0
2018-04-09 07:50:00	AAPL	Stock	42.48	42.48	42.48	42.48	400.0

> showing 50 of 1,068,591 rows — these rows as CSV

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