PREVIEW / stock_30min / 2012-03-16

all stock 30-min files

  file:    by_date/stock_30min/2012/2012-03-16.parquet
  size:    1.5 MB
  rows:    79,226
  symbols: 3,535

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-16 04:00:00	AAPL	Stock	20.9854	20.9854	20.9821	20.9821	12600.0
2012-03-16 04:30:00	AAPL	Stock	20.985	20.9964	20.9768	20.9964	61796.0
2012-03-16 05:00:00	AAPL	Stock	21.0079	21.0125	21.0	21.0	75040.0
2012-03-16 05:30:00	AAPL	Stock	21.0	21.0089	20.99	20.99	51828.0
2012-03-16 06:00:00	AAPL	Stock	21.0	21.0	21.0	21.0	2800.0
2012-03-16 06:30:00	AAPL	Stock	21.0039	21.0179	20.9893	21.0179	68740.0
2012-03-16 07:00:00	AAPL	Stock	21.0314	21.1304	21.0	21.0025	887404.0
2012-03-16 07:30:00	AAPL	Stock	21.025	21.0871	21.025	21.0482	1951068.0
2012-03-16 08:00:00	AAPL	Stock	21.0357	21.1071	20.9589	20.9686	5325096.0
2012-03-16 08:30:00	AAPL	Stock	20.97	21.01	20.9179	20.9196	3429412.0
2012-03-16 09:00:00	AAPL	Stock	20.9146	20.9607	20.8464	20.8829	5567464.0
2012-03-16 09:30:00	AAPL	Stock	20.8829	20.9064	20.6429	20.7607	126841428.0
2012-03-16 10:00:00	AAPL	Stock	20.7596	20.8618	20.7054	20.8448	63893144.0
2012-03-16 10:30:00	AAPL	Stock	20.8475	21.0414	20.8121	20.9632	113497440.0
2012-03-16 11:00:00	AAPL	Stock	20.9604	21.0429	20.8929	20.9107	69580952.0
2012-03-16 11:30:00	AAPL	Stock	20.9105	20.9854	20.8964	20.9804	30924488.0
2012-03-16 12:00:00	AAPL	Stock	20.9818	21.0132	20.9175	20.9521	32818912.0
2012-03-16 12:30:00	AAPL	Stock	20.9518	20.9536	20.8314	20.8575	32199804.0
2012-03-16 13:00:00	AAPL	Stock	20.8582	20.9085	20.8368	20.8779	23948512.0
2012-03-16 13:30:00	AAPL	Stock	20.8798	20.9268	20.875	20.9236	23838640.0
2012-03-16 14:00:00	AAPL	Stock	20.9227	20.9461	20.8947	20.9104	28718956.0
2012-03-16 14:30:00	AAPL	Stock	20.9129	20.9179	20.875	20.8836	21827540.0
2012-03-16 15:00:00	AAPL	Stock	20.8832	20.8978	20.8418	20.8682	35005712.0
2012-03-16 15:30:00	AAPL	Stock	20.8672	20.9136	20.8525	20.9132	68512164.0
2012-03-16 16:00:00	AAPL	Stock	20.9132	20.9237	20.8711	20.8936	54029920.0
2012-03-16 16:30:00	AAPL	Stock	20.8932	20.9237	20.8769	20.8943	7804356.0
2012-03-16 17:00:00	AAPL	Stock	20.8939	20.9132	20.8851	20.8932	609392.0
2012-03-16 17:30:00	AAPL	Stock	20.8946	20.9132	20.8918	20.8929	373520.0
2012-03-16 18:00:00	AAPL	Stock	20.8929	20.9036	20.8918	20.8968	227472.0
2012-03-16 18:30:00	AAPL	Stock	20.8982	20.9036	20.8929	20.8982	171696.0
2012-03-16 19:00:00	AAPL	Stock	20.895	20.9032	20.8929	20.9	133112.0
2012-03-16 19:30:00	AAPL	Stock	20.8996	20.9	20.8893	20.8929	219744.0
2012-03-16 07:30:00	MSFT	Stock	32.92	32.96	32.92	32.95	12383.0
2012-03-16 08:00:00	MSFT	Stock	32.92	32.95	32.85	32.89	23831.0
2012-03-16 08:30:00	MSFT	Stock	32.89	32.93	32.8	32.92	35485.0
2012-03-16 09:00:00	MSFT	Stock	32.93	32.93	32.85	32.9	111230.0
2012-03-16 09:30:00	MSFT	Stock	32.9	32.95	32.77	32.84	6854023.0
2012-03-16 10:00:00	MSFT	Stock	32.847	32.88	32.775	32.805	4120178.0
2012-03-16 10:30:00	MSFT	Stock	32.8	32.85	32.77	32.81	2727018.0
2012-03-16 11:00:00	MSFT	Stock	32.82	32.85	32.75	32.78	2756646.0
2012-03-16 11:30:00	MSFT	Stock	32.77	32.85	32.76	32.845	2113944.0
2012-03-16 12:00:00	MSFT	Stock	32.845	32.85	32.78	32.828	1753601.0
2012-03-16 12:30:00	MSFT	Stock	32.825	32.85	32.772	32.79	2752315.0
2012-03-16 13:00:00	MSFT	Stock	32.78	32.8	32.75	32.78	1969815.0
2012-03-16 13:30:00	MSFT	Stock	32.775	32.78	32.7	32.702	2366336.0
2012-03-16 14:00:00	MSFT	Stock	32.71	32.73	32.66	32.725	2196628.0
2012-03-16 14:30:00	MSFT	Stock	32.725	32.75	32.69	32.69	1285182.0
2012-03-16 15:00:00	MSFT	Stock	32.695	32.7	32.5	32.592	3891921.0
2012-03-16 15:30:00	MSFT	Stock	32.6	32.63	32.54	32.6	4986716.0
2012-03-16 16:00:00	MSFT	Stock	32.595	32.791	32.56	32.58	5360016.0

> showing 50 of 79,226 rows — these rows as CSV

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