PREVIEW / stock_30min / 2012-11-08

all stock 30-min files

  file:    by_date/stock_30min/2012/2012-11-08.parquet
  size:    1.4 MB
  rows:    75,646
  symbols: 3,460

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
2012-11-08 04:00:00	AAPL	Stock	20.0011	20.0011	20.0011	20.0011	2800.0
2012-11-08 05:00:00	AAPL	Stock	19.9736	20.0	19.9643	20.0	107184.0
2012-11-08 05:30:00	AAPL	Stock	19.9821	20.1082	19.9821	20.1071	228536.0
2012-11-08 06:00:00	AAPL	Stock	20.0932	20.0932	20.0821	20.0821	5600.0
2012-11-08 06:30:00	AAPL	Stock	20.0714	20.0893	20.0214	20.0214	111440.0
2012-11-08 07:00:00	AAPL	Stock	20.0357	20.0714	20.025	20.0571	222572.0
2012-11-08 07:30:00	AAPL	Stock	20.0604	20.1318	20.035	20.1036	847448.0
2012-11-08 08:00:00	AAPL	Stock	20.0886	20.1143	20.0636	20.1143	1816360.0
2012-11-08 08:30:00	AAPL	Stock	20.1114	20.1454	20.0786	20.1057	1583456.0
2012-11-08 09:00:00	AAPL	Stock	20.1071	20.1079	20.0143	20.0232	1576596.0
2012-11-08 09:30:00	AAPL	Stock	20.0225	20.0796	19.735	19.8493	123170544.0
2012-11-08 10:00:00	AAPL	Stock	19.8543	19.8743	19.3279	19.4911	167274408.0
2012-11-08 10:30:00	AAPL	Stock	19.4875	19.6393	19.4246	19.5796	109792564.0
2012-11-08 11:00:00	AAPL	Stock	19.5832	19.6332	19.4443	19.5368	67967256.0
2012-11-08 11:30:00	AAPL	Stock	19.535	19.7136	19.4536	19.7068	61156984.0
2012-11-08 12:00:00	AAPL	Stock	19.7136	19.7171	19.4821	19.4933	52499188.0
2012-11-08 12:30:00	AAPL	Stock	19.4968	19.5496	19.425	19.4957	41600048.0
2012-11-08 13:00:00	AAPL	Stock	19.4926	19.5268	19.3214	19.3411	50305332.0
2012-11-08 13:30:00	AAPL	Stock	19.3418	19.5339	19.3411	19.5154	48710984.0
2012-11-08 14:00:00	AAPL	Stock	19.5164	19.5314	19.35	19.3575	37025604.0
2012-11-08 14:30:00	AAPL	Stock	19.3639	19.435	19.2625	19.4168	63530712.0
2012-11-08 15:00:00	AAPL	Stock	19.4175	19.4175	19.29	19.3011	47764052.0
2012-11-08 15:30:00	AAPL	Stock	19.3032	19.3111	19.1175	19.2082	119560812.0
2012-11-08 16:00:00	AAPL	Stock	19.2016	19.9282	19.1793	19.2546	27110412.0
2012-11-08 16:30:00	AAPL	Stock	19.25	19.6772	19.1879	19.2532	1406412.0
2012-11-08 17:00:00	AAPL	Stock	19.2504	19.2604	19.2054	19.25	488292.0
2012-11-08 17:30:00	AAPL	Stock	19.2507	19.2675	19.2414	19.2518	570556.0
2012-11-08 18:00:00	AAPL	Stock	19.25	19.2607	19.2411	19.2411	196868.0
2012-11-08 18:30:00	AAPL	Stock	19.2343	19.2443	19.2132	19.2143	359828.0
2012-11-08 19:00:00	AAPL	Stock	19.2068	19.2339	19.2054	19.2179	462252.0
2012-11-08 19:30:00	AAPL	Stock	19.2243	19.2271	19.1946	19.2036	567308.0
2012-11-08 08:00:00	MSFT	Stock	29.26	29.26	29.16	29.25	32559.0
2012-11-08 08:30:00	MSFT	Stock	29.24	29.26	29.18	29.18	37002.0
2012-11-08 09:00:00	MSFT	Stock	29.18	29.22	29.12	29.15	124653.0
2012-11-08 09:30:00	MSFT	Stock	29.12	29.37	29.11	29.27	4476930.0
2012-11-08 10:00:00	MSFT	Stock	29.28	29.34	29.2	29.25	2593866.0
2012-11-08 10:30:00	MSFT	Stock	29.25	29.25	29.1	29.16	4059598.0
2012-11-08 11:00:00	MSFT	Stock	29.175	29.2	29.08	29.14	3485251.0
2012-11-08 11:30:00	MSFT	Stock	29.145	29.18	29.07	29.12	2533984.0
2012-11-08 12:00:00	MSFT	Stock	29.11	29.13	29.03	29.12	3737671.0
2012-11-08 12:30:00	MSFT	Stock	29.11	29.12	29.05	29.115	2349912.0
2012-11-08 13:00:00	MSFT	Stock	29.116	29.12	29.0	29.055	3191937.0
2012-11-08 13:30:00	MSFT	Stock	29.06	29.11	29.02	29.105	2713112.0
2012-11-08 14:00:00	MSFT	Stock	29.105	29.11	28.96	28.98	4572932.0
2012-11-08 14:30:00	MSFT	Stock	28.984	29.02	28.95	28.97	3040107.0
2012-11-08 15:00:00	MSFT	Stock	28.97	29.02	28.94	28.97	2482025.0
2012-11-08 15:30:00	MSFT	Stock	28.97	28.99	28.8	28.82	7397947.0
2012-11-08 16:00:00	MSFT	Stock	28.81	29.172	28.76	29.172	1779686.0
2012-11-08 16:30:00	MSFT	Stock	28.87	28.87	28.81	28.81	111257.0
2012-11-08 17:00:00	MSFT	Stock	28.83	28.87	28.83	28.85	1543.0

> showing 50 of 75,646 rows — these rows as CSV

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