PREVIEW / stock_30min / 2013-05-16

all stock 30-min files

  file:    by_date/stock_30min/2013/2013-05-16.parquet
  size:    1.5 MB
  rows:    78,915
  symbols: 3,517

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-16 04:00:00	AAPL	Stock	15.2464	15.2464	15.2464	15.2464	8400.0
2013-05-16 04:30:00	AAPL	Stock	15.2461	15.2461	15.2343	15.2343	8400.0
2013-05-16 05:00:00	AAPL	Stock	15.25	15.25	15.2393	15.2393	28000.0
2013-05-16 05:30:00	AAPL	Stock	15.2161	15.2161	15.2143	15.2143	5740.0
2013-05-16 06:00:00	AAPL	Stock	15.2246	15.2246	15.1839	15.1839	28000.0
2013-05-16 06:30:00	AAPL	Stock	15.1832	15.1925	15.1832	15.1925	22400.0
2013-05-16 07:00:00	AAPL	Stock	15.1904	15.2682	15.1904	15.2682	104776.0
2013-05-16 07:30:00	AAPL	Stock	15.2682	15.2807	15.2232	15.2321	211652.0
2013-05-16 08:00:00	AAPL	Stock	15.2329	15.2668	15.125	15.2232	1617532.0
2013-05-16 08:30:00	AAPL	Stock	15.2196	15.2232	15.1875	15.1893	842772.0
2013-05-16 09:00:00	AAPL	Stock	15.1896	15.2011	15.1071	15.1161	2482452.0
2013-05-16 09:30:00	AAPL	Stock	15.1271	15.2679	14.9607	15.2607	120755712.0
2013-05-16 10:00:00	AAPL	Stock	15.2621	15.5071	15.2057	15.41	103031684.0
2013-05-16 10:30:00	AAPL	Stock	15.4041	15.5079	15.3932	15.4679	40458712.0
2013-05-16 11:00:00	AAPL	Stock	15.4679	15.5496	15.4582	15.5204	40432112.0
2013-05-16 11:30:00	AAPL	Stock	15.52	15.625	15.5154	15.6014	44647624.0
2013-05-16 12:00:00	AAPL	Stock	15.6014	15.6061	15.4821	15.4996	42230832.0
2013-05-16 12:30:00	AAPL	Stock	15.4996	15.5936	15.4807	15.5743	23914408.0
2013-05-16 13:00:00	AAPL	Stock	15.575	15.5982	15.5546	15.5754	14744016.0
2013-05-16 13:30:00	AAPL	Stock	15.5742	15.5893	15.5361	15.5782	19740168.0
2013-05-16 14:00:00	AAPL	Stock	15.5782	15.6375	15.5739	15.6082	21127904.0
2013-05-16 14:30:00	AAPL	Stock	15.6075	15.6139	15.4529	15.4564	32675944.0
2013-05-16 15:00:00	AAPL	Stock	15.4569	15.5493	15.4557	15.5111	33973800.0
2013-05-16 15:30:00	AAPL	Stock	15.5091	15.53	15.4821	15.5221	36083348.0
2013-05-16 16:00:00	AAPL	Stock	15.52	15.5446	15.4125	15.5002	19583592.0
2013-05-16 16:30:00	AAPL	Stock	15.4875	15.6117	15.4875	15.5304	1048908.0
2013-05-16 17:00:00	AAPL	Stock	15.5268	15.5321	15.5214	15.5321	114520.0
2013-05-16 17:30:00	AAPL	Stock	15.6117	15.6117	15.5189	15.5336	227500.0
2013-05-16 18:00:00	AAPL	Stock	15.5304	15.5336	15.525	15.5268	73192.0
2013-05-16 18:30:00	AAPL	Stock	15.5268	15.5268	15.5179	15.5179	68796.0
2013-05-16 19:00:00	AAPL	Stock	15.5214	15.5268	15.5186	15.5268	58436.0
2013-05-16 19:30:00	AAPL	Stock	15.5232	15.5329	15.5214	15.5318	87304.0
2013-05-16 04:00:00	MSFT	Stock	33.65	33.65	33.65	33.65	200.0
2013-05-16 04:30:00	MSFT	Stock	33.65	33.65	33.65	33.65	500.0
2013-05-16 05:00:00	MSFT	Stock	33.65	33.65	33.65	33.65	200.0
2013-05-16 07:30:00	MSFT	Stock	33.73	33.74	33.73	33.74	800.0
2013-05-16 08:00:00	MSFT	Stock	33.845	33.88	33.74	33.8	36774.0
2013-05-16 08:30:00	MSFT	Stock	33.8	33.8	33.76	33.8	10118.0
2013-05-16 09:00:00	MSFT	Stock	33.79	33.79	33.52	33.57	50560.0
2013-05-16 09:30:00	MSFT	Stock	33.58	34.1	33.55	34.097	8637409.0
2013-05-16 10:00:00	MSFT	Stock	34.09	34.095	33.95	34.05	4454544.0
2013-05-16 10:30:00	MSFT	Stock	34.06	34.14	34.02	34.03	2823765.0
2013-05-16 11:00:00	MSFT	Stock	34.035	34.11	34.02	34.065	3635890.0
2013-05-16 11:30:00	MSFT	Stock	34.06	34.13	34.05	34.075	2140683.0
2013-05-16 12:00:00	MSFT	Stock	34.075	34.14	34.05	34.1	2434044.0
2013-05-16 12:30:00	MSFT	Stock	34.095	34.11	34.06	34.08	1660992.0
2013-05-16 13:00:00	MSFT	Stock	34.085	34.09	34.03	34.065	2376931.0
2013-05-16 13:30:00	MSFT	Stock	34.06	34.07	34.015	34.05	2534014.0
2013-05-16 14:00:00	MSFT	Stock	34.045	34.15	34.04	34.1	2894240.0
2013-05-16 14:30:00	MSFT	Stock	34.09	34.1	34.04	34.07	2623694.0

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

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