PREVIEW / stock_30min / 2011-09-21

all stock 30-min files

  file:    by_date/stock_30min/2011/2011-09-21.parquet
  size:    1.4 MB
  rows:    74,715
  symbols: 3,500

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-09-21 04:00:00	AAPL	Stock	14.8457	14.8475	14.8214	14.8214	30800.0
2011-09-21 04:30:00	AAPL	Stock	14.7793	14.8039	14.7793	14.8039	22120.0
2011-09-21 05:00:00	AAPL	Stock	14.8129	14.8468	14.8129	14.8343	16800.0
2011-09-21 05:30:00	AAPL	Stock	14.8736	14.8736	14.8557	14.8557	5600.0
2011-09-21 06:00:00	AAPL	Stock	14.8321	14.8364	14.8286	14.8364	8400.0
2011-09-21 06:30:00	AAPL	Stock	14.8386	14.8386	14.8254	14.8254	5600.0
2011-09-21 07:00:00	AAPL	Stock	14.8254	14.9221	14.825	14.9221	653660.0
2011-09-21 07:30:00	AAPL	Stock	14.9221	14.9221	14.8268	14.8286	729456.0
2011-09-21 08:00:00	AAPL	Stock	14.8304	14.8554	14.7821	14.8429	1850072.0
2011-09-21 08:30:00	AAPL	Stock	14.845	14.9096	14.8429	14.9011	1883672.0
2011-09-21 09:00:00	AAPL	Stock	14.9	14.995	14.8839	14.9868	6526268.0
2011-09-21 09:30:00	AAPL	Stock	14.9893	15.0568	14.8829	14.9646	96875016.0
2011-09-21 10:00:00	AAPL	Stock	14.9679	14.9821	14.9111	14.9554	37397444.0
2011-09-21 10:30:00	AAPL	Stock	14.9561	14.9761	14.8532	14.8932	48523272.0
2011-09-21 11:00:00	AAPL	Stock	14.8893	14.9454	14.8854	14.9279	26452748.0
2011-09-21 11:30:00	AAPL	Stock	14.9271	15.0282	14.9232	14.9943	32786236.0
2011-09-21 12:00:00	AAPL	Stock	14.9943	15.0268	14.9132	14.9436	27589520.0
2011-09-21 12:30:00	AAPL	Stock	14.9461	14.9939	14.914	14.9414	25127704.0
2011-09-21 13:00:00	AAPL	Stock	14.9404	14.9857	14.9379	14.9789	17191272.0
2011-09-21 13:30:00	AAPL	Stock	14.9779	14.985	14.9268	14.9302	12956804.0
2011-09-21 14:00:00	AAPL	Stock	14.93	15.0304	14.9036	15.0229	40290992.0
2011-09-21 14:30:00	AAPL	Stock	15.0225	15.0416	14.8432	14.9668	73158148.0
2011-09-21 15:00:00	AAPL	Stock	14.9668	15.0039	14.8929	14.8982	44272368.0
2011-09-21 15:30:00	AAPL	Stock	14.8986	14.905	14.7143	14.7214	90741728.0
2011-09-21 16:00:00	AAPL	Stock	14.7143	14.9932	14.6939	14.7164	7603064.0
2011-09-21 16:30:00	AAPL	Stock	14.7089	14.9194	14.6979	14.7118	1885492.0
2011-09-21 17:00:00	AAPL	Stock	14.7118	14.72	14.6857	14.6954	834820.0
2011-09-21 17:30:00	AAPL	Stock	14.6932	14.7036	14.6836	14.6839	344400.0
2011-09-21 18:00:00	AAPL	Stock	14.6836	14.7193	14.6429	14.6643	750260.0
2011-09-21 18:30:00	AAPL	Stock	14.6693	14.6743	14.6504	14.6539	343140.0
2011-09-21 19:00:00	AAPL	Stock	14.6604	14.6839	14.6496	14.6825	237860.0
2011-09-21 19:30:00	AAPL	Stock	14.6786	14.6875	14.6643	14.6839	304976.0
2011-09-21 07:00:00	MSFT	Stock	27.13	27.13	26.96	27.05	18350.0
2011-09-21 07:30:00	MSFT	Stock	27.03	27.04	26.97	26.97	16200.0
2011-09-21 08:00:00	MSFT	Stock	26.99	27.17	26.9	26.94	46138.0
2011-09-21 08:30:00	MSFT	Stock	26.96	27.05	26.94	27.05	34500.0
2011-09-21 09:00:00	MSFT	Stock	27.04	27.05	26.95	26.99	65396.0
2011-09-21 09:30:00	MSFT	Stock	27.05	27.06	26.725	26.762	9279518.0
2011-09-21 10:00:00	MSFT	Stock	26.76	26.79	26.515	26.57	6294987.0
2011-09-21 10:30:00	MSFT	Stock	26.57	26.58	26.375	26.45	4689739.0
2011-09-21 11:00:00	MSFT	Stock	26.44	26.535	26.43	26.49	2903494.0
2011-09-21 11:30:00	MSFT	Stock	26.49	26.61	26.47	26.59	3045414.0
2011-09-21 12:00:00	MSFT	Stock	26.59	26.66	26.53	26.576	2439860.0
2011-09-21 12:30:00	MSFT	Stock	26.57	26.63	26.55	26.6	2496615.0
2011-09-21 13:00:00	MSFT	Stock	26.59	26.6	26.52	26.55	1983920.0
2011-09-21 13:30:00	MSFT	Stock	26.55	26.6	26.48	26.585	2167675.0
2011-09-21 14:00:00	MSFT	Stock	26.589	26.64	26.37	26.55	6302927.0
2011-09-21 14:30:00	MSFT	Stock	26.552	26.59	26.27	26.365	5709534.0
2011-09-21 15:00:00	MSFT	Stock	26.37	26.47	26.31	26.36	5255320.0
2011-09-21 15:30:00	MSFT	Stock	26.36	26.38	25.97	25.98	15344706.0

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

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