PREVIEW / stock_30min / 2013-03-26

all stock 30-min files

  file:    by_date/stock_30min/2013/2013-03-26.parquet
  size:    1.4 MB
  rows:    75,380
  symbols: 3,484

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-03-26 05:00:00	AAPL	Stock	16.5704	16.5704	16.5704	16.5704	7000.0
2013-03-26 06:00:00	AAPL	Stock	16.5761	16.5761	16.5761	16.5761	2800.0
2013-03-26 07:00:00	AAPL	Stock	16.5893	16.6568	16.5861	16.65	350756.0
2013-03-26 07:30:00	AAPL	Stock	16.6464	16.6464	16.5821	16.5821	322532.0
2013-03-26 08:00:00	AAPL	Stock	16.585	16.6464	16.5339	16.585	1404032.0
2013-03-26 08:30:00	AAPL	Stock	16.5718	16.6021	16.5714	16.5836	414120.0
2013-03-26 09:00:00	AAPL	Stock	16.5836	16.6268	16.5757	16.6129	2296812.0
2013-03-26 09:30:00	AAPL	Stock	16.6079	16.6371	16.4843	16.5143	53857524.0
2013-03-26 10:00:00	AAPL	Stock	16.5154	16.5664	16.4686	16.4732	38352860.0
2013-03-26 10:30:00	AAPL	Stock	16.4732	16.5225	16.45	16.5168	29099140.0
2013-03-26 11:00:00	AAPL	Stock	16.5171	16.5261	16.4839	16.4989	14197232.0
2013-03-26 11:30:00	AAPL	Stock	16.4987	16.5575	16.4964	16.51	15920436.0
2013-03-26 12:00:00	AAPL	Stock	16.5139	16.5357	16.4893	16.5089	13538028.0
2013-03-26 12:30:00	AAPL	Stock	16.5073	16.5311	16.4968	16.5131	8593592.0
2013-03-26 13:00:00	AAPL	Stock	16.5132	16.555	16.5104	16.5525	10573444.0
2013-03-26 13:30:00	AAPL	Stock	16.555	16.5721	16.5289	16.5457	11783772.0
2013-03-26 14:00:00	AAPL	Stock	16.5471	16.5532	16.5204	16.5275	8884008.0
2013-03-26 14:30:00	AAPL	Stock	16.5271	16.5329	16.4714	16.4882	18986212.0
2013-03-26 15:00:00	AAPL	Stock	16.4882	16.4936	16.4475	16.484	21175700.0
2013-03-26 15:30:00	AAPL	Stock	16.4839	16.4929	16.4518	16.4689	28229488.0
2013-03-26 16:00:00	AAPL	Stock	16.4671	16.5564	16.465	16.4714	10349192.0
2013-03-26 16:30:00	AAPL	Stock	16.4714	16.5036	16.4671	16.4786	128912.0
2013-03-26 17:00:00	AAPL	Stock	16.4691	16.4821	16.4691	16.4804	91280.0
2013-03-26 17:30:00	AAPL	Stock	16.4743	16.4743	16.4607	16.4607	136668.0
2013-03-26 18:00:00	AAPL	Stock	16.4611	16.4671	16.4607	16.4671	127400.0
2013-03-26 18:30:00	AAPL	Stock	16.4654	16.4693	16.4639	16.4693	97412.0
2013-03-26 19:00:00	AAPL	Stock	16.4696	16.4696	16.4579	16.4582	234276.0
2013-03-26 19:30:00	AAPL	Stock	16.4582	16.4668	16.4571	16.4618	121772.0
2013-03-26 08:00:00	MSFT	Stock	28.23	28.3	28.11	28.25	12150.0
2013-03-26 08:30:00	MSFT	Stock	28.25	28.27	28.16	28.26	48200.0
2013-03-26 09:00:00	MSFT	Stock	28.26	28.29	28.23	28.29	2398.0
2013-03-26 09:30:00	MSFT	Stock	28.29	28.34	28.21	28.29	2965385.0
2013-03-26 10:00:00	MSFT	Stock	28.29	28.3	28.25	28.29	2139095.0
2013-03-26 10:30:00	MSFT	Stock	28.285	28.3	28.2	28.26	2054578.0
2013-03-26 11:00:00	MSFT	Stock	28.27	28.287	28.25	28.26	1412146.0
2013-03-26 11:30:00	MSFT	Stock	28.26	28.27	28.23	28.25	1197023.0
2013-03-26 12:00:00	MSFT	Stock	28.245	28.255	28.13	28.17	1430444.0
2013-03-26 12:30:00	MSFT	Stock	28.17	28.175	28.11	28.12	1547634.0
2013-03-26 13:00:00	MSFT	Stock	28.12	28.16	28.12	28.14	1734144.0
2013-03-26 13:30:00	MSFT	Stock	28.13	28.18	28.13	28.16	1262755.0
2013-03-26 14:00:00	MSFT	Stock	28.15	28.16	28.13	28.145	1325524.0
2013-03-26 14:30:00	MSFT	Stock	28.148	28.169	28.12	28.16	2055315.0
2013-03-26 15:00:00	MSFT	Stock	28.15	28.19	28.15	28.165	2679094.0
2013-03-26 15:30:00	MSFT	Stock	28.17	28.2	28.11	28.15	4533151.0
2013-03-26 16:00:00	MSFT	Stock	28.15	28.196	28.118	28.12	1217561.0
2013-03-26 16:30:00	MSFT	Stock	28.219	28.219	28.12	28.12	12750.0
2013-03-26 17:00:00	MSFT	Stock	28.155	28.16	28.155	28.16	23212.0
2013-03-26 18:00:00	MSFT	Stock	28.17	28.17	28.16	28.16	2100.0
2013-03-26 18:30:00	MSFT	Stock	28.16	28.16	28.16	28.16	100.0
2013-03-26 19:00:00	MSFT	Stock	28.16	28.16	28.15	28.15	2800.0

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

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