PREVIEW / stock_30min / 2012-03-27

all stock 30-min files

  file:    by_date/stock_30min/2012/2012-03-27.parquet
  size:    1.4 MB
  rows:    75,781
  symbols: 3,524

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-03-27 04:00:00	AAPL	Stock	21.6879	21.6961	21.6879	21.6961	5600.0
2012-03-27 04:30:00	AAPL	Stock	21.6829	21.6829	21.6679	21.6679	64568.0
2012-03-27 05:00:00	AAPL	Stock	21.6779	21.6964	21.6779	21.6786	89600.0
2012-03-27 05:30:00	AAPL	Stock	21.6679	21.6682	21.6679	21.6679	49000.0
2012-03-27 06:00:00	AAPL	Stock	21.6679	21.6964	21.6679	21.6964	60060.0
2012-03-27 06:30:00	AAPL	Stock	21.6786	21.6789	21.6714	21.6714	38276.0
2012-03-27 07:00:00	AAPL	Stock	21.6782	21.6782	21.6554	21.6707	158088.0
2012-03-27 07:30:00	AAPL	Stock	21.6707	21.6707	21.595	21.6179	494816.0
2012-03-27 08:00:00	AAPL	Stock	21.6071	21.6743	21.6036	21.6357	1459836.0
2012-03-27 08:30:00	AAPL	Stock	21.6425	21.675	21.6421	21.65	1578136.0
2012-03-27 09:00:00	AAPL	Stock	21.6518	21.67	21.6311	21.6496	2090592.0
2012-03-27 09:30:00	AAPL	Stock	21.6493	21.9071	21.645	21.8354	133605752.0
2012-03-27 10:00:00	AAPL	Stock	21.8371	21.9554	21.8146	21.9357	70340228.0
2012-03-27 10:30:00	AAPL	Stock	21.9354	21.9611	21.8507	21.8786	58094260.0
2012-03-27 11:00:00	AAPL	Stock	21.8802	21.9439	21.8768	21.9343	29333808.0
2012-03-27 11:30:00	AAPL	Stock	21.9346	21.9425	21.8829	21.9086	20342168.0
2012-03-27 12:00:00	AAPL	Stock	21.9096	21.9504	21.9064	21.9232	23239188.0
2012-03-27 12:30:00	AAPL	Stock	21.9229	21.9321	21.9054	21.92	18098948.0
2012-03-27 13:00:00	AAPL	Stock	21.9186	21.9439	21.9146	21.9286	15510796.0
2012-03-27 13:30:00	AAPL	Stock	21.9293	21.9814	21.9154	21.975	28272160.0
2012-03-27 14:00:00	AAPL	Stock	21.975	21.9814	21.9379	21.9725	28828856.0
2012-03-27 14:30:00	AAPL	Stock	21.9721	21.9804	21.9471	21.9554	21699888.0
2012-03-27 15:00:00	AAPL	Stock	21.959	22.01	21.8721	21.875	64023288.0
2012-03-27 15:30:00	AAPL	Stock	21.8782	21.9543	21.8725	21.9489	64722644.0
2012-03-27 16:00:00	AAPL	Stock	21.9457	21.9536	21.8972	21.9361	7423752.0
2012-03-27 16:30:00	AAPL	Stock	21.9332	21.9457	21.9321	21.9375	3144652.0
2012-03-27 17:00:00	AAPL	Stock	21.9357	21.9375	21.6736	21.9118	396732.0
2012-03-27 17:30:00	AAPL	Stock	21.9107	21.9314	21.9036	21.9314	105000.0
2012-03-27 18:00:00	AAPL	Stock	21.9279	21.9418	21.9257	21.9257	187096.0
2012-03-27 18:30:00	AAPL	Stock	21.9271	21.9396	21.9268	21.9396	94920.0
2012-03-27 19:00:00	AAPL	Stock	21.9396	21.9539	21.9375	21.9464	362460.0
2012-03-27 19:30:00	AAPL	Stock	21.9482	21.9568	21.9464	21.9568	470708.0
2012-03-27 08:00:00	MSFT	Stock	32.66	32.66	32.63	32.63	1921.0
2012-03-27 08:30:00	MSFT	Stock	32.65	32.65	32.63	32.63	600.0
2012-03-27 09:00:00	MSFT	Stock	32.65	32.65	32.61	32.61	11605.0
2012-03-27 09:30:00	MSFT	Stock	32.61	32.7	32.5	32.54	3304181.0
2012-03-27 10:00:00	MSFT	Stock	32.55	32.62	32.4	32.59	2753010.0
2012-03-27 10:30:00	MSFT	Stock	32.595	32.67	32.565	32.64	2449705.0
2012-03-27 11:00:00	MSFT	Stock	32.64	32.68	32.57	32.585	2198946.0
2012-03-27 11:30:00	MSFT	Stock	32.587	32.61	32.57	32.6	1344485.0
2012-03-27 12:00:00	MSFT	Stock	32.598	32.64	32.592	32.62	1056295.0
2012-03-27 12:30:00	MSFT	Stock	32.62	32.62	32.53	32.575	2003265.0
2012-03-27 13:00:00	MSFT	Stock	32.576	32.6	32.5	32.555	1708302.0
2012-03-27 13:30:00	MSFT	Stock	32.555	32.63	32.55	32.626	1131017.0
2012-03-27 14:00:00	MSFT	Stock	32.625	32.67	32.59	32.662	2028327.0
2012-03-27 14:30:00	MSFT	Stock	32.665	32.69	32.62	32.67	2180809.0
2012-03-27 15:00:00	MSFT	Stock	32.66	32.7	32.57	32.57	2699601.0
2012-03-27 15:30:00	MSFT	Stock	32.575	32.6	32.47	32.53	4956479.0
2012-03-27 16:00:00	MSFT	Stock	32.52	32.6	32.5	32.52	4885023.0
2012-03-27 16:30:00	MSFT	Stock	32.46	32.57	32.46	32.47	28560.0

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

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