PREVIEW / stock_30min / 2014-02-03

all stock 30-min files

  file:    by_date/stock_30min/2014/2014-02-03.parquet
  size:    1.7 MB
  rows:    85,244
  symbols: 3,547

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-02-03 05:30:00	AAPL	Stock	17.8571	17.8571	17.8571	17.8571	2800.0
2014-02-03 06:00:00	AAPL	Stock	17.8089	17.8089	17.8089	17.8089	3388.0
2014-02-03 06:30:00	AAPL	Stock	17.8214	17.8571	17.8214	17.8482	78820.0
2014-02-03 07:00:00	AAPL	Stock	17.91	17.9361	17.91	17.9271	62720.0
2014-02-03 07:30:00	AAPL	Stock	17.9375	17.9429	17.8946	17.9429	170044.0
2014-02-03 08:00:00	AAPL	Stock	17.9321	18.035	17.8932	18.0089	1047284.0
2014-02-03 08:30:00	AAPL	Stock	18.0021	18.0089	17.9518	17.9654	671132.0
2014-02-03 09:00:00	AAPL	Stock	17.9646	17.9679	17.8786	17.9593	750624.0
2014-02-03 09:30:00	AAPL	Stock	17.9504	18.1332	17.9364	18.1182	59330152.0
2014-02-03 10:00:00	AAPL	Stock	18.1136	18.1186	17.9107	17.9843	41483708.0
2014-02-03 10:30:00	AAPL	Stock	17.9839	18.0411	17.9565	18.0182	21411964.0
2014-02-03 11:00:00	AAPL	Stock	18.0182	18.0357	17.9371	18.0054	14886788.0
2014-02-03 11:30:00	AAPL	Stock	18.0057	18.0393	17.9643	18.0014	14653324.0
2014-02-03 12:00:00	AAPL	Stock	17.9986	18.0061	17.9293	17.9807	13888000.0
2014-02-03 12:30:00	AAPL	Stock	17.9821	18.0036	17.9168	17.9232	14678888.0
2014-02-03 13:00:00	AAPL	Stock	17.9259	17.9425	17.8539	17.8889	21718424.0
2014-02-03 13:30:00	AAPL	Stock	17.8866	17.9346	17.8611	17.9062	15992592.0
2014-02-03 14:00:00	AAPL	Stock	17.9062	17.9375	17.8939	17.9125	10394496.0
2014-02-03 14:30:00	AAPL	Stock	17.9132	17.9139	17.8436	17.8436	16070712.0
2014-02-03 15:00:00	AAPL	Stock	17.8452	17.9204	17.8321	17.9121	18094496.0
2014-02-03 15:30:00	AAPL	Stock	17.9125	17.9282	17.8382	17.9154	32818128.0
2014-02-03 16:00:00	AAPL	Stock	17.9118	17.9624	17.8986	17.9068	22184484.0
2014-02-03 16:30:00	AAPL	Stock	17.9068	17.9925	17.8989	17.9136	1166984.0
2014-02-03 17:00:00	AAPL	Stock	17.9071	17.9118	17.9036	17.91	366240.0
2014-02-03 17:30:00	AAPL	Stock	17.9043	17.9418	17.9039	17.9343	169036.0
2014-02-03 18:00:00	AAPL	Stock	17.9346	17.9357	17.9118	17.9257	169456.0
2014-02-03 18:30:00	AAPL	Stock	17.925	17.9393	17.9118	17.9393	260820.0
2014-02-03 19:00:00	AAPL	Stock	17.9293	17.9443	17.9261	17.9357	103124.0
2014-02-03 19:30:00	AAPL	Stock	17.9357	17.9464	17.935	17.9464	146412.0
2014-02-03 06:00:00	MSFT	Stock	37.79	37.79	37.58	37.58	600.0
2014-02-03 07:00:00	MSFT	Stock	37.61	37.61	37.6	37.6	1100.0
2014-02-03 07:30:00	MSFT	Stock	37.75	37.75	37.75	37.75	300.0
2014-02-03 08:00:00	MSFT	Stock	37.71	37.75	37.54	37.63	13450.0
2014-02-03 08:30:00	MSFT	Stock	37.63	37.84	37.58	37.63	18948.0
2014-02-03 09:00:00	MSFT	Stock	37.63	37.85	37.62	37.73	57457.0
2014-02-03 09:30:00	MSFT	Stock	37.73	37.985	37.37	37.455	7257328.0
2014-02-03 10:00:00	MSFT	Stock	37.455	37.46	37.17	37.2	4970286.0
2014-02-03 10:30:00	MSFT	Stock	37.19	37.22	36.92	37.15	4344007.0
2014-02-03 11:00:00	MSFT	Stock	37.141	37.24	37.05	37.095	2945799.0
2014-02-03 11:30:00	MSFT	Stock	37.095	37.16	36.94	36.99	2552109.0
2014-02-03 12:00:00	MSFT	Stock	36.985	37.12	36.835	37.06	2626360.0
2014-02-03 12:30:00	MSFT	Stock	37.06	37.215	36.95	36.965	2194473.0
2014-02-03 13:00:00	MSFT	Stock	36.965	37.02	36.74	36.83	3607381.0
2014-02-03 13:30:00	MSFT	Stock	36.835	36.94	36.72	36.88	2665841.0
2014-02-03 14:00:00	MSFT	Stock	36.87	36.88	36.76	36.833	2351780.0
2014-02-03 14:30:00	MSFT	Stock	36.83	36.83	36.6	36.6	2714751.0
2014-02-03 15:00:00	MSFT	Stock	36.605	36.686	36.55	36.63	2969395.0
2014-02-03 15:30:00	MSFT	Stock	36.626	36.665	36.43	36.48	8723478.0
2014-02-03 16:00:00	MSFT	Stock	36.49	37.84	36.46	36.48	9514611.0
2014-02-03 16:30:00	MSFT	Stock	36.49	37.137	36.42	36.55	459062.0

> showing 50 of 85,244 rows — these rows as CSV

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