PREVIEW / stock_30min / 2014-12-26

all stock 30-min files

  file:    by_date/stock_30min/2014/2014-12-26.parquet
  size:    1.5 MB
  rows:    80,241
  symbols: 3,508

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-12-26 07:00:00	AAPL	Stock	28.0875	28.0925	28.0875	28.0925	2800.0
2014-12-26 07:30:00	AAPL	Stock	28.0925	28.1075	28.0925	28.095	8808.0
2014-12-26 08:00:00	AAPL	Stock	28.09	28.0925	28.035	28.075	86864.0
2014-12-26 08:30:00	AAPL	Stock	28.075	28.0825	28.0625	28.07	32380.0
2014-12-26 09:00:00	AAPL	Stock	28.07	28.0775	28.0125	28.0225	62400.0
2014-12-26 09:30:00	AAPL	Stock	28.015	28.1975	28.0025	28.145	11119404.0
2014-12-26 10:00:00	AAPL	Stock	28.1425	28.18	28.125	28.16	6118096.0
2014-12-26 10:30:00	AAPL	Stock	28.16	28.2425	28.1562	28.21	6750244.0
2014-12-26 11:00:00	AAPL	Stock	28.2102	28.2775	28.19	28.2725	6955508.0
2014-12-26 11:30:00	AAPL	Stock	28.2725	28.3	28.23	28.25	6698920.0
2014-12-26 12:00:00	AAPL	Stock	28.2475	28.3	28.2275	28.3	4988380.0
2014-12-26 12:30:00	AAPL	Stock	28.2975	28.3625	28.265	28.36	6442664.0
2014-12-26 13:00:00	AAPL	Stock	28.36	28.4775	28.3575	28.455	10860516.0
2014-12-26 13:30:00	AAPL	Stock	28.455	28.485	28.415	28.4825	6981924.0
2014-12-26 14:00:00	AAPL	Stock	28.4825	28.56	28.4775	28.525	11213960.0
2014-12-26 14:30:00	AAPL	Stock	28.5262	28.5925	28.4925	28.585	7531544.0
2014-12-26 15:00:00	AAPL	Stock	28.585	28.63	28.5225	28.565	11598864.0
2014-12-26 15:30:00	AAPL	Stock	28.5675	28.58	28.4875	28.495	15325788.0
2014-12-26 16:00:00	AAPL	Stock	28.4975	28.515	28.0512	28.5025	14612520.0
2014-12-26 16:30:00	AAPL	Stock	28.5025	28.51	28.2385	28.5025	485544.0
2014-12-26 17:00:00	AAPL	Stock	28.5025	28.5075	28.5025	28.505	44104.0
2014-12-26 17:30:00	AAPL	Stock	28.505	28.52	28.505	28.51	51608.0
2014-12-26 18:00:00	AAPL	Stock	28.51	28.535	28.505	28.535	40736.0
2014-12-26 18:30:00	AAPL	Stock	28.5125	28.5325	28.5125	28.52	11228.0
2014-12-26 19:00:00	AAPL	Stock	28.53	28.53	28.5175	28.5175	4400.0
2014-12-26 19:30:00	AAPL	Stock	28.5225	28.535	28.5125	28.535	40764.0
2014-12-26 09:00:00	MSFT	Stock	48.12	48.45	48.12	48.31	8400.0
2014-12-26 09:30:00	MSFT	Stock	48.41	48.41	48.0	48.007	1480150.0
2014-12-26 10:00:00	MSFT	Stock	48.01	48.1	47.95	48.03	641656.0
2014-12-26 10:30:00	MSFT	Stock	48.025	48.03	47.91	47.99	501975.0
2014-12-26 11:00:00	MSFT	Stock	47.99	47.996	47.87	47.89	570839.0
2014-12-26 11:30:00	MSFT	Stock	47.89	48.01	47.89	47.96	446733.0
2014-12-26 12:00:00	MSFT	Stock	47.965	48.08	47.96	47.99	580523.0
2014-12-26 12:30:00	MSFT	Stock	47.99	48.0	47.88	47.89	472119.0
2014-12-26 13:00:00	MSFT	Stock	47.89	47.98	47.88	47.935	365643.0
2014-12-26 13:30:00	MSFT	Stock	47.94	48.0	47.925	47.944	401255.0
2014-12-26 14:00:00	MSFT	Stock	47.95	48.0	47.92	47.99	416123.0
2014-12-26 14:30:00	MSFT	Stock	47.985	48.03	47.93	47.94	681161.0
2014-12-26 15:00:00	MSFT	Stock	47.94	47.96	47.89	47.92	723207.0
2014-12-26 15:30:00	MSFT	Stock	47.92	47.96	47.82	47.87	1756472.0
2014-12-26 16:00:00	MSFT	Stock	47.88	47.989	47.88	47.88	3745470.0
2014-12-26 16:30:00	MSFT	Stock	47.83	47.988	47.81	47.988	8682.0
2014-12-26 17:00:00	MSFT	Stock	47.88	47.9	47.88	47.9	13557.0
2014-12-26 18:00:00	MSFT	Stock	47.9	47.91	47.9	47.91	600.0
2014-12-26 09:30:00	NVDA	Stock	0.5142	0.5175	0.5133	0.5145	5424160.0
2014-12-26 10:00:00	NVDA	Stock	0.5142	0.5148	0.5133	0.5145	3334480.0
2014-12-26 10:30:00	NVDA	Stock	0.5145	0.5152	0.513	0.5133	4585840.0
2014-12-26 11:00:00	NVDA	Stock	0.5135	0.5145	0.5133	0.5144	1959360.0
2014-12-26 11:30:00	NVDA	Stock	0.5142	0.5155	0.514	0.5152	2773120.0
2014-12-26 12:00:00	NVDA	Stock	0.5155	0.516	0.5152	0.5158	1493640.0

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

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