PREVIEW / stock_30min / 2013-05-17

all stock 30-min files

  file:    by_date/stock_30min/2013/2013-05-17.parquet
  size:    1.5 MB
  rows:    78,754
  symbols: 3,513

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-05-17 05:30:00	AAPL	Stock	15.5357	15.5357	15.5354	15.5357	8400.0
2013-05-17 06:00:00	AAPL	Stock	15.5357	15.5357	15.535	15.535	11200.0
2013-05-17 06:30:00	AAPL	Stock	15.535	15.5861	15.5343	15.5861	43484.0
2013-05-17 07:00:00	AAPL	Stock	15.5929	15.6979	15.5886	15.6789	780864.0
2013-05-17 07:30:00	AAPL	Stock	15.6696	15.7679	15.6607	15.725	1121596.0
2013-05-17 08:00:00	AAPL	Stock	15.7161	15.75	15.6143	15.6714	933576.0
2013-05-17 08:30:00	AAPL	Stock	15.6718	15.6964	15.6693	15.6693	736288.0
2013-05-17 09:00:00	AAPL	Stock	15.6743	15.6893	15.5189	15.6736	1420832.0
2013-05-17 09:30:00	AAPL	Stock	15.6804	15.7175	15.5286	15.6246	88331908.0
2013-05-17 10:00:00	AAPL	Stock	15.625	15.6943	15.4846	15.5179	51968420.0
2013-05-17 10:30:00	AAPL	Stock	15.5132	15.5631	15.4679	15.4971	40193300.0
2013-05-17 11:00:00	AAPL	Stock	15.4964	15.5	15.4143	15.4235	37453360.0
2013-05-17 11:30:00	AAPL	Stock	15.4236	15.4604	15.3932	15.4382	23653644.0
2013-05-17 12:00:00	AAPL	Stock	15.4379	15.4564	15.4018	15.4207	15840188.0
2013-05-17 12:30:00	AAPL	Stock	15.4207	15.4889	15.395	15.4854	16816744.0
2013-05-17 13:00:00	AAPL	Stock	15.4836	15.5211	15.4725	15.5004	23970268.0
2013-05-17 13:30:00	AAPL	Stock	15.4982	15.5018	15.4204	15.4525	16135112.0
2013-05-17 14:00:00	AAPL	Stock	15.4561	15.4604	15.4286	15.4399	12916876.0
2013-05-17 14:30:00	AAPL	Stock	15.44	15.5035	15.4336	15.4943	20936972.0
2013-05-17 15:00:00	AAPL	Stock	15.4943	15.5014	15.4361	15.4643	19308100.0
2013-05-17 15:30:00	AAPL	Stock	15.4624	15.4818	15.4475	15.4732	29568924.0
2013-05-17 16:00:00	AAPL	Stock	15.4732	15.5374	15.4679	15.5	20858264.0
2013-05-17 16:30:00	AAPL	Stock	15.4982	15.5	15.4651	15.4736	861588.0
2013-05-17 17:00:00	AAPL	Stock	15.4954	15.5	15.4857	15.4857	79100.0
2013-05-17 17:30:00	AAPL	Stock	15.4857	15.4911	15.4857	15.4911	23716.0
2013-05-17 18:00:00	AAPL	Stock	15.4911	15.4996	15.4911	15.4921	22960.0
2013-05-17 18:30:00	AAPL	Stock	15.4954	15.5054	15.4954	15.4964	33516.0
2013-05-17 19:00:00	AAPL	Stock	15.4911	15.4964	15.4821	15.4964	21728.0
2013-05-17 19:30:00	AAPL	Stock	15.4964	15.5	15.4911	15.5	108388.0
2013-05-17 04:30:00	MSFT	Stock	34.03	34.03	33.98	33.98	200.0
2013-05-17 05:30:00	MSFT	Stock	34.03	34.03	34.03	34.03	100.0
2013-05-17 06:00:00	MSFT	Stock	34.03	34.03	34.03	34.03	200.0
2013-05-17 07:00:00	MSFT	Stock	34.09	34.1	34.09	34.1	443.0
2013-05-17 07:30:00	MSFT	Stock	34.08	34.09	34.08	34.09	600.0
2013-05-17 08:00:00	MSFT	Stock	34.05	34.1	33.9	34.08	12443.0
2013-05-17 08:30:00	MSFT	Stock	34.07	34.08	34.03	34.06	4628.0
2013-05-17 09:00:00	MSFT	Stock	34.08	34.16	34.06	34.15	74297.0
2013-05-17 09:30:00	MSFT	Stock	34.13	34.3	34.1	34.178	10969315.0
2013-05-17 10:00:00	MSFT	Stock	34.18	34.31	34.17	34.31	2916636.0
2013-05-17 10:30:00	MSFT	Stock	34.31	34.37	34.28	34.36	4092315.0
2013-05-17 11:00:00	MSFT	Stock	34.35	34.39	34.25	34.35	3101535.0
2013-05-17 11:30:00	MSFT	Stock	34.354	34.375	34.3	34.34	1520110.0
2013-05-17 12:00:00	MSFT	Stock	34.343	34.375	34.34	34.353	1439420.0
2013-05-17 12:30:00	MSFT	Stock	34.35	34.36	34.32	34.345	1391038.0
2013-05-17 13:00:00	MSFT	Stock	34.35	34.36	34.28	34.35	2871924.0
2013-05-17 13:30:00	MSFT	Stock	34.34	34.37	34.34	34.365	3260129.0
2013-05-17 14:00:00	MSFT	Stock	34.37	34.5	34.35	34.483	2573676.0
2013-05-17 14:30:00	MSFT	Stock	34.48	34.54	34.43	34.54	4641053.0
2013-05-17 15:00:00	MSFT	Stock	34.54	34.76	34.53	34.72	4694146.0
2013-05-17 15:30:00	MSFT	Stock	34.71	34.87	34.7	34.87	10363190.0

> showing 50 of 78,754 rows — these rows as CSV

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