PREVIEW / stock_30min / 2012-06-07

all stock 30-min files

  file:    by_date/stock_30min/2012/2012-06-07.parquet
  size:    1.4 MB
  rows:    75,820
  symbols: 3,523

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-07 04:00:00	AAPL	Stock	20.445	20.445	20.4286	20.4286	8400.0
2012-06-07 05:00:00	AAPL	Stock	20.4857	20.4857	20.4857	20.4857	2800.0
2012-06-07 05:30:00	AAPL	Stock	20.4643	20.5157	20.4643	20.5157	22400.0
2012-06-07 06:00:00	AAPL	Stock	20.475	20.475	20.475	20.475	5600.0
2012-06-07 06:30:00	AAPL	Stock	20.4682	20.4786	20.4643	20.4786	12600.0
2012-06-07 07:00:00	AAPL	Stock	20.4821	20.5625	20.4736	20.5586	455952.0
2012-06-07 07:30:00	AAPL	Stock	20.5589	20.6143	20.5543	20.5982	421484.0
2012-06-07 08:00:00	AAPL	Stock	20.5964	20.6107	20.5714	20.5804	1111684.0
2012-06-07 08:30:00	AAPL	Stock	20.5786	20.6071	20.5575	20.5775	1265152.0
2012-06-07 09:00:00	AAPL	Stock	20.5732	20.625	20.5614	20.6179	1436176.0
2012-06-07 09:30:00	AAPL	Stock	20.6175	20.6186	20.5014	20.5821	55386912.0
2012-06-07 10:00:00	AAPL	Stock	20.5798	20.5886	20.4575	20.5454	48603492.0
2012-06-07 10:30:00	AAPL	Stock	20.5432	20.5453	20.375	20.4382	39434024.0
2012-06-07 11:00:00	AAPL	Stock	20.4379	20.4796	20.4286	20.462	22738940.0
2012-06-07 11:30:00	AAPL	Stock	20.4611	20.5307	20.4336	20.4857	22106728.0
2012-06-07 12:00:00	AAPL	Stock	20.4825	20.5211	20.45	20.49	16186632.0
2012-06-07 12:30:00	AAPL	Stock	20.4886	20.5286	20.4764	20.5161	12621308.0
2012-06-07 13:00:00	AAPL	Stock	20.5175	20.5886	20.5143	20.5779	22755628.0
2012-06-07 13:30:00	AAPL	Stock	20.5796	20.5893	20.4946	20.5043	21327236.0
2012-06-07 14:00:00	AAPL	Stock	20.5029	20.5461	20.4946	20.5375	13637400.0
2012-06-07 14:30:00	AAPL	Stock	20.5364	20.5493	20.5189	20.5411	10882116.0
2012-06-07 15:00:00	AAPL	Stock	20.5407	20.5446	20.4557	20.4686	23968560.0
2012-06-07 15:30:00	AAPL	Stock	20.4646	20.4775	20.3754	20.4193	47805548.0
2012-06-07 16:00:00	AAPL	Stock	20.4182	20.4999	20.4145	20.4429	8882076.0
2012-06-07 16:30:00	AAPL	Stock	20.4393	20.4739	20.4186	20.4667	434392.0
2012-06-07 17:00:00	AAPL	Stock	20.4667	20.4667	20.4375	20.4393	288204.0
2012-06-07 17:30:00	AAPL	Stock	20.4393	20.44	20.4393	20.4393	35476.0
2012-06-07 18:00:00	AAPL	Stock	20.4407	20.4461	20.4407	20.4461	57316.0
2012-06-07 18:30:00	AAPL	Stock	20.44	20.4461	20.4343	20.4364	72800.0
2012-06-07 19:00:00	AAPL	Stock	20.435	20.435	20.4343	20.4346	16800.0
2012-06-07 19:30:00	AAPL	Stock	20.4414	20.4418	20.4375	20.4393	65268.0
2012-06-07 07:00:00	MSFT	Stock	29.43	29.5	29.26	29.26	4700.0
2012-06-07 07:30:00	MSFT	Stock	29.53	29.53	29.5	29.51	2125.0
2012-06-07 08:00:00	MSFT	Stock	29.46	29.54	29.46	29.51	9952.0
2012-06-07 08:30:00	MSFT	Stock	29.5	29.54	29.43	29.45	5113.0
2012-06-07 09:00:00	MSFT	Stock	29.45	29.63	29.4	29.6	33929.0
2012-06-07 09:30:00	MSFT	Stock	29.64	29.7	29.36	29.39	5406569.0
2012-06-07 10:00:00	MSFT	Stock	29.38	29.455	29.282	29.371	3843275.0
2012-06-07 10:30:00	MSFT	Stock	29.375	29.4	29.22	29.301	3014688.0
2012-06-07 11:00:00	MSFT	Stock	29.31	29.39	29.29	29.348	1696031.0
2012-06-07 11:30:00	MSFT	Stock	29.345	29.45	29.31	29.39	1760713.0
2012-06-07 12:00:00	MSFT	Stock	29.385	29.46	29.335	29.4	1813849.0
2012-06-07 12:30:00	MSFT	Stock	29.405	29.43	29.36	29.403	1188075.0
2012-06-07 13:00:00	MSFT	Stock	29.401	29.46	29.38	29.46	2248108.0
2012-06-07 13:30:00	MSFT	Stock	29.455	29.47	29.3	29.315	1689903.0
2012-06-07 14:00:00	MSFT	Stock	29.31	29.35	29.3	29.329	1680076.0
2012-06-07 14:30:00	MSFT	Stock	29.325	29.35	29.3	29.324	1643682.0
2012-06-07 15:00:00	MSFT	Stock	29.325	29.36	29.25	29.27	2584181.0
2012-06-07 15:30:00	MSFT	Stock	29.275	29.28	29.17	29.23	5130265.0
2012-06-07 16:00:00	MSFT	Stock	29.22	29.35	29.2	29.23	2900196.0

> showing 50 of 75,820 rows — these rows as CSV

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