PREVIEW / stock_1min / 2017-01-05

all stock 1-min files

  file:    by_date/stock_1min/2017/2017-01-05.parquet
  size:    14.9 MB
  rows:    1,073,561
  symbols: 2,578

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-05 07:01:00	AAPL	Stock	28.9625	28.9625	28.9625	28.9625	1000.0
2017-01-05 07:05:00	AAPL	Stock	28.985	28.985	28.985	28.985	2000.0
2017-01-05 07:19:00	AAPL	Stock	28.985	28.985	28.985	28.985	800.0
2017-01-05 07:27:00	AAPL	Stock	28.9725	28.9725	28.96	28.96	1884.0
2017-01-05 07:28:00	AAPL	Stock	28.9575	28.9575	28.9425	28.9425	6644.0
2017-01-05 07:44:00	AAPL	Stock	28.95	28.95	28.95	28.95	400.0
2017-01-05 07:45:00	AAPL	Stock	28.95	28.95	28.95	28.95	400.0
2017-01-05 07:54:00	AAPL	Stock	28.945	28.945	28.945	28.945	400.0
2017-01-05 07:55:00	AAPL	Stock	28.945	28.945	28.945	28.945	400.0
2017-01-05 08:00:00	AAPL	Stock	28.9975	28.9975	28.945	28.945	7640.0
2017-01-05 08:01:00	AAPL	Stock	28.9575	28.9575	28.9575	28.9575	800.0
2017-01-05 08:05:00	AAPL	Stock	28.95	28.95	28.95	28.95	640.0
2017-01-05 08:10:00	AAPL	Stock	28.9525	28.9525	28.9525	28.9525	400.0
2017-01-05 08:16:00	AAPL	Stock	28.97	28.97	28.97	28.97	400.0
2017-01-05 08:19:00	AAPL	Stock	28.98	28.98	28.98	28.98	400.0
2017-01-05 08:20:00	AAPL	Stock	28.965	28.965	28.965	28.965	2400.0
2017-01-05 08:30:00	AAPL	Stock	28.975	28.9825	28.9725	28.9825	2840.0
2017-01-05 08:31:00	AAPL	Stock	28.985	28.985	28.9575	28.9575	5420.0
2017-01-05 08:32:00	AAPL	Stock	28.9675	28.9725	28.9675	28.9675	4400.0
2017-01-05 08:33:00	AAPL	Stock	28.9725	28.985	28.97	28.985	14420.0
2017-01-05 08:34:00	AAPL	Stock	28.975	28.985	28.975	28.985	2400.0
2017-01-05 08:35:00	AAPL	Stock	28.995	29.0	28.9875	28.9875	15120.0
2017-01-05 08:36:00	AAPL	Stock	28.9925	28.9925	28.985	28.985	4620.0
2017-01-05 08:38:00	AAPL	Stock	28.9975	29.0	28.9975	29.0	1740.0
2017-01-05 08:39:00	AAPL	Stock	29.0	29.0	28.9975	28.9975	2288.0
2017-01-05 08:40:00	AAPL	Stock	28.9975	28.9975	28.9975	28.9975	400.0
2017-01-05 08:41:00	AAPL	Stock	28.9875	28.9975	28.9875	28.9975	1600.0
2017-01-05 08:44:00	AAPL	Stock	29.0125	29.0125	29.0125	29.0125	400.0
2017-01-05 08:45:00	AAPL	Stock	29.0125	29.0125	29.01	29.01	4200.0
2017-01-05 08:46:00	AAPL	Stock	29.0125	29.0125	29.0125	29.0125	6764.0
2017-01-05 08:47:00	AAPL	Stock	29.0	29.0	29.0	29.0	2800.0
2017-01-05 08:48:00	AAPL	Stock	29.0	29.0	29.0	29.0	800.0
2017-01-05 08:49:00	AAPL	Stock	29.015	29.015	29.015	29.015	800.0
2017-01-05 08:50:00	AAPL	Stock	29.0025	29.0025	29.0025	29.0025	400.0
2017-01-05 08:51:00	AAPL	Stock	29.0175	29.0175	29.0175	29.0175	400.0
2017-01-05 08:55:00	AAPL	Stock	29.0175	29.0175	29.0175	29.0175	1600.0
2017-01-05 09:02:00	AAPL	Stock	29.015	29.015	29.015	29.015	1200.0
2017-01-05 09:04:00	AAPL	Stock	29.015	29.0175	29.015	29.015	7632.0
2017-01-05 09:05:00	AAPL	Stock	29.015	29.015	29.015	29.015	2800.0
2017-01-05 09:10:00	AAPL	Stock	29.01	29.01	29.01	29.01	600.0
2017-01-05 09:13:00	AAPL	Stock	29.01	29.01	29.01	29.01	800.0
2017-01-05 09:14:00	AAPL	Stock	29.01	29.01	29.01	29.01	12000.0
2017-01-05 09:15:00	AAPL	Stock	29.0	29.0	28.9975	28.9975	2452.0
2017-01-05 09:16:00	AAPL	Stock	28.9925	28.9925	28.9875	28.9875	5180.0
2017-01-05 09:17:00	AAPL	Stock	29.0075	29.0075	29.0	29.0075	12800.0
2017-01-05 09:18:00	AAPL	Stock	29.0075	29.0075	29.0075	29.0075	400.0
2017-01-05 09:19:00	AAPL	Stock	29.0125	29.0125	29.0125	29.0125	3072.0
2017-01-05 09:20:00	AAPL	Stock	29.01	29.01	29.0075	29.0075	1000.0
2017-01-05 09:21:00	AAPL	Stock	29.0075	29.0075	29.0075	29.0075	400.0
2017-01-05 09:22:00	AAPL	Stock	29.0075	29.0175	29.0075	29.0175	2284.0

> showing 50 of 1,073,561 rows — these rows as CSV

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