PREVIEW / stock_1min / 2018-11-01

all stock 1-min files

  file:    by_date/stock_1min/2018/2018-11-01.parquet
  size:    16.8 MB
  rows:    1,177,286
  symbols: 2,318

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-01 04:00:00	AAPL	Stock	54.745	54.745	54.7325	54.7325	4400.0
2018-11-01 04:01:00	AAPL	Stock	54.725	54.725	54.725	54.725	400.0
2018-11-01 04:02:00	AAPL	Stock	54.725	54.725	54.725	54.725	400.0
2018-11-01 04:03:00	AAPL	Stock	54.725	54.725	54.725	54.725	400.0
2018-11-01 04:05:00	AAPL	Stock	54.715	54.715	54.715	54.715	1880.0
2018-11-01 04:06:00	AAPL	Stock	54.625	54.625	54.625	54.625	616.0
2018-11-01 04:08:00	AAPL	Stock	54.715	54.715	54.715	54.715	400.0
2018-11-01 04:10:00	AAPL	Stock	54.715	54.715	54.715	54.715	920.0
2018-11-01 04:14:00	AAPL	Stock	54.715	54.715	54.69	54.69	2800.0
2018-11-01 04:15:00	AAPL	Stock	54.665	54.665	54.665	54.665	988.0
2018-11-01 04:28:00	AAPL	Stock	54.7975	54.8175	54.7975	54.8175	3564.0
2018-11-01 04:29:00	AAPL	Stock	54.825	54.825	54.8175	54.825	3200.0
2018-11-01 04:31:00	AAPL	Stock	54.875	54.875	54.875	54.875	1600.0
2018-11-01 04:36:00	AAPL	Stock	54.905	54.905	54.905	54.905	976.0
2018-11-01 04:37:00	AAPL	Stock	54.905	54.905	54.905	54.905	1200.0
2018-11-01 04:41:00	AAPL	Stock	54.905	54.905	54.905	54.905	1104.0
2018-11-01 04:44:00	AAPL	Stock	54.9075	54.9075	54.905	54.905	3880.0
2018-11-01 04:52:00	AAPL	Stock	54.955	54.955	54.955	54.955	800.0
2018-11-01 05:03:00	AAPL	Stock	54.9	54.9	54.9	54.9	4000.0
2018-11-01 05:04:00	AAPL	Stock	54.915	54.915	54.915	54.915	1464.0
2018-11-01 05:09:00	AAPL	Stock	54.91	54.91	54.91	54.91	400.0
2018-11-01 05:11:00	AAPL	Stock	54.9	54.9	54.8925	54.8925	4812.0
2018-11-01 05:12:00	AAPL	Stock	54.935	54.9475	54.935	54.9475	1880.0
2018-11-01 05:22:00	AAPL	Stock	54.875	54.875	54.875	54.875	1080.0
2018-11-01 05:26:00	AAPL	Stock	54.85	54.85	54.85	54.85	1716.0
2018-11-01 05:28:00	AAPL	Stock	54.85	54.8725	54.85	54.8725	2400.0
2018-11-01 05:30:00	AAPL	Stock	54.9075	54.925	54.9075	54.925	4968.0
2018-11-01 05:44:00	AAPL	Stock	54.875	54.875	54.855	54.855	2448.0
2018-11-01 05:52:00	AAPL	Stock	54.8875	54.8875	54.8875	54.8875	3600.0
2018-11-01 05:55:00	AAPL	Stock	54.9125	54.9375	54.9125	54.9375	23260.0
2018-11-01 06:00:00	AAPL	Stock	54.9875	54.9875	54.9875	54.9875	1756.0
2018-11-01 06:02:00	AAPL	Stock	54.9775	55.02	54.9775	55.02	6468.0
2018-11-01 06:03:00	AAPL	Stock	54.9775	55.0175	54.9775	55.0175	2188.0
2018-11-01 06:06:00	AAPL	Stock	55.0175	55.0175	55.0175	55.0175	400.0
2018-11-01 06:09:00	AAPL	Stock	55.0075	55.0075	55.0075	55.0075	1252.0
2018-11-01 06:10:00	AAPL	Stock	55.0075	55.0075	55.0075	55.0075	2800.0
2018-11-01 06:11:00	AAPL	Stock	55.0	55.005	55.0	55.005	1200.0
2018-11-01 06:15:00	AAPL	Stock	55.045	55.045	54.9875	54.9875	2760.0
2018-11-01 06:22:00	AAPL	Stock	55.0	55.0	55.0	55.0	400.0
2018-11-01 06:24:00	AAPL	Stock	54.995	54.995	54.995	54.995	400.0
2018-11-01 06:27:00	AAPL	Stock	54.995	54.995	54.995	54.995	1200.0
2018-11-01 06:31:00	AAPL	Stock	55.0	55.0	55.0	55.0	4000.0
2018-11-01 06:32:00	AAPL	Stock	55.0	55.0	54.9975	55.0	22508.0
2018-11-01 06:34:00	AAPL	Stock	55.0225	55.0225	55.0225	55.0225	400.0
2018-11-01 06:38:00	AAPL	Stock	55.015	55.0225	55.015	55.02	11040.0
2018-11-01 06:40:00	AAPL	Stock	54.995	55.0025	54.995	55.0	10000.0
2018-11-01 06:41:00	AAPL	Stock	55.0025	55.0025	55.0025	55.0025	4000.0
2018-11-01 06:42:00	AAPL	Stock	55.0	55.0	54.995	54.995	7768.0
2018-11-01 06:43:00	AAPL	Stock	54.995	55.0	54.995	55.0	3704.0
2018-11-01 06:44:00	AAPL	Stock	55.035	55.0375	55.035	55.0375	2368.0

> showing 50 of 1,177,286 rows — these rows as CSV

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