PREVIEW / stock_30min / 2014-12-12

all stock 30-min files

  file:    by_date/stock_30min/2014/2014-12-12.parquet
  size:    1.6 MB
  rows:    85,144
  symbols: 3,550

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-12 04:00:00	AAPL	Stock	27.7775	27.7775	27.63	27.65	11252.0
2014-12-12 04:30:00	AAPL	Stock	27.655	27.7025	27.65	27.655	18772.0
2014-12-12 05:00:00	AAPL	Stock	27.6925	27.7	27.6625	27.675	3944.0
2014-12-12 05:30:00	AAPL	Stock	27.7	27.7025	27.675	27.675	16716.0
2014-12-12 06:00:00	AAPL	Stock	27.6525	27.6725	27.6375	27.645	57628.0
2014-12-12 06:30:00	AAPL	Stock	27.645	27.675	27.64	27.675	43256.0
2014-12-12 07:00:00	AAPL	Stock	27.6625	27.8	27.6625	27.7925	62420.0
2014-12-12 07:30:00	AAPL	Stock	27.8	27.8275	27.755	27.7825	114540.0
2014-12-12 08:00:00	AAPL	Stock	27.79	27.83	27.6325	27.6625	431668.0
2014-12-12 08:30:00	AAPL	Stock	27.6625	27.7625	27.655	27.7075	427820.0
2014-12-12 09:00:00	AAPL	Stock	27.7	27.7125	27.6025	27.625	606832.0
2014-12-12 09:30:00	AAPL	Stock	27.615	27.9675	27.57	27.8525	26212516.0
2014-12-12 10:00:00	AAPL	Stock	27.85	27.8825	27.615	27.735	16626628.0
2014-12-12 10:30:00	AAPL	Stock	27.735	27.7975	27.5725	27.5862	11955248.0
2014-12-12 11:00:00	AAPL	Stock	27.5875	27.6875	27.51	27.5225	14862300.0
2014-12-12 11:30:00	AAPL	Stock	27.5225	27.6825	27.5175	27.5575	13107356.0
2014-12-12 12:00:00	AAPL	Stock	27.5625	27.635	27.5275	27.625	9121224.0
2014-12-12 12:30:00	AAPL	Stock	27.62	27.6725	27.58	27.615	8130140.0
2014-12-12 13:00:00	AAPL	Stock	27.6125	27.85	27.5775	27.8325	11345624.0
2014-12-12 13:30:00	AAPL	Stock	27.8312	27.8525	27.6775	27.725	8841820.0
2014-12-12 14:00:00	AAPL	Stock	27.725	27.7575	27.575	27.5775	8879120.0
2014-12-12 14:30:00	AAPL	Stock	27.575	27.615	27.535	27.5625	8402568.0
2014-12-12 15:00:00	AAPL	Stock	27.5612	27.615	27.535	27.5525	10601920.0
2014-12-12 15:30:00	AAPL	Stock	27.5525	27.5575	27.395	27.43	38271560.0
2014-12-12 16:00:00	AAPL	Stock	27.4325	27.6338	27.4232	27.4325	15991304.0
2014-12-12 16:30:00	AAPL	Stock	27.4525	27.6538	27.425	27.4375	450828.0
2014-12-12 17:00:00	AAPL	Stock	27.4375	27.45	27.43	27.445	434828.0
2014-12-12 17:30:00	AAPL	Stock	27.445	27.445	27.415	27.42	108044.0
2014-12-12 18:00:00	AAPL	Stock	27.415	27.48	27.4125	27.48	289536.0
2014-12-12 18:30:00	AAPL	Stock	27.475	27.4825	27.465	27.4698	27776.0
2014-12-12 19:00:00	AAPL	Stock	27.465	27.47	27.4375	27.45	45548.0
2014-12-12 19:30:00	AAPL	Stock	27.4375	27.445	27.425	27.4375	80020.0
2014-12-12 04:00:00	MSFT	Stock	47.38	47.38	46.59	46.59	1900.0
2014-12-12 05:00:00	MSFT	Stock	46.72	46.72	46.72	46.72	300.0
2014-12-12 06:00:00	MSFT	Stock	46.71	46.75	46.71	46.75	1600.0
2014-12-12 06:30:00	MSFT	Stock	46.79	46.83	46.79	46.82	2500.0
2014-12-12 07:00:00	MSFT	Stock	46.8	46.88	46.8	46.88	3800.0
2014-12-12 07:30:00	MSFT	Stock	46.85	46.85	46.82	46.82	900.0
2014-12-12 08:00:00	MSFT	Stock	46.96	46.97	46.85	46.9	3300.0
2014-12-12 08:30:00	MSFT	Stock	46.84	46.91	46.84	46.86	9875.0
2014-12-12 09:00:00	MSFT	Stock	46.86	46.9	46.64	46.64	121173.0
2014-12-12 09:30:00	MSFT	Stock	46.78	47.73	46.67	47.64	4725389.0
2014-12-12 10:00:00	MSFT	Stock	47.64	47.675	47.33	47.555	2726649.0
2014-12-12 10:30:00	MSFT	Stock	47.56	47.67	47.23	47.26	1960860.0
2014-12-12 11:00:00	MSFT	Stock	47.26	47.38	47.12	47.2	1842924.0
2014-12-12 11:30:00	MSFT	Stock	47.2	47.37	47.14	47.2	1666584.0
2014-12-12 12:00:00	MSFT	Stock	47.2	47.363	47.15	47.36	1420724.0
2014-12-12 12:30:00	MSFT	Stock	47.345	47.395	47.23	47.255	711399.0
2014-12-12 13:00:00	MSFT	Stock	47.26	47.5	47.25	47.48	1252596.0
2014-12-12 13:30:00	MSFT	Stock	47.48	47.71	47.39	47.65	1393132.0

> showing 50 of 85,144 rows — these rows as CSV

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