PREVIEW / stock_30min / 2014-09-08

all stock 30-min files

  file:    by_date/stock_30min/2014/2014-09-08.parquet
  size:    1.6 MB
  rows:    82,928
  symbols: 3,591

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-08 04:00:00	AAPL	Stock	24.8725	24.88	24.8375	24.845	5600.0
2014-09-08 04:30:00	AAPL	Stock	24.8375	24.86	24.8325	24.835	14648.0
2014-09-08 05:00:00	AAPL	Stock	24.8025	24.8425	24.8025	24.8375	4600.0
2014-09-08 05:30:00	AAPL	Stock	24.835	24.84	24.825	24.84	11972.0
2014-09-08 06:00:00	AAPL	Stock	24.8425	24.8425	24.8425	24.8425	400.0
2014-09-08 06:30:00	AAPL	Stock	24.8625	24.8625	24.8125	24.8475	6800.0
2014-09-08 07:00:00	AAPL	Stock	24.8475	24.865	24.815	24.855	76228.0
2014-09-08 07:30:00	AAPL	Stock	24.8625	24.865	24.8225	24.8225	195248.0
2014-09-08 08:00:00	AAPL	Stock	24.8225	24.9825	24.7425	24.7825	606692.0
2014-09-08 08:30:00	AAPL	Stock	24.7875	24.7975	24.775	24.7775	473060.0
2014-09-08 09:00:00	AAPL	Stock	24.78	24.8325	23.3368	24.825	711156.0
2014-09-08 09:30:00	AAPL	Stock	24.825	24.8275	24.6575	24.7375	33038852.0
2014-09-08 10:00:00	AAPL	Stock	24.735	24.7475	24.6625	24.7075	14864932.0
2014-09-08 10:30:00	AAPL	Stock	24.705	24.7425	24.66	24.734	11868900.0
2014-09-08 11:00:00	AAPL	Stock	24.734	24.775	24.72	24.7475	12828448.0
2014-09-08 11:30:00	AAPL	Stock	24.7468	24.75	24.6875	24.696	7158272.0
2014-09-08 12:00:00	AAPL	Stock	24.695	24.7087	24.6625	24.6825	6293124.0
2014-09-08 12:30:00	AAPL	Stock	24.6838	24.72	24.6625	24.6915	5975632.0
2014-09-08 13:00:00	AAPL	Stock	24.6915	24.7175	24.645	24.6475	8225732.0
2014-09-08 13:30:00	AAPL	Stock	24.6482	24.6575	24.5275	24.55	14287664.0
2014-09-08 14:00:00	AAPL	Stock	24.5475	24.565	24.5125	24.543	9656352.0
2014-09-08 14:30:00	AAPL	Stock	24.5425	24.595	24.5275	24.5812	8112240.0
2014-09-08 15:00:00	AAPL	Stock	24.5825	24.605	24.5375	24.5592	9878580.0
2014-09-08 15:30:00	AAPL	Stock	24.56	24.6	24.5575	24.585	19721168.0
2014-09-08 16:00:00	AAPL	Stock	24.59	24.657	24.5	24.6	7652796.0
2014-09-08 16:30:00	AAPL	Stock	24.6	24.7425	24.59	24.6125	698776.0
2014-09-08 17:00:00	AAPL	Stock	24.6125	24.6225	24.61	24.6175	147636.0
2014-09-08 17:30:00	AAPL	Stock	24.615	24.645	24.59	24.63	230356.0
2014-09-08 18:00:00	AAPL	Stock	24.63	24.6325	24.59	24.62	162464.0
2014-09-08 18:30:00	AAPL	Stock	24.6175	24.6375	24.6125	24.6375	97016.0
2014-09-08 19:00:00	AAPL	Stock	24.6375	24.645	24.6275	24.645	56292.0
2014-09-08 19:30:00	AAPL	Stock	24.645	24.645	24.6125	24.6125	115640.0
2014-09-08 04:00:00	MSFT	Stock	46.14	46.15	46.14	46.15	2500.0
2014-09-08 04:30:00	MSFT	Stock	46.15	46.15	46.15	46.15	100.0
2014-09-08 05:30:00	MSFT	Stock	46.09	46.09	46.07	46.07	984.0
2014-09-08 06:00:00	MSFT	Stock	46.07	46.18	46.05	46.18	3184.0
2014-09-08 07:00:00	MSFT	Stock	46.15	46.18	46.14	46.17	27040.0
2014-09-08 07:30:00	MSFT	Stock	46.18	46.28	46.18	46.28	30075.0
2014-09-08 08:00:00	MSFT	Stock	46.17	46.29	46.17	46.18	46040.0
2014-09-08 08:30:00	MSFT	Stock	46.18	46.21	46.13	46.18	70665.0
2014-09-08 09:00:00	MSFT	Stock	46.16	46.18	46.01	46.02	192270.0
2014-09-08 09:30:00	MSFT	Stock	46.02	46.75	45.99	46.665	9423133.0
2014-09-08 10:00:00	MSFT	Stock	46.67	46.8	46.53	46.65	5362340.0
2014-09-08 10:30:00	MSFT	Stock	46.64	46.65	46.47	46.54	3188339.0
2014-09-08 11:00:00	MSFT	Stock	46.54	46.555	46.45	46.495	2795855.0
2014-09-08 11:30:00	MSFT	Stock	46.495	46.51	46.38	46.459	1862651.0
2014-09-08 12:00:00	MSFT	Stock	46.45	46.55	46.45	46.52	1885104.0
2014-09-08 12:30:00	MSFT	Stock	46.52	46.55	46.475	46.539	1660977.0
2014-09-08 13:00:00	MSFT	Stock	46.54	46.55	46.45	46.475	2237080.0
2014-09-08 13:30:00	MSFT	Stock	46.47	46.5	46.39	46.39	2723417.0

> showing 50 of 82,928 rows — these rows as CSV

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