PREVIEW / stock_1min / 2017-09-06

all stock 1-min files

  file:    by_date/stock_1min/2017/2017-09-06.parquet
  size:    14.4 MB
  rows:    1,054,024
  symbols: 2,475

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-09-06 04:01:00	AAPL	Stock	40.605	40.605	40.605	40.605	15588.0
2017-09-06 04:49:00	AAPL	Stock	40.6725	40.6725	40.6725	40.6725	1956.0
2017-09-06 05:09:00	AAPL	Stock	40.6275	40.6275	40.625	40.625	4560.0
2017-09-06 05:39:00	AAPL	Stock	40.605	40.605	40.605	40.605	800.0
2017-09-06 05:52:00	AAPL	Stock	40.605	40.605	40.605	40.605	5884.0
2017-09-06 05:59:00	AAPL	Stock	40.6175	40.6175	40.6175	40.6175	400.0
2017-09-06 06:00:00	AAPL	Stock	40.6725	40.6875	40.6725	40.6875	15672.0
2017-09-06 06:24:00	AAPL	Stock	40.67	40.67	40.67	40.67	400.0
2017-09-06 06:30:00	AAPL	Stock	40.65	40.65	40.65	40.65	800.0
2017-09-06 06:40:00	AAPL	Stock	40.6025	40.6025	40.6	40.6	2772.0
2017-09-06 06:48:00	AAPL	Stock	40.595	40.595	40.585	40.585	4800.0
2017-09-06 06:58:00	AAPL	Stock	40.585	40.585	40.5625	40.5625	2892.0
2017-09-06 07:00:00	AAPL	Stock	40.5825	40.5925	40.5825	40.5925	800.0
2017-09-06 07:02:00	AAPL	Stock	40.5925	40.595	40.5875	40.5875	7356.0
2017-09-06 07:03:00	AAPL	Stock	40.5875	40.595	40.5775	40.5775	10216.0
2017-09-06 07:04:00	AAPL	Stock	40.595	40.595	40.595	40.595	400.0
2017-09-06 07:05:00	AAPL	Stock	40.595	40.595	40.595	40.595	2492.0
2017-09-06 07:07:00	AAPL	Stock	40.61	40.61	40.61	40.61	1200.0
2017-09-06 07:08:00	AAPL	Stock	40.6	40.6	40.6	40.6	400.0
2017-09-06 07:09:00	AAPL	Stock	40.61	40.6125	40.61	40.6125	4700.0
2017-09-06 07:10:00	AAPL	Stock	40.6125	40.625	40.6125	40.625	6900.0
2017-09-06 07:13:00	AAPL	Stock	40.61	40.61	40.61	40.61	1600.0
2017-09-06 07:15:00	AAPL	Stock	40.625	40.625	40.625	40.625	400.0
2017-09-06 07:17:00	AAPL	Stock	40.6125	40.6125	40.6125	40.6125	400.0
2017-09-06 07:23:00	AAPL	Stock	40.6125	40.6125	40.6125	40.6125	1512.0
2017-09-06 07:24:00	AAPL	Stock	40.6225	40.625	40.6225	40.625	1500.0
2017-09-06 07:26:00	AAPL	Stock	40.645	40.645	40.645	40.645	3992.0
2017-09-06 07:33:00	AAPL	Stock	40.6425	40.6425	40.6425	40.6425	400.0
2017-09-06 07:44:00	AAPL	Stock	40.615	40.615	40.6125	40.6125	2000.0
2017-09-06 07:46:00	AAPL	Stock	40.6325	40.6325	40.6325	40.6325	400.0
2017-09-06 07:47:00	AAPL	Stock	40.63	40.63	40.63	40.63	400.0
2017-09-06 07:48:00	AAPL	Stock	40.63	40.6475	40.63	40.6475	4400.0
2017-09-06 07:52:00	AAPL	Stock	40.6325	40.6325	40.625	40.625	11020.0
2017-09-06 07:53:00	AAPL	Stock	40.6325	40.6325	40.625	40.625	3640.0
2017-09-06 07:54:00	AAPL	Stock	40.6125	40.6125	40.6075	40.6075	9600.0
2017-09-06 07:55:00	AAPL	Stock	40.6075	40.6075	40.6075	40.6075	800.0
2017-09-06 07:59:00	AAPL	Stock	40.625	40.625	40.625	40.625	1336.0
2017-09-06 08:00:00	AAPL	Stock	40.6375	40.65	40.5875	40.6475	49104.0
2017-09-06 08:01:00	AAPL	Stock	40.6375	40.6375	40.6375	40.6375	440.0
2017-09-06 08:03:00	AAPL	Stock	40.645	40.66	40.645	40.66	6200.0
2017-09-06 08:04:00	AAPL	Stock	40.66	40.66	40.65	40.655	10200.0
2017-09-06 08:05:00	AAPL	Stock	40.65	40.65	40.6475	40.6475	6800.0
2017-09-06 08:06:00	AAPL	Stock	40.6475	40.6475	40.64	40.64	2400.0
2017-09-06 08:07:00	AAPL	Stock	40.6525	40.6525	40.6525	40.6525	400.0
2017-09-06 08:08:00	AAPL	Stock	40.6525	40.6525	40.65	40.65	1200.0
2017-09-06 08:09:00	AAPL	Stock	40.65	40.65	40.65	40.65	4900.0
2017-09-06 08:10:00	AAPL	Stock	40.6525	40.6525	40.65	40.6525	3600.0
2017-09-06 08:11:00	AAPL	Stock	40.6475	40.6475	40.6475	40.6475	400.0
2017-09-06 08:12:00	AAPL	Stock	40.6375	40.6375	40.6275	40.6275	3780.0
2017-09-06 08:13:00	AAPL	Stock	40.6375	40.6375	40.625	40.625	6404.0

> showing 50 of 1,054,024 rows — these rows as CSV

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