PREVIEW / stock_30min / 2011-11-23

all stock 30-min files

  file:    by_date/stock_30min/2011/2011-11-23.parquet
  size:    1.4 MB
  rows:    74,448
  symbols: 3,534

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-11-23 06:30:00	AAPL	Stock	13.3421	13.375	13.3421	13.375	14000.0
2011-11-23 07:00:00	AAPL	Stock	13.3893	13.3893	13.3393	13.3543	152852.0
2011-11-23 07:30:00	AAPL	Stock	13.3464	13.36	13.3357	13.36	196980.0
2011-11-23 08:00:00	AAPL	Stock	13.3554	13.3721	13.3243	13.3393	631092.0
2011-11-23 08:30:00	AAPL	Stock	13.3393	13.3796	13.3179	13.3393	1079372.0
2011-11-23 09:00:00	AAPL	Stock	13.3393	13.3986	13.3211	13.3754	1440936.0
2011-11-23 09:30:00	AAPL	Stock	13.3821	13.4229	13.2614	13.2644	66035676.0
2011-11-23 10:00:00	AAPL	Stock	13.2636	13.2825	13.1354	13.1696	61009424.0
2011-11-23 10:30:00	AAPL	Stock	13.1696	13.2232	13.1393	13.2121	36716764.0
2011-11-23 11:00:00	AAPL	Stock	13.2096	13.2289	13.1375	13.1543	28540036.0
2011-11-23 11:30:00	AAPL	Stock	13.1536	13.1786	13.1186	13.148	28026068.0
2011-11-23 12:00:00	AAPL	Stock	13.1486	13.1932	13.1454	13.1639	15194004.0
2011-11-23 12:30:00	AAPL	Stock	13.1634	13.1971	13.1435	13.1836	16738008.0
2011-11-23 13:00:00	AAPL	Stock	13.1832	13.2089	13.1739	13.2011	14885444.0
2011-11-23 13:30:00	AAPL	Stock	13.1996	13.2036	13.1396	13.1457	18581136.0
2011-11-23 14:00:00	AAPL	Stock	13.145	13.1564	13.1029	13.1354	26636428.0
2011-11-23 14:30:00	AAPL	Stock	13.1367	13.1714	13.1311	13.1579	14936096.0
2011-11-23 15:00:00	AAPL	Stock	13.1579	13.2157	13.1332	13.1671	29398740.0
2011-11-23 15:30:00	AAPL	Stock	13.1668	13.205	13.1071	13.1071	43189468.0
2011-11-23 16:00:00	AAPL	Stock	13.1071	13.2045	13.095	13.1207	21410648.0
2011-11-23 16:30:00	AAPL	Stock	13.1246	13.1978	13.1071	13.1143	167860.0
2011-11-23 17:00:00	AAPL	Stock	13.1139	13.1225	13.1111	13.1225	141876.0
2011-11-23 17:30:00	AAPL	Stock	13.1225	13.1368	13.1157	13.1286	80136.0
2011-11-23 18:00:00	AAPL	Stock	13.1329	13.1386	13.1068	13.1321	99400.0
2011-11-23 18:30:00	AAPL	Stock	13.1343	13.1379	13.1243	13.1379	92512.0
2011-11-23 19:00:00	AAPL	Stock	13.1386	13.1482	13.1364	13.1429	201152.0
2011-11-23 19:30:00	AAPL	Stock	13.1432	13.1496	13.1389	13.1496	118160.0
2011-11-23 04:00:00	MSFT	Stock	24.67	24.67	24.52	24.52	300.0
2011-11-23 04:30:00	MSFT	Stock	24.52	24.52	24.52	24.52	100.0
2011-11-23 05:00:00	MSFT	Stock	24.52	24.52	24.52	24.52	100.0
2011-11-23 05:30:00	MSFT	Stock	24.53	24.53	24.53	24.53	500.0
2011-11-23 06:00:00	MSFT	Stock	24.5	24.5	24.5	24.5	400.0
2011-11-23 07:30:00	MSFT	Stock	24.61	24.7	24.61	24.7	2174.0
2011-11-23 08:00:00	MSFT	Stock	24.7	24.7	24.5	24.55	45814.0
2011-11-23 08:30:00	MSFT	Stock	24.58	24.63	24.55	24.6	25051.0
2011-11-23 09:00:00	MSFT	Stock	24.6	24.69	24.56	24.65	43068.0
2011-11-23 09:30:00	MSFT	Stock	24.65	24.79	24.56	24.57	3933175.0
2011-11-23 10:00:00	MSFT	Stock	24.56	24.62	24.51	24.55	4099291.0
2011-11-23 10:30:00	MSFT	Stock	24.546	24.62	24.5	24.615	3195621.0
2011-11-23 11:00:00	MSFT	Stock	24.6	24.62	24.5	24.52	4012377.0
2011-11-23 11:30:00	MSFT	Stock	24.52	24.59	24.49	24.535	3755052.0
2011-11-23 12:00:00	MSFT	Stock	24.52	24.6	24.51	24.518	1999273.0
2011-11-23 12:30:00	MSFT	Stock	24.51	24.63	24.49	24.62	3147875.0
2011-11-23 13:00:00	MSFT	Stock	24.615	24.69	24.59	24.665	2274624.0
2011-11-23 13:30:00	MSFT	Stock	24.665	24.67	24.5	24.53	2125668.0
2011-11-23 14:00:00	MSFT	Stock	24.53	24.56	24.495	24.505	2817221.0
2011-11-23 14:30:00	MSFT	Stock	24.505	24.55	24.5	24.52	1942975.0
2011-11-23 15:00:00	MSFT	Stock	24.52	24.64	24.495	24.565	3970144.0
2011-11-23 15:30:00	MSFT	Stock	24.565	24.68	24.47	24.47	7960718.0
2011-11-23 16:00:00	MSFT	Stock	24.47	24.561	24.47	24.541	3113321.0

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

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