PREVIEW / stock_5min / 2012-02-24

all stock 5-min files

  file:    by_date/stock_5min/2012/2012-02-24.parquet
  size:    4.8 MB
  rows:    321,296
  symbols: 3,544

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-02-24 04:00:00	AAPL	Stock	18.48	18.5268	18.48	18.5268	68600.0
2012-02-24 04:05:00	AAPL	Stock	18.535	18.5354	18.535	18.5354	13720.0
2012-02-24 04:10:00	AAPL	Stock	18.5343	18.5354	18.5343	18.5354	17080.0
2012-02-24 04:15:00	AAPL	Stock	18.5357	18.5357	18.5357	18.5357	2800.0
2012-02-24 04:30:00	AAPL	Stock	18.5461	18.5461	18.5461	18.5461	2800.0
2012-02-24 04:45:00	AAPL	Stock	18.5361	18.5361	18.5361	18.5361	2800.0
2012-02-24 04:50:00	AAPL	Stock	18.5357	18.5514	18.5357	18.5514	8400.0
2012-02-24 05:05:00	AAPL	Stock	18.5511	18.5514	18.5511	18.5514	15120.0
2012-02-24 05:10:00	AAPL	Stock	18.5536	18.5714	18.5536	18.5714	14000.0
2012-02-24 05:20:00	AAPL	Stock	18.5643	18.5643	18.5643	18.5643	2800.0
2012-02-24 05:45:00	AAPL	Stock	18.5475	18.5571	18.5429	18.5571	39340.0
2012-02-24 05:50:00	AAPL	Stock	18.5571	18.5571	18.5571	18.5571	10920.0
2012-02-24 05:55:00	AAPL	Stock	18.5571	18.5571	18.5393	18.5571	31080.0
2012-02-24 06:25:00	AAPL	Stock	18.5393	18.5393	18.5357	18.5357	16800.0
2012-02-24 06:30:00	AAPL	Stock	18.5357	18.5568	18.5357	18.5568	7140.0
2012-02-24 06:40:00	AAPL	Stock	18.5646	18.5646	18.5625	18.5625	8400.0
2012-02-24 06:45:00	AAPL	Stock	18.5714	18.5714	18.5536	18.5536	14000.0
2012-02-24 06:50:00	AAPL	Stock	18.5411	18.5411	18.54	18.54	5600.0
2012-02-24 07:00:00	AAPL	Stock	18.5411	18.5636	18.5357	18.5607	101528.0
2012-02-24 07:05:00	AAPL	Stock	18.56	18.5614	18.5232	18.525	97076.0
2012-02-24 07:10:00	AAPL	Stock	18.5314	18.55	18.5314	18.5482	202216.0
2012-02-24 07:15:00	AAPL	Stock	18.5561	18.5714	18.5561	18.5714	212240.0
2012-02-24 07:20:00	AAPL	Stock	18.5786	18.5786	18.5714	18.5714	166320.0
2012-02-24 07:25:00	AAPL	Stock	18.5718	18.5764	18.56	18.5643	170100.0
2012-02-24 07:30:00	AAPL	Stock	18.5632	18.5632	18.5632	18.5632	2800.0
2012-02-24 07:35:00	AAPL	Stock	18.5471	18.5507	18.5464	18.5496	36400.0
2012-02-24 07:40:00	AAPL	Stock	18.55	18.55	18.5182	18.5336	107940.0
2012-02-24 07:45:00	AAPL	Stock	18.5179	18.5179	18.5	18.5025	81900.0
2012-02-24 07:50:00	AAPL	Stock	18.5232	18.5243	18.5179	18.5179	44268.0
2012-02-24 07:55:00	AAPL	Stock	18.5179	18.5179	18.5	18.5	106960.0
2012-02-24 08:00:00	AAPL	Stock	18.51	18.5639	18.4839	18.5071	443072.0
2012-02-24 08:05:00	AAPL	Stock	18.5071	18.5143	18.5004	18.5093	205884.0
2012-02-24 08:10:00	AAPL	Stock	18.5054	18.5125	18.4964	18.4964	138068.0
2012-02-24 08:15:00	AAPL	Stock	18.4961	18.5118	18.4929	18.5071	104244.0
2012-02-24 08:20:00	AAPL	Stock	18.5079	18.51	18.5	18.5064	167888.0
2012-02-24 08:25:00	AAPL	Stock	18.5036	18.5054	18.4846	18.485	200144.0
2012-02-24 08:30:00	AAPL	Stock	18.485	18.5	18.485	18.4929	183652.0
2012-02-24 08:35:00	AAPL	Stock	18.4996	18.4996	18.4718	18.4786	361452.0
2012-02-24 08:40:00	AAPL	Stock	18.4736	18.4929	18.4686	18.4911	345156.0
2012-02-24 08:45:00	AAPL	Stock	18.4932	18.4932	18.4821	18.4861	56000.0
2012-02-24 08:50:00	AAPL	Stock	18.4896	18.5175	18.4896	18.5175	291228.0
2012-02-24 08:55:00	AAPL	Stock	18.5179	18.5264	18.5007	18.5125	361060.0
2012-02-24 09:00:00	AAPL	Stock	18.5086	18.5179	18.5007	18.5179	203728.0
2012-02-24 09:05:00	AAPL	Stock	18.5179	18.5189	18.5125	18.5168	266980.0
2012-02-24 09:10:00	AAPL	Stock	18.5129	18.5193	18.5125	18.5139	125328.0
2012-02-24 09:15:00	AAPL	Stock	18.5121	18.5182	18.5121	18.5179	87752.0
2012-02-24 09:20:00	AAPL	Stock	18.5179	18.5182	18.5054	18.5068	84000.0
2012-02-24 09:25:00	AAPL	Stock	18.5064	18.5643	18.5	18.5596	2268840.0
2012-02-24 09:30:00	AAPL	Stock	18.5636	18.5854	18.5229	18.5632	25275656.0
2012-02-24 09:35:00	AAPL	Stock	18.5646	18.6107	18.55	18.6029	19863284.0

> showing 50 of 321,296 rows — these rows as CSV

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