PREVIEW / stock_30min / 2014-08-12

all stock 30-min files

  file:    by_date/stock_30min/2014/2014-08-12.parquet
  size:    1.5 MB
  rows:    80,661
  symbols: 3,569

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-08-12 04:00:00	AAPL	Stock	24.0625	24.12	24.0625	24.12	3600.0
2014-08-12 04:30:00	AAPL	Stock	24.12	24.12	24.12	24.12	800.0
2014-08-12 05:00:00	AAPL	Stock	24.15	24.15	24.15	24.15	400.0
2014-08-12 05:30:00	AAPL	Stock	24.14	24.14	24.0875	24.0875	20136.0
2014-08-12 06:00:00	AAPL	Stock	24.08	24.115	24.075	24.0975	30656.0
2014-08-12 06:30:00	AAPL	Stock	24.1125	24.1425	24.1125	24.125	21604.0
2014-08-12 07:00:00	AAPL	Stock	24.1175	24.1225	24.08	24.08	45932.0
2014-08-12 07:30:00	AAPL	Stock	24.095	24.095	24.04	24.07	97768.0
2014-08-12 08:00:00	AAPL	Stock	24.07	24.12	24.0525	24.0725	313508.0
2014-08-12 08:30:00	AAPL	Stock	24.07	24.0725	24.0375	24.0575	188276.0
2014-08-12 09:00:00	AAPL	Stock	24.0575	24.0575	24.0075	24.0475	397204.0
2014-08-12 09:30:00	AAPL	Stock	24.01	24.22	24.01	24.15	26022556.0
2014-08-12 10:00:00	AAPL	Stock	24.1512	24.1725	24.075	24.145	12660604.0
2014-08-12 10:30:00	AAPL	Stock	24.145	24.15	24.06	24.0875	9581996.0
2014-08-12 11:00:00	AAPL	Stock	24.0875	24.09	23.975	24.045	12853508.0
2014-08-12 11:30:00	AAPL	Stock	24.045	24.095	24.03	24.0825	6113544.0
2014-08-12 12:00:00	AAPL	Stock	24.08	24.08	24.0	24.0075	5430412.0
2014-08-12 12:30:00	AAPL	Stock	24.005	24.0825	24.0025	24.02	4756420.0
2014-08-12 13:00:00	AAPL	Stock	24.0225	24.0565	24.0125	24.0512	4276244.0
2014-08-12 13:30:00	AAPL	Stock	24.051	24.0575	24.0162	24.0415	4396556.0
2014-08-12 14:00:00	AAPL	Stock	24.04	24.045	23.9575	23.9725	6394168.0
2014-08-12 14:30:00	AAPL	Stock	23.97	23.975	23.9025	23.9112	8149524.0
2014-08-12 15:00:00	AAPL	Stock	23.9112	23.9812	23.9102	23.9775	6404988.0
2014-08-12 15:30:00	AAPL	Stock	23.975	24.0425	23.96	23.9925	13649284.0
2014-08-12 16:00:00	AAPL	Stock	23.9925	24.2	23.9725	23.9725	4562128.0
2014-08-12 16:30:00	AAPL	Stock	23.9675	24.1732	23.9675	23.9825	328308.0
2014-08-12 17:00:00	AAPL	Stock	23.98	23.9925	23.96	23.9925	398680.0
2014-08-12 17:30:00	AAPL	Stock	23.9775	23.9925	23.975	23.9825	751596.0
2014-08-12 18:00:00	AAPL	Stock	23.9825	23.9925	23.9825	23.9925	20640.0
2014-08-12 18:30:00	AAPL	Stock	23.9925	23.9925	23.9775	23.9925	51228.0
2014-08-12 19:00:00	AAPL	Stock	23.99	23.995	23.9875	23.9925	19288.0
2014-08-12 19:30:00	AAPL	Stock	23.9975	23.9975	23.9875	23.9875	24560.0
2014-08-12 08:00:00	MSFT	Stock	43.2	43.2	43.2	43.2	100.0
2014-08-12 09:00:00	MSFT	Stock	43.22	43.22	43.11	43.11	3400.0
2014-08-12 09:30:00	MSFT	Stock	43.04	43.49	43.0	43.34	2903131.0
2014-08-12 10:00:00	MSFT	Stock	43.34	43.54	43.34	43.455	2312589.0
2014-08-12 10:30:00	MSFT	Stock	43.455	43.48	43.29	43.36	1179959.0
2014-08-12 11:00:00	MSFT	Stock	43.35	43.36	43.21	43.29	1446395.0
2014-08-12 11:30:00	MSFT	Stock	43.29	43.37	43.28	43.3	512338.0
2014-08-12 12:00:00	MSFT	Stock	43.3	43.37	43.25	43.33	687391.0
2014-08-12 12:30:00	MSFT	Stock	43.335	43.39	43.31	43.355	753611.0
2014-08-12 13:00:00	MSFT	Stock	43.35	43.48	43.345	43.465	750672.0
2014-08-12 13:30:00	MSFT	Stock	43.47	43.48	43.38	43.417	978357.0
2014-08-12 14:00:00	MSFT	Stock	43.417	43.45	43.31	43.39	1503732.0
2014-08-12 14:30:00	MSFT	Stock	43.38	43.48	43.33	43.39	846173.0
2014-08-12 15:00:00	MSFT	Stock	43.39	43.5	43.38	43.475	1209678.0
2014-08-12 15:30:00	MSFT	Stock	43.47	43.59	43.46	43.525	2737176.0
2014-08-12 16:00:00	MSFT	Stock	43.52	43.55	43.299	43.52	2477308.0
2014-08-12 16:30:00	MSFT	Stock	43.407	43.55	43.407	43.529	371586.0
2014-08-12 17:30:00	MSFT	Stock	43.52	43.52	43.52	43.52	7502.0

> showing 50 of 80,661 rows — these rows as CSV

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