PREVIEW / stock_30min / 2013-05-28

all stock 30-min files

  file:    by_date/stock_30min/2013/2013-05-28.parquet
  size:    1.6 MB
  rows:    81,311
  symbols: 3,533

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
2013-05-28 04:30:00	AAPL	Stock	16.0036	16.0225	16.0	16.0225	28000.0
2013-05-28 05:30:00	AAPL	Stock	16.0036	16.0179	16.0	16.0	37716.0
2013-05-28 06:00:00	AAPL	Stock	15.9946	15.9946	15.9821	15.9821	33488.0
2013-05-28 06:30:00	AAPL	Stock	15.9821	15.9911	15.9329	15.9486	89600.0
2013-05-28 07:00:00	AAPL	Stock	15.9711	16.0532	15.9711	16.0357	596680.0
2013-05-28 07:30:00	AAPL	Stock	16.0314	16.0836	16.0268	16.0643	766248.0
2013-05-28 08:00:00	AAPL	Stock	16.0539	16.0896	15.8929	16.0893	1613640.0
2013-05-28 08:30:00	AAPL	Stock	16.0907	16.1193	16.0786	16.0893	1286208.0
2013-05-28 09:00:00	AAPL	Stock	16.0825	16.1071	16.0546	16.0661	2700544.0
2013-05-28 09:30:00	AAPL	Stock	16.0679	16.1111	15.9414	15.9943	73385564.0
2013-05-28 10:00:00	AAPL	Stock	15.995	16.0532	15.92	15.9646	43318296.0
2013-05-28 10:30:00	AAPL	Stock	15.9664	15.9675	15.8429	15.91	39522924.0
2013-05-28 11:00:00	AAPL	Stock	15.9072	15.9554	15.875	15.9187	20583248.0
2013-05-28 11:30:00	AAPL	Stock	15.9186	15.9221	15.8229	15.8321	20809292.0
2013-05-28 12:00:00	AAPL	Stock	15.8322	15.8714	15.8171	15.8539	19642560.0
2013-05-28 12:30:00	AAPL	Stock	15.8557	15.8557	15.7814	15.8082	18468352.0
2013-05-28 13:00:00	AAPL	Stock	15.8085	15.8286	15.7471	15.7582	19168996.0
2013-05-28 13:30:00	AAPL	Stock	15.7607	15.8193	15.7446	15.7733	22045492.0
2013-05-28 14:00:00	AAPL	Stock	15.7721	15.8189	15.7614	15.7968	12689292.0
2013-05-28 14:30:00	AAPL	Stock	15.7971	15.8214	15.7622	15.8121	12467812.0
2013-05-28 15:00:00	AAPL	Stock	15.8157	15.8461	15.7946	15.8184	18671464.0
2013-05-28 15:30:00	AAPL	Stock	15.8193	15.8279	15.7532	15.7659	24797640.0
2013-05-28 16:00:00	AAPL	Stock	15.7657	15.9265	15.7361	15.7457	16096892.0
2013-05-28 16:30:00	AAPL	Stock	15.7657	16.0174	15.7411	15.7411	1310400.0
2013-05-28 17:00:00	AAPL	Stock	15.7429	15.745	15.7132	15.7143	371924.0
2013-05-28 17:30:00	AAPL	Stock	15.7161	15.725	15.6961	15.7036	273868.0
2013-05-28 18:00:00	AAPL	Stock	15.7136	15.7179	15.7054	15.7179	113988.0
2013-05-28 18:30:00	AAPL	Stock	15.7143	15.7171	15.7143	15.7164	34692.0
2013-05-28 19:00:00	AAPL	Stock	15.7164	15.7318	15.7164	15.7314	100660.0
2013-05-28 19:30:00	AAPL	Stock	15.7261	15.7304	15.7054	15.7143	278656.0
2013-05-28 07:30:00	MSFT	Stock	34.54	34.55	34.5	34.5	1061.0
2013-05-28 08:00:00	MSFT	Stock	34.48	34.6	34.25	34.51	21776.0
2013-05-28 08:30:00	MSFT	Stock	34.5	34.64	34.5	34.6	191122.0
2013-05-28 09:00:00	MSFT	Stock	34.56	34.62	34.53	34.53	82470.0
2013-05-28 09:30:00	MSFT	Stock	34.53	35.18	34.41	34.93	7764382.0
2013-05-28 10:00:00	MSFT	Stock	34.93	35.02	34.78	34.86	3757129.0
2013-05-28 10:30:00	MSFT	Stock	34.85	34.95	34.8	34.865	2783906.0
2013-05-28 11:00:00	MSFT	Stock	34.865	34.93	34.84	34.91	2231067.0
2013-05-28 11:30:00	MSFT	Stock	34.91	34.92	34.76	34.782	1986548.0
2013-05-28 12:00:00	MSFT	Stock	34.785	34.84	34.78	34.81	1524019.0
2013-05-28 12:30:00	MSFT	Stock	34.81	34.81	34.74	34.785	1644753.0
2013-05-28 13:00:00	MSFT	Stock	34.785	34.83	34.673	34.68	1420768.0
2013-05-28 13:30:00	MSFT	Stock	34.69	34.72	34.59	34.685	2493288.0
2013-05-28 14:00:00	MSFT	Stock	34.68	34.825	34.66	34.79	2523604.0
2013-05-28 14:30:00	MSFT	Stock	34.795	34.86	34.69	34.81	2405297.0
2013-05-28 15:00:00	MSFT	Stock	34.81	34.92	34.79	34.89	2703646.0
2013-05-28 15:30:00	MSFT	Stock	34.882	35.05	34.882	35.02	8412383.0
2013-05-28 16:00:00	MSFT	Stock	35.01	35.04	34.861	35.0	4185078.0
2013-05-28 16:30:00	MSFT	Stock	35.01	35.04	34.82	35.04	189112.0
2013-05-28 17:00:00	MSFT	Stock	35.04	35.05	35.04	35.05	6512.0

> showing 50 of 81,311 rows — these rows as CSV

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