PREVIEW / stock_30min / 2012-10-09

all stock 30-min files

  file:    by_date/stock_30min/2012/2012-10-09.parquet
  size:    1.4 MB
  rows:    74,380
  symbols: 3,473

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-10-09 04:00:00	AAPL	Stock	22.5711	22.5743	22.5432	22.5714	37296.0
2012-10-09 04:30:00	AAPL	Stock	22.5232	22.5357	22.5089	22.5321	159236.0
2012-10-09 05:00:00	AAPL	Stock	22.5354	22.5493	22.5321	22.5429	79800.0
2012-10-09 05:30:00	AAPL	Stock	22.5411	22.5857	22.5357	22.575	226996.0
2012-10-09 06:00:00	AAPL	Stock	22.5893	22.62	22.5893	22.6071	86520.0
2012-10-09 06:30:00	AAPL	Stock	22.6071	22.6429	22.6071	22.6429	136696.0
2012-10-09 07:00:00	AAPL	Stock	22.65	22.7764	22.6364	22.7361	979132.0
2012-10-09 07:30:00	AAPL	Stock	22.7264	22.75	22.7054	22.7429	491596.0
2012-10-09 08:00:00	AAPL	Stock	22.7357	22.7429	22.6704	22.7171	1421924.0
2012-10-09 08:30:00	AAPL	Stock	22.715	22.775	22.7143	22.7214	1523480.0
2012-10-09 09:00:00	AAPL	Stock	22.7214	22.8479	22.6986	22.8143	2788380.0
2012-10-09 09:30:00	AAPL	Stock	22.8089	22.845	22.5529	22.5568	97409676.0
2012-10-09 10:00:00	AAPL	Stock	22.5575	22.6429	22.4286	22.4604	102740512.0
2012-10-09 10:30:00	AAPL	Stock	22.4596	22.5425	22.2696	22.37	94554320.0
2012-10-09 11:00:00	AAPL	Stock	22.3686	22.4921	22.3307	22.4168	61651548.0
2012-10-09 11:30:00	AAPL	Stock	22.4168	22.5357	22.3857	22.5246	47017880.0
2012-10-09 12:00:00	AAPL	Stock	22.5239	22.6904	22.4904	22.6405	65872996.0
2012-10-09 12:30:00	AAPL	Stock	22.6384	22.65	22.5079	22.6121	35659708.0
2012-10-09 13:00:00	AAPL	Stock	22.6121	22.7754	22.6032	22.6682	55254724.0
2012-10-09 13:30:00	AAPL	Stock	22.6682	22.8096	22.6143	22.73	40273240.0
2012-10-09 14:00:00	AAPL	Stock	22.7268	22.8679	22.7036	22.8546	46681096.0
2012-10-09 14:30:00	AAPL	Stock	22.8546	22.8746	22.7711	22.8604	41671112.0
2012-10-09 15:00:00	AAPL	Stock	22.8606	22.8746	22.6418	22.67	46760336.0
2012-10-09 15:30:00	AAPL	Stock	22.6693	22.7318	22.6155	22.7204	58052008.0
2012-10-09 16:00:00	AAPL	Stock	22.7089	22.7679	22.6114	22.7532	13553568.0
2012-10-09 16:30:00	AAPL	Stock	22.7532	22.7586	22.6576	22.7564	333760.0
2012-10-09 17:00:00	AAPL	Stock	22.7918	22.7918	22.7214	22.7218	505484.0
2012-10-09 17:30:00	AAPL	Stock	22.7218	22.7218	22.6786	22.6821	347984.0
2012-10-09 18:00:00	AAPL	Stock	22.6929	22.725	22.6929	22.7246	143024.0
2012-10-09 18:30:00	AAPL	Stock	22.7236	22.7304	22.7189	22.7264	118636.0
2012-10-09 19:00:00	AAPL	Stock	22.7196	22.7311	22.7161	22.725	111020.0
2012-10-09 19:30:00	AAPL	Stock	22.7304	22.7321	22.6911	22.6911	299236.0
2012-10-09 06:30:00	MSFT	Stock	29.98	29.98	29.98	29.98	100.0
2012-10-09 08:00:00	MSFT	Stock	29.9	29.9	29.78	29.82	4300.0
2012-10-09 08:30:00	MSFT	Stock	29.825	29.85	29.825	29.85	5700.0
2012-10-09 09:00:00	MSFT	Stock	29.83	29.84	29.67	29.68	18506.0
2012-10-09 09:30:00	MSFT	Stock	29.68	29.74	29.43	29.48	4509009.0
2012-10-09 10:00:00	MSFT	Stock	29.48	29.55	29.46	29.48	2811331.0
2012-10-09 10:30:00	MSFT	Stock	29.48	29.51	29.26	29.35	3775016.0
2012-10-09 11:00:00	MSFT	Stock	29.35	29.39	29.285	29.345	3714776.0
2012-10-09 11:30:00	MSFT	Stock	29.35	29.39	29.31	29.335	3414627.0
2012-10-09 12:00:00	MSFT	Stock	29.335	29.38	29.31	29.32	2681928.0
2012-10-09 12:30:00	MSFT	Stock	29.31	29.32	29.26	29.3	2010687.0
2012-10-09 13:00:00	MSFT	Stock	29.29	29.33	29.28	29.308	2188985.0
2012-10-09 13:30:00	MSFT	Stock	29.3	29.32	29.27	29.29	1968674.0
2012-10-09 14:00:00	MSFT	Stock	29.29	29.32	29.26	29.3	1980974.0
2012-10-09 14:30:00	MSFT	Stock	29.3	29.3	29.25	29.282	2176608.0
2012-10-09 15:00:00	MSFT	Stock	29.285	29.3	29.19	29.21	3402640.0
2012-10-09 15:30:00	MSFT	Stock	29.205	29.29	29.18	29.28	6720879.0
2012-10-09 16:00:00	MSFT	Stock	29.28	29.405	29.243	29.28	1955168.0

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

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