PREVIEW / stock_30min / 2012-01-24

all stock 30-min files

  file:    by_date/stock_30min/2012/2012-01-24.parquet
  size:    1.4 MB
  rows:    74,310
  symbols: 3,522

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-24 04:00:00	AAPL	Stock	15.2679	15.2679	15.2643	15.2679	22400.0
2012-01-24 04:30:00	AAPL	Stock	15.25	15.25	15.2354	15.2496	16800.0
2012-01-24 05:00:00	AAPL	Stock	15.2432	15.2432	15.2143	15.2279	14000.0
2012-01-24 05:30:00	AAPL	Stock	15.2143	15.2143	15.2143	15.2143	2800.0
2012-01-24 06:00:00	AAPL	Stock	15.1964	15.2232	15.1964	15.2	28840.0
2012-01-24 07:00:00	AAPL	Stock	15.2143	15.2311	15.2046	15.2046	135884.0
2012-01-24 07:30:00	AAPL	Stock	15.2193	15.2214	15.1964	15.1964	174300.0
2012-01-24 08:00:00	AAPL	Stock	15.2032	15.23	15.1886	15.1886	1042636.0
2012-01-24 08:30:00	AAPL	Stock	15.1886	15.2175	15.1671	15.1857	1281168.0
2012-01-24 09:00:00	AAPL	Stock	15.1861	15.1911	15.175	15.1807	1081668.0
2012-01-24 09:30:00	AAPL	Stock	15.1825	15.1825	15.1129	15.1389	46762128.0
2012-01-24 10:00:00	AAPL	Stock	15.1386	15.1786	15.1171	15.1489	26656476.0
2012-01-24 10:30:00	AAPL	Stock	15.1492	15.1764	15.1379	15.1436	16928996.0
2012-01-24 11:00:00	AAPL	Stock	15.1458	15.15	15.1257	15.145	15411004.0
2012-01-24 11:30:00	AAPL	Stock	15.1436	15.1475	15.1093	15.1286	19057444.0
2012-01-24 12:00:00	AAPL	Stock	15.1275	15.1536	15.125	15.1332	14202440.0
2012-01-24 12:30:00	AAPL	Stock	15.1336	15.1493	15.1261	15.1393	12610192.0
2012-01-24 13:00:00	AAPL	Stock	15.1396	15.1404	15.0936	15.0966	17332952.0
2012-01-24 13:30:00	AAPL	Stock	15.0968	15.1057	15.0307	15.0761	37311456.0
2012-01-24 14:00:00	AAPL	Stock	15.0761	15.1139	15.0752	15.0952	20908524.0
2012-01-24 14:30:00	AAPL	Stock	15.0954	15.0971	15.0579	15.0725	22339380.0
2012-01-24 15:00:00	AAPL	Stock	15.0714	15.0893	15.0564	15.0807	24141124.0
2012-01-24 15:30:00	AAPL	Stock	15.08	15.0882	14.9839	15.018	76099632.0
2012-01-24 16:00:00	AAPL	Stock	15.0161	15.2707	14.9643	15.0786	2921240.0
2012-01-24 16:30:00	AAPL	Stock	16.7482	16.7482	15.0146	16.1968	86964332.0
2012-01-24 17:00:00	AAPL	Stock	16.1996	16.2504	16.0714	16.1529	49438872.0
2012-01-24 17:30:00	AAPL	Stock	16.1525	16.2286	15.0179	16.2143	14064820.0
2012-01-24 18:00:00	AAPL	Stock	16.2143	16.2232	16.1607	16.1875	9436868.0
2012-01-24 18:30:00	AAPL	Stock	16.1882	16.1946	16.1429	16.145	4437524.0
2012-01-24 19:00:00	AAPL	Stock	16.1446	16.1532	16.1071	16.1532	3296972.0
2012-01-24 19:30:00	AAPL	Stock	16.1464	16.1564	16.1071	16.11	1762684.0
2012-01-24 07:00:00	MSFT	Stock	29.54	29.54	29.5	29.52	700.0
2012-01-24 07:30:00	MSFT	Stock	29.5	29.5	29.5	29.5	1500.0
2012-01-24 08:00:00	MSFT	Stock	29.57	29.58	29.54	29.57	5216.0
2012-01-24 08:30:00	MSFT	Stock	29.55	29.55	29.51	29.52	24386.0
2012-01-24 09:00:00	MSFT	Stock	29.51	29.73	29.29	29.45	503325.0
2012-01-24 09:30:00	MSFT	Stock	29.47	29.57	29.372	29.46	7083715.0
2012-01-24 10:00:00	MSFT	Stock	29.46	29.53	29.42	29.42	4095963.0
2012-01-24 10:30:00	MSFT	Stock	29.42	29.47	29.4	29.456	3799577.0
2012-01-24 11:00:00	MSFT	Stock	29.455	29.47	29.35	29.45	3989434.0
2012-01-24 11:30:00	MSFT	Stock	29.45	29.46	29.3	29.355	2777208.0
2012-01-24 12:00:00	MSFT	Stock	29.36	29.41	29.22	29.22	2942480.0
2012-01-24 12:30:00	MSFT	Stock	29.22	29.34	29.22	29.3	3068184.0
2012-01-24 13:00:00	MSFT	Stock	29.3	29.31	29.19	29.22	2578355.0
2012-01-24 13:30:00	MSFT	Stock	29.21	29.29	29.18	29.29	2160788.0
2012-01-24 14:00:00	MSFT	Stock	29.29	29.36	29.26	29.31	2852316.0
2012-01-24 14:30:00	MSFT	Stock	29.31	29.38	29.28	29.355	2889145.0
2012-01-24 15:00:00	MSFT	Stock	29.36	29.39	29.32	29.38	3258895.0
2012-01-24 15:30:00	MSFT	Stock	29.38	29.39	29.28	29.34	6505301.0
2012-01-24 16:00:00	MSFT	Stock	29.335	29.569	29.29	29.3	247026.0

> showing 50 of 74,310 rows — these rows as CSV

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