PREVIEW / stock_5min / 2012-06-07

all stock 5-min files

  file:    by_date/stock_5min/2012/2012-06-07.parquet
  size:    4.8 MB
  rows:    327,861
  symbols: 3,523

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-06-07 04:05:00	AAPL	Stock	20.445	20.445	20.445	20.445	5600.0
2012-06-07 04:10:00	AAPL	Stock	20.4286	20.4286	20.4286	20.4286	2800.0
2012-06-07 05:25:00	AAPL	Stock	20.4857	20.4857	20.4857	20.4857	2800.0
2012-06-07 05:40:00	AAPL	Stock	20.4643	20.4661	20.4643	20.4661	14000.0
2012-06-07 05:45:00	AAPL	Stock	20.4925	20.4925	20.4925	20.4925	2800.0
2012-06-07 05:50:00	AAPL	Stock	20.4946	20.4946	20.4946	20.4946	2800.0
2012-06-07 05:55:00	AAPL	Stock	20.5157	20.5157	20.5157	20.5157	2800.0
2012-06-07 06:10:00	AAPL	Stock	20.475	20.475	20.475	20.475	2800.0
2012-06-07 06:15:00	AAPL	Stock	20.475	20.475	20.475	20.475	2800.0
2012-06-07 06:40:00	AAPL	Stock	20.4682	20.4682	20.4646	20.4646	5600.0
2012-06-07 06:55:00	AAPL	Stock	20.4643	20.4786	20.4643	20.4786	7000.0
2012-06-07 07:00:00	AAPL	Stock	20.4821	20.535	20.4736	20.5089	121800.0
2012-06-07 07:05:00	AAPL	Stock	20.5093	20.5625	20.5089	20.5375	166824.0
2012-06-07 07:10:00	AAPL	Stock	20.5493	20.5536	20.5357	20.5382	72240.0
2012-06-07 07:15:00	AAPL	Stock	20.5529	20.5529	20.5529	20.5529	2800.0
2012-06-07 07:20:00	AAPL	Stock	20.5496	20.5604	20.5475	20.555	57652.0
2012-06-07 07:25:00	AAPL	Stock	20.5536	20.5593	20.5489	20.5586	34636.0
2012-06-07 07:30:00	AAPL	Stock	20.5589	20.5786	20.5579	20.575	57092.0
2012-06-07 07:35:00	AAPL	Stock	20.5714	20.5714	20.5604	20.5686	53200.0
2012-06-07 07:40:00	AAPL	Stock	20.5743	20.5743	20.5543	20.5571	30800.0
2012-06-07 07:45:00	AAPL	Stock	20.5561	20.5839	20.5561	20.5839	75516.0
2012-06-07 07:50:00	AAPL	Stock	20.5836	20.5982	20.5836	20.5918	101276.0
2012-06-07 07:55:00	AAPL	Stock	20.5893	20.6143	20.5893	20.5982	103600.0
2012-06-07 08:00:00	AAPL	Stock	20.5964	20.6107	20.5714	20.5996	369796.0
2012-06-07 08:05:00	AAPL	Stock	20.6061	20.6071	20.5821	20.5929	184268.0
2012-06-07 08:10:00	AAPL	Stock	20.5982	20.5993	20.5796	20.5893	172760.0
2012-06-07 08:15:00	AAPL	Stock	20.5825	20.5893	20.5807	20.5854	162568.0
2012-06-07 08:20:00	AAPL	Stock	20.5875	20.5875	20.5807	20.5839	102452.0
2012-06-07 08:25:00	AAPL	Stock	20.585	20.5854	20.5779	20.5804	119840.0
2012-06-07 08:30:00	AAPL	Stock	20.5786	20.5879	20.5768	20.5768	116060.0
2012-06-07 08:35:00	AAPL	Stock	20.5768	20.5804	20.5575	20.5643	437724.0
2012-06-07 08:40:00	AAPL	Stock	20.5625	20.5864	20.5625	20.5786	206836.0
2012-06-07 08:45:00	AAPL	Stock	20.5786	20.5893	20.5725	20.5889	212100.0
2012-06-07 08:50:00	AAPL	Stock	20.5889	20.6071	20.5889	20.6	135268.0
2012-06-07 08:55:00	AAPL	Stock	20.5904	20.6039	20.5729	20.5775	157164.0
2012-06-07 09:00:00	AAPL	Stock	20.5732	20.5804	20.5614	20.5764	119532.0
2012-06-07 09:05:00	AAPL	Stock	20.5754	20.5893	20.575	20.5811	354788.0
2012-06-07 09:10:00	AAPL	Stock	20.5846	20.5864	20.5804	20.5857	102536.0
2012-06-07 09:15:00	AAPL	Stock	20.5854	20.5904	20.5846	20.5893	158900.0
2012-06-07 09:20:00	AAPL	Stock	20.5829	20.5893	20.5786	20.5821	88088.0
2012-06-07 09:25:00	AAPL	Stock	20.5889	20.625	20.5825	20.6179	612332.0
2012-06-07 09:30:00	AAPL	Stock	20.6175	20.6186	20.5275	20.5304	16204888.0
2012-06-07 09:35:00	AAPL	Stock	20.5311	20.5693	20.5014	20.5346	10656968.0
2012-06-07 09:40:00	AAPL	Stock	20.5344	20.5871	20.5179	20.5668	8553972.0
2012-06-07 09:45:00	AAPL	Stock	20.5693	20.5832	20.5589	20.5768	6556564.0
2012-06-07 09:50:00	AAPL	Stock	20.5775	20.5907	20.5646	20.5761	6698860.0
2012-06-07 09:55:00	AAPL	Stock	20.5779	20.595	20.5625	20.5821	6715660.0
2012-06-07 10:00:00	AAPL	Stock	20.5798	20.5886	20.5114	20.5364	12071052.0
2012-06-07 10:05:00	AAPL	Stock	20.5329	20.5696	20.5221	20.5292	6558776.0
2012-06-07 10:10:00	AAPL	Stock	20.5268	20.5314	20.4593	20.4864	10088148.0

> showing 50 of 327,861 rows — these rows as CSV

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