PREVIEW / stock_30min / 2014-10-08

all stock 30-min files

  file:    by_date/stock_30min/2014/2014-10-08.parquet
  size:    1.6 MB
  rows:    83,705
  symbols: 3,548

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-10-08 04:00:00	AAPL	Stock	24.6375	24.6375	24.63	24.63	1600.0
2014-10-08 04:30:00	AAPL	Stock	24.63	24.6325	24.5875	24.5875	9000.0
2014-10-08 05:00:00	AAPL	Stock	24.5975	24.6525	24.5625	24.575	23040.0
2014-10-08 05:30:00	AAPL	Stock	24.5775	24.6525	24.5725	24.64	26600.0
2014-10-08 06:00:00	AAPL	Stock	24.655	24.7	24.615	24.655	55920.0
2014-10-08 06:30:00	AAPL	Stock	24.6725	24.75	24.6725	24.7125	73008.0
2014-10-08 07:00:00	AAPL	Stock	24.7125	24.7775	24.675	24.775	74392.0
2014-10-08 07:30:00	AAPL	Stock	24.775	24.7775	24.75	24.765	31740.0
2014-10-08 08:00:00	AAPL	Stock	24.7625	24.795	24.6875	24.7725	171624.0
2014-10-08 08:30:00	AAPL	Stock	24.7675	24.7875	24.705	24.7225	307920.0
2014-10-08 09:00:00	AAPL	Stock	24.72	24.73	24.67	24.685	175500.0
2014-10-08 09:30:00	AAPL	Stock	24.69	24.84	24.6375	24.6375	22147812.0
2014-10-08 10:00:00	AAPL	Stock	24.64	24.7775	24.6025	24.7388	15132084.0
2014-10-08 10:30:00	AAPL	Stock	24.7375	24.7562	24.6075	24.625	11909880.0
2014-10-08 11:00:00	AAPL	Stock	24.625	24.795	24.5775	24.7812	11976108.0
2014-10-08 11:30:00	AAPL	Stock	24.78	24.8125	24.705	24.7825	7988508.0
2014-10-08 12:00:00	AAPL	Stock	24.7825	24.815	24.755	24.7575	8902372.0
2014-10-08 12:30:00	AAPL	Stock	24.7575	24.82	24.75	24.7975	5814148.0
2014-10-08 13:00:00	AAPL	Stock	24.8	24.845	24.7925	24.8025	5438628.0
2014-10-08 13:30:00	AAPL	Stock	24.805	24.8975	24.8042	24.8875	8542700.0
2014-10-08 14:00:00	AAPL	Stock	24.8875	25.0875	24.8862	25.0475	24606064.0
2014-10-08 14:30:00	AAPL	Stock	25.05	25.17	25.0478	25.1625	30301024.0
2014-10-08 15:00:00	AAPL	Stock	25.1625	25.2775	25.1525	25.259	25723904.0
2014-10-08 15:30:00	AAPL	Stock	25.2588	25.275	25.185	25.1935	28140160.0
2014-10-08 16:00:00	AAPL	Stock	25.2	25.2288	24.6908	25.19	10928688.0
2014-10-08 16:30:00	AAPL	Stock	25.2	25.2	25.18	25.2	363396.0
2014-10-08 17:00:00	AAPL	Stock	25.2	25.205	25.0422	25.1975	52040.0
2014-10-08 17:30:00	AAPL	Stock	25.1975	25.2	25.19	25.195	63984.0
2014-10-08 18:00:00	AAPL	Stock	25.1925	25.2	25.1825	25.1875	85636.0
2014-10-08 18:30:00	AAPL	Stock	25.1825	25.1875	25.1825	25.1825	23268.0
2014-10-08 19:00:00	AAPL	Stock	25.1875	25.2	25.1875	25.1875	67548.0
2014-10-08 19:30:00	AAPL	Stock	25.185	25.1975	25.1825	25.195	39732.0
2014-10-08 05:00:00	MSFT	Stock	45.42	45.42	45.42	45.42	1000.0
2014-10-08 06:00:00	MSFT	Stock	45.42	45.42	45.42	45.42	1700.0
2014-10-08 06:30:00	MSFT	Stock	45.42	45.42	45.42	45.42	2300.0
2014-10-08 07:30:00	MSFT	Stock	45.53	45.58	45.47	45.47	2053.0
2014-10-08 08:00:00	MSFT	Stock	45.45	45.5	45.45	45.46	1905.0
2014-10-08 08:30:00	MSFT	Stock	45.5	45.5	45.46	45.46	4749.0
2014-10-08 09:00:00	MSFT	Stock	45.45	45.45	45.38	45.38	28596.0
2014-10-08 09:30:00	MSFT	Stock	45.48	45.89	45.34	45.66	2590295.0
2014-10-08 10:00:00	MSFT	Stock	45.67	45.9	45.635	45.795	1580538.0
2014-10-08 10:30:00	MSFT	Stock	45.8	45.85	45.58	45.62	1598012.0
2014-10-08 11:00:00	MSFT	Stock	45.61	45.8	45.54	45.796	1394923.0
2014-10-08 11:30:00	MSFT	Stock	45.79	45.9	45.75	45.895	1004709.0
2014-10-08 12:00:00	MSFT	Stock	45.89	46.03	45.865	46.03	1287525.0
2014-10-08 12:30:00	MSFT	Stock	46.02	46.12	46.0	46.11	1352956.0
2014-10-08 13:00:00	MSFT	Stock	46.11	46.19	46.075	46.09	1067797.0
2014-10-08 13:30:00	MSFT	Stock	46.09	46.23	46.07	46.22	895549.0
2014-10-08 14:00:00	MSFT	Stock	46.215	46.65	46.21	46.585	3918428.0
2014-10-08 14:30:00	MSFT	Stock	46.59	46.68	46.49	46.586	2613427.0

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

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