PREVIEW / stock_30min / 2011-05-17

all stock 30-min files

  file:    by_date/stock_30min/2011/2011-05-17.parquet
  size:    1.4 MB
  rows:    76,039
  symbols: 3,566

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-05-17 04:30:00	AAPL	Stock	11.9243	11.9243	11.9243	11.9243	2800.0
2011-05-17 05:30:00	AAPL	Stock	11.9286	11.9286	11.9286	11.9286	25816.0
2011-05-17 06:00:00	AAPL	Stock	11.9286	11.9286	11.9286	11.9286	2800.0
2011-05-17 06:30:00	AAPL	Stock	11.95	11.9518	11.9464	11.9464	102984.0
2011-05-17 07:00:00	AAPL	Stock	11.9396	11.9589	11.9214	11.9429	269416.0
2011-05-17 07:30:00	AAPL	Stock	11.9286	11.9411	11.9089	11.9107	144228.0
2011-05-17 08:00:00	AAPL	Stock	11.9196	11.9196	11.8439	11.8657	1459864.0
2011-05-17 08:30:00	AAPL	Stock	11.8575	11.8832	11.8464	11.8679	1247204.0
2011-05-17 09:00:00	AAPL	Stock	11.8696	11.8964	11.8511	11.8571	2060380.0
2011-05-17 09:30:00	AAPL	Stock	11.8571	11.9018	11.8118	11.8524	62652464.0
2011-05-17 10:00:00	AAPL	Stock	11.8521	11.9554	11.8179	11.9544	56401604.0
2011-05-17 10:30:00	AAPL	Stock	11.9546	11.9565	11.8571	11.8682	35341908.0
2011-05-17 11:00:00	AAPL	Stock	11.8686	11.8718	11.8125	11.8446	30876776.0
2011-05-17 11:30:00	AAPL	Stock	11.8457	11.8679	11.8214	11.8575	25087972.0
2011-05-17 12:00:00	AAPL	Stock	11.8579	11.8857	11.8486	11.8571	21508480.0
2011-05-17 12:30:00	AAPL	Stock	11.8579	11.9229	11.8504	11.8696	22941380.0
2011-05-17 13:00:00	AAPL	Stock	11.8711	11.8939	11.8632	11.8854	17927056.0
2011-05-17 13:30:00	AAPL	Stock	11.8857	11.9018	11.8621	11.882	16240224.0
2011-05-17 14:00:00	AAPL	Stock	11.8818	11.8918	11.8482	11.8489	17566108.0
2011-05-17 14:30:00	AAPL	Stock	11.85	11.9386	11.8468	11.9321	24165708.0
2011-05-17 15:00:00	AAPL	Stock	11.9321	11.9518	11.92	11.9236	33403496.0
2011-05-17 15:30:00	AAPL	Stock	11.925	12.005	11.9218	12.0039	53330704.0
2011-05-17 16:00:00	AAPL	Stock	12.0039	12.0196	11.8649	12.0179	20965028.0
2011-05-17 16:30:00	AAPL	Stock	12.0179	12.0429	11.9221	12.0329	597576.0
2011-05-17 17:00:00	AAPL	Stock	12.0307	12.0321	12.025	12.0314	162876.0
2011-05-17 17:30:00	AAPL	Stock	12.0321	12.0321	12.0257	12.0286	151424.0
2011-05-17 18:00:00	AAPL	Stock	12.0286	12.0357	12.005	12.0339	175980.0
2011-05-17 18:30:00	AAPL	Stock	12.0268	12.035	12.0268	12.035	28000.0
2011-05-17 19:00:00	AAPL	Stock	12.0343	12.0354	12.0321	12.0339	46200.0
2011-05-17 19:30:00	AAPL	Stock	12.0346	12.0357	12.0321	12.0321	248248.0
2011-05-17 05:00:00	MSFT	Stock	24.55	24.55	24.55	24.55	2600.0
2011-05-17 06:00:00	MSFT	Stock	24.54	24.55	24.53	24.55	1000.0
2011-05-17 06:30:00	MSFT	Stock	24.54	24.54	24.51	24.53	2500.0
2011-05-17 07:00:00	MSFT	Stock	24.49	24.5	24.48	24.48	3100.0
2011-05-17 07:30:00	MSFT	Stock	24.5	24.51	24.42	24.47	10700.0
2011-05-17 08:00:00	MSFT	Stock	24.48	24.51	24.45	24.48	28290.0
2011-05-17 08:30:00	MSFT	Stock	24.48	24.49	24.44	24.44	19920.0
2011-05-17 09:00:00	MSFT	Stock	24.44	24.5	24.37	24.4	106827.0
2011-05-17 09:30:00	MSFT	Stock	24.39	24.42	24.27	24.325	8255834.0
2011-05-17 10:00:00	MSFT	Stock	24.325	24.42	24.31	24.4	5427642.0
2011-05-17 10:30:00	MSFT	Stock	24.39	24.4	24.29	24.311	4577803.0
2011-05-17 11:00:00	MSFT	Stock	24.32	24.42	24.3	24.39	6240053.0
2011-05-17 11:30:00	MSFT	Stock	24.399	24.44	24.35	24.35	4673701.0
2011-05-17 12:00:00	MSFT	Stock	24.35	24.45	24.35	24.445	3526189.0
2011-05-17 12:30:00	MSFT	Stock	24.45	24.56	24.43	24.46	4423499.0
2011-05-17 13:00:00	MSFT	Stock	24.465	24.63	24.46	24.63	4757857.0
2011-05-17 13:30:00	MSFT	Stock	24.62	24.65	24.56	24.62	3734141.0
2011-05-17 14:00:00	MSFT	Stock	24.618	24.7	24.58	24.61	4849263.0
2011-05-17 14:30:00	MSFT	Stock	24.61	24.67	24.6	24.66	4611910.0
2011-05-17 15:00:00	MSFT	Stock	24.66	24.66	24.55	24.56	3923948.0

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

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