PREVIEW / stock_30min / 2015-06-26

all stock 30-min files

  file:    by_date/stock_30min/2015/2015-06-26.parquet
  size:    1.6 MB
  rows:    83,035
  symbols: 3,502

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-06-26 04:00:00	AAPL	Stock	31.94	31.94	31.9325	31.935	4800.0
2015-06-26 04:30:00	AAPL	Stock	31.9075	31.9125	31.9	31.9125	2404.0
2015-06-26 05:30:00	AAPL	Stock	31.9175	31.9175	31.9175	31.9175	400.0
2015-06-26 06:00:00	AAPL	Stock	31.915	31.925	31.9	31.9	7716.0
2015-06-26 06:30:00	AAPL	Stock	31.935	31.9375	31.935	31.9375	4720.0
2015-06-26 07:00:00	AAPL	Stock	31.93	31.9725	31.93	31.945	111260.0
2015-06-26 07:30:00	AAPL	Stock	31.95	31.9725	31.9325	31.9375	55352.0
2015-06-26 08:00:00	AAPL	Stock	31.935	31.975	31.825	31.8775	189020.0
2015-06-26 08:30:00	AAPL	Stock	31.885	31.895	31.855	31.89	229232.0
2015-06-26 09:00:00	AAPL	Stock	31.8875	31.9475	31.8675	31.9175	266064.0
2015-06-26 09:30:00	AAPL	Stock	31.9175	31.9975	31.73	31.975	21800388.0
2015-06-26 10:00:00	AAPL	Stock	31.975	31.995	31.805	31.8725	11352468.0
2015-06-26 10:30:00	AAPL	Stock	31.875	31.88	31.76	31.7675	8605904.0
2015-06-26 11:00:00	AAPL	Stock	31.7675	31.845	31.7575	31.775	6502080.0
2015-06-26 11:30:00	AAPL	Stock	31.7775	31.805	31.6925	31.7282	8066444.0
2015-06-26 12:00:00	AAPL	Stock	31.7298	31.77	31.6775	31.76	5866344.0
2015-06-26 12:30:00	AAPL	Stock	31.7575	31.7575	31.6425	31.65	7450312.0
2015-06-26 13:00:00	AAPL	Stock	31.6498	31.695	31.6275	31.692	8076660.0
2015-06-26 13:30:00	AAPL	Stock	31.69	31.755	31.6625	31.7025	5365556.0
2015-06-26 14:00:00	AAPL	Stock	31.7012	31.705	31.6275	31.6598	5245180.0
2015-06-26 14:30:00	AAPL	Stock	31.6588	31.715	31.65	31.69	5227728.0
2015-06-26 15:00:00	AAPL	Stock	31.69	31.7725	31.6825	31.7515	7480788.0
2015-06-26 15:30:00	AAPL	Stock	31.75	31.765	31.665	31.695	16474952.0
2015-06-26 16:00:00	AAPL	Stock	31.71	31.7475	31.6875	31.7125	26488184.0
2015-06-26 16:30:00	AAPL	Stock	31.7132	31.7325	31.6875	31.72	641572.0
2015-06-26 17:00:00	AAPL	Stock	31.72	31.7475	31.7175	31.7475	47040.0
2015-06-26 17:30:00	AAPL	Stock	31.7368	31.745	31.725	31.745	9780.0
2015-06-26 18:00:00	AAPL	Stock	31.7325	31.7425	31.725	31.74	36232.0
2015-06-26 18:30:00	AAPL	Stock	31.7275	31.73	31.7125	31.715	23504.0
2015-06-26 19:00:00	AAPL	Stock	31.7182	31.725	31.705	31.705	36744.0
2015-06-26 19:30:00	AAPL	Stock	31.705	31.7092	31.6925	31.695	143808.0
2015-06-26 04:00:00	MSFT	Stock	45.65	45.65	45.65	45.65	100.0
2015-06-26 04:30:00	MSFT	Stock	45.64	45.65	45.64	45.65	2222.0
2015-06-26 07:00:00	MSFT	Stock	45.58	45.58	45.57	45.58	2100.0
2015-06-26 07:30:00	MSFT	Stock	45.57	45.65	45.57	45.58	10900.0
2015-06-26 08:00:00	MSFT	Stock	45.57	45.6	45.47	45.47	9674.0
2015-06-26 08:30:00	MSFT	Stock	45.55	45.59	45.55	45.56	1018.0
2015-06-26 09:00:00	MSFT	Stock	45.583	45.78	45.52	45.76	27594.0
2015-06-26 09:30:00	MSFT	Stock	45.7	46.16	45.63	46.12	4076591.0
2015-06-26 10:00:00	MSFT	Stock	46.13	46.28	45.8	45.95	2696389.0
2015-06-26 10:30:00	MSFT	Stock	45.95	45.96	45.57	45.651	2204427.0
2015-06-26 11:00:00	MSFT	Stock	45.66	45.81	45.61	45.72	1368041.0
2015-06-26 11:30:00	MSFT	Stock	45.72	45.76	45.53	45.53	1163479.0
2015-06-26 12:00:00	MSFT	Stock	45.53	45.614	45.44	45.455	1226846.0
2015-06-26 12:30:00	MSFT	Stock	45.455	45.46	45.095	45.12	2478342.0
2015-06-26 13:00:00	MSFT	Stock	45.12	45.215	45.05	45.185	1798069.0
2015-06-26 13:30:00	MSFT	Stock	45.19	45.26	45.105	45.16	1166675.0
2015-06-26 14:00:00	MSFT	Stock	45.169	45.2	45.04	45.094	1436622.0
2015-06-26 14:30:00	MSFT	Stock	45.09	45.19	45.03	45.125	1626709.0
2015-06-26 15:00:00	MSFT	Stock	45.13	45.36	45.12	45.33	1849923.0

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

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