PREVIEW / stock_30min / 2014-09-18

all stock 30-min files

  file:    by_date/stock_30min/2014/2014-09-18.parquet
  size:    1.6 MB
  rows:    83,645
  symbols: 3,582

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-09-18 04:00:00	AAPL	Stock	25.33	25.395	25.33	25.3325	5052.0
2014-09-18 04:30:00	AAPL	Stock	25.3575	25.405	25.3575	25.405	2396.0
2014-09-18 05:00:00	AAPL	Stock	25.4325	25.4375	25.4225	25.4375	11560.0
2014-09-18 05:30:00	AAPL	Stock	25.48	25.48	25.48	25.48	2024.0
2014-09-18 06:00:00	AAPL	Stock	25.4775	25.5475	25.4775	25.515	65216.0
2014-09-18 06:30:00	AAPL	Stock	25.515	25.5425	25.5075	25.5275	81360.0
2014-09-18 07:00:00	AAPL	Stock	25.5275	25.5725	25.5275	25.57	206628.0
2014-09-18 07:30:00	AAPL	Stock	25.57	25.6775	25.5675	25.575	427924.0
2014-09-18 08:00:00	AAPL	Stock	25.575	25.6325	25.515	25.5525	463992.0
2014-09-18 08:30:00	AAPL	Stock	25.5525	25.565	25.54	25.5525	220384.0
2014-09-18 09:00:00	AAPL	Stock	25.5525	25.61	25.4875	25.4925	815348.0
2014-09-18 09:30:00	AAPL	Stock	25.4875	25.5875	25.455	25.5338	24206592.0
2014-09-18 10:00:00	AAPL	Stock	25.5325	25.5475	25.4675	25.4975	13480252.0
2014-09-18 10:30:00	AAPL	Stock	25.4988	25.555	25.485	25.5197	11355380.0
2014-09-18 11:00:00	AAPL	Stock	25.5175	25.535	25.505	25.515	6632288.0
2014-09-18 11:30:00	AAPL	Stock	25.515	25.525	25.4875	25.5062	6019756.0
2014-09-18 12:00:00	AAPL	Stock	25.5075	25.5225	25.4925	25.51	5288860.0
2014-09-18 12:30:00	AAPL	Stock	25.5112	25.525	25.49	25.5052	4680116.0
2014-09-18 13:00:00	AAPL	Stock	25.5075	25.5225	25.4775	25.4875	5772696.0
2014-09-18 13:30:00	AAPL	Stock	25.4875	25.496	25.455	25.4828	7214476.0
2014-09-18 14:00:00	AAPL	Stock	25.4825	25.5175	25.48	25.4875	7016648.0
2014-09-18 14:30:00	AAPL	Stock	25.49	25.5	25.4675	25.4775	5925368.0
2014-09-18 15:00:00	AAPL	Stock	25.475	25.4825	25.39	25.45	12580512.0
2014-09-18 15:30:00	AAPL	Stock	25.45	25.4625	25.4125	25.446	16268132.0
2014-09-18 16:00:00	AAPL	Stock	25.4475	25.4975	25.395	25.4805	9540220.0
2014-09-18 16:30:00	AAPL	Stock	25.445	25.4625	25.445	25.46	326976.0
2014-09-18 17:00:00	AAPL	Stock	25.46	25.4625	25.4475	25.45	571292.0
2014-09-18 17:30:00	AAPL	Stock	25.45	25.45	25.445	25.4475	21552.0
2014-09-18 18:00:00	AAPL	Stock	25.445	25.4575	25.4375	25.45	147352.0
2014-09-18 18:30:00	AAPL	Stock	25.45	25.47	25.4475	25.46	1034928.0
2014-09-18 19:00:00	AAPL	Stock	25.46	25.4675	25.455	25.465	25308.0
2014-09-18 19:30:00	AAPL	Stock	25.4625	25.465	25.445	25.45	64768.0
2014-09-18 04:00:00	MSFT	Stock	46.52	46.52	46.52	46.52	100.0
2014-09-18 08:00:00	MSFT	Stock	46.635	46.7	46.635	46.69	979.0
2014-09-18 08:30:00	MSFT	Stock	46.65	46.69	46.65	46.67	1095.0
2014-09-18 09:00:00	MSFT	Stock	46.69	46.7	46.58	46.61	17763.0
2014-09-18 09:30:00	MSFT	Stock	46.6	46.63	46.46	46.61	3651015.0
2014-09-18 10:00:00	MSFT	Stock	46.61	46.62	46.51	46.525	2805944.0
2014-09-18 10:30:00	MSFT	Stock	46.523	46.6	46.51	46.55	1610973.0
2014-09-18 11:00:00	MSFT	Stock	46.56	46.58	46.55	46.577	1377200.0
2014-09-18 11:30:00	MSFT	Stock	46.58	46.6	46.51	46.53	1883701.0
2014-09-18 12:00:00	MSFT	Stock	46.53	46.54	46.5	46.53	1285412.0
2014-09-18 12:30:00	MSFT	Stock	46.53	46.63	46.52	46.59	1570954.0
2014-09-18 13:00:00	MSFT	Stock	46.595	46.6	46.54	46.59	1098088.0
2014-09-18 13:30:00	MSFT	Stock	46.59	46.63	46.56	46.595	1921304.0
2014-09-18 14:00:00	MSFT	Stock	46.599	46.74	46.59	46.725	1762629.0
2014-09-18 14:30:00	MSFT	Stock	46.73	46.81	46.72	46.8	1771054.0
2014-09-18 15:00:00	MSFT	Stock	46.8	46.83	46.74	46.749	2818999.0
2014-09-18 15:30:00	MSFT	Stock	46.75	46.78	46.66	46.68	6215517.0
2014-09-18 16:00:00	MSFT	Stock	46.68	46.72	46.4	46.698	4537338.0

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

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