PREVIEW / stock_30min / 2011-02-10

all stock 30-min files

  file:    by_date/stock_30min/2011/2011-02-10.parquet
  size:    1.4 MB
  rows:    76,194
  symbols: 3,541

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-02-10 04:00:00	AAPL	Stock	12.7089	12.7089	12.6786	12.6786	11200.0
2011-02-10 04:30:00	AAPL	Stock	12.68	12.6929	12.6764	12.6929	67200.0
2011-02-10 05:00:00	AAPL	Stock	12.7046	12.725	12.7046	12.7204	58800.0
2011-02-10 05:30:00	AAPL	Stock	12.7179	12.7179	12.7143	12.7143	12600.0
2011-02-10 06:00:00	AAPL	Stock	12.6893	12.6982	12.6893	12.6982	11200.0
2011-02-10 06:30:00	AAPL	Stock	12.6968	12.7411	12.6968	12.7411	42000.0
2011-02-10 07:00:00	AAPL	Stock	12.7143	12.7175	12.7036	12.7139	279860.0
2011-02-10 07:30:00	AAPL	Stock	12.7139	12.7807	12.7139	12.7357	258664.0
2011-02-10 08:00:00	AAPL	Stock	12.7382	12.7479	12.6936	12.7357	1736056.0
2011-02-10 08:30:00	AAPL	Stock	12.7361	12.7429	12.7007	12.7296	1214388.0
2011-02-10 09:00:00	AAPL	Stock	12.7286	12.7643	12.7221	12.7632	1620612.0
2011-02-10 09:30:00	AAPL	Stock	12.7643	12.7807	12.7189	12.7539	69075020.0
2011-02-10 10:00:00	AAPL	Stock	12.7529	12.8511	12.7404	12.8372	67505200.0
2011-02-10 10:30:00	AAPL	Stock	12.8375	12.8411	12.8121	12.8218	38683876.0
2011-02-10 11:00:00	AAPL	Stock	12.8204	12.8525	12.8143	12.8511	34160308.0
2011-02-10 11:30:00	AAPL	Stock	12.8511	12.8571	12.8325	12.8364	32271316.0
2011-02-10 12:00:00	AAPL	Stock	12.8361	12.8482	12.82	12.8375	21716716.0
2011-02-10 12:30:00	AAPL	Stock	12.8375	12.845	12.8018	12.8193	24070760.0
2011-02-10 13:00:00	AAPL	Stock	12.8193	12.8232	12.76	12.7622	30218776.0
2011-02-10 13:30:00	AAPL	Stock	12.76	12.7673	12.4286	12.62	227463796.0
2011-02-10 14:00:00	AAPL	Stock	12.6204	12.7054	12.5904	12.6989	87205384.0
2011-02-10 14:30:00	AAPL	Stock	12.6982	12.7307	12.65	12.6693	58908192.0
2011-02-10 15:00:00	AAPL	Stock	12.6696	12.6982	12.5982	12.6725	69939380.0
2011-02-10 15:30:00	AAPL	Stock	12.6729	12.7036	12.5932	12.6621	129430028.0
2011-02-10 16:00:00	AAPL	Stock	12.6636	12.7863	12.6339	12.6432	14546196.0
2011-02-10 16:30:00	AAPL	Stock	12.6432	12.681	12.6293	12.6318	620592.0
2011-02-10 17:00:00	AAPL	Stock	12.6325	12.7644	12.6254	12.6254	404012.0
2011-02-10 17:30:00	AAPL	Stock	12.6286	12.6321	12.6125	12.6254	320320.0
2011-02-10 18:00:00	AAPL	Stock	12.6254	12.6621	12.6254	12.6496	494368.0
2011-02-10 18:30:00	AAPL	Stock	12.65	12.6514	12.6436	12.6486	96628.0
2011-02-10 19:00:00	AAPL	Stock	12.65	12.65	12.6411	12.6457	155204.0
2011-02-10 19:30:00	AAPL	Stock	12.6429	12.6464	12.6357	12.6464	332976.0
2011-02-10 04:00:00	MSFT	Stock	27.8	27.8	27.77	27.77	300.0
2011-02-10 04:30:00	MSFT	Stock	27.7	27.7	27.7	27.7	300.0
2011-02-10 06:00:00	MSFT	Stock	27.7	27.72	27.7	27.72	3000.0
2011-02-10 07:00:00	MSFT	Stock	27.78	27.83	27.78	27.83	500.0
2011-02-10 07:30:00	MSFT	Stock	27.83	27.83	27.83	27.83	700.0
2011-02-10 08:00:00	MSFT	Stock	27.83	27.9	27.78	27.82	10622.0
2011-02-10 08:30:00	MSFT	Stock	27.88	27.9	27.84	27.84	18703.0
2011-02-10 09:00:00	MSFT	Stock	27.85	27.94	27.85	27.94	57439.0
2011-02-10 09:30:00	MSFT	Stock	27.94	27.94	27.36	27.398	11781570.0
2011-02-10 10:00:00	MSFT	Stock	27.398	27.56	27.29	27.478	9950567.0
2011-02-10 10:30:00	MSFT	Stock	27.47	27.54	27.438	27.52	5052252.0
2011-02-10 11:00:00	MSFT	Stock	27.518	27.62	27.48	27.497	4785590.0
2011-02-10 11:30:00	MSFT	Stock	27.5	27.53	27.45	27.459	3180155.0
2011-02-10 12:00:00	MSFT	Stock	27.459	27.48	27.41	27.42	3092057.0
2011-02-10 12:30:00	MSFT	Stock	27.41	27.45	27.41	27.415	2577095.0
2011-02-10 13:00:00	MSFT	Stock	27.41	27.42	27.36	27.37	2632007.0
2011-02-10 13:30:00	MSFT	Stock	27.37	27.45	27.36	27.4	3605425.0
2011-02-10 14:00:00	MSFT	Stock	27.4	27.4	27.32	27.38	4046732.0

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

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