PREVIEW / stock_1min / 2018-11-05

all stock 1-min files

  file:    by_date/stock_1min/2018/2018-11-05.parquet
  size:    15.7 MB
  rows:    1,105,012
  symbols: 2,309

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-11-05 04:00:00	AAPL	Stock	51.625	51.625	51.625	51.625	7988.0
2018-11-05 04:01:00	AAPL	Stock	51.625	51.625	51.62	51.62	2000.0
2018-11-05 04:06:00	AAPL	Stock	51.575	51.575	51.575	51.575	948.0
2018-11-05 04:07:00	AAPL	Stock	51.55	51.5525	51.55	51.5525	3740.0
2018-11-05 04:08:00	AAPL	Stock	51.62	51.6225	51.62	51.6225	3628.0
2018-11-05 04:18:00	AAPL	Stock	51.525	51.525	51.525	51.525	1160.0
2018-11-05 04:19:00	AAPL	Stock	51.525	51.525	51.525	51.525	652.0
2018-11-05 04:24:00	AAPL	Stock	51.5375	51.5375	51.5375	51.5375	1200.0
2018-11-05 04:25:00	AAPL	Stock	51.525	51.525	51.525	51.525	4000.0
2018-11-05 04:26:00	AAPL	Stock	51.525	51.525	51.525	51.525	800.0
2018-11-05 04:28:00	AAPL	Stock	51.5	51.5	51.4675	51.4675	6588.0
2018-11-05 04:29:00	AAPL	Stock	51.4275	51.4275	51.425	51.425	1596.0
2018-11-05 04:32:00	AAPL	Stock	51.435	51.435	51.4275	51.4275	1952.0
2018-11-05 04:35:00	AAPL	Stock	51.4325	51.4375	51.4325	51.4375	1068.0
2018-11-05 04:36:00	AAPL	Stock	51.49	51.49	51.48	51.48	800.0
2018-11-05 04:39:00	AAPL	Stock	51.4725	51.4725	51.4725	51.4725	1564.0
2018-11-05 04:40:00	AAPL	Stock	51.4725	51.4725	51.4725	51.4725	2004.0
2018-11-05 04:45:00	AAPL	Stock	51.4625	51.4625	51.4625	51.4625	4784.0
2018-11-05 05:00:00	AAPL	Stock	51.5775	51.5775	51.5775	51.5775	584.0
2018-11-05 05:01:00	AAPL	Stock	51.605	51.615	51.5775	51.5775	1876.0
2018-11-05 05:16:00	AAPL	Stock	51.57	51.57	51.57	51.57	3200.0
2018-11-05 05:19:00	AAPL	Stock	51.5	51.5	51.5	51.5	1312.0
2018-11-05 05:21:00	AAPL	Stock	51.5	51.5	51.5	51.5	800.0
2018-11-05 05:22:00	AAPL	Stock	51.57	51.57	51.57	51.57	400.0
2018-11-05 05:37:00	AAPL	Stock	51.5525	51.5525	51.5025	51.5025	5520.0
2018-11-05 05:38:00	AAPL	Stock	51.5575	51.56	51.5575	51.56	1200.0
2018-11-05 05:39:00	AAPL	Stock	51.505	51.505	51.505	51.505	400.0
2018-11-05 05:40:00	AAPL	Stock	51.5025	51.5025	51.5025	51.5025	4768.0
2018-11-05 05:45:00	AAPL	Stock	51.505	51.505	51.5025	51.5025	1600.0
2018-11-05 05:46:00	AAPL	Stock	51.535	51.535	51.535	51.535	896.0
2018-11-05 05:47:00	AAPL	Stock	51.5025	51.5025	51.5025	51.5025	3580.0
2018-11-05 05:48:00	AAPL	Stock	51.5025	51.5025	51.5	51.5	3496.0
2018-11-05 05:50:00	AAPL	Stock	51.525	51.535	51.525	51.535	4800.0
2018-11-05 05:51:00	AAPL	Stock	51.5375	51.5375	51.425	51.425	15832.0
2018-11-05 05:53:00	AAPL	Stock	51.48	51.48	51.425	51.425	5768.0
2018-11-05 05:54:00	AAPL	Stock	51.5175	51.5175	51.5175	51.5175	800.0
2018-11-05 05:55:00	AAPL	Stock	51.5175	51.5175	51.5175	51.5175	400.0
2018-11-05 05:56:00	AAPL	Stock	51.5475	51.55	51.5475	51.5475	3600.0
2018-11-05 05:57:00	AAPL	Stock	51.525	51.55	51.525	51.55	2400.0
2018-11-05 06:04:00	AAPL	Stock	51.5375	51.565	51.5375	51.565	1472.0
2018-11-05 06:05:00	AAPL	Stock	51.575	51.575	51.565	51.575	3768.0
2018-11-05 06:08:00	AAPL	Stock	51.55	51.55	51.55	51.55	528.0
2018-11-05 06:09:00	AAPL	Stock	51.5025	51.5025	51.5	51.5	4800.0
2018-11-05 06:10:00	AAPL	Stock	51.4975	51.5	51.465	51.465	2400.0
2018-11-05 06:12:00	AAPL	Stock	51.5	51.5	51.5	51.5	2000.0
2018-11-05 06:13:00	AAPL	Stock	51.5	51.5	51.5	51.5	3880.0
2018-11-05 06:15:00	AAPL	Stock	51.475	51.475	51.47	51.47	844.0
2018-11-05 06:16:00	AAPL	Stock	51.465	51.475	51.465	51.475	836.0
2018-11-05 06:17:00	AAPL	Stock	51.47	51.47	51.47	51.47	400.0
2018-11-05 06:18:00	AAPL	Stock	51.47	51.47	51.47	51.47	1600.0

> showing 50 of 1,105,012 rows — these rows as CSV

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