PREVIEW / stock_1min / 2017-01-03

all stock 1-min files

  file:    by_date/stock_1min/2017/2017-01-03.parquet
  size:    15.5 MB
  rows:    1,105,600
  symbols: 2,589

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-03 04:03:00	AAPL	Stock	29.005	29.005	29.005	29.005	800.0
2017-01-03 04:06:00	AAPL	Stock	29.035	29.035	29.035	29.035	400.0
2017-01-03 04:07:00	AAPL	Stock	29.035	29.06	29.03	29.0375	5480.0
2017-01-03 04:08:00	AAPL	Stock	29.0375	29.0375	29.0325	29.0325	4400.0
2017-01-03 04:09:00	AAPL	Stock	29.0375	29.0375	29.0375	29.0375	400.0
2017-01-03 04:11:00	AAPL	Stock	29.0	29.04	29.0	29.04	2000.0
2017-01-03 04:12:00	AAPL	Stock	29.04	29.04	29.0375	29.0375	1968.0
2017-01-03 04:16:00	AAPL	Stock	29.0425	29.0425	29.0425	29.0425	400.0
2017-01-03 04:17:00	AAPL	Stock	29.0425	29.0425	29.0425	29.0425	2400.0
2017-01-03 04:18:00	AAPL	Stock	29.0425	29.0425	29.0425	29.0425	800.0
2017-01-03 04:19:00	AAPL	Stock	29.0375	29.0375	29.0	29.005	8080.0
2017-01-03 04:23:00	AAPL	Stock	29.0125	29.0125	29.0125	29.0125	560.0
2017-01-03 04:24:00	AAPL	Stock	29.0125	29.0125	29.0125	29.0125	400.0
2017-01-03 04:29:00	AAPL	Stock	29.0125	29.0125	29.0125	29.0125	1200.0
2017-01-03 04:30:00	AAPL	Stock	29.0125	29.0125	29.0125	29.0125	2328.0
2017-01-03 04:31:00	AAPL	Stock	29.0125	29.0125	29.01	29.01	2292.0
2017-01-03 04:35:00	AAPL	Stock	29.0125	29.0125	29.0125	29.0125	428.0
2017-01-03 04:53:00	AAPL	Stock	29.0125	29.0125	29.0125	29.0125	800.0
2017-01-03 05:01:00	AAPL	Stock	29.0075	29.0075	29.005	29.0075	2960.0
2017-01-03 05:23:00	AAPL	Stock	29.015	29.015	29.0025	29.0025	1656.0
2017-01-03 05:41:00	AAPL	Stock	29.005	29.005	29.0	29.0	9456.0
2017-01-03 05:46:00	AAPL	Stock	29.0	29.0	29.0	29.0	480.0
2017-01-03 05:55:00	AAPL	Stock	29.005	29.005	29.005	29.005	400.0
2017-01-03 06:01:00	AAPL	Stock	29.0175	29.0175	29.0175	29.0175	2000.0
2017-01-03 06:10:00	AAPL	Stock	29.03	29.03	29.03	29.03	1032.0
2017-01-03 06:11:00	AAPL	Stock	29.03	29.03	29.03	29.03	1200.0
2017-01-03 06:12:00	AAPL	Stock	29.03	29.03	29.03	29.03	2164.0
2017-01-03 06:27:00	AAPL	Stock	29.035	29.035	29.035	29.035	480.0
2017-01-03 06:29:00	AAPL	Stock	29.035	29.045	29.035	29.045	2916.0
2017-01-03 06:44:00	AAPL	Stock	29.07	29.07	29.07	29.07	400.0
2017-01-03 07:02:00	AAPL	Stock	29.0575	29.0575	29.0575	29.0575	2000.0
2017-01-03 07:03:00	AAPL	Stock	29.0725	29.0825	29.0725	29.0825	1120.0
2017-01-03 07:04:00	AAPL	Stock	29.0925	29.0925	29.0925	29.0925	1636.0
2017-01-03 07:06:00	AAPL	Stock	29.095	29.095	29.095	29.095	3600.0
2017-01-03 07:09:00	AAPL	Stock	29.075	29.075	29.075	29.075	800.0
2017-01-03 07:14:00	AAPL	Stock	29.0875	29.0875	29.0875	29.0875	1800.0
2017-01-03 07:18:00	AAPL	Stock	29.0775	29.0775	29.0775	29.0775	1200.0
2017-01-03 07:20:00	AAPL	Stock	29.09	29.09	29.09	29.09	2000.0
2017-01-03 07:21:00	AAPL	Stock	29.0775	29.0775	29.075	29.075	2640.0
2017-01-03 07:31:00	AAPL	Stock	29.04	29.04	29.03	29.0325	5600.0
2017-01-03 07:32:00	AAPL	Stock	29.0325	29.0325	29.0325	29.0325	1600.0
2017-01-03 07:33:00	AAPL	Stock	29.0325	29.0325	29.0325	29.0325	400.0
2017-01-03 07:38:00	AAPL	Stock	29.0475	29.0475	29.0475	29.0475	800.0
2017-01-03 07:46:00	AAPL	Stock	29.045	29.0475	29.045	29.0475	2400.0
2017-01-03 07:50:00	AAPL	Stock	29.0375	29.0375	29.0375	29.0375	800.0
2017-01-03 07:51:00	AAPL	Stock	29.0425	29.0425	29.0425	29.0425	3140.0
2017-01-03 07:54:00	AAPL	Stock	29.035	29.035	29.0175	29.0175	5620.0
2017-01-03 07:55:00	AAPL	Stock	29.015	29.0175	29.015	29.015	11400.0
2017-01-03 07:56:00	AAPL	Stock	29.0075	29.0075	29.005	29.005	7200.0
2017-01-03 08:00:00	AAPL	Stock	29.02	29.1	29.015	29.04	35652.0

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

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