PREVIEW / stock_1min / 2018-10-31

all stock 1-min files

  file:    by_date/stock_1min/2018/2018-10-31.parquet
  size:    16.7 MB
  rows:    1,160,726
  symbols: 2,330

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-10-31 04:06:00	AAPL	Stock	54.0	54.0	54.0	54.0	400.0
2018-10-31 04:10:00	AAPL	Stock	54.0	54.0	54.0	54.0	2000.0
2018-10-31 04:11:00	AAPL	Stock	54.0	54.0	54.0	54.0	2144.0
2018-10-31 04:15:00	AAPL	Stock	53.975	53.975	53.975	53.975	400.0
2018-10-31 04:24:00	AAPL	Stock	54.0	54.0	54.0	54.0	400.0
2018-10-31 04:25:00	AAPL	Stock	54.0	54.0	54.0	54.0	5596.0
2018-10-31 04:30:00	AAPL	Stock	54.1875	54.1875	54.1875	54.1875	800.0
2018-10-31 04:38:00	AAPL	Stock	54.175	54.18	54.175	54.18	2400.0
2018-10-31 04:39:00	AAPL	Stock	54.18	54.18	54.18	54.18	400.0
2018-10-31 04:40:00	AAPL	Stock	54.1175	54.1175	54.1175	54.1175	400.0
2018-10-31 04:41:00	AAPL	Stock	54.175	54.175	54.175	54.175	848.0
2018-10-31 04:47:00	AAPL	Stock	54.185	54.185	54.185	54.185	2000.0
2018-10-31 04:49:00	AAPL	Stock	54.18	54.18	54.18	54.18	400.0
2018-10-31 04:50:00	AAPL	Stock	54.145	54.145	54.145	54.145	600.0
2018-10-31 04:55:00	AAPL	Stock	54.125	54.1725	54.125	54.1725	1648.0
2018-10-31 05:01:00	AAPL	Stock	54.1625	54.1725	54.1625	54.1725	2400.0
2018-10-31 05:07:00	AAPL	Stock	54.095	54.095	54.095	54.095	2000.0
2018-10-31 05:16:00	AAPL	Stock	54.075	54.075	54.075	54.075	520.0
2018-10-31 05:20:00	AAPL	Stock	54.075	54.075	54.0625	54.0625	7600.0
2018-10-31 05:25:00	AAPL	Stock	54.0625	54.0625	54.0625	54.0625	640.0
2018-10-31 05:26:00	AAPL	Stock	54.0625	54.1	54.0625	54.1	800.0
2018-10-31 05:28:00	AAPL	Stock	54.1175	54.1175	54.1175	54.1175	2000.0
2018-10-31 05:32:00	AAPL	Stock	54.125	54.125	54.1225	54.125	8136.0
2018-10-31 05:34:00	AAPL	Stock	54.155	54.155	54.155	54.155	2544.0
2018-10-31 05:40:00	AAPL	Stock	54.075	54.075	54.075	54.075	700.0
2018-10-31 05:42:00	AAPL	Stock	54.075	54.075	54.0625	54.0625	2188.0
2018-10-31 05:46:00	AAPL	Stock	54.0225	54.025	54.0225	54.025	1704.0
2018-10-31 05:52:00	AAPL	Stock	54.0075	54.0075	54.0075	54.0075	2280.0
2018-10-31 05:59:00	AAPL	Stock	54.0375	54.0375	54.0375	54.0375	400.0
2018-10-31 06:04:00	AAPL	Stock	53.9775	53.9775	53.9775	53.9775	1760.0
2018-10-31 06:09:00	AAPL	Stock	53.9825	53.9825	53.9825	53.9825	400.0
2018-10-31 06:10:00	AAPL	Stock	53.9775	53.9775	53.9775	53.9775	1000.0
2018-10-31 06:11:00	AAPL	Stock	53.975	53.975	53.975	53.975	1752.0
2018-10-31 06:15:00	AAPL	Stock	53.9625	53.9625	53.9625	53.9625	492.0
2018-10-31 06:18:00	AAPL	Stock	53.995	53.995	53.995	53.995	400.0
2018-10-31 06:26:00	AAPL	Stock	53.895	53.895	53.8775	53.8775	6400.0
2018-10-31 06:28:00	AAPL	Stock	53.8775	53.8775	53.8625	53.8625	20752.0
2018-10-31 06:29:00	AAPL	Stock	53.8625	53.8625	53.8625	53.8625	3600.0
2018-10-31 06:30:00	AAPL	Stock	53.8625	53.8625	53.8625	53.8625	3200.0
2018-10-31 06:31:00	AAPL	Stock	53.85	53.8625	53.85	53.8625	2200.0
2018-10-31 06:32:00	AAPL	Stock	53.8625	53.9125	53.8625	53.91	11600.0
2018-10-31 06:34:00	AAPL	Stock	53.8625	53.8625	53.8625	53.8625	400.0
2018-10-31 06:35:00	AAPL	Stock	53.8375	53.8375	53.8375	53.8375	464.0
2018-10-31 06:37:00	AAPL	Stock	53.86	53.86	53.86	53.86	800.0
2018-10-31 06:42:00	AAPL	Stock	53.8875	53.9125	53.8875	53.9125	6904.0
2018-10-31 06:43:00	AAPL	Stock	53.9125	53.9125	53.9125	53.9125	14016.0
2018-10-31 06:44:00	AAPL	Stock	53.9125	53.925	53.9125	53.925	800.0
2018-10-31 06:46:00	AAPL	Stock	53.95	53.95	53.95	53.95	1080.0
2018-10-31 06:49:00	AAPL	Stock	53.9675	53.9675	53.9675	53.9675	1320.0
2018-10-31 06:50:00	AAPL	Stock	53.9625	53.985	53.9625	53.985	3960.0

> showing 50 of 1,160,726 rows — these rows as CSV

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