PREVIEW / stock_30min / 2012-01-26

all stock 30-min files

  file:    by_date/stock_30min/2012/2012-01-26.parquet
  size:    1.4 MB
  rows:    77,720
  symbols: 3,520

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-01-26 04:00:00	AAPL	Stock	15.9754	16.0	15.9729	16.0	47600.0
2012-01-26 04:30:00	AAPL	Stock	16.0	16.0489	16.0	16.0382	92400.0
2012-01-26 05:00:00	AAPL	Stock	16.0304	16.0461	16.0268	16.0268	56000.0
2012-01-26 05:30:00	AAPL	Stock	16.0321	16.0321	16.0179	16.0179	19600.0
2012-01-26 06:00:00	AAPL	Stock	16.0321	16.0379	16.0304	16.0357	44800.0
2012-01-26 06:30:00	AAPL	Stock	16.0214	16.0214	16.0179	16.0179	16800.0
2012-01-26 07:00:00	AAPL	Stock	16.0179	16.0314	16.0064	16.0214	303492.0
2012-01-26 07:30:00	AAPL	Stock	16.0175	16.0357	16.0043	16.0214	706356.0
2012-01-26 08:00:00	AAPL	Stock	16.025	16.0321	15.9514	16.0182	928844.0
2012-01-26 08:30:00	AAPL	Stock	16.0186	16.035	15.9904	15.9929	454692.0
2012-01-26 09:00:00	AAPL	Stock	15.9929	16.0425	15.9404	16.0157	2779560.0
2012-01-26 09:30:00	AAPL	Stock	16.0129	16.0282	15.9243	16.0036	61444432.0
2012-01-26 10:00:00	AAPL	Stock	16.0036	16.0036	15.9489	15.9493	29799280.0
2012-01-26 10:30:00	AAPL	Stock	15.9493	15.9561	15.8611	15.8664	38920896.0
2012-01-26 11:00:00	AAPL	Stock	15.8668	15.9164	15.8514	15.9114	22155364.0
2012-01-26 11:30:00	AAPL	Stock	15.9086	15.9139	15.8696	15.9054	18678632.0
2012-01-26 12:00:00	AAPL	Stock	15.9043	15.9057	15.8714	15.8821	13350372.0
2012-01-26 12:30:00	AAPL	Stock	15.8821	15.8982	15.8625	15.8796	14008512.0
2012-01-26 13:00:00	AAPL	Stock	15.8782	15.88	15.8489	15.8668	13555500.0
2012-01-26 13:30:00	AAPL	Stock	15.8664	15.8804	15.8536	15.8779	14282716.0
2012-01-26 14:00:00	AAPL	Stock	15.8779	15.8802	15.85	15.8618	12124812.0
2012-01-26 14:30:00	AAPL	Stock	15.8594	15.8846	15.8579	15.8671	11833276.0
2012-01-26 15:00:00	AAPL	Stock	15.8668	15.8743	15.8264	15.8284	21520996.0
2012-01-26 15:30:00	AAPL	Stock	15.8304	15.8811	15.8287	15.8771	33942916.0
2012-01-26 16:00:00	AAPL	Stock	15.8796	15.9201	15.8611	15.8743	1048460.0
2012-01-26 16:30:00	AAPL	Stock	15.875	15.9088	15.8306	15.8754	459620.0
2012-01-26 17:00:00	AAPL	Stock	15.9521	15.9521	15.8621	15.8854	253764.0
2012-01-26 17:30:00	AAPL	Stock	15.8825	15.9039	15.8821	15.8932	234864.0
2012-01-26 18:00:00	AAPL	Stock	15.8921	15.8929	15.8818	15.8875	25284.0
2012-01-26 18:30:00	AAPL	Stock	15.8857	15.8929	15.8857	15.8893	25900.0
2012-01-26 19:00:00	AAPL	Stock	15.8893	15.8893	15.8625	15.8696	182224.0
2012-01-26 19:30:00	AAPL	Stock	15.8661	15.8729	15.8625	15.8625	50064.0
2012-01-26 05:00:00	MSFT	Stock	29.63	29.63	29.63	29.63	1000.0
2012-01-26 06:30:00	MSFT	Stock	29.56	29.56	29.55	29.55	1100.0
2012-01-26 07:00:00	MSFT	Stock	29.55	29.55	29.55	29.55	1400.0
2012-01-26 07:30:00	MSFT	Stock	29.55	29.65	29.55	29.65	600.0
2012-01-26 08:00:00	MSFT	Stock	29.64	29.7	29.59	29.68	15186.0
2012-01-26 08:30:00	MSFT	Stock	29.61	29.7	29.6	29.65	5277.0
2012-01-26 09:00:00	MSFT	Stock	29.65	29.65	29.544	29.544	85125.0
2012-01-26 09:30:00	MSFT	Stock	29.63	29.69	29.49	29.61	4849364.0
2012-01-26 10:00:00	MSFT	Stock	29.61	29.7	29.51	29.675	4551904.0
2012-01-26 10:30:00	MSFT	Stock	29.674	29.68	29.51	29.53	4566794.0
2012-01-26 11:00:00	MSFT	Stock	29.53	29.675	29.52	29.63	4829159.0
2012-01-26 11:30:00	MSFT	Stock	29.63	29.665	29.6	29.622	2463029.0
2012-01-26 12:00:00	MSFT	Stock	29.628	29.636	29.53	29.55	2866280.0
2012-01-26 12:30:00	MSFT	Stock	29.55	29.6	29.52	29.59	2139119.0
2012-01-26 13:00:00	MSFT	Stock	29.585	29.6	29.57	29.59	1106357.0
2012-01-26 13:30:00	MSFT	Stock	29.59	29.59	29.48	29.58	2504174.0
2012-01-26 14:00:00	MSFT	Stock	29.572	29.58	29.48	29.54	2482603.0
2012-01-26 14:30:00	MSFT	Stock	29.536	29.56	29.4	29.51	4019629.0

> showing 50 of 77,720 rows — these rows as CSV

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