PREVIEW / stock_5min / 2016-06-17

all stock 5-min files

  file:    by_date/stock_5min/2016/2016-06-17.parquet
  size:    5.3 MB
  rows:    356,573
  symbols: 3,284

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
2016-06-17 04:25:00	AAPL	Stock	24.3675	24.3675	24.3175	24.3175	3600.0
2016-06-17 05:00:00	AAPL	Stock	24.32	24.32	24.32	24.32	2000.0
2016-06-17 05:05:00	AAPL	Stock	24.32	24.32	24.32	24.32	800.0
2016-06-17 05:20:00	AAPL	Stock	24.32	24.32	24.305	24.305	6800.0
2016-06-17 05:25:00	AAPL	Stock	24.295	24.295	24.25	24.25	8472.0
2016-06-17 05:30:00	AAPL	Stock	24.235	24.3375	24.2125	24.3375	2312.0
2016-06-17 06:00:00	AAPL	Stock	24.3325	24.3325	24.25	24.25	6240.0
2016-06-17 06:10:00	AAPL	Stock	24.25	24.25	24.245	24.245	3880.0
2016-06-17 06:20:00	AAPL	Stock	24.25	24.25	24.25	24.25	2000.0
2016-06-17 06:35:00	AAPL	Stock	24.2525	24.3125	24.2525	24.3125	6000.0
2016-06-17 06:55:00	AAPL	Stock	24.2875	24.2875	24.2525	24.2525	7564.0
2016-06-17 07:00:00	AAPL	Stock	24.2575	24.2575	24.255	24.255	12436.0
2016-06-17 07:05:00	AAPL	Stock	24.27	24.27	24.265	24.265	1324.0
2016-06-17 07:10:00	AAPL	Stock	24.2775	24.2775	24.2775	24.2775	400.0
2016-06-17 07:15:00	AAPL	Stock	24.2775	24.2775	24.275	24.275	16800.0
2016-06-17 07:30:00	AAPL	Stock	24.2525	24.2525	24.2525	24.2525	920.0
2016-06-17 07:35:00	AAPL	Stock	24.2625	24.275	24.23	24.25	42436.0
2016-06-17 07:40:00	AAPL	Stock	24.25	24.25	24.225	24.225	39256.0
2016-06-17 07:50:00	AAPL	Stock	24.25	24.25	24.245	24.245	1200.0
2016-06-17 07:55:00	AAPL	Stock	24.25	24.25	24.225	24.225	17480.0
2016-06-17 08:00:00	AAPL	Stock	24.295	24.295	24.225	24.2525	108844.0
2016-06-17 08:05:00	AAPL	Stock	24.2525	24.2525	24.2375	24.25	31960.0
2016-06-17 08:10:00	AAPL	Stock	24.26	24.285	24.26	24.285	9040.0
2016-06-17 08:15:00	AAPL	Stock	24.265	24.28	24.265	24.28	51000.0
2016-06-17 08:20:00	AAPL	Stock	24.28	24.33	24.28	24.33	39920.0
2016-06-17 08:25:00	AAPL	Stock	24.3325	24.3375	24.3125	24.3275	15792.0
2016-06-17 08:30:00	AAPL	Stock	24.3175	24.325	24.2725	24.2775	88352.0
2016-06-17 08:35:00	AAPL	Stock	24.2725	24.285	24.22	24.2425	194348.0
2016-06-17 08:40:00	AAPL	Stock	24.2375	24.2575	24.2375	24.25	93152.0
2016-06-17 08:45:00	AAPL	Stock	24.2475	24.25	24.2175	24.22	120724.0
2016-06-17 08:50:00	AAPL	Stock	24.225	24.225	24.175	24.175	136396.0
2016-06-17 08:55:00	AAPL	Stock	24.1625	24.175	23.955	23.9875	787264.0
2016-06-17 09:00:00	AAPL	Stock	23.9875	24.0	23.8875	23.93	1038828.0
2016-06-17 09:05:00	AAPL	Stock	23.9575	23.995	23.925	23.94	543928.0
2016-06-17 09:10:00	AAPL	Stock	23.96	23.96	23.8875	23.9275	828136.0
2016-06-17 09:15:00	AAPL	Stock	23.9375	23.9925	23.9075	23.9125	545160.0
2016-06-17 09:20:00	AAPL	Stock	23.905	24.1625	23.85	24.12	2355592.0
2016-06-17 09:25:00	AAPL	Stock	24.12	24.2	24.0525	24.1575	2536400.0
2016-06-17 09:30:00	AAPL	Stock	24.155	24.1625	24.0	24.055	31987920.0
2016-06-17 09:35:00	AAPL	Stock	24.055	24.0575	23.9625	23.9825	6019484.0
2016-06-17 09:40:00	AAPL	Stock	23.98	24.07	23.9675	24.0575	4333656.0
2016-06-17 09:45:00	AAPL	Stock	24.055	24.0725	24.0165	24.025	2883236.0
2016-06-17 09:50:00	AAPL	Stock	24.0225	24.0322	23.9775	23.99	3718200.0
2016-06-17 09:55:00	AAPL	Stock	23.99	24.035	23.9875	24.03	2059116.0
2016-06-17 10:00:00	AAPL	Stock	24.0275	24.045	23.9975	24.0025	2290656.0
2016-06-17 10:05:00	AAPL	Stock	24.0038	24.025	23.95	23.9738	4269268.0
2016-06-17 10:10:00	AAPL	Stock	23.9742	24.02	23.9125	23.955	4610444.0
2016-06-17 10:15:00	AAPL	Stock	23.9538	23.9925	23.9425	23.9812	2566936.0
2016-06-17 10:20:00	AAPL	Stock	23.9812	23.985	23.9125	23.9275	2464952.0
2016-06-17 10:25:00	AAPL	Stock	23.9275	23.9325	23.8975	23.905	2500744.0

> showing 50 of 356,573 rows — these rows as CSV

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