PREVIEW / stock_30min / 2013-04-05

all stock 30-min files

  file:    by_date/stock_30min/2013/2013-04-05.parquet
  size:    1.5 MB
  rows:    76,992
  symbols: 3,474

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-05 04:00:00	AAPL	Stock	15.2643	15.2643	15.2643	15.2643	2800.0
2013-04-05 04:30:00	AAPL	Stock	15.2857	15.2857	15.2857	15.2857	10528.0
2013-04-05 05:00:00	AAPL	Stock	15.2736	15.2736	15.2589	15.2589	43932.0
2013-04-05 05:30:00	AAPL	Stock	15.2525	15.2525	15.2482	15.2482	39704.0
2013-04-05 06:30:00	AAPL	Stock	15.2268	15.2268	15.2268	15.2268	2800.0
2013-04-05 07:00:00	AAPL	Stock	15.2007	15.2575	15.1786	15.1804	354144.0
2013-04-05 07:30:00	AAPL	Stock	15.1882	15.2254	15.1882	15.2189	74256.0
2013-04-05 08:00:00	AAPL	Stock	15.2261	15.2457	15.2036	15.2296	395640.0
2013-04-05 08:30:00	AAPL	Stock	15.2261	15.2357	15.125	15.135	2503872.0
2013-04-05 09:00:00	AAPL	Stock	15.1361	15.1718	15.1325	15.1564	1915340.0
2013-04-05 09:30:00	AAPL	Stock	15.1546	15.1654	15.0482	15.0718	66630844.0
2013-04-05 10:00:00	AAPL	Stock	15.075	15.1536	15.0546	15.1243	33135368.0
2013-04-05 10:30:00	AAPL	Stock	15.1246	15.1414	15.0786	15.0996	28098252.0
2013-04-05 11:00:00	AAPL	Stock	15.0996	15.1768	15.0932	15.1404	24581620.0
2013-04-05 11:30:00	AAPL	Stock	15.1357	15.1518	15.1071	15.1154	17754828.0
2013-04-05 12:00:00	AAPL	Stock	15.1154	15.1171	15.0768	15.0946	16754080.0
2013-04-05 12:30:00	AAPL	Stock	15.0968	15.11	15.0768	15.0854	13316968.0
2013-04-05 13:00:00	AAPL	Stock	15.0879	15.095	15.0679	15.0875	15659112.0
2013-04-05 13:30:00	AAPL	Stock	15.0871	15.1064	15.0704	15.0896	12772956.0
2013-04-05 14:00:00	AAPL	Stock	15.09	15.1139	15.0679	15.0929	14067872.0
2013-04-05 14:30:00	AAPL	Stock	15.0921	15.1304	15.0886	15.0968	13046096.0
2013-04-05 15:00:00	AAPL	Stock	15.0968	15.0988	15.0268	15.0271	31425688.0
2013-04-05 15:30:00	AAPL	Stock	15.0304	15.1193	14.9886	15.1143	65760380.0
2013-04-05 16:00:00	AAPL	Stock	15.1132	15.1461	15.0939	15.1286	14018060.0
2013-04-05 16:30:00	AAPL	Stock	15.125	15.1429	15.0322	15.1429	1122576.0
2013-04-05 17:00:00	AAPL	Stock	15.1418	15.1446	15.1143	15.1446	236488.0
2013-04-05 17:30:00	AAPL	Stock	15.1429	15.1429	15.1346	15.1393	74704.0
2013-04-05 18:00:00	AAPL	Stock	15.1411	15.1411	15.1411	15.1411	2800.0
2013-04-05 18:30:00	AAPL	Stock	15.1329	15.1364	15.1321	15.1339	44800.0
2013-04-05 19:00:00	AAPL	Stock	15.1339	15.1371	15.1314	15.1314	50400.0
2013-04-05 19:30:00	AAPL	Stock	15.1321	15.1857	15.1271	15.1782	623560.0
2013-04-05 06:30:00	MSFT	Stock	28.51	28.51	28.5	28.5	5114.0
2013-04-05 07:30:00	MSFT	Stock	28.46	28.5	28.45	28.45	3125.0
2013-04-05 08:00:00	MSFT	Stock	28.44	28.45	28.41	28.42	4773.0
2013-04-05 08:30:00	MSFT	Stock	28.4	28.4	28.26	28.3	21772.0
2013-04-05 09:00:00	MSFT	Stock	28.31	28.33	28.22	28.25	159393.0
2013-04-05 09:30:00	MSFT	Stock	28.22	28.32	28.11	28.2	6545442.0
2013-04-05 10:00:00	MSFT	Stock	28.2	28.46	28.17	28.34	5184889.0
2013-04-05 10:30:00	MSFT	Stock	28.335	28.39	28.325	28.37	3298422.0
2013-04-05 11:00:00	MSFT	Stock	28.36	28.43	28.35	28.355	1833039.0
2013-04-05 11:30:00	MSFT	Stock	28.35	28.37	28.245	28.305	2748551.0
2013-04-05 12:00:00	MSFT	Stock	28.302	28.39	28.295	28.335	3649067.0
2013-04-05 12:30:00	MSFT	Stock	28.33	28.45	28.33	28.355	2039594.0
2013-04-05 13:00:00	MSFT	Stock	28.35	28.41	28.35	28.4	1384065.0
2013-04-05 13:30:00	MSFT	Stock	28.403	28.42	28.38	28.4	2393416.0
2013-04-05 14:00:00	MSFT	Stock	28.405	28.47	28.39	28.45	1977483.0
2013-04-05 14:30:00	MSFT	Stock	28.45	28.57	28.45	28.55	2925711.0
2013-04-05 15:00:00	MSFT	Stock	28.55	28.58	28.525	28.55	3364696.0
2013-04-05 15:30:00	MSFT	Stock	28.555	28.78	28.52	28.7	7072880.0
2013-04-05 16:00:00	MSFT	Stock	28.7	28.743	28.403	28.67	4231004.0

> showing 50 of 76,992 rows — these rows as CSV

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