PREVIEW / stock_30min / 2011-07-15

all stock 30-min files

  file:    by_date/stock_30min/2011/2011-07-15.parquet
  size:    1.4 MB
  rows:    74,029
  symbols: 3,530

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-07-15 04:00:00	AAPL	Stock	12.7989	12.825	12.7989	12.825	17500.0
2011-07-15 04:30:00	AAPL	Stock	12.8214	12.8214	12.8214	12.8214	2800.0
2011-07-15 05:30:00	AAPL	Stock	12.8643	12.8643	12.8636	12.8636	8400.0
2011-07-15 07:00:00	AAPL	Stock	12.8732	12.9286	12.8639	12.9286	234696.0
2011-07-15 07:30:00	AAPL	Stock	12.9289	12.9289	12.865	12.8882	406672.0
2011-07-15 08:00:00	AAPL	Stock	12.8889	12.9214	12.8889	12.9193	2122344.0
2011-07-15 08:30:00	AAPL	Stock	12.9164	12.9164	12.8929	12.9125	1424052.0
2011-07-15 09:00:00	AAPL	Stock	12.9107	12.925	12.8925	12.8929	2728236.0
2011-07-15 09:30:00	AAPL	Stock	12.8989	12.9268	12.8504	12.8743	94906364.0
2011-07-15 10:00:00	AAPL	Stock	12.8729	12.9007	12.8275	12.844	43162476.0
2011-07-15 10:30:00	AAPL	Stock	12.8443	12.8707	12.8425	12.8543	23976064.0
2011-07-15 11:00:00	AAPL	Stock	12.8557	12.8786	12.8504	12.8743	18031804.0
2011-07-15 11:30:00	AAPL	Stock	12.8739	12.8775	12.8632	12.8636	13929384.0
2011-07-15 12:00:00	AAPL	Stock	12.8648	12.8968	12.8579	12.8875	27471136.0
2011-07-15 12:30:00	AAPL	Stock	12.8879	12.8918	12.8679	12.88	14127344.0
2011-07-15 13:00:00	AAPL	Stock	12.8796	12.9007	12.8671	12.8986	20125140.0
2011-07-15 13:30:00	AAPL	Stock	12.8989	12.9011	12.8732	12.8802	14021812.0
2011-07-15 14:00:00	AAPL	Stock	12.8786	12.8904	12.875	12.8796	16823044.0
2011-07-15 14:30:00	AAPL	Stock	12.8786	12.8896	12.8729	12.885	17767372.0
2011-07-15 15:00:00	AAPL	Stock	12.8829	12.9554	12.8807	12.9543	40030760.0
2011-07-15 15:30:00	AAPL	Stock	12.9543	13.0357	12.95	13.0343	107321648.0
2011-07-15 16:00:00	AAPL	Stock	13.0343	13.0461	12.911	13.0361	13599516.0
2011-07-15 16:30:00	AAPL	Stock	13.0361	13.0375	12.9559	13.0375	1016344.0
2011-07-15 17:00:00	AAPL	Stock	13.0375	13.0389	13.035	13.0361	1486324.0
2011-07-15 17:30:00	AAPL	Stock	13.0361	13.0389	13.0339	13.0375	457352.0
2011-07-15 18:00:00	AAPL	Stock	13.0375	13.0432	13.0329	13.0411	608748.0
2011-07-15 18:30:00	AAPL	Stock	13.0411	13.0446	13.0343	13.0343	291424.0
2011-07-15 19:00:00	AAPL	Stock	13.0475	13.0536	13.0446	13.0518	241192.0
2011-07-15 19:30:00	AAPL	Stock	13.0532	13.0639	13.0357	13.0536	449652.0
2011-07-15 07:30:00	MSFT	Stock	26.47	26.54	26.47	26.53	601.0
2011-07-15 08:00:00	MSFT	Stock	26.58	26.58	26.53	26.56	6726.0
2011-07-15 08:30:00	MSFT	Stock	26.53	26.58	26.53	26.57	7707.0
2011-07-15 09:00:00	MSFT	Stock	26.59	26.76	26.47	26.48	76910.0
2011-07-15 09:30:00	MSFT	Stock	26.47	26.73	26.47	26.505	10496746.0
2011-07-15 10:00:00	MSFT	Stock	26.505	26.67	26.49	26.54	4200928.0
2011-07-15 10:30:00	MSFT	Stock	26.55	26.66	26.52	26.525	2802918.0
2011-07-15 11:00:00	MSFT	Stock	26.52	26.7	26.49	26.67	2121989.0
2011-07-15 11:30:00	MSFT	Stock	26.673	26.71	26.58	26.58	1943902.0
2011-07-15 12:00:00	MSFT	Stock	26.58	26.78	26.58	26.76	3350020.0
2011-07-15 12:30:00	MSFT	Stock	26.76	26.79	26.68	26.77	2124156.0
2011-07-15 13:00:00	MSFT	Stock	26.77	26.91	26.74	26.91	3258016.0
2011-07-15 13:30:00	MSFT	Stock	26.905	26.93	26.75	26.76	3057251.0
2011-07-15 14:00:00	MSFT	Stock	26.75	26.865	26.74	26.78	2858742.0
2011-07-15 14:30:00	MSFT	Stock	26.78	26.82	26.7	26.71	1960623.0
2011-07-15 15:00:00	MSFT	Stock	26.7	26.85	26.69	26.82	1893032.0
2011-07-15 15:30:00	MSFT	Stock	26.82	26.86	26.72	26.78	5999023.0
2011-07-15 16:00:00	MSFT	Stock	26.79	26.81	26.684	26.718	2802044.0
2011-07-15 16:30:00	MSFT	Stock	26.76	26.827	26.75	26.76	13400.0
2011-07-15 17:00:00	MSFT	Stock	26.47	26.87	26.47	26.8	10040.0
2011-07-15 17:30:00	MSFT	Stock	26.83	26.83	26.82	26.82	241.0

> showing 50 of 74,029 rows — these rows as CSV

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