PREVIEW / stock_1min / 2017-01-27

all stock 1-min files

  file:    by_date/stock_1min/2017/2017-01-27.parquet
  size:    13.7 MB
  rows:    994,349
  symbols: 2,564

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-01-27 04:49:00	AAPL	Stock	30.4675	30.4675	30.4675	30.4675	400.0
2017-01-27 07:15:00	AAPL	Stock	30.5	30.51	30.5	30.51	6000.0
2017-01-27 07:19:00	AAPL	Stock	30.5125	30.5125	30.5125	30.5125	400.0
2017-01-27 07:43:00	AAPL	Stock	30.48	30.48	30.4625	30.4625	800.0
2017-01-27 07:44:00	AAPL	Stock	30.48	30.48	30.48	30.48	400.0
2017-01-27 07:48:00	AAPL	Stock	30.505	30.505	30.505	30.505	1400.0
2017-01-27 07:50:00	AAPL	Stock	30.4925	30.4925	30.4925	30.4925	800.0
2017-01-27 07:51:00	AAPL	Stock	30.4925	30.4925	30.4925	30.4925	2800.0
2017-01-27 07:55:00	AAPL	Stock	30.48	30.48	30.48	30.48	2000.0
2017-01-27 07:57:00	AAPL	Stock	30.4775	30.4775	30.4775	30.4775	1200.0
2017-01-27 08:00:00	AAPL	Stock	30.4775	30.4775	30.4775	30.4775	800.0
2017-01-27 08:01:00	AAPL	Stock	30.4975	30.4975	30.4975	30.4975	2436.0
2017-01-27 08:03:00	AAPL	Stock	30.4975	30.4975	30.4975	30.4975	400.0
2017-01-27 08:04:00	AAPL	Stock	30.4975	30.4975	30.4975	30.4975	2000.0
2017-01-27 08:10:00	AAPL	Stock	30.49	30.49	30.49	30.49	400.0
2017-01-27 08:12:00	AAPL	Stock	30.4875	30.4875	30.4875	30.4875	1200.0
2017-01-27 08:14:00	AAPL	Stock	30.4775	30.49	30.4775	30.49	2400.0
2017-01-27 08:15:00	AAPL	Stock	30.4775	30.4775	30.4775	30.4775	632.0
2017-01-27 08:20:00	AAPL	Stock	30.49	30.49	30.49	30.49	480.0
2017-01-27 08:22:00	AAPL	Stock	30.49	30.5	30.49	30.49	17276.0
2017-01-27 08:24:00	AAPL	Stock	30.5	30.5	30.5	30.5	3688.0
2017-01-27 08:25:00	AAPL	Stock	30.5025	30.5025	30.495	30.495	3600.0
2017-01-27 08:26:00	AAPL	Stock	30.495	30.4975	30.495	30.4975	9636.0
2017-01-27 08:28:00	AAPL	Stock	30.4975	30.4975	30.4975	30.4975	400.0
2017-01-27 08:34:00	AAPL	Stock	30.5	30.5	30.5	30.5	1200.0
2017-01-27 08:35:00	AAPL	Stock	30.515	30.515	30.515	30.515	1140.0
2017-01-27 08:37:00	AAPL	Stock	30.5275	30.5275	30.5275	30.5275	728.0
2017-01-27 08:41:00	AAPL	Stock	30.5375	30.5375	30.5375	30.5375	400.0
2017-01-27 08:50:00	AAPL	Stock	30.5175	30.5175	30.5175	30.5175	1480.0
2017-01-27 08:52:00	AAPL	Stock	30.525	30.525	30.525	30.525	1600.0
2017-01-27 08:55:00	AAPL	Stock	30.525	30.525	30.525	30.525	400.0
2017-01-27 08:56:00	AAPL	Stock	30.5175	30.5175	30.5175	30.5175	400.0
2017-01-27 08:58:00	AAPL	Stock	30.525	30.525	30.525	30.525	1960.0
2017-01-27 09:01:00	AAPL	Stock	30.5175	30.5175	30.5175	30.5175	2000.0
2017-01-27 09:05:00	AAPL	Stock	30.5175	30.5175	30.515	30.515	9648.0
2017-01-27 09:06:00	AAPL	Stock	30.5025	30.5025	30.5	30.5	4000.0
2017-01-27 09:07:00	AAPL	Stock	30.5	30.505	30.5	30.505	5216.0
2017-01-27 09:08:00	AAPL	Stock	30.505	30.505	30.505	30.505	400.0
2017-01-27 09:09:00	AAPL	Stock	30.495	30.495	30.495	30.495	800.0
2017-01-27 09:10:00	AAPL	Stock	30.495	30.495	30.49	30.49	13968.0
2017-01-27 09:13:00	AAPL	Stock	30.4925	30.4925	30.4925	30.4925	1200.0
2017-01-27 09:16:00	AAPL	Stock	30.49	30.49	30.49	30.49	11312.0
2017-01-27 09:19:00	AAPL	Stock	30.49	30.49	30.49	30.49	6716.0
2017-01-27 09:22:00	AAPL	Stock	30.495	30.495	30.495	30.495	600.0
2017-01-27 09:23:00	AAPL	Stock	30.495	30.495	30.49	30.49	4000.0
2017-01-27 09:24:00	AAPL	Stock	30.49	30.49	30.49	30.49	1800.0
2017-01-27 09:26:00	AAPL	Stock	30.5	30.5	30.5	30.5	12316.0
2017-01-27 09:27:00	AAPL	Stock	30.49	30.49	30.49	30.49	400.0
2017-01-27 09:28:00	AAPL	Stock	30.4975	30.53	30.4975	30.5275	4948.0
2017-01-27 09:29:00	AAPL	Stock	30.5475	30.55	30.5075	30.5125	73400.0

> showing 50 of 994,349 rows — these rows as CSV

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