PREVIEW / stock_30min / 2014-12-29

all stock 30-min files

  file:    by_date/stock_30min/2014/2014-12-29.parquet
  size:    1.6 MB
  rows:    83,302
  symbols: 3,555

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-29 04:00:00	AAPL	Stock	28.55	28.55	28.4375	28.4375	30208.0
2014-12-29 04:30:00	AAPL	Stock	28.4875	28.525	28.45	28.4875	30892.0
2014-12-29 05:00:00	AAPL	Stock	28.5	28.53	28.4875	28.525	21312.0
2014-12-29 05:30:00	AAPL	Stock	28.4875	28.5	28.4625	28.4875	19952.0
2014-12-29 06:00:00	AAPL	Stock	28.5	28.5	28.4425	28.4425	6372.0
2014-12-29 06:30:00	AAPL	Stock	28.4425	28.4875	28.4425	28.475	10800.0
2014-12-29 07:00:00	AAPL	Stock	28.4925	28.5	28.4125	28.48	31672.0
2014-12-29 07:30:00	AAPL	Stock	28.4725	28.485	28.425	28.425	39220.0
2014-12-29 08:00:00	AAPL	Stock	28.4375	28.5	28.415	28.445	277476.0
2014-12-29 08:30:00	AAPL	Stock	28.4475	28.4575	28.4375	28.45	129856.0
2014-12-29 09:00:00	AAPL	Stock	28.455	28.475	28.425	28.445	277960.0
2014-12-29 09:30:00	AAPL	Stock	28.4475	28.685	28.425	28.595	22883748.0
2014-12-29 10:00:00	AAPL	Stock	28.5975	28.6025	28.53	28.53	8774860.0
2014-12-29 10:30:00	AAPL	Stock	28.53	28.6825	28.5275	28.674	8764464.0
2014-12-29 11:00:00	AAPL	Stock	28.6725	28.6925	28.635	28.6475	6362992.0
2014-12-29 11:30:00	AAPL	Stock	28.6475	28.6675	28.625	28.625	4158608.0
2014-12-29 12:00:00	AAPL	Stock	28.6262	28.6375	28.5875	28.595	4781036.0
2014-12-29 12:30:00	AAPL	Stock	28.5962	28.6325	28.5875	28.5925	4473836.0
2014-12-29 13:00:00	AAPL	Stock	28.5925	28.62	28.57	28.6025	3813972.0
2014-12-29 13:30:00	AAPL	Stock	28.6	28.6	28.5382	28.5525	5114180.0
2014-12-29 14:00:00	AAPL	Stock	28.5525	28.555	28.5275	28.55	4379620.0
2014-12-29 14:30:00	AAPL	Stock	28.55	28.56	28.4475	28.4538	6177316.0
2014-12-29 15:00:00	AAPL	Stock	28.4538	28.5	28.4375	28.49	5772776.0
2014-12-29 15:30:00	AAPL	Stock	28.49	28.5125	28.4625	28.48	9270592.0
2014-12-29 16:00:00	AAPL	Stock	28.4775	28.5655	28.4775	28.48	7428556.0
2014-12-29 16:30:00	AAPL	Stock	28.4825	28.5692	28.4775	28.4875	387028.0
2014-12-29 17:00:00	AAPL	Stock	28.4925	28.6288	28.4775	28.4775	170756.0
2014-12-29 17:30:00	AAPL	Stock	28.495	28.495	28.4875	28.49	23692.0
2014-12-29 18:00:00	AAPL	Stock	28.4775	28.495	28.4775	28.49	51580.0
2014-12-29 18:30:00	AAPL	Stock	28.495	28.5	28.495	28.495	19552.0
2014-12-29 19:00:00	AAPL	Stock	28.495	28.5	28.495	28.495	26876.0
2014-12-29 19:30:00	AAPL	Stock	28.495	28.5125	28.4925	28.5125	58340.0
2014-12-29 05:30:00	MSFT	Stock	47.84	47.84	47.76	47.76	600.0
2014-12-29 06:00:00	MSFT	Stock	47.7	47.7	47.7	47.7	100.0
2014-12-29 07:30:00	MSFT	Stock	47.7	47.7	47.7	47.7	170.0
2014-12-29 08:00:00	MSFT	Stock	47.69	47.69	47.57	47.57	1400.0
2014-12-29 08:30:00	MSFT	Stock	47.62	47.62	47.62	47.62	400.0
2014-12-29 09:00:00	MSFT	Stock	47.75	47.75	47.53	47.62	39474.0
2014-12-29 09:30:00	MSFT	Stock	47.7	47.78	47.41	47.505	2173772.0
2014-12-29 10:00:00	MSFT	Stock	47.52	47.55	47.26	47.3	1525146.0
2014-12-29 10:30:00	MSFT	Stock	47.3	47.52	47.291	47.45	1039951.0
2014-12-29 11:00:00	MSFT	Stock	47.44	47.57	47.43	47.57	759079.0
2014-12-29 11:30:00	MSFT	Stock	47.565	47.57	47.48	47.5	486489.0
2014-12-29 12:00:00	MSFT	Stock	47.505	47.545	47.47	47.48	627901.0
2014-12-29 12:30:00	MSFT	Stock	47.485	47.52	47.43	47.435	453326.0
2014-12-29 13:00:00	MSFT	Stock	47.435	47.52	47.43	47.495	339882.0
2014-12-29 13:30:00	MSFT	Stock	47.495	47.5	47.39	47.425	485296.0
2014-12-29 14:00:00	MSFT	Stock	47.425	47.45	47.39	47.445	434567.0
2014-12-29 14:30:00	MSFT	Stock	47.445	47.45	47.4	47.415	437251.0
2014-12-29 15:00:00	MSFT	Stock	47.415	47.44	47.36	47.4	873345.0

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

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