PREVIEW / stock_30min / 2015-01-06

all stock 30-min files

  file:    by_date/stock_30min/2015/2015-01-06.parquet
  size:    1.6 MB
  rows:    84,032
  symbols: 3,546

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-06 04:00:00	AAPL	Stock	26.5	26.55	26.5	26.55	17320.0
2015-01-06 04:30:00	AAPL	Stock	26.525	26.55	26.5	26.5	12312.0
2015-01-06 05:00:00	AAPL	Stock	26.5	26.5	26.4625	26.4625	5060.0
2015-01-06 05:30:00	AAPL	Stock	26.5	26.5125	26.5	26.5	8240.0
2015-01-06 06:00:00	AAPL	Stock	26.5	26.625	26.5	26.6225	19624.0
2015-01-06 06:30:00	AAPL	Stock	26.67	26.75	26.67	26.7475	17008.0
2015-01-06 07:00:00	AAPL	Stock	26.73	26.805	26.6975	26.7	68016.0
2015-01-06 07:30:00	AAPL	Stock	26.7175	26.7375	26.675	26.6875	50628.0
2015-01-06 08:00:00	AAPL	Stock	26.6975	26.7525	26.5	26.6575	297336.0
2015-01-06 08:30:00	AAPL	Stock	26.66	26.66	26.5725	26.59	521388.0
2015-01-06 09:00:00	AAPL	Stock	26.585	26.67	26.575	26.65	435456.0
2015-01-06 09:30:00	AAPL	Stock	26.64	26.69	26.32	26.4075	28177816.0
2015-01-06 10:00:00	AAPL	Stock	26.4075	26.8	26.375	26.7535	23771308.0
2015-01-06 10:30:00	AAPL	Stock	26.7525	26.7825	26.5025	26.525	17316744.0
2015-01-06 11:00:00	AAPL	Stock	26.5225	26.5382	26.37	26.4218	14544228.0
2015-01-06 11:30:00	AAPL	Stock	26.42	26.425	26.1575	26.3225	20747564.0
2015-01-06 12:00:00	AAPL	Stock	26.3225	26.45	26.2178	26.3178	16011888.0
2015-01-06 12:30:00	AAPL	Stock	26.3175	26.595	26.305	26.5825	13461316.0
2015-01-06 13:00:00	AAPL	Stock	26.58	26.5875	26.2825	26.41	12615044.0
2015-01-06 13:30:00	AAPL	Stock	26.4075	26.6075	26.365	26.6025	11853788.0
2015-01-06 14:00:00	AAPL	Stock	26.6025	26.61	26.46	26.585	13444232.0
2015-01-06 14:30:00	AAPL	Stock	26.5775	26.7625	26.5275	26.705	19333828.0
2015-01-06 15:00:00	AAPL	Stock	26.7025	26.8575	26.6175	26.8495	19679704.0
2015-01-06 15:30:00	AAPL	Stock	26.8498	26.8525	26.5125	26.5575	26808700.0
2015-01-06 16:00:00	AAPL	Stock	26.565	26.6302	26.4568	26.5702	6652736.0
2015-01-06 16:30:00	AAPL	Stock	26.56	26.5738	26.5112	26.565	207776.0
2015-01-06 17:00:00	AAPL	Stock	26.5625	26.5625	26.54	26.54	8884.0
2015-01-06 17:30:00	AAPL	Stock	26.56	26.575	26.545	26.575	77012.0
2015-01-06 18:00:00	AAPL	Stock	26.57	26.595	26.565	26.585	157116.0
2015-01-06 18:30:00	AAPL	Stock	26.5925	26.5925	26.5925	26.5925	29096.0
2015-01-06 19:00:00	AAPL	Stock	26.5975	26.6375	26.5975	26.635	122160.0
2015-01-06 19:30:00	AAPL	Stock	26.63	26.6525	26.62	26.645	59476.0
2015-01-06 07:00:00	MSFT	Stock	46.5	46.5	46.5	46.5	100.0
2015-01-06 07:30:00	MSFT	Stock	46.5	46.5	46.5	46.5	800.0
2015-01-06 08:00:00	MSFT	Stock	46.325	46.5	46.325	46.5	18675.0
2015-01-06 08:30:00	MSFT	Stock	46.5	46.5	46.38	46.4	4767.0
2015-01-06 09:00:00	MSFT	Stock	46.4	46.44	46.29	46.34	25476.0
2015-01-06 09:30:00	MSFT	Stock	46.38	46.749	46.29	46.54	2973284.0
2015-01-06 10:00:00	MSFT	Stock	46.54	46.68	46.405	46.605	2753845.0
2015-01-06 10:30:00	MSFT	Stock	46.605	46.68	46.36	46.389	2180334.0
2015-01-06 11:00:00	MSFT	Stock	46.38	46.395	46.245	46.37	1671542.0
2015-01-06 11:30:00	MSFT	Stock	46.363	46.38	46.18	46.185	1775341.0
2015-01-06 12:00:00	MSFT	Stock	46.18	46.19	45.83	45.965	2146634.0
2015-01-06 12:30:00	MSFT	Stock	45.945	46.21	45.94	46.17	2174380.0
2015-01-06 13:00:00	MSFT	Stock	46.16	46.17	45.64	45.764	1772348.0
2015-01-06 13:30:00	MSFT	Stock	45.76	45.85	45.67	45.817	1825739.0
2015-01-06 14:00:00	MSFT	Stock	45.81	45.87	45.54	45.795	2240219.0
2015-01-06 14:30:00	MSFT	Stock	45.795	45.986	45.75	45.86	1896959.0
2015-01-06 15:00:00	MSFT	Stock	45.855	46.065	45.76	46.055	2073883.0
2015-01-06 15:30:00	MSFT	Stock	46.055	46.055	45.56	45.6	5572625.0

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

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