PREVIEW / stock_5min / 2017-07-28

all stock 5-min files

  file:    by_date/stock_5min/2017/2017-07-28.parquet
  size:    5.2 MB
  rows:    337,708
  symbols: 2,969

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-07-28 04:30:00	AAPL	Stock	37.3725	37.3725	37.3725	37.3725	400.0
2017-07-28 04:35:00	AAPL	Stock	37.3025	37.375	37.3025	37.3725	8900.0
2017-07-28 04:45:00	AAPL	Stock	37.3675	37.3675	37.3675	37.3675	400.0
2017-07-28 04:50:00	AAPL	Stock	37.3675	37.3675	37.3675	37.3675	400.0
2017-07-28 05:30:00	AAPL	Stock	37.325	37.325	37.325	37.325	6000.0
2017-07-28 05:45:00	AAPL	Stock	37.3725	37.3725	37.3725	37.3725	400.0
2017-07-28 05:55:00	AAPL	Stock	37.35	37.35	37.325	37.325	3200.0
2017-07-28 06:00:00	AAPL	Stock	37.3725	37.3725	37.3725	37.3725	400.0
2017-07-28 06:35:00	AAPL	Stock	37.325	37.325	37.325	37.325	400.0
2017-07-28 06:40:00	AAPL	Stock	37.35	37.35	37.3375	37.3375	2352.0
2017-07-28 06:45:00	AAPL	Stock	37.355	37.355	37.355	37.355	3840.0
2017-07-28 06:50:00	AAPL	Stock	37.3375	37.3375	37.3375	37.3375	2400.0
2017-07-28 06:55:00	AAPL	Stock	37.3325	37.3375	37.33	37.3375	7760.0
2017-07-28 07:00:00	AAPL	Stock	37.375	37.39	37.375	37.39	4228.0
2017-07-28 07:05:00	AAPL	Stock	37.3875	37.3875	37.3875	37.3875	1900.0
2017-07-28 07:15:00	AAPL	Stock	37.4025	37.4025	37.4025	37.4025	400.0
2017-07-28 07:25:00	AAPL	Stock	37.42	37.4225	37.4075	37.4075	5600.0
2017-07-28 07:30:00	AAPL	Stock	37.39	37.4075	37.39	37.4075	1444.0
2017-07-28 07:35:00	AAPL	Stock	37.4125	37.4125	37.4125	37.4125	400.0
2017-07-28 07:40:00	AAPL	Stock	37.4125	37.4325	37.395	37.4325	5748.0
2017-07-28 07:55:00	AAPL	Stock	37.4175	37.4175	37.4175	37.4175	400.0
2017-07-28 08:00:00	AAPL	Stock	37.445	37.4475	37.395	37.395	24304.0
2017-07-28 08:05:00	AAPL	Stock	37.41	37.4175	37.395	37.4175	19152.0
2017-07-28 08:10:00	AAPL	Stock	37.4175	37.4175	37.4175	37.4175	4920.0
2017-07-28 08:15:00	AAPL	Stock	37.4175	37.425	37.4175	37.4175	9476.0
2017-07-28 08:20:00	AAPL	Stock	37.425	37.4375	37.425	37.435	10044.0
2017-07-28 08:25:00	AAPL	Stock	37.43	37.43	37.3775	37.3775	22804.0
2017-07-28 08:30:00	AAPL	Stock	37.3875	37.45	37.3875	37.425	12248.0
2017-07-28 08:35:00	AAPL	Stock	37.3775	37.4	37.3775	37.4	27196.0
2017-07-28 08:40:00	AAPL	Stock	37.395	37.425	37.395	37.425	7780.0
2017-07-28 08:45:00	AAPL	Stock	37.4375	37.4375	37.4375	37.4375	1688.0
2017-07-28 08:50:00	AAPL	Stock	37.45	37.45	37.4	37.4375	7828.0
2017-07-28 08:55:00	AAPL	Stock	37.4275	37.4575	37.4125	37.4575	14348.0
2017-07-28 09:00:00	AAPL	Stock	37.4625	37.485	37.4375	37.4625	13384.0
2017-07-28 09:05:00	AAPL	Stock	37.455	37.48	37.4525	37.4525	11928.0
2017-07-28 09:10:00	AAPL	Stock	37.4725	37.475	37.4575	37.4575	14536.0
2017-07-28 09:15:00	AAPL	Stock	37.47	37.4825	37.455	37.46	13840.0
2017-07-28 09:20:00	AAPL	Stock	37.4625	37.4725	37.44	37.4525	26048.0
2017-07-28 09:25:00	AAPL	Stock	37.4525	37.4925	37.4	37.475	137004.0
2017-07-28 09:30:00	AAPL	Stock	37.485	37.515	37.345	37.365	3303688.0
2017-07-28 09:35:00	AAPL	Stock	37.3675	37.4625	37.34	37.4	2783080.0
2017-07-28 09:40:00	AAPL	Stock	37.4025	37.5575	37.4	37.52	2279652.0
2017-07-28 09:45:00	AAPL	Stock	37.5175	37.5175	37.44	37.453	1380256.0
2017-07-28 09:50:00	AAPL	Stock	37.4515	37.48	37.355	37.375	1485868.0
2017-07-28 09:55:00	AAPL	Stock	37.37	37.445	37.315	37.38	1156760.0
2017-07-28 10:00:00	AAPL	Stock	37.3802	37.4625	37.375	37.4575	784524.0
2017-07-28 10:05:00	AAPL	Stock	37.4588	37.47	37.39	37.4238	711872.0
2017-07-28 10:10:00	AAPL	Stock	37.425	37.515	37.4225	37.515	1027740.0
2017-07-28 10:15:00	AAPL	Stock	37.515	37.55	37.48	37.51	870948.0
2017-07-28 10:20:00	AAPL	Stock	37.51	37.5312	37.4175	37.4325	660572.0

> showing 50 of 337,708 rows — these rows as CSV

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