PREVIEW / stock_30min / 2016-10-28

all stock 30-min files

  file:    by_date/stock_30min/2016/2016-10-28.parquet
  size:    1.5 MB
  rows:    79,131
  symbols: 3,184

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-10-28 04:00:00	AAPL	Stock	28.5	28.5	28.47	28.475	5200.0
2016-10-28 04:30:00	AAPL	Stock	28.45	28.45	28.45	28.45	400.0
2016-10-28 06:00:00	AAPL	Stock	28.495	28.5	28.495	28.5	4400.0
2016-10-28 06:30:00	AAPL	Stock	28.505	28.56	28.505	28.56	18292.0
2016-10-28 07:00:00	AAPL	Stock	28.55	28.625	28.53	28.58	15364.0
2016-10-28 07:30:00	AAPL	Stock	28.575	28.5775	28.5275	28.55	8136.0
2016-10-28 08:00:00	AAPL	Stock	28.535	28.5825	28.5225	28.5425	56804.0
2016-10-28 08:30:00	AAPL	Stock	28.5375	28.57	28.525	28.555	95060.0
2016-10-28 09:00:00	AAPL	Stock	28.55	28.61	28.465	28.465	326212.0
2016-10-28 09:30:00	AAPL	Stock	28.465	28.7775	28.4625	28.7025	16902240.0
2016-10-28 10:00:00	AAPL	Stock	28.705	28.7325	28.59	28.6615	9426312.0
2016-10-28 10:30:00	AAPL	Stock	28.66	28.7338	28.66	28.6912	6526512.0
2016-10-28 11:00:00	AAPL	Stock	28.6925	28.75	28.6825	28.7315	4827176.0
2016-10-28 11:30:00	AAPL	Stock	28.7325	28.7675	28.715	28.75	5264540.0
2016-10-28 12:00:00	AAPL	Stock	28.7475	28.8025	28.7175	28.775	5489404.0
2016-10-28 12:30:00	AAPL	Stock	28.775	28.7825	28.7375	28.7715	4240960.0
2016-10-28 13:00:00	AAPL	Stock	28.77	28.785	28.5425	28.5825	13164988.0
2016-10-28 13:30:00	AAPL	Stock	28.5825	28.59	28.375	28.3838	13098628.0
2016-10-28 14:00:00	AAPL	Stock	28.385	28.4925	28.3625	28.4775	13561676.0
2016-10-28 14:30:00	AAPL	Stock	28.48	28.535	28.3875	28.4225	8805292.0
2016-10-28 15:00:00	AAPL	Stock	28.42	28.53	28.41	28.4975	8451576.0
2016-10-28 15:30:00	AAPL	Stock	28.4952	28.4975	28.375	28.43	15582604.0
2016-10-28 16:00:00	AAPL	Stock	28.43	28.4475	28.4025	28.43	12157284.0
2016-10-28 16:30:00	AAPL	Stock	28.4125	28.4425	28.4125	28.44	47928.0
2016-10-28 17:00:00	AAPL	Stock	28.43	28.44	28.425	28.4275	32344.0
2016-10-28 17:30:00	AAPL	Stock	28.4375	28.4375	28.4275	28.4275	18220.0
2016-10-28 18:00:00	AAPL	Stock	28.425	28.4325	28.425	28.425	19316.0
2016-10-28 18:30:00	AAPL	Stock	28.425	28.425	28.4025	28.42	14488.0
2016-10-28 19:00:00	AAPL	Stock	28.42	28.4225	28.4025	28.4225	16132.0
2016-10-28 19:30:00	AAPL	Stock	28.4225	28.4225	28.38	28.4025	16836.0
2016-10-28 04:00:00	MSFT	Stock	59.79	59.79	59.76	59.76	2200.0
2016-10-28 04:30:00	MSFT	Stock	59.85	59.85	59.85	59.85	400.0
2016-10-28 05:00:00	MSFT	Stock	59.89	59.89	59.89	59.89	500.0
2016-10-28 06:00:00	MSFT	Stock	60.0	60.0	60.0	60.0	200.0
2016-10-28 06:30:00	MSFT	Stock	59.94	60.01	59.94	60.01	2100.0
2016-10-28 07:00:00	MSFT	Stock	60.08	60.1	60.08	60.1	10508.0
2016-10-28 07:30:00	MSFT	Stock	60.1	60.17	60.1	60.17	400.0
2016-10-28 08:00:00	MSFT	Stock	60.2	60.21	60.12	60.12	1400.0
2016-10-28 08:30:00	MSFT	Stock	60.2	60.23	60.1	60.14	15899.0
2016-10-28 09:00:00	MSFT	Stock	60.14	60.17	60.02	60.02	70435.0
2016-10-28 09:30:00	MSFT	Stock	60.01	60.46	60.01	60.34	3584203.0
2016-10-28 10:00:00	MSFT	Stock	60.34	60.39	60.1	60.19	2102873.0
2016-10-28 10:30:00	MSFT	Stock	60.195	60.46	60.18	60.4	1872135.0
2016-10-28 11:00:00	MSFT	Stock	60.4	60.52	60.39	60.46	1038879.0
2016-10-28 11:30:00	MSFT	Stock	60.46	60.49	60.37	60.37	997131.0
2016-10-28 12:00:00	MSFT	Stock	60.375	60.44	60.32	60.37	758328.0
2016-10-28 12:30:00	MSFT	Stock	60.38	60.38	60.26	60.31	897287.0
2016-10-28 13:00:00	MSFT	Stock	60.305	60.326	59.79	59.93	2746481.0
2016-10-28 13:30:00	MSFT	Stock	59.93	59.971	59.67	59.7	2174248.0
2016-10-28 14:00:00	MSFT	Stock	59.7	59.95	59.58	59.92	2360574.0

> showing 50 of 79,131 rows — these rows as CSV

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