PREVIEW / stock_1hour / 2016-04-05

all stock 1-hour files

  file:    by_date/stock_1hour/2016/2016-04-05.parquet
  size:    1.0 MB
  rows:    48,062
  symbols: 3,325

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-04-05 04:00:00	AAPL	Stock	27.625	27.625	27.4975	27.5	14968.0
2016-04-05 05:00:00	AAPL	Stock	27.5	27.565	27.5	27.565	2000.0
2016-04-05 06:00:00	AAPL	Stock	27.5325	27.575	27.5	27.53	9812.0
2016-04-05 07:00:00	AAPL	Stock	27.5475	27.5825	27.2825	27.37	566072.0
2016-04-05 08:00:00	AAPL	Stock	27.3725	27.61	27.2975	27.4375	624720.0
2016-04-05 09:00:00	AAPL	Stock	27.4375	27.6075	27.355	27.44	16925128.0
2016-04-05 10:00:00	AAPL	Stock	27.445	27.6825	27.4375	27.5775	18325816.0
2016-04-05 11:00:00	AAPL	Stock	27.576	27.61	27.4575	27.4942	12733836.0
2016-04-05 12:00:00	AAPL	Stock	27.4925	27.5438	27.415	27.4925	9122048.0
2016-04-05 13:00:00	AAPL	Stock	27.4925	27.56	27.4275	27.5375	10241896.0
2016-04-05 14:00:00	AAPL	Stock	27.5375	27.58	27.4778	27.5562	8902864.0
2016-04-05 15:00:00	AAPL	Stock	27.5575	27.565	27.3975	27.4508	14260120.0
2016-04-05 16:00:00	AAPL	Stock	27.4525	27.78	27.3525	27.5625	4898016.0
2016-04-05 17:00:00	AAPL	Stock	27.5375	27.54	27.5	27.5225	80548.0
2016-04-05 18:00:00	AAPL	Stock	27.5225	27.5325	27.5025	27.5325	14568.0
2016-04-05 19:00:00	AAPL	Stock	27.5325	27.5625	27.5125	27.5275	34940.0
2016-04-05 07:00:00	MSFT	Stock	54.9	54.92	54.86	54.86	300.0
2016-04-05 08:00:00	MSFT	Stock	54.85	55.0	54.85	55.0	5650.0
2016-04-05 09:00:00	MSFT	Stock	54.97	55.3	54.71	54.808	2430722.0
2016-04-05 10:00:00	MSFT	Stock	54.805	55.25	54.805	54.945	2512241.0
2016-04-05 11:00:00	MSFT	Stock	54.94	55.07	54.79	54.85	1698722.0
2016-04-05 12:00:00	MSFT	Stock	54.845	54.91	54.46	54.5	2299676.0
2016-04-05 13:00:00	MSFT	Stock	54.5	54.88	54.49	54.8	1534039.0
2016-04-05 14:00:00	MSFT	Stock	54.81	54.944	54.73	54.87	1634940.0
2016-04-05 15:00:00	MSFT	Stock	54.874	54.89	54.47	54.56	3940957.0
2016-04-05 16:00:00	MSFT	Stock	54.57	55.43	54.55	54.63	1579411.0
2016-04-05 17:00:00	MSFT	Stock	54.63	54.63	54.63	54.63	214.0
2016-04-05 18:00:00	MSFT	Stock	54.69	54.69	54.68	54.68	986.0
2016-04-05 19:00:00	MSFT	Stock	54.69	54.69	54.69	54.69	1000.0
2016-04-05 09:00:00	NVDA	Stock	0.8863	0.8965	0.8812	0.895	20488760.0
2016-04-05 10:00:00	NVDA	Stock	0.8954	0.9019	0.8945	0.8956	38452760.0
2016-04-05 11:00:00	NVDA	Stock	0.8958	0.8982	0.8922	0.894	55656920.0
2016-04-05 12:00:00	NVDA	Stock	0.894	0.9006	0.8925	0.8944	34267520.0
2016-04-05 13:00:00	NVDA	Stock	0.8944	0.902	0.8938	0.8968	62550480.0
2016-04-05 14:00:00	NVDA	Stock	0.8968	0.8995	0.8945	0.8988	30240680.0
2016-04-05 15:00:00	NVDA	Stock	0.8985	0.899	0.8928	0.8938	55173120.0
2016-04-05 16:00:00	NVDA	Stock	0.8938	0.8968	0.893	0.893	2927120.0
2016-04-05 17:00:00	NVDA	Stock	0.8975	0.8975	0.8975	0.8975	220000.0
2016-04-05 18:00:00	NVDA	Stock	0.895	0.895	0.895	0.895	6000.0
2016-04-05 19:00:00	NVDA	Stock	0.8975	0.8975	0.8975	0.8975	18600.0
2016-04-05 04:00:00	AMZN	Stock	29.597	29.597	29.597	29.597	2000.0
2016-04-05 08:00:00	AMZN	Stock	29.5205	29.5205	29.425	29.425	50080.0
2016-04-05 09:00:00	AMZN	Stock	29.4635	29.6735	29.425	29.6236	5552580.0
2016-04-05 10:00:00	AMZN	Stock	29.621	29.6695	29.4115	29.436	7400180.0
2016-04-05 11:00:00	AMZN	Stock	29.437	29.527	29.3535	29.3978	4620720.0
2016-04-05 12:00:00	AMZN	Stock	29.409	29.4465	29.3225	29.3535	2547900.0
2016-04-05 13:00:00	AMZN	Stock	29.3545	29.5255	29.3385	29.478	4293480.0
2016-04-05 14:00:00	AMZN	Stock	29.487	29.5495	29.425	29.499	3037580.0
2016-04-05 15:00:00	AMZN	Stock	29.4975	29.518	29.2625	29.307	10493600.0
2016-04-05 16:00:00	AMZN	Stock	29.307	29.35	29.2875	29.35	596900.0

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

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