PREVIEW / stock_30min / 2015-06-15

all stock 30-min files

  file:    by_date/stock_30min/2015/2015-06-15.parquet
  size:    1.6 MB
  rows:    83,845
  symbols: 3,513

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-06-15 04:00:00	AAPL	Stock	31.75	31.75	31.615	31.625	116396.0
2015-06-15 04:30:00	AAPL	Stock	31.625	31.65	31.625	31.625	12092.0
2015-06-15 05:00:00	AAPL	Stock	31.625	31.6375	31.625	31.6375	4720.0
2015-06-15 05:30:00	AAPL	Stock	31.6425	31.6425	31.6175	31.6175	29092.0
2015-06-15 06:00:00	AAPL	Stock	31.6175	31.625	31.6125	31.625	34200.0
2015-06-15 06:30:00	AAPL	Stock	31.625	31.655	31.625	31.6425	19636.0
2015-06-15 07:00:00	AAPL	Stock	31.64	31.64	31.595	31.595	34880.0
2015-06-15 07:30:00	AAPL	Stock	31.595	31.595	31.555	31.5675	69676.0
2015-06-15 08:00:00	AAPL	Stock	31.575	31.6475	31.5625	31.585	495300.0
2015-06-15 08:30:00	AAPL	Stock	31.5875	31.5875	31.5375	31.5825	473252.0
2015-06-15 09:00:00	AAPL	Stock	31.58	31.605	31.505	31.5275	846584.0
2015-06-15 09:30:00	AAPL	Stock	31.5275	31.635	31.4275	31.5625	28065148.0
2015-06-15 10:00:00	AAPL	Stock	31.565	31.6725	31.55	31.58	14973880.0
2015-06-15 10:30:00	AAPL	Stock	31.58	31.62	31.5225	31.5725	9155536.0
2015-06-15 11:00:00	AAPL	Stock	31.57	31.72	31.57	31.6538	11195016.0
2015-06-15 11:30:00	AAPL	Stock	31.6525	31.74	31.6325	31.7075	7019200.0
2015-06-15 12:00:00	AAPL	Stock	31.705	31.765	31.655	31.665	7550668.0
2015-06-15 12:30:00	AAPL	Stock	31.66	31.6875	31.5975	31.67	7839932.0
2015-06-15 13:00:00	AAPL	Stock	31.67	31.7	31.6475	31.6615	3593152.0
2015-06-15 13:30:00	AAPL	Stock	31.6625	31.7375	31.615	31.6825	6519592.0
2015-06-15 14:00:00	AAPL	Stock	31.68	31.81	31.68	31.7775	9195400.0
2015-06-15 14:30:00	AAPL	Stock	31.775	31.7875	31.7125	31.7325	5968000.0
2015-06-15 15:00:00	AAPL	Stock	31.73	31.74	31.6625	31.6825	7161852.0
2015-06-15 15:30:00	AAPL	Stock	31.6825	31.78	31.6738	31.7325	12632828.0
2015-06-15 16:00:00	AAPL	Stock	31.73	31.745	31.7028	31.735	8160876.0
2015-06-15 16:30:00	AAPL	Stock	31.73	31.74	31.7275	31.735	18280.0
2015-06-15 17:00:00	AAPL	Stock	31.7375	31.7425	31.7125	31.7125	23052.0
2015-06-15 17:30:00	AAPL	Stock	31.72	31.7342	31.71	31.7292	268464.0
2015-06-15 18:00:00	AAPL	Stock	31.7175	31.7275	31.7125	31.7275	42740.0
2015-06-15 18:30:00	AAPL	Stock	31.7275	31.7275	31.71	31.7175	9280.0
2015-06-15 19:00:00	AAPL	Stock	31.7125	31.7225	31.705	31.7225	10600.0
2015-06-15 19:30:00	AAPL	Stock	31.7075	31.7275	31.7075	31.7175	15772.0
2015-06-15 04:00:00	MSFT	Stock	45.96	45.96	45.76	45.76	2200.0
2015-06-15 07:30:00	MSFT	Stock	45.78	45.78	45.76	45.77	1380.0
2015-06-15 08:00:00	MSFT	Stock	45.76	45.76	45.74	45.75	1862.0
2015-06-15 08:30:00	MSFT	Stock	45.72	45.72	45.72	45.72	200.0
2015-06-15 09:00:00	MSFT	Stock	45.78	45.88	45.47	45.48	32381.0
2015-06-15 09:30:00	MSFT	Stock	45.48	45.53	45.02	45.08	5904033.0
2015-06-15 10:00:00	MSFT	Stock	45.08	45.27	45.08	45.23	2486185.0
2015-06-15 10:30:00	MSFT	Stock	45.24	45.4	45.2	45.236	2132685.0
2015-06-15 11:00:00	MSFT	Stock	45.24	45.41	45.22	45.225	1908111.0
2015-06-15 11:30:00	MSFT	Stock	45.23	45.44	45.225	45.32	1069996.0
2015-06-15 12:00:00	MSFT	Stock	45.32	45.34	45.2	45.21	1219388.0
2015-06-15 12:30:00	MSFT	Stock	45.21	45.46	45.21	45.46	882586.0
2015-06-15 13:00:00	MSFT	Stock	45.46	45.53	45.38	45.44	902106.0
2015-06-15 13:30:00	MSFT	Stock	45.44	45.65	45.41	45.47	1660267.0
2015-06-15 14:00:00	MSFT	Stock	45.47	45.57	45.4	45.5	932383.0
2015-06-15 14:30:00	MSFT	Stock	45.5	45.548	45.37	45.41	1121623.0
2015-06-15 15:00:00	MSFT	Stock	45.405	45.44	45.35	45.37	1372236.0
2015-06-15 15:30:00	MSFT	Stock	45.375	45.55	45.35	45.48	3348647.0

> showing 50 of 83,845 rows — these rows as CSV

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