PREVIEW / stock_30min / 2014-03-13

all stock 30-min files

  file:    by_date/stock_30min/2014/2014-03-13.parquet
  size:    1.6 MB
  rows:    83,064
  symbols: 3,538

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
2014-03-13 04:30:00	AAPL	Stock	19.1857	19.1857	19.1857	19.1857	14000.0
2014-03-13 05:00:00	AAPL	Stock	19.2061	19.2061	19.2061	19.2061	2800.0
2014-03-13 05:30:00	AAPL	Stock	19.1796	19.1796	19.1796	19.1796	2800.0
2014-03-13 07:00:00	AAPL	Stock	19.2	19.2343	19.2	19.2143	72800.0
2014-03-13 07:30:00	AAPL	Stock	19.2139	19.2357	19.2139	19.2236	79800.0
2014-03-13 08:00:00	AAPL	Stock	19.2064	19.2286	19.19	19.2143	326032.0
2014-03-13 08:30:00	AAPL	Stock	19.2143	19.2207	19.1964	19.2064	343224.0
2014-03-13 09:00:00	AAPL	Stock	19.2046	19.2107	19.1943	19.1961	340816.0
2014-03-13 09:30:00	AAPL	Stock	19.1907	19.2475	19.1089	19.2311	33584600.0
2014-03-13 10:00:00	AAPL	Stock	19.2307	19.2736	19.1996	19.2207	21943516.0
2014-03-13 10:30:00	AAPL	Stock	19.2225	19.2225	19.1361	19.1679	14400988.0
2014-03-13 11:00:00	AAPL	Stock	19.1707	19.185	19.1332	19.1382	9640260.0
2014-03-13 11:30:00	AAPL	Stock	19.1407	19.1429	19.0714	19.085	11962916.0
2014-03-13 12:00:00	AAPL	Stock	19.0864	19.0971	19.0379	19.0432	12562928.0
2014-03-13 12:30:00	AAPL	Stock	19.0436	19.0461	18.9736	18.985	17457384.0
2014-03-13 13:00:00	AAPL	Stock	18.9821	19.0071	18.9043	19.0014	23168852.0
2014-03-13 13:30:00	AAPL	Stock	19.0014	19.0168	18.9443	18.9736	10148236.0
2014-03-13 14:00:00	AAPL	Stock	18.9675	18.9904	18.9364	18.9471	8967476.0
2014-03-13 14:30:00	AAPL	Stock	18.9454	18.9907	18.9436	18.9558	9903936.0
2014-03-13 15:00:00	AAPL	Stock	18.9564	18.9779	18.8986	18.9457	14271544.0
2014-03-13 15:30:00	AAPL	Stock	18.9457	18.9682	18.925	18.9532	18283748.0
2014-03-13 16:00:00	AAPL	Stock	18.9518	19.1299	18.9196	19.1299	8953308.0
2014-03-13 16:30:00	AAPL	Stock	18.9286	19.0916	18.8929	18.915	555716.0
2014-03-13 17:00:00	AAPL	Stock	18.9161	18.9264	18.8412	18.9107	33768.0
2014-03-13 17:30:00	AAPL	Stock	18.9071	18.9143	18.8996	18.8996	73472.0
2014-03-13 18:00:00	AAPL	Stock	18.9	18.9	18.8875	18.8875	104300.0
2014-03-13 18:30:00	AAPL	Stock	18.9	18.9021	18.8889	18.8939	28560.0
2014-03-13 19:00:00	AAPL	Stock	18.9018	18.9118	18.8929	18.8946	70756.0
2014-03-13 19:30:00	AAPL	Stock	18.9025	18.9071	18.9021	18.9057	42672.0
2014-03-13 06:00:00	MSFT	Stock	38.29	38.29	38.29	38.29	930.0
2014-03-13 08:00:00	MSFT	Stock	38.38	38.38	38.27	38.27	704.0
2014-03-13 08:30:00	MSFT	Stock	38.38	38.38	38.38	38.38	3400.0
2014-03-13 09:00:00	MSFT	Stock	38.37	38.41	38.36	38.41	2821.0
2014-03-13 09:30:00	MSFT	Stock	38.42	38.45	38.3	38.33	2286624.0
2014-03-13 10:00:00	MSFT	Stock	38.34	38.38	38.27	38.335	1977459.0
2014-03-13 10:30:00	MSFT	Stock	38.335	38.35	38.14	38.2	2005503.0
2014-03-13 11:00:00	MSFT	Stock	38.195	38.21	38.12	38.14	2351803.0
2014-03-13 11:30:00	MSFT	Stock	38.14	38.15	38.01	38.095	1993775.0
2014-03-13 12:00:00	MSFT	Stock	38.095	38.11	37.912	37.955	1859344.0
2014-03-13 12:30:00	MSFT	Stock	37.956	38.01	37.82	37.88	2449233.0
2014-03-13 13:00:00	MSFT	Stock	37.88	37.889	37.69	37.86	2565560.0
2014-03-13 13:30:00	MSFT	Stock	37.87	37.9	37.7	37.744	1712497.0
2014-03-13 14:00:00	MSFT	Stock	37.74	37.83	37.641	37.82	2187864.0
2014-03-13 14:30:00	MSFT	Stock	37.82	37.92	37.75	37.83	1932756.0
2014-03-13 15:00:00	MSFT	Stock	37.83	37.89	37.73	37.785	2509900.0
2014-03-13 15:30:00	MSFT	Stock	37.79	37.91	37.75	37.91	3760179.0
2014-03-13 16:00:00	MSFT	Stock	37.89	37.953	37.81	37.9	1289800.0
2014-03-13 16:30:00	MSFT	Stock	37.9	37.9	37.89	37.89	33882.0
2014-03-13 17:00:00	MSFT	Stock	37.89	37.89	37.89	37.89	126.0
2014-03-13 17:30:00	MSFT	Stock	38.27	38.27	37.9	37.9	1600.0

> showing 50 of 83,064 rows — these rows as CSV

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