PREVIEW / stock_5min / 2017-07-24

all stock 5-min files

  file:    by_date/stock_5min/2017/2017-07-24.parquet
  size:    5.3 MB
  rows:    349,315
  symbols: 2,978

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-24 05:40:00	AAPL	Stock	37.525	37.525	37.525	37.525	400.0
2017-07-24 06:55:00	AAPL	Stock	37.475	37.475	37.475	37.475	2000.0
2017-07-24 07:05:00	AAPL	Stock	37.5	37.5	37.5	37.5	4000.0
2017-07-24 07:20:00	AAPL	Stock	37.4875	37.4875	37.4875	37.4875	1300.0
2017-07-24 07:25:00	AAPL	Stock	37.5	37.5	37.5	37.5	1920.0
2017-07-24 07:30:00	AAPL	Stock	37.5125	37.5125	37.5125	37.5125	2100.0
2017-07-24 07:50:00	AAPL	Stock	37.52	37.52	37.52	37.52	1992.0
2017-07-24 07:55:00	AAPL	Stock	37.5275	37.5275	37.5275	37.5275	1200.0
2017-07-24 08:00:00	AAPL	Stock	37.5275	37.5375	37.52	37.5375	15472.0
2017-07-24 08:05:00	AAPL	Stock	37.5375	37.5375	37.5375	37.5375	528.0
2017-07-24 08:25:00	AAPL	Stock	37.5625	37.5825	37.5625	37.5825	1600.0
2017-07-24 08:30:00	AAPL	Stock	37.5825	37.5925	37.5825	37.5925	5468.0
2017-07-24 08:35:00	AAPL	Stock	37.5875	37.59	37.5875	37.59	1600.0
2017-07-24 08:40:00	AAPL	Stock	37.59	37.59	37.5875	37.5875	3024.0
2017-07-24 08:45:00	AAPL	Stock	37.5875	37.595	37.5875	37.5925	7700.0
2017-07-24 08:50:00	AAPL	Stock	37.5775	37.5775	37.5775	37.5775	5000.0
2017-07-24 08:55:00	AAPL	Stock	37.5625	37.5625	37.5625	37.5625	1296.0
2017-07-24 09:00:00	AAPL	Stock	37.58	37.5825	37.58	37.5825	3200.0
2017-07-24 09:05:00	AAPL	Stock	37.57	37.57	37.57	37.57	400.0
2017-07-24 09:10:00	AAPL	Stock	37.585	37.585	37.5825	37.5825	44120.0
2017-07-24 09:15:00	AAPL	Stock	37.5825	37.5875	37.5825	37.5875	2284.0
2017-07-24 09:20:00	AAPL	Stock	37.595	37.595	37.595	37.595	2200.0
2017-07-24 09:25:00	AAPL	Stock	37.5875	37.66	37.5875	37.6375	16628.0
2017-07-24 09:30:00	AAPL	Stock	37.645	37.6675	37.5358	37.5698	2209972.0
2017-07-24 09:35:00	AAPL	Stock	37.57	37.5775	37.475	37.508	1165280.0
2017-07-24 09:40:00	AAPL	Stock	37.51	37.5625	37.5025	37.535	1003588.0
2017-07-24 09:45:00	AAPL	Stock	37.5375	37.565	37.51	37.5485	940028.0
2017-07-24 09:50:00	AAPL	Stock	37.55	37.605	37.5475	37.605	1203912.0
2017-07-24 09:55:00	AAPL	Stock	37.6025	37.645	37.5875	37.6375	1420816.0
2017-07-24 10:00:00	AAPL	Stock	37.6375	37.7025	37.6275	37.6875	1323128.0
2017-07-24 10:05:00	AAPL	Stock	37.6862	37.7225	37.6825	37.7	1442776.0
2017-07-24 10:10:00	AAPL	Stock	37.7	37.8025	37.6975	37.7925	1990104.0
2017-07-24 10:15:00	AAPL	Stock	37.794	37.7985	37.725	37.7425	1214036.0
2017-07-24 10:20:00	AAPL	Stock	37.7475	37.77	37.7175	37.76	766204.0
2017-07-24 10:25:00	AAPL	Stock	37.7625	37.7725	37.73	37.76	744252.0
2017-07-24 10:30:00	AAPL	Stock	37.7575	37.795	37.7375	37.7775	918592.0
2017-07-24 10:35:00	AAPL	Stock	37.7775	37.7975	37.7675	37.7825	739936.0
2017-07-24 10:40:00	AAPL	Stock	37.785	37.8312	37.7825	37.825	998936.0
2017-07-24 10:45:00	AAPL	Stock	37.825	37.8325	37.8125	37.8165	696560.0
2017-07-24 10:50:00	AAPL	Stock	37.8175	37.83	37.7975	37.8075	591648.0
2017-07-24 10:55:00	AAPL	Stock	37.805	37.8062	37.776	37.78	610544.0
2017-07-24 11:00:00	AAPL	Stock	37.78	37.785	37.7475	37.7725	580792.0
2017-07-24 11:05:00	AAPL	Stock	37.7725	37.7775	37.7422	37.765	506104.0
2017-07-24 11:10:00	AAPL	Stock	37.765	37.775	37.705	37.75	655720.0
2017-07-24 11:15:00	AAPL	Stock	37.751	37.76	37.7315	37.7562	522160.0
2017-07-24 11:20:00	AAPL	Stock	37.756	37.765	37.725	37.7375	468100.0
2017-07-24 11:25:00	AAPL	Stock	37.7375	37.765	37.7125	37.7525	771288.0
2017-07-24 11:30:00	AAPL	Stock	37.7537	37.795	37.7525	37.795	435320.0
2017-07-24 11:35:00	AAPL	Stock	37.795	37.815	37.785	37.81	444404.0
2017-07-24 11:40:00	AAPL	Stock	37.81	37.826	37.8025	37.82	470632.0

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

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