PREVIEW / stock_5min / 2019-07-31

all stock 5-min files

  file:    by_date/stock_5min/2019/2019-07-31.parquet
  size:    6.0 MB
  rows:    382,521
  symbols: 2,602

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
2019-07-31 04:00:00	AAPL	Stock	54.5325	54.5325	54.35	54.4225	30460.0
2019-07-31 04:05:00	AAPL	Stock	54.4	54.455	54.4	54.4125	9972.0
2019-07-31 04:10:00	AAPL	Stock	54.4125	54.4125	54.41	54.41	1560.0
2019-07-31 04:15:00	AAPL	Stock	54.41	54.42	54.41	54.42	19992.0
2019-07-31 04:20:00	AAPL	Stock	54.46	54.5475	54.46	54.5375	22088.0
2019-07-31 04:25:00	AAPL	Stock	54.55	54.575	54.525	54.55	12596.0
2019-07-31 04:30:00	AAPL	Stock	54.5075	54.545	54.5	54.545	12220.0
2019-07-31 04:35:00	AAPL	Stock	54.5275	54.5275	54.5275	54.5275	400.0
2019-07-31 04:40:00	AAPL	Stock	54.475	54.5	54.4425	54.4425	2588.0
2019-07-31 04:45:00	AAPL	Stock	54.4975	54.4975	54.4975	54.4975	400.0
2019-07-31 04:50:00	AAPL	Stock	54.5	54.5025	54.4875	54.495	4124.0
2019-07-31 04:55:00	AAPL	Stock	54.5	54.5	54.5	54.5	800.0
2019-07-31 05:00:00	AAPL	Stock	54.5	54.5475	54.5	54.5475	19304.0
2019-07-31 05:05:00	AAPL	Stock	54.525	54.5475	54.505	54.505	4820.0
2019-07-31 05:10:00	AAPL	Stock	54.545	54.55	54.5375	54.5375	9200.0
2019-07-31 05:15:00	AAPL	Stock	54.505	54.525	54.4825	54.4875	8480.0
2019-07-31 05:20:00	AAPL	Stock	54.4575	54.4575	54.4525	54.4575	4400.0
2019-07-31 05:25:00	AAPL	Stock	54.4725	54.4725	54.425	54.425	4076.0
2019-07-31 05:35:00	AAPL	Stock	54.3875	54.4375	54.3875	54.4375	2204.0
2019-07-31 05:40:00	AAPL	Stock	54.3825	54.4175	54.35	54.35	10184.0
2019-07-31 05:45:00	AAPL	Stock	54.355	54.355	54.275	54.275	15924.0
2019-07-31 05:50:00	AAPL	Stock	54.3125	54.3125	54.2875	54.2875	5968.0
2019-07-31 05:55:00	AAPL	Stock	54.29	54.3275	54.29	54.3275	6640.0
2019-07-31 06:00:00	AAPL	Stock	54.325	54.445	54.325	54.4375	12644.0
2019-07-31 06:10:00	AAPL	Stock	54.4375	54.4375	54.375	54.375	11964.0
2019-07-31 06:15:00	AAPL	Stock	54.4325	54.4425	54.4325	54.4425	2924.0
2019-07-31 06:20:00	AAPL	Stock	54.38	54.38	54.29	54.375	17344.0
2019-07-31 06:25:00	AAPL	Stock	54.435	54.435	54.435	54.435	400.0
2019-07-31 06:30:00	AAPL	Stock	54.375	54.38	54.375	54.375	12280.0
2019-07-31 06:35:00	AAPL	Stock	54.415	54.42	54.415	54.42	904.0
2019-07-31 06:45:00	AAPL	Stock	54.3775	54.385	54.335	54.3375	12148.0
2019-07-31 06:50:00	AAPL	Stock	54.3275	54.3475	54.3125	54.3475	10560.0
2019-07-31 06:55:00	AAPL	Stock	54.3475	54.3675	54.3375	54.3375	3600.0
2019-07-31 07:00:00	AAPL	Stock	54.37	54.5	54.3475	54.45	97324.0
2019-07-31 07:05:00	AAPL	Stock	54.45	54.525	54.425	54.45	118236.0
2019-07-31 07:10:00	AAPL	Stock	54.47	54.5	54.4475	54.465	36548.0
2019-07-31 07:15:00	AAPL	Stock	54.485	54.5	54.375	54.375	79892.0
2019-07-31 07:20:00	AAPL	Stock	54.375	54.4	54.3225	54.4	47852.0
2019-07-31 07:25:00	AAPL	Stock	54.395	54.45	54.395	54.425	12372.0
2019-07-31 07:30:00	AAPL	Stock	54.425	54.4275	54.375	54.425	74180.0
2019-07-31 07:35:00	AAPL	Stock	54.43	54.5475	54.415	54.5475	221812.0
2019-07-31 07:40:00	AAPL	Stock	54.5375	54.5725	54.525	54.55	93312.0
2019-07-31 07:45:00	AAPL	Stock	54.55	54.565	54.5275	54.5625	55308.0
2019-07-31 07:50:00	AAPL	Stock	54.56	54.5625	54.455	54.475	69828.0
2019-07-31 07:55:00	AAPL	Stock	54.48	54.4875	54.4375	54.455	54928.0
2019-07-31 08:00:00	AAPL	Stock	54.4325	54.5675	54.33	54.4625	260040.0
2019-07-31 08:05:00	AAPL	Stock	54.4525	54.4525	54.34	54.3875	141596.0
2019-07-31 08:10:00	AAPL	Stock	54.375	54.45	54.375	54.4	49964.0
2019-07-31 08:15:00	AAPL	Stock	54.435	54.435	54.3175	54.345	149896.0
2019-07-31 08:20:00	AAPL	Stock	54.3278	54.345	54.2775	54.345	138996.0

> showing 50 of 382,521 rows — these rows as CSV

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