PREVIEW / stock_30min / 2012-06-15

all stock 30-min files

  file:    by_date/stock_30min/2012/2012-06-15.parquet
  size:    1.5 MB
  rows:    78,080
  symbols: 3,532

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-06-15 04:00:00	AAPL	Stock	20.4714	20.4714	20.4714	20.4714	2800.0
2012-06-15 05:30:00	AAPL	Stock	20.48	20.48	20.48	20.48	2800.0
2012-06-15 06:00:00	AAPL	Stock	20.4821	20.4821	20.4821	20.4821	28560.0
2012-06-15 07:00:00	AAPL	Stock	20.4804	20.4925	20.4679	20.4925	94640.0
2012-06-15 07:30:00	AAPL	Stock	20.4957	20.4964	20.4679	20.4679	26600.0
2012-06-15 08:00:00	AAPL	Stock	20.4793	20.4921	20.445	20.4668	461328.0
2012-06-15 08:30:00	AAPL	Stock	20.4579	20.4614	20.4186	20.4214	796488.0
2012-06-15 09:00:00	AAPL	Stock	20.4214	20.4214	20.3711	20.3786	1997184.0
2012-06-15 09:30:00	AAPL	Stock	20.3864	20.4418	20.3411	20.4366	40782532.0
2012-06-15 10:00:00	AAPL	Stock	20.4314	20.4514	20.3821	20.4068	25374104.0
2012-06-15 10:30:00	AAPL	Stock	20.4064	20.4093	20.3514	20.3893	17911376.0
2012-06-15 11:00:00	AAPL	Stock	20.3889	20.4382	20.3664	20.4275	20680044.0
2012-06-15 11:30:00	AAPL	Stock	20.4275	20.4454	20.3964	20.4043	11795924.0
2012-06-15 12:00:00	AAPL	Stock	20.4061	20.4218	20.3821	20.3989	7564676.0
2012-06-15 12:30:00	AAPL	Stock	20.3989	20.4046	20.3693	20.375	10417568.0
2012-06-15 13:00:00	AAPL	Stock	20.3771	20.4011	20.36	20.3629	11492796.0
2012-06-15 13:30:00	AAPL	Stock	20.3614	20.3818	20.3518	20.3679	9343768.0
2012-06-15 14:00:00	AAPL	Stock	20.3675	20.3736	20.3504	20.3654	8684704.0
2012-06-15 14:30:00	AAPL	Stock	20.3646	20.3836	20.3554	20.3639	10923024.0
2012-06-15 15:00:00	AAPL	Stock	20.3637	20.43	20.3618	20.4193	24924872.0
2012-06-15 15:30:00	AAPL	Stock	20.4207	20.5221	20.4164	20.5046	54197220.0
2012-06-15 16:00:00	AAPL	Stock	20.5046	20.5268	20.4146	20.5143	25738188.0
2012-06-15 16:30:00	AAPL	Stock	20.5046	20.5211	20.4255	20.5079	4188212.0
2012-06-15 17:00:00	AAPL	Stock	20.5079	20.5114	20.5046	20.5071	229012.0
2012-06-15 17:30:00	AAPL	Stock	20.5071	20.5143	20.5071	20.5079	173068.0
2012-06-15 18:00:00	AAPL	Stock	20.5079	20.5154	20.5071	20.5093	91532.0
2012-06-15 18:30:00	AAPL	Stock	20.5136	20.5154	20.5093	20.5125	104020.0
2012-06-15 19:00:00	AAPL	Stock	20.5104	20.5139	20.5096	20.5096	28476.0
2012-06-15 19:30:00	AAPL	Stock	20.51	20.5125	20.5054	20.5125	365092.0
2012-06-15 07:30:00	MSFT	Stock	29.43	29.45	29.43	29.45	1800.0
2012-06-15 08:00:00	MSFT	Stock	29.43	29.46	29.41	29.46	5121.0
2012-06-15 08:30:00	MSFT	Stock	29.46	29.49	29.45	29.47	12274.0
2012-06-15 09:00:00	MSFT	Stock	29.47	29.63	29.43	29.58	221914.0
2012-06-15 09:30:00	MSFT	Stock	29.56	29.87	29.49	29.86	15854283.0
2012-06-15 10:00:00	MSFT	Stock	29.86	29.95	29.82	29.865	4278734.0
2012-06-15 10:30:00	MSFT	Stock	29.87	29.95	29.83	29.92	2910653.0
2012-06-15 11:00:00	MSFT	Stock	29.925	29.95	29.87	29.94	2237915.0
2012-06-15 11:30:00	MSFT	Stock	29.94	29.98	29.929	29.94	1788501.0
2012-06-15 12:00:00	MSFT	Stock	29.94	29.96	29.86	29.91	1481361.0
2012-06-15 12:30:00	MSFT	Stock	29.91	29.95	29.88	29.91	1288604.0
2012-06-15 13:00:00	MSFT	Stock	29.91	29.98	29.9	29.94	1460434.0
2012-06-15 13:30:00	MSFT	Stock	29.95	29.99	29.92	29.99	1399081.0
2012-06-15 14:00:00	MSFT	Stock	29.984	30.0	29.92	29.98	2272901.0
2012-06-15 14:30:00	MSFT	Stock	29.978	30.08	29.97	29.97	3201574.0
2012-06-15 15:00:00	MSFT	Stock	29.97	30.04	29.94	30.039	3614434.0
2012-06-15 15:30:00	MSFT	Stock	30.04	30.05	29.93	30.02	11424175.0
2012-06-15 16:00:00	MSFT	Stock	30.02	30.04	29.881	30.03	7219659.0
2012-06-15 16:30:00	MSFT	Stock	30.02	30.03	29.894	30.03	831071.0
2012-06-15 17:00:00	MSFT	Stock	30.03	30.04	30.02	30.04	76889.0
2012-06-15 17:30:00	MSFT	Stock	30.04	30.05	30.0	30.05	7196.0

> showing 50 of 78,080 rows — these rows as CSV

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