PREVIEW / stock_30min / 2012-10-04

all stock 30-min files

  file:    by_date/stock_30min/2012/2012-10-04.parquet
  size:    1.4 MB
  rows:    75,568
  symbols: 3,480

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-10-04 04:00:00	AAPL	Stock	24.075	24.0857	24.0357	24.0357	25200.0
2012-10-04 05:00:00	AAPL	Stock	23.9329	23.9329	23.9329	23.9329	2800.0
2012-10-04 05:30:00	AAPL	Stock	24.0	24.0268	24.0	24.0268	5600.0
2012-10-04 06:00:00	AAPL	Stock	24.0357	24.0493	24.0357	24.0493	11200.0
2012-10-04 06:30:00	AAPL	Stock	24.0489	24.0493	24.0429	24.0429	30800.0
2012-10-04 07:00:00	AAPL	Stock	24.0321	24.0393	24.0143	24.0296	496832.0
2012-10-04 07:30:00	AAPL	Stock	24.0357	24.0429	23.9604	23.9893	492464.0
2012-10-04 08:00:00	AAPL	Stock	23.9821	24.0304	23.9693	23.9754	989912.0
2012-10-04 08:30:00	AAPL	Stock	23.9804	24.0093	23.9571	23.9821	1437016.0
2012-10-04 09:00:00	AAPL	Stock	23.9804	23.9839	23.9289	23.9743	1626800.0
2012-10-04 09:30:00	AAPL	Stock	23.9732	24.0389	23.8968	23.9732	56574812.0
2012-10-04 10:00:00	AAPL	Stock	23.9843	24.0804	23.9564	24.0557	32765376.0
2012-10-04 10:30:00	AAPL	Stock	24.0557	24.0729	23.9618	24.0171	24302824.0
2012-10-04 11:00:00	AAPL	Stock	24.0099	24.0179	23.8968	23.9025	18781952.0
2012-10-04 11:30:00	AAPL	Stock	23.9007	23.97	23.8671	23.9586	20068832.0
2012-10-04 12:00:00	AAPL	Stock	23.9584	24.0	23.9164	23.9221	14048272.0
2012-10-04 12:30:00	AAPL	Stock	23.9221	23.9339	23.8132	23.8525	25305616.0
2012-10-04 13:00:00	AAPL	Stock	23.8521	23.875	23.7893	23.8222	17204936.0
2012-10-04 13:30:00	AAPL	Stock	23.8196	23.8546	23.7786	23.8411	21551628.0
2012-10-04 14:00:00	AAPL	Stock	23.8414	23.8489	23.7696	23.8275	16219644.0
2012-10-04 14:30:00	AAPL	Stock	23.8243	23.9268	23.8125	23.8954	27658456.0
2012-10-04 15:00:00	AAPL	Stock	23.8936	23.9707	23.8893	23.9068	26105240.0
2012-10-04 15:30:00	AAPL	Stock	23.9129	23.9275	23.8089	23.8175	33120192.0
2012-10-04 16:00:00	AAPL	Stock	23.8146	23.9316	23.775	23.8143	20492500.0
2012-10-04 16:30:00	AAPL	Stock	23.7875	23.9831	23.7832	23.7857	260344.0
2012-10-04 17:00:00	AAPL	Stock	23.7861	23.8143	23.7836	23.7857	212576.0
2012-10-04 17:30:00	AAPL	Stock	23.7832	23.7886	23.7779	23.7779	139384.0
2012-10-04 18:00:00	AAPL	Stock	23.7779	23.7821	23.7746	23.775	190456.0
2012-10-04 18:30:00	AAPL	Stock	23.7739	23.7782	23.7543	23.7543	131768.0
2012-10-04 19:00:00	AAPL	Stock	23.7611	23.7614	23.7543	23.7604	50400.0
2012-10-04 19:30:00	AAPL	Stock	23.7596	23.7625	23.7554	23.7607	179284.0
2012-10-04 07:30:00	MSFT	Stock	30.06	30.07	29.84	29.99	7400.0
2012-10-04 08:00:00	MSFT	Stock	29.9	29.94	29.8	29.9	30950.0
2012-10-04 08:30:00	MSFT	Stock	29.87	29.98	29.87	29.91	32308.0
2012-10-04 09:00:00	MSFT	Stock	29.92	29.96	29.86	29.91	44924.0
2012-10-04 09:30:00	MSFT	Stock	29.97	30.0	29.581	29.63	5123181.0
2012-10-04 10:00:00	MSFT	Stock	29.63	29.8	29.57	29.685	4392583.0
2012-10-04 10:30:00	MSFT	Stock	29.683	29.765	29.64	29.749	2744429.0
2012-10-04 11:00:00	MSFT	Stock	29.745	29.75	29.64	29.68	2677550.0
2012-10-04 11:30:00	MSFT	Stock	29.67	29.755	29.66	29.73	2156852.0
2012-10-04 12:00:00	MSFT	Stock	29.735	29.83	29.7	29.79	2306417.0
2012-10-04 12:30:00	MSFT	Stock	29.795	29.81	29.77	29.79	1173349.0
2012-10-04 13:00:00	MSFT	Stock	29.79	29.84	29.78	29.83	1348276.0
2012-10-04 13:30:00	MSFT	Stock	29.83	29.9	29.83	29.89	1578856.0
2012-10-04 14:00:00	MSFT	Stock	29.88	29.89	29.8	29.82	1759183.0
2012-10-04 14:30:00	MSFT	Stock	29.82	29.95	29.8	29.94	2326530.0
2012-10-04 15:00:00	MSFT	Stock	29.93	29.99	29.89	29.95	3311169.0
2012-10-04 15:30:00	MSFT	Stock	29.95	30.03	29.92	30.015	8992662.0
2012-10-04 16:00:00	MSFT	Stock	30.025	30.03	29.817	30.01	1525254.0
2012-10-04 16:30:00	MSFT	Stock	30.0	30.0	29.907	30.0	10802.0

> showing 50 of 75,568 rows — these rows as CSV

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