PREVIEW / stock_30min / 2014-08-07

all stock 30-min files

  file:    by_date/stock_30min/2014/2014-08-07.parquet
  size:    1.6 MB
  rows:    81,328
  symbols: 3,562

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-07 04:00:00	AAPL	Stock	23.6525	23.705	23.6525	23.675	4224.0
2014-08-07 04:30:00	AAPL	Stock	23.745	23.745	23.745	23.745	404.0
2014-08-07 05:00:00	AAPL	Stock	23.7125	23.7125	23.7125	23.7125	9364.0
2014-08-07 05:30:00	AAPL	Stock	23.7125	23.735	23.7025	23.705	4400.0
2014-08-07 06:30:00	AAPL	Stock	23.72	23.72	23.6875	23.6925	17600.0
2014-08-07 07:00:00	AAPL	Stock	23.68	23.7325	23.68	23.7275	29300.0
2014-08-07 07:30:00	AAPL	Stock	23.7175	23.7175	23.6425	23.67	186712.0
2014-08-07 08:00:00	AAPL	Stock	23.675	23.745	23.6475	23.73	339968.0
2014-08-07 08:30:00	AAPL	Stock	23.7325	23.735	23.695	23.72	250816.0
2014-08-07 09:00:00	AAPL	Stock	23.7125	23.7325	23.7025	23.725	156600.0
2014-08-07 09:30:00	AAPL	Stock	23.7325	23.805	23.6775	23.8	20677204.0
2014-08-07 10:00:00	AAPL	Stock	23.7975	23.935	23.7475	23.9275	18178620.0
2014-08-07 10:30:00	AAPL	Stock	23.9252	23.9875	23.83	23.8688	17351384.0
2014-08-07 11:00:00	AAPL	Stock	23.8675	23.92	23.8325	23.8825	10789444.0
2014-08-07 11:30:00	AAPL	Stock	23.8825	23.93	23.7625	23.775	12857192.0
2014-08-07 12:00:00	AAPL	Stock	23.7775	23.8375	23.75	23.7725	8689316.0
2014-08-07 12:30:00	AAPL	Stock	23.77	23.77	23.6925	23.7262	10179296.0
2014-08-07 13:00:00	AAPL	Stock	23.7275	23.78	23.7238	23.765	5969896.0
2014-08-07 13:30:00	AAPL	Stock	23.7662	23.8225	23.75	23.815	5162488.0
2014-08-07 14:00:00	AAPL	Stock	23.8128	23.815	23.73	23.7388	5259192.0
2014-08-07 14:30:00	AAPL	Stock	23.7375	23.7425	23.685	23.6975	7652888.0
2014-08-07 15:00:00	AAPL	Stock	23.7	23.7275	23.525	23.5775	16386516.0
2014-08-07 15:30:00	AAPL	Stock	23.5798	23.6225	23.545	23.62	14721148.0
2014-08-07 16:00:00	AAPL	Stock	23.62	23.8818	23.6	23.615	9534712.0
2014-08-07 16:30:00	AAPL	Stock	23.6175	23.625	23.6175	23.62	475244.0
2014-08-07 17:00:00	AAPL	Stock	23.6175	23.6872	23.575	23.59	83144.0
2014-08-07 17:30:00	AAPL	Stock	23.59	23.62	23.575	23.5875	88032.0
2014-08-07 18:00:00	AAPL	Stock	23.5875	23.62	23.5575	23.57	180696.0
2014-08-07 18:30:00	AAPL	Stock	23.57	23.575	23.55	23.55	134612.0
2014-08-07 19:00:00	AAPL	Stock	23.55	23.565	23.55	23.55	82548.0
2014-08-07 19:30:00	AAPL	Stock	23.56	23.5625	23.5425	23.55	116600.0
2014-08-07 08:00:00	MSFT	Stock	42.97	42.97	42.97	42.97	350.0
2014-08-07 08:30:00	MSFT	Stock	42.86	42.86	42.8	42.8	7050.0
2014-08-07 09:00:00	MSFT	Stock	42.83	42.84	42.77	42.84	5700.0
2014-08-07 09:30:00	MSFT	Stock	42.84	43.39	42.65	43.31	4427273.0
2014-08-07 10:00:00	MSFT	Stock	43.31	43.43	43.17	43.285	2647777.0
2014-08-07 10:30:00	MSFT	Stock	43.28	43.33	43.07	43.26	2158203.0
2014-08-07 11:00:00	MSFT	Stock	43.26	43.27	43.05	43.17	2011056.0
2014-08-07 11:30:00	MSFT	Stock	43.17	43.295	43.11	43.215	1734339.0
2014-08-07 12:00:00	MSFT	Stock	43.21	43.25	43.15	43.205	1100003.0
2014-08-07 12:30:00	MSFT	Stock	43.2	43.25	43.06	43.22	1361007.0
2014-08-07 13:00:00	MSFT	Stock	43.22	43.315	43.195	43.26	1233282.0
2014-08-07 13:30:00	MSFT	Stock	43.26	43.45	43.25	43.41	1871655.0
2014-08-07 14:00:00	MSFT	Stock	43.41	43.44	43.29	43.345	1448413.0
2014-08-07 14:30:00	MSFT	Stock	43.33	43.35	43.24	43.246	1183516.0
2014-08-07 15:00:00	MSFT	Stock	43.25	43.34	43.09	43.17	3043860.0
2014-08-07 15:30:00	MSFT	Stock	43.164	43.31	43.11	43.23	3385694.0
2014-08-07 16:00:00	MSFT	Stock	43.23	43.297	43.1	43.21	1648050.0
2014-08-07 16:30:00	MSFT	Stock	43.23	43.23	43.23	43.23	146794.0
2014-08-07 17:00:00	MSFT	Stock	43.249	43.28	43.249	43.28	487.0

> showing 50 of 81,328 rows — these rows as CSV

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