PREVIEW / stock_30min / 2011-07-29

all stock 30-min files

  file:    by_date/stock_30min/2011/2011-07-29.parquet
  size:    1.4 MB
  rows:    76,234
  symbols: 3,549

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-29 04:00:00	AAPL	Stock	13.9286	13.9286	13.8757	13.895	42000.0
2011-07-29 04:30:00	AAPL	Stock	13.9189	13.9332	13.9036	13.9036	19600.0
2011-07-29 05:00:00	AAPL	Stock	13.93	13.93	13.93	13.93	2800.0
2011-07-29 05:30:00	AAPL	Stock	13.9225	13.9225	13.9161	13.9161	5600.0
2011-07-29 06:00:00	AAPL	Stock	13.9239	13.9239	13.9239	13.9239	2800.0
2011-07-29 06:30:00	AAPL	Stock	13.92	13.92	13.875	13.875	22904.0
2011-07-29 07:00:00	AAPL	Stock	13.8904	13.9196	13.8893	13.8968	133700.0
2011-07-29 07:30:00	AAPL	Stock	13.8964	13.9093	13.8857	13.9093	206220.0
2011-07-29 08:00:00	AAPL	Stock	13.9079	13.9429	13.9	13.9146	1498840.0
2011-07-29 08:30:00	AAPL	Stock	13.9125	13.9132	13.8571	13.8646	4139324.0
2011-07-29 09:00:00	AAPL	Stock	13.8679	13.8689	13.8225	13.8443	2557352.0
2011-07-29 09:30:00	AAPL	Stock	13.8443	13.9143	13.7143	13.9054	99121176.0
2011-07-29 10:00:00	AAPL	Stock	13.9082	13.9432	13.8404	13.9246	60085284.0
2011-07-29 10:30:00	AAPL	Stock	13.9241	14.0671	13.9032	14.0589	68725076.0
2011-07-29 11:00:00	AAPL	Stock	14.0589	14.1125	13.9979	14.0506	73577364.0
2011-07-29 11:30:00	AAPL	Stock	14.0526	14.0675	13.9864	14.0246	37576616.0
2011-07-29 12:00:00	AAPL	Stock	14.0268	14.0454	13.9571	13.9911	33592636.0
2011-07-29 12:30:00	AAPL	Stock	13.9914	14.0089	13.9711	13.9768	21746004.0
2011-07-29 13:00:00	AAPL	Stock	13.9768	14.0121	13.9679	13.9975	19998468.0
2011-07-29 13:30:00	AAPL	Stock	13.9961	14.0561	13.9871	14.0296	28759024.0
2011-07-29 14:00:00	AAPL	Stock	14.0265	14.0618	14.0007	14.0114	21897484.0
2011-07-29 14:30:00	AAPL	Stock	14.0121	14.0514	14.0042	14.0089	22485484.0
2011-07-29 15:00:00	AAPL	Stock	14.0082	14.0186	13.9521	13.9732	34910988.0
2011-07-29 15:30:00	AAPL	Stock	13.9732	14.0066	13.9407	13.9533	68771248.0
2011-07-29 16:00:00	AAPL	Stock	13.9704	13.9795	13.9364	13.9496	21682808.0
2011-07-29 16:30:00	AAPL	Stock	13.945	13.9894	13.9375	13.9375	436688.0
2011-07-29 17:00:00	AAPL	Stock	13.9418	13.9489	13.9396	13.9489	196140.0
2011-07-29 17:30:00	AAPL	Stock	13.9489	13.9771	13.9396	13.9729	207284.0
2011-07-29 18:00:00	AAPL	Stock	13.9725	13.9786	13.9639	13.9739	200620.0
2011-07-29 18:30:00	AAPL	Stock	13.9707	13.9811	13.9457	13.9661	232596.0
2011-07-29 19:00:00	AAPL	Stock	13.9682	14.0	13.9646	13.9893	221312.0
2011-07-29 19:30:00	AAPL	Stock	13.9857	13.9929	13.9714	13.9911	212072.0
2011-07-29 06:30:00	MSFT	Stock	27.51	27.51	27.51	27.51	200.0
2011-07-29 07:00:00	MSFT	Stock	27.53	27.56	27.53	27.54	1250.0
2011-07-29 07:30:00	MSFT	Stock	27.51	27.51	27.48	27.49	6225.0
2011-07-29 08:00:00	MSFT	Stock	27.5	27.59	27.49	27.55	17892.0
2011-07-29 08:30:00	MSFT	Stock	27.55	27.57	27.51	27.53	105717.0
2011-07-29 09:00:00	MSFT	Stock	27.53	27.55	27.51	27.51	61462.0
2011-07-29 09:30:00	MSFT	Stock	27.51	27.62	27.36	27.56	6312141.0
2011-07-29 10:00:00	MSFT	Stock	27.56	27.63	27.37	27.395	7189006.0
2011-07-29 10:30:00	MSFT	Stock	27.395	27.605	27.26	27.535	8071252.0
2011-07-29 11:00:00	MSFT	Stock	27.53	27.71	27.49	27.64	3855477.0
2011-07-29 11:30:00	MSFT	Stock	27.642	27.66	27.47	27.534	3242695.0
2011-07-29 12:00:00	MSFT	Stock	27.54	27.57	27.45	27.47	2822320.0
2011-07-29 12:30:00	MSFT	Stock	27.47	27.57	27.45	27.48	2355219.0
2011-07-29 13:00:00	MSFT	Stock	27.48	27.52	27.455	27.47	1794307.0
2011-07-29 13:30:00	MSFT	Stock	27.47	27.59	27.44	27.56	2224224.0
2011-07-29 14:00:00	MSFT	Stock	27.56	27.59	27.46	27.5	3066816.0
2011-07-29 14:30:00	MSFT	Stock	27.491	27.54	27.44	27.502	2608835.0
2011-07-29 15:00:00	MSFT	Stock	27.5	27.54	27.405	27.455	4038427.0

> showing 50 of 76,234 rows — these rows as CSV

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