PREVIEW / stock_30min / 2015-10-06

all stock 30-min files

  file:    by_date/stock_30min/2015/2015-10-06.parquet
  size:    1.6 MB
  rows:    81,356
  symbols: 3,427

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-10-06 04:00:00	AAPL	Stock	27.5825	27.585	27.4425	27.475	16720.0
2015-10-06 04:30:00	AAPL	Stock	27.475	27.535	27.475	27.535	2600.0
2015-10-06 05:00:00	AAPL	Stock	27.5375	27.545	27.5375	27.545	4404.0
2015-10-06 05:30:00	AAPL	Stock	27.5575	27.5575	27.5125	27.5125	9440.0
2015-10-06 06:00:00	AAPL	Stock	27.545	27.55	27.515	27.52	12064.0
2015-10-06 06:30:00	AAPL	Stock	27.56	27.565	27.5475	27.5475	49360.0
2015-10-06 07:00:00	AAPL	Stock	27.55	27.57	27.5025	27.5325	33612.0
2015-10-06 07:30:00	AAPL	Stock	27.5275	27.535	27.4525	27.535	50896.0
2015-10-06 08:00:00	AAPL	Stock	27.525	27.61	27.525	27.61	284424.0
2015-10-06 08:30:00	AAPL	Stock	27.61	27.6575	27.6075	27.64	201092.0
2015-10-06 09:00:00	AAPL	Stock	27.6475	27.685	27.6225	27.6425	116504.0
2015-10-06 09:30:00	AAPL	Stock	27.6575	27.8725	27.525	27.6	30842984.0
2015-10-06 10:00:00	AAPL	Stock	27.5995	27.6075	27.4412	27.525	18560280.0
2015-10-06 10:30:00	AAPL	Stock	27.5225	27.5725	27.45	27.5025	11971008.0
2015-10-06 11:00:00	AAPL	Stock	27.5002	27.65	27.495	27.64	11574772.0
2015-10-06 11:30:00	AAPL	Stock	27.64	27.7875	27.5075	27.7325	15791520.0
2015-10-06 12:00:00	AAPL	Stock	27.7322	27.805	27.7125	27.7875	10239944.0
2015-10-06 12:30:00	AAPL	Stock	27.7875	27.8238	27.67	27.75	9675796.0
2015-10-06 13:00:00	AAPL	Stock	27.75	27.91	27.7312	27.91	11449284.0
2015-10-06 13:30:00	AAPL	Stock	27.9102	27.935	27.81	27.865	9768504.0
2015-10-06 14:00:00	AAPL	Stock	27.8625	27.9175	27.7875	27.905	8731024.0
2015-10-06 14:30:00	AAPL	Stock	27.9025	27.9312	27.8075	27.84	8877324.0
2015-10-06 15:00:00	AAPL	Stock	27.8375	27.88	27.7825	27.8225	8692664.0
2015-10-06 15:30:00	AAPL	Stock	27.8225	27.885	27.7875	27.8325	16593576.0
2015-10-06 16:00:00	AAPL	Stock	27.8275	27.875	27.7	27.725	9367504.0
2015-10-06 16:30:00	AAPL	Stock	27.73	27.745	27.625	27.625	268716.0
2015-10-06 17:00:00	AAPL	Stock	27.6325	27.6325	27.5125	27.5625	278028.0
2015-10-06 17:30:00	AAPL	Stock	27.6075	27.6125	27.575	27.6125	45216.0
2015-10-06 18:00:00	AAPL	Stock	27.6125	27.625	27.6025	27.6225	33828.0
2015-10-06 18:30:00	AAPL	Stock	27.6225	27.6475	27.615	27.645	31048.0
2015-10-06 19:00:00	AAPL	Stock	27.6425	27.645	27.6275	27.6375	30600.0
2015-10-06 19:30:00	AAPL	Stock	27.6375	27.645	27.6375	27.6425	29868.0
2015-10-06 04:00:00	MSFT	Stock	46.26	46.26	46.26	46.26	900.0
2015-10-06 04:30:00	MSFT	Stock	46.26	46.26	46.26	46.26	100.0
2015-10-06 05:30:00	MSFT	Stock	46.4	46.4	46.4	46.4	100.0
2015-10-06 07:00:00	MSFT	Stock	46.42	46.42	46.4	46.4	1200.0
2015-10-06 08:00:00	MSFT	Stock	46.45	46.5	46.45	46.47	1400.0
2015-10-06 08:30:00	MSFT	Stock	46.45	46.53	46.4	46.48	6818.0
2015-10-06 09:00:00	MSFT	Stock	46.55	46.56	46.33	46.33	13610.0
2015-10-06 09:30:00	MSFT	Stock	46.35	46.56	46.22	46.52	2544051.0
2015-10-06 10:00:00	MSFT	Stock	46.516	46.73	46.38	46.67	1704838.0
2015-10-06 10:30:00	MSFT	Stock	46.66	46.92	46.624	46.816	1500109.0
2015-10-06 11:00:00	MSFT	Stock	46.81	47.15	46.804	47.15	1969866.0
2015-10-06 11:30:00	MSFT	Stock	47.15	47.175	46.95	47.0	1788050.0
2015-10-06 12:00:00	MSFT	Stock	47.0	47.04	46.78	46.915	1242106.0
2015-10-06 12:30:00	MSFT	Stock	46.917	46.99	46.84	46.894	1260176.0
2015-10-06 13:00:00	MSFT	Stock	46.89	46.98	46.81	46.91	984459.0
2015-10-06 13:30:00	MSFT	Stock	46.915	47.0	46.85	46.97	874982.0
2015-10-06 14:00:00	MSFT	Stock	46.97	47.07	46.9	47.029	1380704.0
2015-10-06 14:30:00	MSFT	Stock	47.02	47.03	46.805	46.86	1516106.0

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

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