PREVIEW / stock_30min / 2015-02-27

all stock 30-min files

  file:    by_date/stock_30min/2015/2015-02-27.parquet
  size:    1.7 MB
  rows:    84,587
  symbols: 3,517

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-02-27 04:00:00	AAPL	Stock	32.5975	32.6675	32.58	32.58	19280.0
2015-02-27 04:30:00	AAPL	Stock	32.57	32.6	32.5625	32.6	4400.0
2015-02-27 05:00:00	AAPL	Stock	32.62	32.62	32.59	32.62	3440.0
2015-02-27 05:30:00	AAPL	Stock	32.62	32.6225	32.6125	32.6225	7676.0
2015-02-27 06:00:00	AAPL	Stock	32.575	32.62	32.545	32.595	15240.0
2015-02-27 06:30:00	AAPL	Stock	32.5875	32.6325	32.585	32.63	14420.0
2015-02-27 07:00:00	AAPL	Stock	32.625	32.6325	32.6025	32.6125	68388.0
2015-02-27 07:30:00	AAPL	Stock	32.62	32.645	32.6075	32.645	64212.0
2015-02-27 08:00:00	AAPL	Stock	32.6375	32.6375	32.48	32.5325	533124.0
2015-02-27 08:30:00	AAPL	Stock	32.5275	32.56	32.5	32.52	227900.0
2015-02-27 09:00:00	AAPL	Stock	32.5275	32.55	32.46	32.505	601992.0
2015-02-27 09:30:00	AAPL	Stock	32.5	32.55	32.1475	32.475	38372892.0
2015-02-27 10:00:00	AAPL	Stock	32.475	32.6425	32.32	32.5375	27084952.0
2015-02-27 10:30:00	AAPL	Stock	32.536	32.57	32.4125	32.445	12912776.0
2015-02-27 11:00:00	AAPL	Stock	32.445	32.505	32.3775	32.403	11656264.0
2015-02-27 11:30:00	AAPL	Stock	32.4075	32.505	32.405	32.475	8167424.0
2015-02-27 12:00:00	AAPL	Stock	32.4775	32.5025	32.4525	32.4862	6845492.0
2015-02-27 12:30:00	AAPL	Stock	32.4875	32.5025	32.3925	32.4275	7307556.0
2015-02-27 13:00:00	AAPL	Stock	32.4252	32.4875	32.405	32.4382	7682616.0
2015-02-27 13:30:00	AAPL	Stock	32.4375	32.46	32.3625	32.4035	10140484.0
2015-02-27 14:00:00	AAPL	Stock	32.405	32.4075	32.225	32.245	11702908.0
2015-02-27 14:30:00	AAPL	Stock	32.2475	32.31	32.1925	32.2675	13602340.0
2015-02-27 15:00:00	AAPL	Stock	32.2675	32.2975	32.1825	32.24	12586488.0
2015-02-27 15:30:00	AAPL	Stock	32.24	32.245	32.06	32.1175	32254124.0
2015-02-27 16:00:00	AAPL	Stock	32.115	32.353	32.097	32.1325	32690228.0
2015-02-27 16:30:00	AAPL	Stock	32.1322	32.3795	32.115	32.125	549388.0
2015-02-27 17:00:00	AAPL	Stock	32.125	32.1275	32.1125	32.1125	535888.0
2015-02-27 17:30:00	AAPL	Stock	32.105	32.115	32.0925	32.0975	58192.0
2015-02-27 18:00:00	AAPL	Stock	32.0972	32.115	32.095	32.115	100400.0
2015-02-27 18:30:00	AAPL	Stock	32.1	32.11	32.0925	32.11	50948.0
2015-02-27 19:00:00	AAPL	Stock	32.11	32.11	32.1	32.1075	25008.0
2015-02-27 19:30:00	AAPL	Stock	32.105	32.1125	32.0975	32.1125	68464.0
2015-02-27 06:00:00	MSFT	Stock	44.0	44.0	44.0	44.0	900.0
2015-02-27 08:00:00	MSFT	Stock	44.0	44.04	44.0	44.0	3300.0
2015-02-27 08:30:00	MSFT	Stock	44.0	44.0	44.0	44.0	5022.0
2015-02-27 09:00:00	MSFT	Stock	44.0	44.22	43.95	44.16	51197.0
2015-02-27 09:30:00	MSFT	Stock	44.12	44.2	43.76	43.86	3521548.0
2015-02-27 10:00:00	MSFT	Stock	43.86	43.948	43.75	43.81	2783537.0
2015-02-27 10:30:00	MSFT	Stock	43.81	43.9	43.8	43.815	1183911.0
2015-02-27 11:00:00	MSFT	Stock	43.82	43.88	43.76	43.76	1810801.0
2015-02-27 11:30:00	MSFT	Stock	43.761	43.78	43.7	43.77	1256086.0
2015-02-27 12:00:00	MSFT	Stock	43.77	43.9	43.75	43.88	843624.0
2015-02-27 12:30:00	MSFT	Stock	43.88	43.89	43.8	43.814	766214.0
2015-02-27 13:00:00	MSFT	Stock	43.815	43.836	43.78	43.81	1315469.0
2015-02-27 13:30:00	MSFT	Stock	43.807	43.82	43.74	43.795	715257.0
2015-02-27 14:00:00	MSFT	Stock	43.8	43.82	43.75	43.81	1775189.0
2015-02-27 14:30:00	MSFT	Stock	43.82	43.82	43.71	43.755	1454926.0
2015-02-27 15:00:00	MSFT	Stock	43.76	43.785	43.66	43.765	2300931.0
2015-02-27 15:30:00	MSFT	Stock	43.77	43.89	43.72	43.84	5083519.0
2015-02-27 16:00:00	MSFT	Stock	43.85	43.88	43.68	43.82	7160263.0

> showing 50 of 84,587 rows — these rows as CSV

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