PREVIEW / stock_30min / 2013-04-18

all stock 30-min files

  file:    by_date/stock_30min/2013/2013-04-18.parquet
  size:    1.4 MB
  rows:    75,717
  symbols: 3,452

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
2013-04-18 04:00:00	AAPL	Stock	14.37	14.37	14.37	14.37	2800.0
2013-04-18 05:00:00	AAPL	Stock	14.3864	14.3996	14.3864	14.3996	39452.0
2013-04-18 05:30:00	AAPL	Stock	14.425	14.4375	14.425	14.4375	11200.0
2013-04-18 06:00:00	AAPL	Stock	14.4464	14.4464	14.4375	14.4375	8400.0
2013-04-18 06:30:00	AAPL	Stock	14.4107	14.4286	14.4018	14.4286	115472.0
2013-04-18 07:00:00	AAPL	Stock	14.4139	14.5171	14.4139	14.4911	364364.0
2013-04-18 07:30:00	AAPL	Stock	14.4907	14.5629	14.4507	14.5318	1036364.0
2013-04-18 08:00:00	AAPL	Stock	14.5379	14.55	14.4071	14.4686	2428132.0
2013-04-18 08:30:00	AAPL	Stock	14.4686	14.5214	14.3929	14.4821	5387424.0
2013-04-18 09:00:00	AAPL	Stock	14.4821	14.5511	14.4536	14.4536	4364388.0
2013-04-18 09:30:00	AAPL	Stock	14.4643	14.4925	14.2368	14.25	102111548.0
2013-04-18 10:00:00	AAPL	Stock	14.25	14.2632	14.1039	14.1293	103967836.0
2013-04-18 10:30:00	AAPL	Stock	14.1314	14.2032	14.0557	14.1825	66643024.0
2013-04-18 11:00:00	AAPL	Stock	14.1843	14.1864	14.0807	14.1196	38479980.0
2013-04-18 11:30:00	AAPL	Stock	14.1125	14.1382	14.0557	14.1193	35715120.0
2013-04-18 12:00:00	AAPL	Stock	14.1196	14.1489	14.0846	14.1139	28766248.0
2013-04-18 12:30:00	AAPL	Stock	14.1121	14.155	14.0982	14.125	19301268.0
2013-04-18 13:00:00	AAPL	Stock	14.1296	14.1336	14.0893	14.1071	16326044.0
2013-04-18 13:30:00	AAPL	Stock	14.1075	14.1143	14.0196	14.0314	28393988.0
2013-04-18 14:00:00	AAPL	Stock	14.03	14.0379	13.9575	13.9957	45793524.0
2013-04-18 14:30:00	AAPL	Stock	13.9957	14.0236	13.9194	13.9429	42353108.0
2013-04-18 15:00:00	AAPL	Stock	13.9429	13.9943	13.9252	13.9389	35605892.0
2013-04-18 15:30:00	AAPL	Stock	13.9407	14.0614	13.9357	13.9964	57265600.0
2013-04-18 16:00:00	AAPL	Stock	14.0018	14.1192	13.9125	13.9218	21211120.0
2013-04-18 16:30:00	AAPL	Stock	13.9236	14.1384	13.9221	13.9682	1294244.0
2013-04-18 17:00:00	AAPL	Stock	13.9779	14.0018	13.9539	13.9732	696388.0
2013-04-18 17:30:00	AAPL	Stock	13.9732	13.9811	13.9654	13.9668	86996.0
2013-04-18 18:00:00	AAPL	Stock	13.9711	13.9714	13.9575	13.9693	157248.0
2013-04-18 18:30:00	AAPL	Stock	13.9689	13.9811	13.9689	13.9804	103488.0
2013-04-18 19:00:00	AAPL	Stock	13.9775	13.9786	13.9643	13.9646	110880.0
2013-04-18 19:30:00	AAPL	Stock	13.9679	13.9729	13.9643	13.9707	172844.0
2013-04-18 05:30:00	MSFT	Stock	29.09	29.09	29.09	29.09	200.0
2013-04-18 06:30:00	MSFT	Stock	28.87	28.87	28.87	28.87	200.0
2013-04-18 07:00:00	MSFT	Stock	28.89	28.9	28.89	28.9	913.0
2013-04-18 07:30:00	MSFT	Stock	28.9	28.9	28.9	28.9	1082.0
2013-04-18 08:00:00	MSFT	Stock	28.91	28.95	28.9	28.93	8558.0
2013-04-18 08:30:00	MSFT	Stock	28.9	28.9	28.87	28.87	4485.0
2013-04-18 09:00:00	MSFT	Stock	28.87	29.01	28.78	28.98	22053.0
2013-04-18 09:30:00	MSFT	Stock	28.98	28.98	28.75	28.83	4241360.0
2013-04-18 10:00:00	MSFT	Stock	28.825	28.845	28.5	28.6	7404798.0
2013-04-18 10:30:00	MSFT	Stock	28.61	28.785	28.6	28.76	3330580.0
2013-04-18 11:00:00	MSFT	Stock	28.77	28.86	28.74	28.81	4364540.0
2013-04-18 11:30:00	MSFT	Stock	28.81	28.81	28.67	28.705	2639864.0
2013-04-18 12:00:00	MSFT	Stock	28.705	28.79	28.695	28.775	2446004.0
2013-04-18 12:30:00	MSFT	Stock	28.77	28.85	28.76	28.806	1704903.0
2013-04-18 13:00:00	MSFT	Stock	28.8	28.87	28.79	28.846	2316011.0
2013-04-18 13:30:00	MSFT	Stock	28.84	28.86	28.81	28.82	2075664.0
2013-04-18 14:00:00	MSFT	Stock	28.82	28.83	28.72	28.75	3009816.0
2013-04-18 14:30:00	MSFT	Stock	28.755	28.78	28.71	28.725	2951901.0
2013-04-18 15:00:00	MSFT	Stock	28.72	28.8	28.69	28.76	3403382.0

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

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