PREVIEW / stock_5min / 2017-06-22

all stock 5-min files

  file:    by_date/stock_5min/2017/2017-06-22.parquet
  size:    5.3 MB
  rows:    349,975
  symbols: 3,023

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-06-22 04:20:00	AAPL	Stock	36.5225	36.5225	36.5225	36.5225	800.0
2017-06-22 04:50:00	AAPL	Stock	36.4925	36.4925	36.4875	36.4875	1716.0
2017-06-22 06:00:00	AAPL	Stock	36.485	36.485	36.485	36.485	2000.0
2017-06-22 06:05:00	AAPL	Stock	36.455	36.455	36.455	36.455	400.0
2017-06-22 06:10:00	AAPL	Stock	36.455	36.455	36.455	36.455	1224.0
2017-06-22 06:45:00	AAPL	Stock	36.45	36.45	36.45	36.45	1140.0
2017-06-22 07:25:00	AAPL	Stock	36.47	36.47	36.47	36.47	400.0
2017-06-22 07:30:00	AAPL	Stock	36.46	36.46	36.45	36.45	4652.0
2017-06-22 07:50:00	AAPL	Stock	36.4425	36.4425	36.4425	36.4425	400.0
2017-06-22 07:55:00	AAPL	Stock	36.44	36.45	36.4125	36.4475	19040.0
2017-06-22 08:00:00	AAPL	Stock	36.45	36.45	36.4275	36.44	9724.0
2017-06-22 08:05:00	AAPL	Stock	36.435	36.4375	36.4175	36.4175	21976.0
2017-06-22 08:15:00	AAPL	Stock	36.425	36.425	36.425	36.425	1736.0
2017-06-22 08:20:00	AAPL	Stock	36.44	36.44	36.4375	36.4375	12544.0
2017-06-22 08:25:00	AAPL	Stock	36.4625	36.465	36.45	36.465	8000.0
2017-06-22 08:40:00	AAPL	Stock	36.475	36.475	36.4725	36.4725	3000.0
2017-06-22 08:45:00	AAPL	Stock	36.4725	36.48	36.4725	36.48	22604.0
2017-06-22 08:55:00	AAPL	Stock	36.465	36.465	36.4475	36.4475	6708.0
2017-06-22 09:05:00	AAPL	Stock	36.4475	36.4475	36.445	36.445	3464.0
2017-06-22 09:10:00	AAPL	Stock	36.45	36.45	36.45	36.45	800.0
2017-06-22 09:15:00	AAPL	Stock	36.4525	36.48	36.4525	36.4575	2600.0
2017-06-22 09:20:00	AAPL	Stock	36.455	36.48	36.45	36.45	7520.0
2017-06-22 09:25:00	AAPL	Stock	36.475	36.5	36.405	36.4375	25004.0
2017-06-22 09:30:00	AAPL	Stock	36.4375	36.4925	36.345	36.3975	2520308.0
2017-06-22 09:35:00	AAPL	Stock	36.4075	36.4218	36.3325	36.3548	1104668.0
2017-06-22 09:40:00	AAPL	Stock	36.35	36.41	36.345	36.355	1242040.0
2017-06-22 09:45:00	AAPL	Stock	36.3562	36.3675	36.3075	36.3175	1121612.0
2017-06-22 09:50:00	AAPL	Stock	36.3175	36.3475	36.28	36.3325	1597420.0
2017-06-22 09:55:00	AAPL	Stock	36.3325	36.3598	36.3025	36.3325	953180.0
2017-06-22 10:00:00	AAPL	Stock	36.335	36.345	36.2925	36.342	892304.0
2017-06-22 10:05:00	AAPL	Stock	36.3425	36.3975	36.34	36.375	1120588.0
2017-06-22 10:10:00	AAPL	Stock	36.3775	36.39	36.3575	36.3725	673712.0
2017-06-22 10:15:00	AAPL	Stock	36.3725	36.425	36.365	36.415	862040.0
2017-06-22 10:20:00	AAPL	Stock	36.4125	36.415	36.3725	36.3902	517020.0
2017-06-22 10:25:00	AAPL	Stock	36.39	36.39	36.3075	36.3175	1033560.0
2017-06-22 10:30:00	AAPL	Stock	36.3175	36.3425	36.29	36.295	1131672.0
2017-06-22 10:35:00	AAPL	Stock	36.2938	36.355	36.28	36.3475	862276.0
2017-06-22 10:40:00	AAPL	Stock	36.3475	36.3825	36.3375	36.36	1039708.0
2017-06-22 10:45:00	AAPL	Stock	36.36	36.425	36.3525	36.4038	1030116.0
2017-06-22 10:50:00	AAPL	Stock	36.405	36.44	36.405	36.4368	739308.0
2017-06-22 10:55:00	AAPL	Stock	36.4375	36.4475	36.3775	36.38	689956.0
2017-06-22 11:00:00	AAPL	Stock	36.38	36.3938	36.3312	36.365	508860.0
2017-06-22 11:05:00	AAPL	Stock	36.365	36.3825	36.345	36.355	540656.0
2017-06-22 11:10:00	AAPL	Stock	36.355	36.375	36.3475	36.3575	494420.0
2017-06-22 11:15:00	AAPL	Stock	36.36	36.3625	36.295	36.3425	794012.0
2017-06-22 11:20:00	AAPL	Stock	36.345	36.35	36.3215	36.33	388372.0
2017-06-22 11:25:00	AAPL	Stock	36.3275	36.3728	36.32	36.355	451168.0
2017-06-22 11:30:00	AAPL	Stock	36.3575	36.3625	36.3175	36.3525	480068.0
2017-06-22 11:35:00	AAPL	Stock	36.35	36.365	36.325	36.3432	350720.0
2017-06-22 11:40:00	AAPL	Stock	36.345	36.365	36.2925	36.3	764432.0

> showing 50 of 349,975 rows — these rows as CSV

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