PREVIEW / stock_30min / 2015-08-04

all stock 30-min files

  file:    by_date/stock_30min/2015/2015-08-04.parquet
  size:    1.6 MB
  rows:    80,870
  symbols: 3,458

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
2015-08-04 04:00:00	AAPL	Stock	29.375	29.5375	29.35	29.5	194480.0
2015-08-04 04:30:00	AAPL	Stock	29.535	29.5375	29.4875	29.4875	20976.0
2015-08-04 05:00:00	AAPL	Stock	29.5	29.5	29.5	29.5	39916.0
2015-08-04 05:30:00	AAPL	Stock	29.5	29.5375	29.5	29.5375	24972.0
2015-08-04 06:00:00	AAPL	Stock	29.525	29.5325	29.425	29.425	89268.0
2015-08-04 06:30:00	AAPL	Stock	29.4625	29.4675	29.4	29.4125	99880.0
2015-08-04 07:00:00	AAPL	Stock	29.4125	29.425	29.3825	29.3875	227000.0
2015-08-04 07:30:00	AAPL	Stock	29.3875	29.4	29.31	29.3525	337032.0
2015-08-04 08:00:00	AAPL	Stock	29.35	29.5125	29.3025	29.395	800968.0
2015-08-04 08:30:00	AAPL	Stock	29.3925	29.4225	29.2825	29.335	594176.0
2015-08-04 09:00:00	AAPL	Stock	29.35	29.47	29.2875	29.2875	970224.0
2015-08-04 09:30:00	AAPL	Stock	29.295	29.425	28.8775	28.9925	69966536.0
2015-08-04 10:00:00	AAPL	Stock	28.9958	29.0625	28.525	28.7175	70876216.0
2015-08-04 10:30:00	AAPL	Stock	28.71	28.7875	28.3125	28.4	62027700.0
2015-08-04 11:00:00	AAPL	Stock	28.4	28.7225	28.36	28.7172	46186632.0
2015-08-04 11:30:00	AAPL	Stock	28.7172	28.8025	28.65	28.7825	27940184.0
2015-08-04 12:00:00	AAPL	Stock	28.7815	28.87	28.5775	28.6028	23742988.0
2015-08-04 12:30:00	AAPL	Stock	28.6045	28.7025	28.5375	28.625	15019188.0
2015-08-04 13:00:00	AAPL	Stock	28.6275	28.76	28.6025	28.755	12805332.0
2015-08-04 13:30:00	AAPL	Stock	28.7525	28.85	28.6175	28.6775	18002272.0
2015-08-04 14:00:00	AAPL	Stock	28.68	28.8375	28.6675	28.8325	14442476.0
2015-08-04 14:30:00	AAPL	Stock	28.8325	28.91	28.7625	28.9042	18554560.0
2015-08-04 15:00:00	AAPL	Stock	28.905	28.9625	28.7	28.7125	22254456.0
2015-08-04 15:30:00	AAPL	Stock	28.7162	28.7675	28.54	28.6575	34870668.0
2015-08-04 16:00:00	AAPL	Stock	28.66	28.7662	28.5525	28.5825	6733940.0
2015-08-04 16:30:00	AAPL	Stock	28.585	28.595	28.56	28.575	194720.0
2015-08-04 17:00:00	AAPL	Stock	28.5625	28.826	28.5625	28.585	507692.0
2015-08-04 17:30:00	AAPL	Stock	28.5825	28.5975	28.5425	28.5425	197300.0
2015-08-04 18:00:00	AAPL	Stock	28.55	28.5632	28.52	28.55	129168.0
2015-08-04 18:30:00	AAPL	Stock	28.5475	28.575	28.5425	28.575	110596.0
2015-08-04 19:00:00	AAPL	Stock	28.575	28.575	28.52	28.53	163904.0
2015-08-04 19:30:00	AAPL	Stock	28.5275	28.5375	28.445	28.45	525324.0
2015-08-04 08:00:00	MSFT	Stock	46.79	46.79	46.79	46.79	1000.0
2015-08-04 08:30:00	MSFT	Stock	46.79	46.79	46.79	46.79	1000.0
2015-08-04 09:00:00	MSFT	Stock	46.79	46.8	46.75	46.75	2900.0
2015-08-04 09:30:00	MSFT	Stock	46.75	47.33	46.68	47.24	2982762.0
2015-08-04 10:00:00	MSFT	Stock	47.235	47.51	47.22	47.5	3040690.0
2015-08-04 10:30:00	MSFT	Stock	47.5	47.535	47.34	47.41	2574854.0
2015-08-04 11:00:00	MSFT	Stock	47.402	47.52	47.385	47.41	1876594.0
2015-08-04 11:30:00	MSFT	Stock	47.4	47.45	47.35	47.395	1202450.0
2015-08-04 12:00:00	MSFT	Stock	47.38	47.59	47.38	47.47	1779938.0
2015-08-04 12:30:00	MSFT	Stock	47.47	47.55	47.29	47.29	1065739.0
2015-08-04 13:00:00	MSFT	Stock	47.3	47.57	47.27	47.56	894509.0
2015-08-04 13:30:00	MSFT	Stock	47.57	47.63	47.38	47.39	1677659.0
2015-08-04 14:00:00	MSFT	Stock	47.38	47.46	47.31	47.435	1477762.0
2015-08-04 14:30:00	MSFT	Stock	47.44	47.67	47.4	47.662	1498616.0
2015-08-04 15:00:00	MSFT	Stock	47.67	47.71	47.58	47.61	2135749.0
2015-08-04 15:30:00	MSFT	Stock	47.61	47.68	47.53	47.55	5489214.0
2015-08-04 16:00:00	MSFT	Stock	47.55	48.3	46.81	47.478	2881592.0
2015-08-04 16:30:00	MSFT	Stock	47.6	47.6	47.59	47.59	1200.0

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

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