PREVIEW / stock_30min / 2011-05-16

all stock 30-min files

  file:    by_date/stock_30min/2011/2011-05-16.parquet
  size:    1.4 MB
  rows:    76,577
  symbols: 3,559

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
2011-05-16 05:30:00	AAPL	Stock	12.1082	12.1082	12.1082	12.1082	2800.0
2011-05-16 06:00:00	AAPL	Stock	12.085	12.085	12.08	12.0807	14000.0
2011-05-16 07:00:00	AAPL	Stock	12.0929	12.1307	12.0857	12.125	181720.0
2011-05-16 07:30:00	AAPL	Stock	12.1164	12.1343	12.1075	12.1214	184016.0
2011-05-16 08:00:00	AAPL	Stock	12.125	12.1525	12.1125	12.1321	625352.0
2011-05-16 08:30:00	AAPL	Stock	12.13	12.1607	12.0946	12.1054	706636.0
2011-05-16 09:00:00	AAPL	Stock	12.105	12.1354	12.105	12.1146	972440.0
2011-05-16 09:30:00	AAPL	Stock	12.1143	12.1864	12.0625	12.1229	78125348.0
2011-05-16 10:00:00	AAPL	Stock	12.1229	12.1496	12.0786	12.09	29122576.0
2011-05-16 10:30:00	AAPL	Stock	12.0893	12.1227	12.0829	12.0996	17471272.0
2011-05-16 11:00:00	AAPL	Stock	12.1025	12.125	12.0579	12.0714	26476996.0
2011-05-16 11:30:00	AAPL	Stock	12.0704	12.0775	12.0143	12.0316	27566168.0
2011-05-16 12:00:00	AAPL	Stock	12.0318	12.0414	12.0039	12.0236	22737988.0
2011-05-16 12:30:00	AAPL	Stock	12.0239	12.0379	11.9671	11.9693	28985516.0
2011-05-16 13:00:00	AAPL	Stock	11.9693	11.9893	11.9475	11.9782	30337272.0
2011-05-16 13:30:00	AAPL	Stock	11.9796	11.9992	11.9671	11.9682	16054724.0
2011-05-16 14:00:00	AAPL	Stock	11.9686	11.9786	11.9432	11.9504	18610032.0
2011-05-16 14:30:00	AAPL	Stock	11.9507	11.9639	11.9136	11.9336	36166592.0
2011-05-16 15:00:00	AAPL	Stock	11.9336	11.9664	11.9286	11.9371	26911528.0
2011-05-16 15:30:00	AAPL	Stock	11.9368	11.9554	11.8786	11.9043	55694912.0
2011-05-16 16:00:00	AAPL	Stock	11.9036	12.0192	11.895	11.9004	23004324.0
2011-05-16 16:30:00	AAPL	Stock	11.9018	12.0367	11.8814	11.8814	1483132.0
2011-05-16 17:00:00	AAPL	Stock	11.8839	11.8929	11.8839	11.8893	164388.0
2011-05-16 17:30:00	AAPL	Stock	11.8882	11.8918	11.8857	11.89	114576.0
2011-05-16 18:00:00	AAPL	Stock	11.8893	11.9036	11.8893	11.8964	320320.0
2011-05-16 18:30:00	AAPL	Stock	11.8954	11.9014	11.8936	11.8982	49532.0
2011-05-16 19:00:00	AAPL	Stock	11.8982	11.8989	11.8857	11.8864	137844.0
2011-05-16 19:30:00	AAPL	Stock	11.8875	11.8875	11.8786	11.8875	172172.0
2011-05-16 06:00:00	MSFT	Stock	25.0	25.0	25.0	25.0	990.0
2011-05-16 07:30:00	MSFT	Stock	24.98	24.98	24.98	24.98	200.0
2011-05-16 08:00:00	MSFT	Stock	25.0	25.04	25.0	25.04	59740.0
2011-05-16 08:30:00	MSFT	Stock	25.03	25.04	25.03	25.03	27600.0
2011-05-16 09:00:00	MSFT	Stock	25.03	25.03	24.91	24.96	113464.0
2011-05-16 09:30:00	MSFT	Stock	24.95	25.07	24.92	24.95	7442517.0
2011-05-16 10:00:00	MSFT	Stock	24.95	24.99	24.85	24.86	5560746.0
2011-05-16 10:30:00	MSFT	Stock	24.86	24.92	24.81	24.87	5327511.0
2011-05-16 11:00:00	MSFT	Stock	24.87	24.9	24.84	24.845	3510350.0
2011-05-16 11:30:00	MSFT	Stock	24.845	24.92	24.83	24.83	4304624.0
2011-05-16 12:00:00	MSFT	Stock	24.83	24.84	24.65	24.71	7591183.0
2011-05-16 12:30:00	MSFT	Stock	24.72	24.8	24.64	24.649	5069755.0
2011-05-16 13:00:00	MSFT	Stock	24.64	24.66	24.56	24.615	6783643.0
2011-05-16 13:30:00	MSFT	Stock	24.61	24.7	24.61	24.62	2969787.0
2011-05-16 14:00:00	MSFT	Stock	24.625	24.685	24.61	24.62	4190350.0
2011-05-16 14:30:00	MSFT	Stock	24.62	24.69	24.61	24.65	5341520.0
2011-05-16 15:00:00	MSFT	Stock	24.64	24.71	24.58	24.585	4128083.0
2011-05-16 15:30:00	MSFT	Stock	24.585	24.63	24.5	24.58	14366771.0
2011-05-16 16:00:00	MSFT	Stock	24.57	24.802	24.53	24.57	10288905.0
2011-05-16 16:30:00	MSFT	Stock	24.56	24.597	24.52	24.52	1388411.0
2011-05-16 17:00:00	MSFT	Stock	24.882	24.882	24.52	24.53	24783.0
2011-05-16 17:30:00	MSFT	Stock	24.53	24.53	24.46	24.46	28592.0

> showing 50 of 76,577 rows — these rows as CSV

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