PREVIEW / stock_30min / 2011-07-12

all stock 30-min files

  file:    by_date/stock_30min/2011/2011-07-12.parquet
  size:    1.4 MB
  rows:    74,878
  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
2011-07-12 04:00:00	AAPL	Stock	12.5096	12.5096	12.3593	12.4036	121800.0
2011-07-12 04:30:00	AAPL	Stock	12.4375	12.4643	12.4161	12.4482	74200.0
2011-07-12 05:00:00	AAPL	Stock	12.4657	12.4964	12.4632	12.4964	89320.0
2011-07-12 05:30:00	AAPL	Stock	12.5089	12.5089	12.5	12.5036	101696.0
2011-07-12 06:00:00	AAPL	Stock	12.5	12.5125	12.5	12.5018	11200.0
2011-07-12 06:30:00	AAPL	Stock	12.5054	12.5286	12.5054	12.5286	53200.0
2011-07-12 07:00:00	AAPL	Stock	12.5268	12.5321	12.4964	12.5071	799904.0
2011-07-12 07:30:00	AAPL	Stock	12.5064	12.6171	12.5004	12.5932	692244.0
2011-07-12 08:00:00	AAPL	Stock	12.6004	12.625	12.5179	12.6071	1858472.0
2011-07-12 08:30:00	AAPL	Stock	12.6018	12.6929	12.5986	12.6654	2356312.0
2011-07-12 09:00:00	AAPL	Stock	12.6679	12.6768	12.6221	12.625	2309804.0
2011-07-12 09:30:00	AAPL	Stock	12.6282	12.7	12.4507	12.5711	118818168.0
2011-07-12 10:00:00	AAPL	Stock	12.5711	12.6489	12.5675	12.5893	44625168.0
2011-07-12 10:30:00	AAPL	Stock	12.5921	12.6457	12.5718	12.6136	30815176.0
2011-07-12 11:00:00	AAPL	Stock	12.6161	12.6757	12.6104	12.661	26333356.0
2011-07-12 11:30:00	AAPL	Stock	12.6614	12.6939	12.6529	12.6607	22920408.0
2011-07-12 12:00:00	AAPL	Stock	12.6614	12.6875	12.6461	12.6635	17401188.0
2011-07-12 12:30:00	AAPL	Stock	12.6657	12.6821	12.6561	12.6718	13065276.0
2011-07-12 13:00:00	AAPL	Stock	12.6689	12.7179	12.6625	12.6825	20083364.0
2011-07-12 13:30:00	AAPL	Stock	12.6825	12.7371	12.6793	12.7321	18017272.0
2011-07-12 14:00:00	AAPL	Stock	12.7329	12.7743	12.7214	12.7404	33725776.0
2011-07-12 14:30:00	AAPL	Stock	12.7407	12.7625	12.7196	12.7293	23203908.0
2011-07-12 15:00:00	AAPL	Stock	12.7293	12.7511	12.6857	12.7068	25743284.0
2011-07-12 15:30:00	AAPL	Stock	12.7075	12.7143	12.6339	12.6375	39346188.0
2011-07-12 16:00:00	AAPL	Stock	12.6364	12.6789	12.6336	12.6375	5467980.0
2011-07-12 16:30:00	AAPL	Stock	12.6393	12.6429	12.6354	12.6364	161756.0
2011-07-12 17:00:00	AAPL	Stock	12.6414	12.6429	12.6346	12.6364	140448.0
2011-07-12 17:30:00	AAPL	Stock	12.6354	12.6361	12.6261	12.6311	148680.0
2011-07-12 18:00:00	AAPL	Stock	12.6311	12.6357	12.625	12.6339	251552.0
2011-07-12 18:30:00	AAPL	Stock	12.6271	12.6329	12.625	12.6329	55020.0
2011-07-12 19:00:00	AAPL	Stock	12.6289	12.6329	12.6289	12.6329	21168.0
2011-07-12 19:30:00	AAPL	Stock	12.6357	12.65	12.6304	12.65	257824.0
2011-07-12 04:00:00	MSFT	Stock	26.34	26.34	26.15	26.15	300.0
2011-07-12 07:00:00	MSFT	Stock	26.39	26.39	26.3	26.35	1100.0
2011-07-12 07:30:00	MSFT	Stock	26.37	26.49	26.37	26.49	5779.0
2011-07-12 08:00:00	MSFT	Stock	26.45	26.55	26.45	26.53	16368.0
2011-07-12 08:30:00	MSFT	Stock	26.5	26.6	26.5	26.57	12335.0
2011-07-12 09:00:00	MSFT	Stock	26.6	26.65	26.53	26.59	77393.0
2011-07-12 09:30:00	MSFT	Stock	26.55	26.61	26.44	26.52	6060471.0
2011-07-12 10:00:00	MSFT	Stock	26.52	26.64	26.43	26.485	4184579.0
2011-07-12 10:30:00	MSFT	Stock	26.49	26.5	26.34	26.451	3760908.0
2011-07-12 11:00:00	MSFT	Stock	26.45	26.625	26.43	26.58	3031468.0
2011-07-12 11:30:00	MSFT	Stock	26.58	26.6	26.53	26.56	1988492.0
2011-07-12 12:00:00	MSFT	Stock	26.56	26.64	26.55	26.552	1963496.0
2011-07-12 12:30:00	MSFT	Stock	26.55	26.63	26.54	26.61	1438839.0
2011-07-12 13:00:00	MSFT	Stock	26.6	26.7	26.55	26.55	2521958.0
2011-07-12 13:30:00	MSFT	Stock	26.55	26.62	26.535	26.58	1150531.0
2011-07-12 14:00:00	MSFT	Stock	26.58	26.79	26.58	26.71	4482316.0
2011-07-12 14:30:00	MSFT	Stock	26.71	26.73	26.59	26.614	3173834.0
2011-07-12 15:00:00	MSFT	Stock	26.615	26.66	26.561	26.613	3763139.0

> showing 50 of 74,878 rows — these rows as CSV

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