PREVIEW / stock_5min / 2016-04-07

all stock 5-min files

  file:    by_date/stock_5min/2016/2016-04-07.parquet
  size:    5.3 MB
  rows:    352,736
  symbols: 3,324

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-04-07 04:05:00	AAPL	Stock	27.65	27.75	27.65	27.75	2400.0
2016-04-07 04:15:00	AAPL	Stock	27.6625	27.6625	27.655	27.655	15544.0
2016-04-07 04:20:00	AAPL	Stock	27.6325	27.6325	27.625	27.625	3656.0
2016-04-07 04:50:00	AAPL	Stock	27.625	27.625	27.625	27.625	3200.0
2016-04-07 05:15:00	AAPL	Stock	27.625	27.625	27.625	27.625	800.0
2016-04-07 05:20:00	AAPL	Stock	27.625	27.625	27.625	27.625	1200.0
2016-04-07 05:25:00	AAPL	Stock	27.625	27.625	27.625	27.625	800.0
2016-04-07 05:30:00	AAPL	Stock	27.625	27.625	27.625	27.625	2000.0
2016-04-07 05:35:00	AAPL	Stock	27.6375	27.6375	27.6375	27.6375	4000.0
2016-04-07 05:40:00	AAPL	Stock	27.6375	27.6375	27.625	27.625	6744.0
2016-04-07 05:55:00	AAPL	Stock	27.605	27.605	27.605	27.605	1200.0
2016-04-07 06:00:00	AAPL	Stock	27.605	27.605	27.605	27.605	2800.0
2016-04-07 06:05:00	AAPL	Stock	27.6225	27.6225	27.6225	27.6225	1600.0
2016-04-07 06:10:00	AAPL	Stock	27.6225	27.6225	27.6225	27.6225	3200.0
2016-04-07 06:15:00	AAPL	Stock	27.65	27.65	27.65	27.65	2212.0
2016-04-07 06:45:00	AAPL	Stock	27.635	27.635	27.635	27.635	708.0
2016-04-07 06:55:00	AAPL	Stock	27.5975	27.5975	27.5975	27.5975	4000.0
2016-04-07 07:00:00	AAPL	Stock	27.6375	27.6375	27.6375	27.6375	2000.0
2016-04-07 07:05:00	AAPL	Stock	27.64	27.64	27.58	27.59	26308.0
2016-04-07 07:10:00	AAPL	Stock	27.585	27.6	27.58	27.6	17200.0
2016-04-07 07:15:00	AAPL	Stock	27.605	27.605	27.575	27.575	22920.0
2016-04-07 07:20:00	AAPL	Stock	27.5775	27.5775	27.5625	27.5775	13000.0
2016-04-07 07:25:00	AAPL	Stock	27.57	27.57	27.57	27.57	2800.0
2016-04-07 07:30:00	AAPL	Stock	27.5625	27.5625	27.505	27.505	52300.0
2016-04-07 07:35:00	AAPL	Stock	27.5025	27.525	27.475	27.525	13116.0
2016-04-07 07:40:00	AAPL	Stock	27.525	27.5475	27.525	27.5475	1600.0
2016-04-07 07:45:00	AAPL	Stock	27.525	27.5625	27.5125	27.5625	26480.0
2016-04-07 07:50:00	AAPL	Stock	27.5525	27.5525	27.55	27.55	4800.0
2016-04-07 07:55:00	AAPL	Stock	27.55	27.55	27.525	27.525	39796.0
2016-04-07 08:00:00	AAPL	Stock	27.5475	27.6	27.5375	27.5775	99876.0
2016-04-07 08:05:00	AAPL	Stock	27.59	27.5925	27.575	27.575	70656.0
2016-04-07 08:10:00	AAPL	Stock	27.5775	27.6025	27.575	27.6025	4200.0
2016-04-07 08:15:00	AAPL	Stock	27.5975	27.61	27.59	27.59	3000.0
2016-04-07 08:20:00	AAPL	Stock	27.6075	27.62	27.6	27.62	41584.0
2016-04-07 08:25:00	AAPL	Stock	27.62	27.6225	27.6	27.61	44572.0
2016-04-07 08:30:00	AAPL	Stock	27.6125	27.6125	27.6125	27.6125	18000.0
2016-04-07 08:35:00	AAPL	Stock	27.6125	27.6275	27.6025	27.6175	74060.0
2016-04-07 08:40:00	AAPL	Stock	27.6025	27.6175	27.5925	27.6025	37316.0
2016-04-07 08:45:00	AAPL	Stock	27.6025	27.62	27.6	27.615	62656.0
2016-04-07 08:50:00	AAPL	Stock	27.62	27.6275	27.6075	27.6075	35600.0
2016-04-07 08:55:00	AAPL	Stock	27.6075	27.6225	27.6075	27.6225	8040.0
2016-04-07 09:00:00	AAPL	Stock	27.61	27.62	27.595	27.615	52020.0
2016-04-07 09:05:00	AAPL	Stock	27.6025	27.615	27.6025	27.615	3480.0
2016-04-07 09:10:00	AAPL	Stock	27.615	27.6225	27.615	27.615	24364.0
2016-04-07 09:15:00	AAPL	Stock	27.6075	27.6225	27.605	27.61	35528.0
2016-04-07 09:20:00	AAPL	Stock	27.61	27.61	27.5525	27.5525	218684.0
2016-04-07 09:25:00	AAPL	Stock	27.55	27.575	27.485	27.49	220716.0
2016-04-07 09:30:00	AAPL	Stock	27.4875	27.5425	27.4	27.4725	5100480.0
2016-04-07 09:35:00	AAPL	Stock	27.4725	27.5675	27.425	27.452	4461284.0
2016-04-07 09:40:00	AAPL	Stock	27.455	27.4975	27.4475	27.4775	2375544.0

> showing 50 of 352,736 rows — these rows as CSV

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