PREVIEW / stock_5min / 2011-07-19

all stock 5-min files

  file:    by_date/stock_5min/2011/2011-07-19.parquet
  size:    4.9 MB
  rows:    331,564
  symbols: 3,530

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
2011-07-19 04:05:00	AAPL	Stock	13.4404	13.4404	13.4404	13.4404	2800.0
2011-07-19 04:20:00	AAPL	Stock	13.4643	13.4643	13.4554	13.4554	5600.0
2011-07-19 04:30:00	AAPL	Stock	13.4643	13.4675	13.4643	13.4675	16800.0
2011-07-19 04:45:00	AAPL	Stock	13.4696	13.4696	13.4646	13.4646	6608.0
2011-07-19 05:20:00	AAPL	Stock	13.4646	13.4646	13.4646	13.4646	2800.0
2011-07-19 05:35:00	AAPL	Stock	13.465	13.4664	13.4643	13.4643	35392.0
2011-07-19 05:40:00	AAPL	Stock	13.4757	13.4757	13.4546	13.4546	11200.0
2011-07-19 05:45:00	AAPL	Stock	13.4536	13.4536	13.4536	13.4536	2800.0
2011-07-19 06:15:00	AAPL	Stock	13.4643	13.4643	13.4643	13.4643	2800.0
2011-07-19 06:20:00	AAPL	Stock	13.4643	13.4643	13.4639	13.4639	5600.0
2011-07-19 06:30:00	AAPL	Stock	13.4643	13.4643	13.4643	13.4643	2800.0
2011-07-19 06:50:00	AAPL	Stock	13.4504	13.4504	13.4082	13.4329	58800.0
2011-07-19 06:55:00	AAPL	Stock	13.4329	13.4329	13.4329	13.4329	2800.0
2011-07-19 07:00:00	AAPL	Stock	13.4143	13.4643	13.4129	13.4604	91000.0
2011-07-19 07:05:00	AAPL	Stock	13.4643	13.465	13.4571	13.4604	103656.0
2011-07-19 07:10:00	AAPL	Stock	13.4575	13.4818	13.4575	13.4818	86352.0
2011-07-19 07:15:00	AAPL	Stock	13.475	13.4821	13.4682	13.4682	61600.0
2011-07-19 07:20:00	AAPL	Stock	13.4682	13.4682	13.4464	13.4536	112700.0
2011-07-19 07:25:00	AAPL	Stock	13.4536	13.4607	13.4464	13.4464	47600.0
2011-07-19 07:30:00	AAPL	Stock	13.4464	13.4643	13.4464	13.4639	91560.0
2011-07-19 07:35:00	AAPL	Stock	13.4604	13.4607	13.4604	13.4607	5600.0
2011-07-19 07:40:00	AAPL	Stock	13.4632	13.4643	13.4532	13.4557	90132.0
2011-07-19 07:45:00	AAPL	Stock	13.4557	13.4589	13.4464	13.4464	62300.0
2011-07-19 07:50:00	AAPL	Stock	13.4468	13.4536	13.4321	13.4493	158620.0
2011-07-19 07:55:00	AAPL	Stock	13.4589	13.4589	13.45	13.4557	64400.0
2011-07-19 08:00:00	AAPL	Stock	13.4557	13.4732	13.4518	13.4643	1424752.0
2011-07-19 08:05:00	AAPL	Stock	13.4607	13.4796	13.4607	13.4718	367192.0
2011-07-19 08:10:00	AAPL	Stock	13.475	13.4854	13.4725	13.4846	566832.0
2011-07-19 08:15:00	AAPL	Stock	13.48	13.4904	13.4771	13.4771	432768.0
2011-07-19 08:20:00	AAPL	Stock	13.4771	13.4961	13.475	13.4961	1265348.0
2011-07-19 08:25:00	AAPL	Stock	13.4961	13.5154	13.4946	13.5054	902356.0
2011-07-19 08:30:00	AAPL	Stock	13.5111	13.5307	13.5082	13.53	606872.0
2011-07-19 08:35:00	AAPL	Stock	13.5282	13.53	13.5129	13.5214	732536.0
2011-07-19 08:40:00	AAPL	Stock	13.525	13.5321	13.5246	13.5304	595868.0
2011-07-19 08:45:00	AAPL	Stock	13.5332	13.5625	13.5279	13.5443	781004.0
2011-07-19 08:50:00	AAPL	Stock	13.5429	13.5446	13.5314	13.5314	811496.0
2011-07-19 08:55:00	AAPL	Stock	13.5296	13.5357	13.5193	13.5193	497644.0
2011-07-19 09:00:00	AAPL	Stock	13.5186	13.5254	13.5	13.5	922768.0
2011-07-19 09:05:00	AAPL	Stock	13.5043	13.5121	13.4911	13.5	893256.0
2011-07-19 09:10:00	AAPL	Stock	13.5014	13.5118	13.4921	13.51	346416.0
2011-07-19 09:15:00	AAPL	Stock	13.5075	13.5096	13.4932	13.4964	266840.0
2011-07-19 09:20:00	AAPL	Stock	13.4932	13.5071	13.4932	13.5014	177128.0
2011-07-19 09:25:00	AAPL	Stock	13.5007	13.5036	13.4875	13.5	478940.0
2011-07-19 09:30:00	AAPL	Stock	13.4996	13.5	13.4107	13.4622	33938352.0
2011-07-19 09:35:00	AAPL	Stock	13.461	13.4643	13.4343	13.4536	20283732.0
2011-07-19 09:40:00	AAPL	Stock	13.4536	13.4807	13.4407	13.4472	14431032.0
2011-07-19 09:45:00	AAPL	Stock	13.4475	13.4804	13.4364	13.4775	9955792.0
2011-07-19 09:50:00	AAPL	Stock	13.4782	13.5082	13.4696	13.4885	14930272.0
2011-07-19 09:55:00	AAPL	Stock	13.4886	13.4911	13.4564	13.4654	12055260.0
2011-07-19 10:00:00	AAPL	Stock	13.4675	13.4743	13.4589	13.4632	6974912.0

> showing 50 of 331,564 rows — these rows as CSV

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