PREVIEW / stock_5min / 2018-05-23

all stock 5-min files

  file:    by_date/stock_5min/2018/2018-05-23.parquet
  size:    5.5 MB
  rows:    357,366
  symbols: 2,847

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-05-23 04:00:00	AAPL	Stock	46.4975	46.4975	46.4975	46.4975	4248.0
2018-05-23 04:15:00	AAPL	Stock	46.515	46.515	46.4425	46.4425	2700.0
2018-05-23 04:20:00	AAPL	Stock	46.3775	46.3775	46.375	46.375	4460.0
2018-05-23 04:25:00	AAPL	Stock	46.35	46.35	46.35	46.35	1600.0
2018-05-23 04:30:00	AAPL	Stock	46.31	46.31	46.31	46.31	400.0
2018-05-23 04:35:00	AAPL	Stock	46.35	46.35	46.3375	46.3375	2000.0
2018-05-23 04:40:00	AAPL	Stock	46.3375	46.3375	46.3	46.3125	32840.0
2018-05-23 04:50:00	AAPL	Stock	46.3125	46.3125	46.3125	46.3125	1160.0
2018-05-23 04:55:00	AAPL	Stock	46.3125	46.3125	46.2625	46.2625	2016.0
2018-05-23 05:00:00	AAPL	Stock	46.2525	46.2525	46.25	46.25	1400.0
2018-05-23 05:05:00	AAPL	Stock	46.2375	46.2375	46.175	46.175	15580.0
2018-05-23 05:10:00	AAPL	Stock	46.175	46.2375	46.1625	46.2125	5740.0
2018-05-23 05:15:00	AAPL	Stock	46.25	46.25	46.25	46.25	3116.0
2018-05-23 05:20:00	AAPL	Stock	46.25	46.25	46.25	46.25	1212.0
2018-05-23 05:25:00	AAPL	Stock	46.25	46.25	46.25	46.25	508.0
2018-05-23 06:15:00	AAPL	Stock	46.3	46.3	46.3	46.3	2000.0
2018-05-23 06:25:00	AAPL	Stock	46.3	46.3	46.3	46.3	2400.0
2018-05-23 06:30:00	AAPL	Stock	46.3425	46.3425	46.3425	46.3425	400.0
2018-05-23 06:35:00	AAPL	Stock	46.3425	46.3425	46.3425	46.3425	1040.0
2018-05-23 06:40:00	AAPL	Stock	46.32	46.32	46.32	46.32	1400.0
2018-05-23 06:45:00	AAPL	Stock	46.32	46.355	46.3025	46.355	3720.0
2018-05-23 06:55:00	AAPL	Stock	46.33	46.33	46.325	46.325	3600.0
2018-05-23 07:00:00	AAPL	Stock	46.375	46.4875	46.3025	46.4475	78624.0
2018-05-23 07:05:00	AAPL	Stock	46.4025	46.435	46.4	46.4	8300.0
2018-05-23 07:10:00	AAPL	Stock	46.43	46.4325	46.3825	46.3875	8252.0
2018-05-23 07:15:00	AAPL	Stock	46.4	46.425	46.35	46.35	73404.0
2018-05-23 07:20:00	AAPL	Stock	46.36	46.3875	46.35	46.3875	7124.0
2018-05-23 07:25:00	AAPL	Stock	46.4475	46.4475	46.4375	46.4375	800.0
2018-05-23 07:30:00	AAPL	Stock	46.4475	46.4625	46.425	46.425	3916.0
2018-05-23 07:35:00	AAPL	Stock	46.4375	46.4375	46.4375	46.4375	1680.0
2018-05-23 07:40:00	AAPL	Stock	46.425	46.425	46.425	46.425	1784.0
2018-05-23 07:45:00	AAPL	Stock	46.435	46.435	46.3875	46.3875	5968.0
2018-05-23 07:50:00	AAPL	Stock	46.38	46.4175	46.38	46.4025	16840.0
2018-05-23 07:55:00	AAPL	Stock	46.405	46.405	46.3875	46.4	5184.0
2018-05-23 08:00:00	AAPL	Stock	46.41	46.4875	46.3025	46.365	140728.0
2018-05-23 08:05:00	AAPL	Stock	46.38	46.415	46.3775	46.415	72852.0
2018-05-23 08:10:00	AAPL	Stock	46.4225	46.45	46.4225	46.45	21404.0
2018-05-23 08:15:00	AAPL	Stock	46.47	46.485	46.45	46.45	27508.0
2018-05-23 08:20:00	AAPL	Stock	46.45	46.475	46.4375	46.4525	43128.0
2018-05-23 08:25:00	AAPL	Stock	46.455	46.485	46.455	46.475	50052.0
2018-05-23 08:30:00	AAPL	Stock	46.4775	46.5375	46.4775	46.5	64436.0
2018-05-23 08:35:00	AAPL	Stock	46.5	46.525	46.495	46.525	66172.0
2018-05-23 08:40:00	AAPL	Stock	46.5375	46.5575	46.5325	46.5375	37728.0
2018-05-23 08:45:00	AAPL	Stock	46.5375	46.555	46.5	46.5125	96012.0
2018-05-23 08:50:00	AAPL	Stock	46.52	46.5375	46.5075	46.5375	60584.0
2018-05-23 08:55:00	AAPL	Stock	46.5425	46.5525	46.5375	46.5525	19032.0
2018-05-23 09:00:00	AAPL	Stock	46.5475	46.5475	46.465	46.4825	89192.0
2018-05-23 09:05:00	AAPL	Stock	46.485	46.525	46.4825	46.4875	36112.0
2018-05-23 09:10:00	AAPL	Stock	46.5	46.525	46.5	46.5225	12416.0
2018-05-23 09:15:00	AAPL	Stock	46.5225	46.545	46.5075	46.515	24956.0

> showing 50 of 357,366 rows — these rows as CSV

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