PREVIEW / stock_30min / 2012-04-10

all stock 30-min files

  file:    by_date/stock_30min/2012/2012-04-10.parquet
  size:    1.5 MB
  rows:    77,136
  symbols: 3,511

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-04-10 04:00:00	AAPL	Stock	22.7779	22.8368	22.7779	22.7857	232708.0
2012-04-10 04:30:00	AAPL	Stock	22.7989	22.8007	22.7804	22.7857	109704.0
2012-04-10 05:00:00	AAPL	Stock	22.7768	22.7857	22.7679	22.7857	33880.0
2012-04-10 05:30:00	AAPL	Stock	22.7857	22.8214	22.7857	22.8214	111160.0
2012-04-10 06:00:00	AAPL	Stock	22.8125	22.8214	22.8093	22.8214	23240.0
2012-04-10 06:30:00	AAPL	Stock	22.8214	22.8571	22.8214	22.8518	140308.0
2012-04-10 07:00:00	AAPL	Stock	22.85	22.8743	22.8125	22.8125	597016.0
2012-04-10 07:30:00	AAPL	Stock	22.8214	22.8236	22.775	22.8214	470148.0
2012-04-10 08:00:00	AAPL	Stock	22.8286	22.87	22.7225	22.8696	3464440.0
2012-04-10 08:30:00	AAPL	Stock	22.8696	22.8893	22.8439	22.8636	2281020.0
2012-04-10 09:00:00	AAPL	Stock	22.8625	22.8729	22.8407	22.8554	3393964.0
2012-04-10 09:30:00	AAPL	Stock	22.8557	22.9786	22.8393	22.9625	108899476.0
2012-04-10 10:00:00	AAPL	Stock	22.9639	23.0	22.8575	22.9364	81358508.0
2012-04-10 10:30:00	AAPL	Stock	22.9317	22.9607	22.9029	22.9179	34065640.0
2012-04-10 11:00:00	AAPL	Stock	22.9129	22.9243	22.7975	22.8839	68393304.0
2012-04-10 11:30:00	AAPL	Stock	22.8857	22.8893	22.6386	22.7471	76310640.0
2012-04-10 12:00:00	AAPL	Stock	22.7496	22.75	22.3929	22.6532	128975196.0
2012-04-10 12:30:00	AAPL	Stock	22.65	22.6871	22.55	22.6214	48948032.0
2012-04-10 13:00:00	AAPL	Stock	22.6229	22.6589	22.4861	22.5892	41408444.0
2012-04-10 13:30:00	AAPL	Stock	22.585	22.6143	22.5304	22.5804	26808740.0
2012-04-10 14:00:00	AAPL	Stock	22.5782	22.6	22.4364	22.5039	39244660.0
2012-04-10 14:30:00	AAPL	Stock	22.505	22.5579	22.3571	22.5157	70816676.0
2012-04-10 15:00:00	AAPL	Stock	22.5207	22.5211	22.3837	22.4429	54873280.0
2012-04-10 15:30:00	AAPL	Stock	22.4411	22.5868	22.4321	22.4554	71306060.0
2012-04-10 16:00:00	AAPL	Stock	22.4443	22.8866	22.37	22.5186	15333304.0
2012-04-10 16:30:00	AAPL	Stock	22.5214	22.5536	22.4006	22.5536	1544368.0
2012-04-10 17:00:00	AAPL	Stock	22.5514	22.5514	22.5375	22.5482	297164.0
2012-04-10 17:30:00	AAPL	Stock	22.5482	22.5625	22.5464	22.5625	369348.0
2012-04-10 18:00:00	AAPL	Stock	22.5621	22.5643	22.5546	22.5607	248416.0
2012-04-10 18:30:00	AAPL	Stock	22.5604	22.5679	22.55	22.55	211288.0
2012-04-10 19:00:00	AAPL	Stock	22.55	22.5932	22.5486	22.5893	606368.0
2012-04-10 19:30:00	AAPL	Stock	22.5893	22.6068	22.5639	22.5714	461552.0
2012-04-10 07:00:00	MSFT	Stock	31.26	31.26	31.25	31.25	1400.0
2012-04-10 07:30:00	MSFT	Stock	31.19	31.2	31.14	31.14	2400.0
2012-04-10 08:00:00	MSFT	Stock	31.14	31.27	31.1	31.19	7146.0
2012-04-10 08:30:00	MSFT	Stock	31.2	31.22	31.19	31.21	7950.0
2012-04-10 09:00:00	MSFT	Stock	31.2	31.2	31.0	31.07	30954.0
2012-04-10 09:30:00	MSFT	Stock	31.07	31.19	30.9	31.09	5393415.0
2012-04-10 10:00:00	MSFT	Stock	31.099	31.12	30.91	30.945	2883226.0
2012-04-10 10:30:00	MSFT	Stock	30.945	31.0	30.86	30.89	2325269.0
2012-04-10 11:00:00	MSFT	Stock	30.894	30.91	30.74	30.815	3936583.0
2012-04-10 11:30:00	MSFT	Stock	30.815	30.86	30.59	30.641	4056707.0
2012-04-10 12:00:00	MSFT	Stock	30.64	30.69	30.48	30.548	4617223.0
2012-04-10 12:30:00	MSFT	Stock	30.55	30.57	30.39	30.51	4193494.0
2012-04-10 13:00:00	MSFT	Stock	30.51	30.51	30.35	30.425	2873829.0
2012-04-10 13:30:00	MSFT	Stock	30.422	30.46	30.35	30.41	2482416.0
2012-04-10 14:00:00	MSFT	Stock	30.41	30.45	30.36	30.428	2616080.0
2012-04-10 14:30:00	MSFT	Stock	30.43	30.43	30.31	30.39	2978456.0
2012-04-10 15:00:00	MSFT	Stock	30.39	30.42	30.3	30.4	3624282.0
2012-04-10 15:30:00	MSFT	Stock	30.4	30.48	30.36	30.47	8292680.0

> showing 50 of 77,136 rows — these rows as CSV

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