PREVIEW / stock_1hour / 2015-01-09

all stock 1-hour files

  file:    by_date/stock_1hour/2015/2015-01-09.parquet
  size:    1.0 MB
  rows:    48,181
  symbols: 3,518

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-09 04:00:00	AAPL	Stock	28.0975	28.0975	28.0025	28.0025	18084.0
2015-01-09 05:00:00	AAPL	Stock	28.0025	28.1	27.9925	28.0375	22708.0
2015-01-09 06:00:00	AAPL	Stock	28.025	28.0625	27.9825	27.985	58996.0
2015-01-09 07:00:00	AAPL	Stock	27.9775	27.9975	27.955	27.9725	152800.0
2015-01-09 08:00:00	AAPL	Stock	27.975	28.15	27.96	28.1475	1221512.0
2015-01-09 09:00:00	AAPL	Stock	28.145	28.3125	27.9575	28.06	40388744.0
2015-01-09 10:00:00	AAPL	Stock	28.06	28.1375	27.67	27.84	42609936.0
2015-01-09 11:00:00	AAPL	Stock	27.8375	27.84	27.5525	27.785	26389312.0
2015-01-09 12:00:00	AAPL	Stock	27.785	27.9425	27.7625	27.785	15619820.0
2015-01-09 13:00:00	AAPL	Stock	27.7875	27.9225	27.7675	27.8775	13248068.0
2015-01-09 14:00:00	AAPL	Stock	27.875	28.0725	27.83	28.0625	19213324.0
2015-01-09 15:00:00	AAPL	Stock	28.0625	28.165	27.9525	28.0	37138772.0
2015-01-09 16:00:00	AAPL	Stock	28.0012	28.0175	27.8098	27.995	7059916.0
2015-01-09 17:00:00	AAPL	Stock	28.0	28.005	27.8972	27.99	147060.0
2015-01-09 18:00:00	AAPL	Stock	27.995	28.0075	27.99	27.99	91808.0
2015-01-09 19:00:00	AAPL	Stock	27.9875	28.015	27.9775	27.9775	59936.0
2015-01-09 05:00:00	MSFT	Stock	47.55	47.55	47.55	47.55	100.0
2015-01-09 06:00:00	MSFT	Stock	47.51	47.51	47.45	47.45	300.0
2015-01-09 07:00:00	MSFT	Stock	47.48	47.49	47.46	47.46	1125.0
2015-01-09 08:00:00	MSFT	Stock	47.41	47.75	47.41	47.64	30927.0
2015-01-09 09:00:00	MSFT	Stock	47.63	47.82	47.52	47.66	2965284.0
2015-01-09 10:00:00	MSFT	Stock	47.66	47.665	47.19	47.35	3669560.0
2015-01-09 11:00:00	MSFT	Stock	47.35	47.355	46.9	47.135	3359276.0
2015-01-09 12:00:00	MSFT	Stock	47.135	47.43	47.12	47.21	2541234.0
2015-01-09 13:00:00	MSFT	Stock	47.21	47.42	47.175	47.265	1809433.0
2015-01-09 14:00:00	MSFT	Stock	47.26	47.39	47.14	47.37	2742255.0
2015-01-09 15:00:00	MSFT	Stock	47.36	47.48	47.14	47.19	3461807.0
2015-01-09 16:00:00	MSFT	Stock	47.19	47.328	47.022	47.303	2317952.0
2015-01-09 17:00:00	MSFT	Stock	47.09	47.3	47.09	47.12	14750.0
2015-01-09 18:00:00	MSFT	Stock	47.1	47.12	47.09	47.12	800.0
2015-01-09 19:00:00	MSFT	Stock	47.1	47.1	47.1	47.1	100.0
2015-01-09 09:00:00	NVDA	Stock	0.4992	0.5022	0.497	0.5011	25617840.0
2015-01-09 10:00:00	NVDA	Stock	0.501	0.5015	0.494	0.496	28710760.0
2015-01-09 11:00:00	NVDA	Stock	0.496	0.496	0.4914	0.4935	16457880.0
2015-01-09 12:00:00	NVDA	Stock	0.4935	0.4958	0.4928	0.4931	28843640.0
2015-01-09 13:00:00	NVDA	Stock	0.4934	0.4978	0.4932	0.4972	18531360.0
2015-01-09 14:00:00	NVDA	Stock	0.4972	0.4976	0.4942	0.496	23656520.0
2015-01-09 15:00:00	NVDA	Stock	0.496	0.4995	0.4958	0.4985	53577680.0
2015-01-09 16:00:00	NVDA	Stock	0.4982	0.4985	0.4968	0.4985	2111680.0
2015-01-09 17:00:00	NVDA	Stock	0.496	0.4985	0.496	0.4985	676960.0
2015-01-09 08:00:00	AMZN	Stock	14.9845	15.093	14.9845	15.05	88400.0
2015-01-09 09:00:00	AMZN	Stock	15.0785	15.1435	15.009	15.05	7263300.0
2015-01-09 10:00:00	AMZN	Stock	15.038	15.1245	14.932	14.9455	7482600.0
2015-01-09 11:00:00	AMZN	Stock	14.936	14.9825	14.8635	14.9775	4902660.0
2015-01-09 12:00:00	AMZN	Stock	14.974	14.9995	14.941	14.9452	4018260.0
2015-01-09 13:00:00	AMZN	Stock	14.9435	14.961	14.912	14.912	3993820.0
2015-01-09 14:00:00	AMZN	Stock	14.9105	14.932	14.879	14.882	5113940.0
2015-01-09 15:00:00	AMZN	Stock	14.8835	14.932	14.834	14.8465	12141840.0
2015-01-09 16:00:00	AMZN	Stock	14.8465	14.9879	14.822	14.824	337380.0
2015-01-09 17:00:00	AMZN	Stock	14.956	14.956	14.835	14.835	13400.0

> showing 50 of 48,181 rows — these rows as CSV

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