PREVIEW / stock_30min / 2015-02-11

all stock 30-min files

  file:    by_date/stock_30min/2015/2015-02-11.parquet
  size:    1.6 MB
  rows:    82,576
  symbols: 3,519

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-02-11 04:00:00	AAPL	Stock	30.505	30.555	30.495	30.55	30504.0
2015-02-11 04:30:00	AAPL	Stock	30.555	30.555	30.5325	30.55	23748.0
2015-02-11 05:00:00	AAPL	Stock	30.575	30.5825	30.57	30.5825	13172.0
2015-02-11 05:30:00	AAPL	Stock	30.57	30.6225	30.5625	30.595	58048.0
2015-02-11 06:00:00	AAPL	Stock	30.5875	30.6225	30.575	30.5875	103160.0
2015-02-11 06:30:00	AAPL	Stock	30.6	30.605	30.575	30.59	35920.0
2015-02-11 07:00:00	AAPL	Stock	30.59	30.63	30.5875	30.6075	165056.0
2015-02-11 07:30:00	AAPL	Stock	30.61	30.625	30.5625	30.5725	82864.0
2015-02-11 08:00:00	AAPL	Stock	30.5625	30.6375	30.56	30.635	854868.0
2015-02-11 08:30:00	AAPL	Stock	30.6325	30.6375	30.6125	30.62	596264.0
2015-02-11 09:00:00	AAPL	Stock	30.62	30.7225	30.5925	30.6825	1192920.0
2015-02-11 09:30:00	AAPL	Stock	30.715	30.92	30.625	30.919	50886004.0
2015-02-11 10:00:00	AAPL	Stock	30.9175	30.985	30.8525	30.945	25526924.0
2015-02-11 10:30:00	AAPL	Stock	30.945	31.0325	30.925	30.9625	23917708.0
2015-02-11 11:00:00	AAPL	Stock	30.96	31.01	30.9525	30.9875	14065328.0
2015-02-11 11:30:00	AAPL	Stock	30.99	31.09	30.9528	31.0725	15259896.0
2015-02-11 12:00:00	AAPL	Stock	31.0725	31.1075	31.05	31.0725	13069144.0
2015-02-11 12:30:00	AAPL	Stock	31.0725	31.0925	30.99	31.0402	14867296.0
2015-02-11 13:00:00	AAPL	Stock	31.0425	31.06	30.9125	31.0	15087460.0
2015-02-11 13:30:00	AAPL	Stock	31.0025	31.0875	30.985	31.0562	11087884.0
2015-02-11 14:00:00	AAPL	Stock	31.0575	31.14	31.055	31.1325	15538372.0
2015-02-11 14:30:00	AAPL	Stock	31.1298	31.19	31.125	31.1775	15791892.0
2015-02-11 15:00:00	AAPL	Stock	31.1775	31.23	31.1125	31.2175	21339488.0
2015-02-11 15:30:00	AAPL	Stock	31.2175	31.23	31.1675	31.2175	26213716.0
2015-02-11 16:00:00	AAPL	Stock	31.22	31.2475	30.8292	31.2275	8729688.0
2015-02-11 16:30:00	AAPL	Stock	31.23	31.3125	31.0295	31.295	800488.0
2015-02-11 17:00:00	AAPL	Stock	31.2875	31.3125	31.22	31.31	1182620.0
2015-02-11 17:30:00	AAPL	Stock	31.31	31.3125	31.3	31.3	177068.0
2015-02-11 18:00:00	AAPL	Stock	31.3	31.305	31.22	31.2875	396520.0
2015-02-11 18:30:00	AAPL	Stock	31.2975	31.3	31.28	31.2875	187152.0
2015-02-11 19:00:00	AAPL	Stock	31.2875	31.305	31.285	31.3	134668.0
2015-02-11 19:30:00	AAPL	Stock	31.3	31.3	31.2875	31.2975	179736.0
2015-02-11 08:00:00	MSFT	Stock	42.56	42.56	42.51	42.51	1000.0
2015-02-11 08:30:00	MSFT	Stock	42.6	42.6	42.56	42.56	35355.0
2015-02-11 09:00:00	MSFT	Stock	42.56	42.59	42.56	42.59	6046.0
2015-02-11 09:30:00	MSFT	Stock	42.59	42.65	42.31	42.4	4684937.0
2015-02-11 10:00:00	MSFT	Stock	42.39	42.44	42.3	42.38	2176667.0
2015-02-11 10:30:00	MSFT	Stock	42.37	42.39	42.27	42.325	1193037.0
2015-02-11 11:00:00	MSFT	Stock	42.32	42.59	42.32	42.52	3151832.0
2015-02-11 11:30:00	MSFT	Stock	42.52	42.55	42.49	42.5	1475076.0
2015-02-11 12:00:00	MSFT	Stock	42.5	42.53	42.45	42.49	1530497.0
2015-02-11 12:30:00	MSFT	Stock	42.49	42.51	42.36	42.395	1247960.0
2015-02-11 13:00:00	MSFT	Stock	42.395	42.45	42.34	42.37	1553328.0
2015-02-11 13:30:00	MSFT	Stock	42.37	42.4	42.21	42.32	1874882.0
2015-02-11 14:00:00	MSFT	Stock	42.325	42.395	42.21	42.27	1689715.0
2015-02-11 14:30:00	MSFT	Stock	42.27	42.365	42.235	42.315	1480787.0
2015-02-11 15:00:00	MSFT	Stock	42.32	42.415	42.245	42.4	2426885.0
2015-02-11 15:30:00	MSFT	Stock	42.4	42.41	42.22	42.37	6748058.0
2015-02-11 16:00:00	MSFT	Stock	42.37	42.535	42.25	42.33	1828632.0
2015-02-11 16:30:00	MSFT	Stock	42.37	42.49	42.37	42.38	24006.0

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

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