PREVIEW / stock_30min / 2015-01-08

all stock 30-min files

  file:    by_date/stock_30min/2015/2015-01-08.parquet
  size:    1.6 MB
  rows:    84,588
  symbols: 3,534

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-01-08 04:00:00	AAPL	Stock	27.0475	27.2125	27.0475	27.1375	24312.0
2015-01-08 04:30:00	AAPL	Stock	27.1425	27.175	27.1425	27.175	7200.0
2015-01-08 05:00:00	AAPL	Stock	27.15	27.175	27.15	27.175	2400.0
2015-01-08 05:30:00	AAPL	Stock	27.1625	27.1925	27.1625	27.1925	15756.0
2015-01-08 06:00:00	AAPL	Stock	27.1925	27.27	27.1875	27.25	49484.0
2015-01-08 06:30:00	AAPL	Stock	27.25	27.275	27.215	27.275	60460.0
2015-01-08 07:00:00	AAPL	Stock	27.2625	27.2875	27.2275	27.24	146776.0
2015-01-08 07:30:00	AAPL	Stock	27.245	27.2625	27.23	27.2475	79116.0
2015-01-08 08:00:00	AAPL	Stock	27.2375	27.2875	27.0625	27.2525	509984.0
2015-01-08 08:30:00	AAPL	Stock	27.245	27.2625	27.2275	27.24	236308.0
2015-01-08 09:00:00	AAPL	Stock	27.245	27.35	26.9375	27.35	767900.0
2015-01-08 09:30:00	AAPL	Stock	27.3075	27.4725	27.175	27.4625	29531996.0
2015-01-08 10:00:00	AAPL	Stock	27.4625	27.6025	27.4475	27.5155	19599192.0
2015-01-08 10:30:00	AAPL	Stock	27.515	27.5805	27.45	27.5805	14654836.0
2015-01-08 11:00:00	AAPL	Stock	27.5825	27.6962	27.575	27.6912	16429292.0
2015-01-08 11:30:00	AAPL	Stock	27.6925	27.8825	27.67	27.8712	17393748.0
2015-01-08 12:00:00	AAPL	Stock	27.8712	27.9	27.7275	27.8125	13528372.0
2015-01-08 12:30:00	AAPL	Stock	27.8125	27.8725	27.81	27.8625	7789896.0
2015-01-08 13:00:00	AAPL	Stock	27.8612	27.99	27.8575	27.9775	12500716.0
2015-01-08 13:30:00	AAPL	Stock	27.98	28.0375	27.8675	27.9	16930448.0
2015-01-08 14:00:00	AAPL	Stock	27.9025	28.0175	27.8778	28.0152	10628832.0
2015-01-08 14:30:00	AAPL	Stock	28.015	28.025	27.965	27.985	9605732.0
2015-01-08 15:00:00	AAPL	Stock	27.985	28.02	27.9438	28.02	9934024.0
2015-01-08 15:30:00	AAPL	Stock	28.0198	28.0375	27.8925	27.9675	22492992.0
2015-01-08 16:00:00	AAPL	Stock	27.9725	28.0175	27.3545	28.0125	17719308.0
2015-01-08 16:30:00	AAPL	Stock	28.0125	28.0225	27.7668	28.0	842344.0
2015-01-08 17:00:00	AAPL	Stock	28.0	28.01	27.99	28.0	46724.0
2015-01-08 17:30:00	AAPL	Stock	28.0	28.0575	28.0	28.0325	244876.0
2015-01-08 18:00:00	AAPL	Stock	28.03	28.05	28.0175	28.0475	54196.0
2015-01-08 18:30:00	AAPL	Stock	28.0425	28.12	27.9725	28.12	251036.0
2015-01-08 19:00:00	AAPL	Stock	28.1225	28.1425	28.0775	28.1	119552.0
2015-01-08 19:30:00	AAPL	Stock	28.1	28.1125	28.0775	28.0875	62692.0
2015-01-08 04:30:00	MSFT	Stock	46.52	46.57	46.52	46.57	900.0
2015-01-08 05:00:00	MSFT	Stock	46.57	46.57	46.57	46.57	200.0
2015-01-08 06:00:00	MSFT	Stock	46.57	46.57	46.57	46.57	757.0
2015-01-08 06:30:00	MSFT	Stock	46.6	46.62	46.35	46.35	1535.0
2015-01-08 07:00:00	MSFT	Stock	46.55	46.67	46.55	46.64	2350.0
2015-01-08 07:30:00	MSFT	Stock	46.64	46.64	46.55	46.55	900.0
2015-01-08 08:00:00	MSFT	Stock	46.48	46.62	46.48	46.54	4321.0
2015-01-08 08:30:00	MSFT	Stock	46.55	46.58	46.54	46.56	3640.0
2015-01-08 09:00:00	MSFT	Stock	46.54	46.81	46.23	46.81	23397.0
2015-01-08 09:30:00	MSFT	Stock	46.75	47.42	46.72	47.37	3728324.0
2015-01-08 10:00:00	MSFT	Stock	47.37	47.47	47.32	47.4	2335223.0
2015-01-08 10:30:00	MSFT	Stock	47.405	47.635	47.4	47.63	2313537.0
2015-01-08 11:00:00	MSFT	Stock	47.64	47.75	47.43	47.45	2054959.0
2015-01-08 11:30:00	MSFT	Stock	47.45	47.56	47.44	47.47	1413070.0
2015-01-08 12:00:00	MSFT	Stock	47.47	47.535	47.38	47.53	935948.0
2015-01-08 12:30:00	MSFT	Stock	47.524	47.58	47.46	47.53	973935.0
2015-01-08 13:00:00	MSFT	Stock	47.53	47.625	47.48	47.57	1118906.0
2015-01-08 13:30:00	MSFT	Stock	47.57	47.66	47.5	47.599	1215260.0

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

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