PREVIEW / stock_30min / 2013-09-27

all stock 30-min files

  file:    by_date/stock_30min/2013/2013-09-27.parquet
  size:    1.5 MB
  rows:    79,192
  symbols: 3,523

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-09-27 04:00:00	AAPL	Stock	17.3846	17.3846	17.3846	17.3846	2800.0
2013-09-27 05:00:00	AAPL	Stock	17.3714	17.3807	17.3643	17.3807	14000.0
2013-09-27 06:30:00	AAPL	Stock	17.3393	17.3489	17.3221	17.3393	30800.0
2013-09-27 07:00:00	AAPL	Stock	17.3375	17.3679	17.3375	17.3393	211736.0
2013-09-27 07:30:00	AAPL	Stock	17.3214	17.3275	17.2932	17.3275	200732.0
2013-09-27 08:00:00	AAPL	Stock	17.3279	17.3786	17.2714	17.2896	1105384.0
2013-09-27 08:30:00	AAPL	Stock	17.2979	17.3211	17.2857	17.3075	516236.0
2013-09-27 09:00:00	AAPL	Stock	17.3139	17.365	17.2686	17.2768	1454712.0
2013-09-27 09:30:00	AAPL	Stock	17.2779	17.3096	17.1955	17.2339	41195588.0
2013-09-27 10:00:00	AAPL	Stock	17.2339	17.2943	17.2111	17.2625	22786960.0
2013-09-27 10:30:00	AAPL	Stock	17.2671	17.2714	17.225	17.2396	13170724.0
2013-09-27 11:00:00	AAPL	Stock	17.2396	17.2532	17.2164	17.2365	10140648.0
2013-09-27 11:30:00	AAPL	Stock	17.2379	17.2454	17.2129	17.2171	8534764.0
2013-09-27 12:00:00	AAPL	Stock	17.2168	17.2643	17.2129	17.2455	10146248.0
2013-09-27 12:30:00	AAPL	Stock	17.2443	17.255	17.2368	17.2475	6161652.0
2013-09-27 13:00:00	AAPL	Stock	17.2471	17.2618	17.2304	17.2382	7512820.0
2013-09-27 13:30:00	AAPL	Stock	17.2386	17.2511	17.2229	17.2293	5963412.0
2013-09-27 14:00:00	AAPL	Stock	17.2311	17.2311	17.19	17.2046	12992280.0
2013-09-27 14:30:00	AAPL	Stock	17.2046	17.2189	17.1839	17.1865	8937796.0
2013-09-27 15:00:00	AAPL	Stock	17.1843	17.205	17.1686	17.2046	14869008.0
2013-09-27 15:30:00	AAPL	Stock	17.2014	17.2407	17.2011	17.24	28597212.0
2013-09-27 16:00:00	AAPL	Stock	17.2379	17.2539	17.2286	17.2411	13151992.0
2013-09-27 16:30:00	AAPL	Stock	17.2479	17.25	17.2224	17.2446	355796.0
2013-09-27 17:00:00	AAPL	Stock	17.2429	17.2489	17.2411	17.2489	617092.0
2013-09-27 17:30:00	AAPL	Stock	17.2464	17.2479	17.2464	17.2464	28000.0
2013-09-27 18:00:00	AAPL	Stock	17.2411	17.2454	17.2411	17.2446	134428.0
2013-09-27 18:30:00	AAPL	Stock	17.2436	17.2479	17.2404	17.2464	31556.0
2013-09-27 19:00:00	AAPL	Stock	17.2432	17.2475	17.2425	17.2446	88788.0
2013-09-27 19:30:00	AAPL	Stock	17.2464	17.25	17.2446	17.2464	85932.0
2013-09-27 05:00:00	MSFT	Stock	32.93	32.93	32.93	32.93	100.0
2013-09-27 05:30:00	MSFT	Stock	32.89	32.89	32.86	32.86	300.0
2013-09-27 06:00:00	MSFT	Stock	32.86	32.93	32.86	32.93	2200.0
2013-09-27 07:30:00	MSFT	Stock	32.92	32.93	32.92	32.93	1900.0
2013-09-27 08:00:00	MSFT	Stock	32.93	33.04	32.93	32.93	15999.0
2013-09-27 08:30:00	MSFT	Stock	32.99	32.99	32.92	32.95	9490.0
2013-09-27 09:00:00	MSFT	Stock	32.92	33.1	32.77	32.89	542070.0
2013-09-27 09:30:00	MSFT	Stock	32.88	33.25	32.87	33.12	7467282.0
2013-09-27 10:00:00	MSFT	Stock	33.12	33.31	33.08	33.26	4512136.0
2013-09-27 10:30:00	MSFT	Stock	33.25	33.65	33.24	33.59	7227091.0
2013-09-27 11:00:00	MSFT	Stock	33.583	33.6	33.46	33.52	4117480.0
2013-09-27 11:30:00	MSFT	Stock	33.52	33.73	33.51	33.715	4262958.0
2013-09-27 12:00:00	MSFT	Stock	33.71	33.75	33.68	33.74	2554016.0
2013-09-27 12:30:00	MSFT	Stock	33.74	33.75	33.64	33.66	2702984.0
2013-09-27 13:00:00	MSFT	Stock	33.655	33.68	33.46	33.463	2536068.0
2013-09-27 13:30:00	MSFT	Stock	33.47	33.54	33.44	33.45	1781796.0
2013-09-27 14:00:00	MSFT	Stock	33.44	33.45	33.28	33.36	1967247.0
2013-09-27 14:30:00	MSFT	Stock	33.36	33.45	33.33	33.4	1331036.0
2013-09-27 15:00:00	MSFT	Stock	33.4	33.405	33.22	33.275	2373092.0
2013-09-27 15:30:00	MSFT	Stock	33.28	33.39	33.23	33.29	6201052.0
2013-09-27 16:00:00	MSFT	Stock	33.29	33.43	33.06	33.28	2203975.0

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

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