PREVIEW / stock_5min / 2012-07-31

all stock 5-min files

  file:    by_date/stock_5min/2012/2012-07-31.parquet
  size:    4.7 MB
  rows:    315,849
  symbols: 3,501

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
2012-07-31 04:45:00	AAPL	Stock	21.4107	21.4107	21.4107	21.4107	14000.0
2012-07-31 05:15:00	AAPL	Stock	21.4286	21.4643	21.4286	21.4643	34300.0
2012-07-31 05:25:00	AAPL	Stock	21.4643	21.4643	21.4643	21.4643	2800.0
2012-07-31 06:00:00	AAPL	Stock	21.4643	21.4643	21.4643	21.4643	11200.0
2012-07-31 06:05:00	AAPL	Stock	21.4643	21.4643	21.4464	21.4464	16800.0
2012-07-31 06:15:00	AAPL	Stock	21.4286	21.4286	21.4286	21.4286	8120.0
2012-07-31 06:25:00	AAPL	Stock	21.4143	21.4143	21.4143	21.4143	7000.0
2012-07-31 06:40:00	AAPL	Stock	21.4232	21.4232	21.4089	21.4089	8400.0
2012-07-31 06:45:00	AAPL	Stock	21.4214	21.4214	21.4214	21.4214	2800.0
2012-07-31 06:50:00	AAPL	Stock	21.4214	21.4214	21.4214	21.4214	2800.0
2012-07-31 07:00:00	AAPL	Stock	21.4196	21.4196	21.3929	21.4111	28000.0
2012-07-31 07:05:00	AAPL	Stock	21.4196	21.4821	21.4196	21.4821	203364.0
2012-07-31 07:10:00	AAPL	Stock	21.4821	21.5043	21.47	21.5	102620.0
2012-07-31 07:15:00	AAPL	Stock	21.5	21.5339	21.4914	21.5	240016.0
2012-07-31 07:20:00	AAPL	Stock	21.4929	21.5136	21.4821	21.5	282240.0
2012-07-31 07:25:00	AAPL	Stock	21.5	21.5286	21.5	21.5179	160356.0
2012-07-31 07:30:00	AAPL	Stock	21.5164	21.5164	21.5164	21.5164	28000.0
2012-07-31 07:35:00	AAPL	Stock	21.5179	21.5179	21.5	21.5018	109592.0
2012-07-31 07:40:00	AAPL	Stock	21.5004	21.5004	21.5	21.5	10220.0
2012-07-31 07:45:00	AAPL	Stock	21.4914	21.5004	21.4857	21.5004	85512.0
2012-07-31 07:55:00	AAPL	Stock	21.5104	21.5125	21.5011	21.5011	27664.0
2012-07-31 08:00:00	AAPL	Stock	21.4932	21.5446	21.4196	21.535	695464.0
2012-07-31 08:05:00	AAPL	Stock	21.5289	21.5482	21.5204	21.5432	336812.0
2012-07-31 08:10:00	AAPL	Stock	21.5346	21.5493	21.5282	21.5321	240772.0
2012-07-31 08:15:00	AAPL	Stock	21.5343	21.5357	21.5107	21.5143	116088.0
2012-07-31 08:20:00	AAPL	Stock	21.5114	21.5179	21.4946	21.5	183260.0
2012-07-31 08:25:00	AAPL	Stock	21.5107	21.5196	21.5	21.5093	146860.0
2012-07-31 08:30:00	AAPL	Stock	21.5079	21.5268	21.5046	21.5054	227892.0
2012-07-31 08:35:00	AAPL	Stock	21.5011	21.5104	21.4925	21.4957	316624.0
2012-07-31 08:40:00	AAPL	Stock	21.4973	21.5339	21.4973	21.5339	269892.0
2012-07-31 08:45:00	AAPL	Stock	21.5286	21.5454	21.525	21.5454	363524.0
2012-07-31 08:50:00	AAPL	Stock	21.5446	21.5768	21.5443	21.5604	930636.0
2012-07-31 08:55:00	AAPL	Stock	21.5625	21.5639	21.5361	21.5468	337176.0
2012-07-31 09:00:00	AAPL	Stock	21.5496	21.5589	21.5396	21.5589	196560.0
2012-07-31 09:05:00	AAPL	Stock	21.5632	21.5682	21.5436	21.5504	248024.0
2012-07-31 09:10:00	AAPL	Stock	21.5429	21.5471	21.5164	21.5196	773332.0
2012-07-31 09:15:00	AAPL	Stock	21.5232	21.5643	21.5171	21.5546	305088.0
2012-07-31 09:20:00	AAPL	Stock	21.55	21.5607	21.5393	21.5475	264572.0
2012-07-31 09:25:00	AAPL	Stock	21.545	21.5714	21.5357	21.5357	777280.0
2012-07-31 09:30:00	AAPL	Stock	21.5368	21.6525	21.5257	21.6457	30433200.0
2012-07-31 09:35:00	AAPL	Stock	21.6472	21.6964	21.6314	21.6911	22037148.0
2012-07-31 09:40:00	AAPL	Stock	21.6889	21.7121	21.6189	21.7109	13800248.0
2012-07-31 09:45:00	AAPL	Stock	21.7109	21.7154	21.6536	21.6877	10443888.0
2012-07-31 09:50:00	AAPL	Stock	21.6925	21.71	21.6607	21.6607	9919812.0
2012-07-31 09:55:00	AAPL	Stock	21.6611	21.675	21.6268	21.6686	8226148.0
2012-07-31 10:00:00	AAPL	Stock	21.6704	21.6939	21.6114	21.6418	9832620.0
2012-07-31 10:05:00	AAPL	Stock	21.6421	21.6493	21.6164	21.6299	5441352.0
2012-07-31 10:10:00	AAPL	Stock	21.6307	21.6604	21.625	21.655	4757900.0
2012-07-31 10:15:00	AAPL	Stock	21.6525	21.6775	21.6482	21.66	5774944.0
2012-07-31 10:20:00	AAPL	Stock	21.6651	21.6839	21.645	21.6761	6616008.0

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

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