PREVIEW / stock_30min / 2016-03-17

all stock 30-min files

  file:    by_date/stock_30min/2016/2016-03-17.parquet
  size:    1.6 MB
  rows:    82,509
  symbols: 3,340

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
2016-03-17 04:00:00	AAPL	Stock	26.355	26.5375	26.355	26.49	17208.0
2016-03-17 04:30:00	AAPL	Stock	26.5175	26.5625	26.5175	26.525	23280.0
2016-03-17 05:00:00	AAPL	Stock	26.535	26.535	26.4575	26.4775	34492.0
2016-03-17 05:30:00	AAPL	Stock	26.485	26.485	26.425	26.425	21004.0
2016-03-17 06:00:00	AAPL	Stock	26.4325	26.4375	26.3025	26.3025	15980.0
2016-03-17 06:30:00	AAPL	Stock	26.3075	26.3625	26.3	26.3275	17720.0
2016-03-17 07:00:00	AAPL	Stock	26.37	26.39	26.3075	26.3125	59864.0
2016-03-17 07:30:00	AAPL	Stock	26.305	26.3375	26.26	26.3175	59476.0
2016-03-17 08:00:00	AAPL	Stock	26.35	26.55	26.28	26.33	690524.0
2016-03-17 08:30:00	AAPL	Stock	26.3175	26.3375	26.275	26.325	339832.0
2016-03-17 09:00:00	AAPL	Stock	26.3375	26.4	26.3125	26.38	780400.0
2016-03-17 09:30:00	AAPL	Stock	26.38	26.3975	26.24	26.295	20411496.0
2016-03-17 10:00:00	AAPL	Stock	26.295	26.43	26.2525	26.41	10502000.0
2016-03-17 10:30:00	AAPL	Stock	26.41	26.53	26.3838	26.4948	11180812.0
2016-03-17 11:00:00	AAPL	Stock	26.4935	26.5125	26.44	26.48	7080228.0
2016-03-17 11:30:00	AAPL	Stock	26.4825	26.56	26.475	26.5338	5582336.0
2016-03-17 12:00:00	AAPL	Stock	26.535	26.5925	26.4875	26.585	11039052.0
2016-03-17 12:30:00	AAPL	Stock	26.585	26.6175	26.5425	26.5425	5784476.0
2016-03-17 13:00:00	AAPL	Stock	26.54	26.5748	26.4875	26.495	5698020.0
2016-03-17 13:30:00	AAPL	Stock	26.495	26.5568	26.45	26.5075	4679480.0
2016-03-17 14:00:00	AAPL	Stock	26.505	26.545	26.4758	26.4862	5059580.0
2016-03-17 14:30:00	AAPL	Stock	26.4875	26.4975	26.4	26.4012	7208652.0
2016-03-17 15:00:00	AAPL	Stock	26.4	26.5	26.3925	26.4925	6288496.0
2016-03-17 15:30:00	AAPL	Stock	26.4925	26.5125	26.4375	26.45	10805828.0
2016-03-17 16:00:00	AAPL	Stock	26.4498	26.4725	26.282	26.455	8941796.0
2016-03-17 16:30:00	AAPL	Stock	26.45	26.4825	26.45	26.4825	40760.0
2016-03-17 17:00:00	AAPL	Stock	26.475	26.475	26.4475	26.455	547400.0
2016-03-17 17:30:00	AAPL	Stock	26.455	26.4625	26.455	26.455	2820.0
2016-03-17 18:00:00	AAPL	Stock	26.4625	26.4775	26.4625	26.475	13104.0
2016-03-17 18:30:00	AAPL	Stock	26.4775	26.495	26.4775	26.49	29316.0
2016-03-17 19:00:00	AAPL	Stock	26.4925	26.4925	26.48	26.48	2796.0
2016-03-17 19:30:00	AAPL	Stock	26.4875	26.5	26.48	26.5	44876.0
2016-03-17 04:30:00	MSFT	Stock	54.55	54.55	54.55	54.55	200.0
2016-03-17 05:30:00	MSFT	Stock	54.34	54.34	54.34	54.34	600.0
2016-03-17 06:30:00	MSFT	Stock	54.02	54.1	54.02	54.1	1000.0
2016-03-17 07:00:00	MSFT	Stock	54.1	54.1	54.1	54.1	100.0
2016-03-17 08:00:00	MSFT	Stock	54.0	54.05	54.0	54.05	261.0
2016-03-17 08:30:00	MSFT	Stock	54.09	54.22	54.09	54.2	2652.0
2016-03-17 09:00:00	MSFT	Stock	54.2	54.25	54.2	54.2	4715.0
2016-03-17 09:30:00	MSFT	Stock	54.2	54.46	54.0	54.375	2934529.0
2016-03-17 10:00:00	MSFT	Stock	54.37	54.51	54.24	54.455	1765095.0
2016-03-17 10:30:00	MSFT	Stock	54.45	54.72	54.315	54.68	1571233.0
2016-03-17 11:00:00	MSFT	Stock	54.68	54.8	54.585	54.595	1848512.0
2016-03-17 11:30:00	MSFT	Stock	54.6	54.82	54.57	54.81	1636834.0
2016-03-17 12:00:00	MSFT	Stock	54.82	54.9	54.72	54.9	1341114.0
2016-03-17 12:30:00	MSFT	Stock	54.89	55.0	54.89	54.95	1515190.0
2016-03-17 13:00:00	MSFT	Stock	54.96	54.965	54.62	54.62	982686.0
2016-03-17 13:30:00	MSFT	Stock	54.62	54.8	54.55	54.775	1030834.0
2016-03-17 14:00:00	MSFT	Stock	54.77	54.8	54.7	54.73	1153928.0
2016-03-17 14:30:00	MSFT	Stock	54.72	54.8	54.6	54.615	1388266.0

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

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