PREVIEW / stock_5min / 2013-11-13

all stock 5-min files

  file:    by_date/stock_5min/2013/2013-11-13.parquet
  size:    5.2 MB
  rows:    345,637
  symbols: 3,534

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
2013-11-13 04:00:00	AAPL	Stock	18.5625	18.5643	18.5571	18.5571	22512.0
2013-11-13 04:25:00	AAPL	Stock	18.5625	18.5625	18.5625	18.5625	5600.0
2013-11-13 04:35:00	AAPL	Stock	18.5404	18.5404	18.5404	18.5404	2800.0
2013-11-13 04:50:00	AAPL	Stock	18.5375	18.5375	18.5375	18.5375	4200.0
2013-11-13 05:00:00	AAPL	Stock	18.5568	18.5568	18.5568	18.5568	2800.0
2013-11-13 06:20:00	AAPL	Stock	18.5364	18.5364	18.5364	18.5364	2800.0
2013-11-13 06:50:00	AAPL	Stock	18.5714	18.5714	18.5714	18.5714	5600.0
2013-11-13 07:00:00	AAPL	Stock	18.5554	18.5554	18.5464	18.5464	30912.0
2013-11-13 07:05:00	AAPL	Stock	18.5711	18.5857	18.5711	18.5857	38024.0
2013-11-13 07:15:00	AAPL	Stock	18.5893	18.5893	18.5857	18.5857	14532.0
2013-11-13 07:20:00	AAPL	Stock	18.5857	18.5964	18.5857	18.5964	8400.0
2013-11-13 07:25:00	AAPL	Stock	18.5964	18.5982	18.5964	18.5982	5600.0
2013-11-13 07:30:00	AAPL	Stock	18.59	18.59	18.545	18.545	71400.0
2013-11-13 07:35:00	AAPL	Stock	18.5504	18.5504	18.55	18.55	19600.0
2013-11-13 07:50:00	AAPL	Stock	18.5457	18.5457	18.5446	18.5446	11424.0
2013-11-13 07:55:00	AAPL	Stock	18.5629	18.5629	18.5536	18.5536	14000.0
2013-11-13 08:00:00	AAPL	Stock	18.55	18.5971	18.5179	18.5446	156296.0
2013-11-13 08:05:00	AAPL	Stock	18.55	18.55	18.5179	18.5246	108024.0
2013-11-13 08:10:00	AAPL	Stock	18.5236	18.525	18.505	18.5057	36400.0
2013-11-13 08:15:00	AAPL	Stock	18.5	18.5718	18.4911	18.5179	1883896.0
2013-11-13 08:20:00	AAPL	Stock	18.5268	18.5368	18.5268	18.5357	28000.0
2013-11-13 08:25:00	AAPL	Stock	18.5289	18.5718	18.5232	18.5321	2836540.0
2013-11-13 08:30:00	AAPL	Stock	18.5204	18.5204	18.5071	18.5071	38220.0
2013-11-13 08:35:00	AAPL	Stock	18.5114	18.5114	18.5114	18.5114	28000.0
2013-11-13 08:40:00	AAPL	Stock	18.5114	18.5136	18.5039	18.5039	65520.0
2013-11-13 08:45:00	AAPL	Stock	18.5039	18.5061	18.5007	18.5007	57400.0
2013-11-13 08:50:00	AAPL	Stock	18.5011	18.5154	18.5	18.5	58800.0
2013-11-13 08:55:00	AAPL	Stock	18.5071	18.5071	18.5071	18.5071	8400.0
2013-11-13 09:00:00	AAPL	Stock	18.5046	18.5089	18.5046	18.5064	36400.0
2013-11-13 09:05:00	AAPL	Stock	18.5132	18.5132	18.5054	18.5054	5600.0
2013-11-13 09:10:00	AAPL	Stock	18.5057	18.5157	18.5054	18.5157	67004.0
2013-11-13 09:15:00	AAPL	Stock	18.5125	18.5125	18.5107	18.5107	5600.0
2013-11-13 09:20:00	AAPL	Stock	18.505	18.5321	18.505	18.5161	144760.0
2013-11-13 09:25:00	AAPL	Stock	18.5161	18.5214	18.4914	18.5089	214088.0
2013-11-13 09:30:00	AAPL	Stock	18.5	18.5354	18.4729	18.4964	8896132.0
2013-11-13 09:35:00	AAPL	Stock	18.4957	18.5175	18.4629	18.4632	6461448.0
2013-11-13 09:40:00	AAPL	Stock	18.4639	18.4968	18.4639	18.4675	4937380.0
2013-11-13 09:45:00	AAPL	Stock	18.4736	18.5121	18.4643	18.4939	5637912.0
2013-11-13 09:50:00	AAPL	Stock	18.4939	18.5318	18.4871	18.5311	4541068.0
2013-11-13 09:55:00	AAPL	Stock	18.5293	18.5607	18.5157	18.5536	3778292.0
2013-11-13 10:00:00	AAPL	Stock	18.5532	18.5846	18.5429	18.5536	4522896.0
2013-11-13 10:05:00	AAPL	Stock	18.5531	18.5614	18.5243	18.5496	2270772.0
2013-11-13 10:10:00	AAPL	Stock	18.5504	18.5832	18.5446	18.5832	2431576.0
2013-11-13 10:15:00	AAPL	Stock	18.5832	18.5979	18.5686	18.5918	3792964.0
2013-11-13 10:20:00	AAPL	Stock	18.59	18.5939	18.5568	18.5796	4293632.0
2013-11-13 10:25:00	AAPL	Stock	18.58	18.595	18.5764	18.5782	2681532.0
2013-11-13 10:30:00	AAPL	Stock	18.5796	18.5904	18.5725	18.5739	1946196.0
2013-11-13 10:35:00	AAPL	Stock	18.5743	18.5775	18.5495	18.5536	2356536.0
2013-11-13 10:40:00	AAPL	Stock	18.5571	18.5679	18.5404	18.5591	2527784.0
2013-11-13 10:45:00	AAPL	Stock	18.5611	18.5664	18.5536	18.5536	1401764.0

> showing 50 of 345,637 rows — these rows as CSV

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