PREVIEW / stock_30min / 2013-03-18

all stock 30-min files

  file:    by_date/stock_30min/2013/2013-03-18.parquet
  size:    1.5 MB
  rows:    79,049
  symbols: 3,489

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-03-18 04:00:00	AAPL	Stock	15.8929	15.8929	15.6786	15.6786	42784.0
2013-03-18 05:00:00	AAPL	Stock	15.71	15.7143	15.71	15.7143	67088.0
2013-03-18 05:30:00	AAPL	Stock	15.7107	15.7143	15.7107	15.7143	22400.0
2013-03-18 06:00:00	AAPL	Stock	15.7146	15.7318	15.71	15.71	32200.0
2013-03-18 06:30:00	AAPL	Stock	15.71	15.7121	15.6964	15.6964	54908.0
2013-03-18 07:00:00	AAPL	Stock	15.6896	15.7571	15.6593	15.7214	470596.0
2013-03-18 07:30:00	AAPL	Stock	15.7218	15.7439	15.7061	15.7439	402948.0
2013-03-18 08:00:00	AAPL	Stock	15.7439	15.815	15.6696	15.7982	2137240.0
2013-03-18 08:30:00	AAPL	Stock	15.7921	15.8071	15.7725	15.7739	1587712.0
2013-03-18 09:00:00	AAPL	Stock	15.7786	15.7882	15.7521	15.7636	1400812.0
2013-03-18 09:30:00	AAPL	Stock	15.7671	15.9814	15.7571	15.92	95863796.0
2013-03-18 10:00:00	AAPL	Stock	15.9204	16.0554	15.8875	16.0454	50620528.0
2013-03-18 10:30:00	AAPL	Stock	16.0429	16.0607	15.9871	16.0464	34854092.0
2013-03-18 11:00:00	AAPL	Stock	16.0449	16.0621	16.0046	16.0057	23641856.0
2013-03-18 11:30:00	AAPL	Stock	16.0062	16.0854	16.0036	16.0843	25815468.0
2013-03-18 12:00:00	AAPL	Stock	16.0846	16.1707	16.0775	16.1118	47520256.0
2013-03-18 12:30:00	AAPL	Stock	16.1154	16.1511	16.0932	16.1304	22966496.0
2013-03-18 13:00:00	AAPL	Stock	16.1307	16.2107	16.12	16.2014	33166168.0
2013-03-18 13:30:00	AAPL	Stock	16.2039	16.2364	16.1821	16.2161	28423528.0
2013-03-18 14:00:00	AAPL	Stock	16.2174	16.2679	16.2107	16.2535	28893732.0
2013-03-18 14:30:00	AAPL	Stock	16.2532	16.3332	16.2482	16.2832	40799136.0
2013-03-18 15:00:00	AAPL	Stock	16.2821	16.3379	16.2693	16.2957	42949480.0
2013-03-18 15:30:00	AAPL	Stock	16.3012	16.3182	16.215	16.2757	80413004.0
2013-03-18 16:00:00	AAPL	Stock	16.2773	16.2982	16.0396	16.2696	15162084.0
2013-03-18 16:30:00	AAPL	Stock	16.2707	16.3009	15.9339	16.2646	687372.0
2013-03-18 17:00:00	AAPL	Stock	15.8518	16.2757	15.8518	16.2664	659120.0
2013-03-18 17:30:00	AAPL	Stock	16.2732	16.3036	16.2729	16.3036	1909852.0
2013-03-18 18:00:00	AAPL	Stock	16.3029	16.3029	16.2861	16.2961	3887940.0
2013-03-18 18:30:00	AAPL	Stock	16.2996	16.2996	16.2875	16.2882	157780.0
2013-03-18 19:00:00	AAPL	Stock	16.2921	16.3	16.2861	16.2882	133364.0
2013-03-18 19:30:00	AAPL	Stock	16.2921	16.2964	16.2868	16.2893	252700.0
2013-03-18 07:00:00	MSFT	Stock	27.79	27.79	27.76	27.76	3150.0
2013-03-18 07:30:00	MSFT	Stock	27.79	27.8	27.79	27.8	2220.0
2013-03-18 08:00:00	MSFT	Stock	27.84	27.87	27.75	27.8	5734.0
2013-03-18 08:30:00	MSFT	Stock	27.84	27.85	27.82	27.85	15749.0
2013-03-18 09:00:00	MSFT	Stock	27.85	27.89	27.8	27.88	460570.0
2013-03-18 09:30:00	MSFT	Stock	27.87	28.08	27.81	28.07	8061112.0
2013-03-18 10:00:00	MSFT	Stock	28.07	28.21	28.07	28.165	4320456.0
2013-03-18 10:30:00	MSFT	Stock	28.167	28.2	28.13	28.15	2334401.0
2013-03-18 11:00:00	MSFT	Stock	28.16	28.17	28.085	28.1	2881139.0
2013-03-18 11:30:00	MSFT	Stock	28.092	28.24	27.85	28.24	2455679.0
2013-03-18 12:00:00	MSFT	Stock	28.24	28.28	28.22	28.254	2007357.0
2013-03-18 12:30:00	MSFT	Stock	28.255	28.26	28.2	28.235	2267318.0
2013-03-18 13:00:00	MSFT	Stock	28.235	28.28	28.22	28.245	1201283.0
2013-03-18 13:30:00	MSFT	Stock	28.245	28.25	28.205	28.22	1563382.0
2013-03-18 14:00:00	MSFT	Stock	28.22	28.27	28.2	28.26	1672498.0
2013-03-18 14:30:00	MSFT	Stock	28.27	28.27	28.16	28.161	2136406.0
2013-03-18 15:00:00	MSFT	Stock	28.165	28.18	28.1	28.125	2600458.0
2013-03-18 15:30:00	MSFT	Stock	28.12	28.17	28.09	28.1	7223074.0
2013-03-18 16:00:00	MSFT	Stock	28.1	28.303	28.097	28.11	2901033.0

> showing 50 of 79,049 rows — these rows as CSV

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