PREVIEW / stock_1hour / 2007-11-16

all stock 1-hour files

  file:    by_date/stock_1hour/2007/2007-11-16.parquet
  size:    812 KB
  rows:    40,358
  symbols: 3,190

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
2007-11-16 05:00:00	AAPL	Stock	5.8707	5.8707	5.8707	5.8707	2800.0
2007-11-16 06:00:00	AAPL	Stock	5.8839	5.8839	5.8571	5.8571	20720.0
2007-11-16 07:00:00	AAPL	Stock	5.8843	5.9464	5.8843	5.9214	619640.0
2007-11-16 08:00:00	AAPL	Stock	5.9282	5.9707	5.9143	5.9371	9355892.0
2007-11-16 09:00:00	AAPL	Stock	5.9375	5.9464	5.7836	5.7868	205739016.0
2007-11-16 10:00:00	AAPL	Stock	5.7879	5.8121	5.6904	5.7739	266735448.0
2007-11-16 11:00:00	AAPL	Stock	5.7729	5.9286	5.7721	5.8964	207265912.0
2007-11-16 12:00:00	AAPL	Stock	5.8968	5.955	5.8436	5.8529	153202700.0
2007-11-16 13:00:00	AAPL	Stock	5.8525	5.9004	5.8164	5.8654	136283504.0
2007-11-16 14:00:00	AAPL	Stock	5.8646	5.9004	5.8046	5.8832	170740444.0
2007-11-16 15:00:00	AAPL	Stock	5.8836	5.965	5.85	5.94	209262984.0
2007-11-16 16:00:00	AAPL	Stock	5.9404	5.9589	5.847	5.9554	22674176.0
2007-11-16 17:00:00	AAPL	Stock	5.9586	5.9679	5.847	5.9582	2110500.0
2007-11-16 18:00:00	AAPL	Stock	5.9582	5.96	5.9461	5.9568	309848.0
2007-11-16 19:00:00	AAPL	Stock	5.9571	5.9604	5.9529	5.9554	211400.0
2007-11-16 07:00:00	MSFT	Stock	33.56	33.81	33.56	33.81	1800.0
2007-11-16 08:00:00	MSFT	Stock	33.78	33.95	33.78	33.88	32643.0
2007-11-16 09:00:00	MSFT	Stock	33.88	33.99	33.725	33.76	14379643.0
2007-11-16 10:00:00	MSFT	Stock	33.76	34.01	33.71	33.84	10737508.0
2007-11-16 11:00:00	MSFT	Stock	33.84	34.19	33.84	34.11	8731192.0
2007-11-16 12:00:00	MSFT	Stock	34.11	34.26	33.85	34.04	8123825.0
2007-11-16 13:00:00	MSFT	Stock	34.04	34.18	34.03	34.08	4427823.0
2007-11-16 14:00:00	MSFT	Stock	34.08	34.09	33.72	33.88	9670841.0
2007-11-16 15:00:00	MSFT	Stock	33.88	34.12	33.8	34.05	11164432.0
2007-11-16 16:00:00	MSFT	Stock	34.04	34.09	33.71	34.006	3688824.0
2007-11-16 17:00:00	MSFT	Stock	34.09	34.1	33.952	34.1	156712.0
2007-11-16 18:00:00	MSFT	Stock	34.08	34.09	34.05	34.06	2305.0
2007-11-16 19:00:00	MSFT	Stock	34.05	34.05	34.04	34.04	1070.0
2007-11-16 08:00:00	NVDA	Stock	0.7935	0.8048	0.7925	0.8048	591000.0
2007-11-16 09:00:00	NVDA	Stock	0.8028	0.8088	0.7935	0.8023	70190880.0
2007-11-16 10:00:00	NVDA	Stock	0.8023	0.8045	0.7963	0.8018	63137840.0
2007-11-16 11:00:00	NVDA	Stock	0.802	0.812	0.8018	0.8113	51073440.0
2007-11-16 12:00:00	NVDA	Stock	0.8113	0.8135	0.8025	0.8058	50002800.0
2007-11-16 13:00:00	NVDA	Stock	0.8058	0.8088	0.8012	0.8072	37768120.0
2007-11-16 14:00:00	NVDA	Stock	0.8075	0.808	0.798	0.8035	58356920.0
2007-11-16 15:00:00	NVDA	Stock	0.8035	0.813	0.8018	0.8105	79112440.0
2007-11-16 16:00:00	NVDA	Stock	0.8105	0.8113	0.7935	0.8113	6601440.0
2007-11-16 17:00:00	NVDA	Stock	0.81	0.8113	0.81	0.8113	417960.0
2007-11-16 18:00:00	NVDA	Stock	0.81	0.812	0.8062	0.808	310200.0
2007-11-16 19:00:00	NVDA	Stock	0.8098	0.8098	0.8098	0.8098	24000.0
2007-11-16 07:00:00	AMZN	Stock	3.9495	3.985	3.925	3.925	45800.0
2007-11-16 08:00:00	AMZN	Stock	3.937	3.9525	3.8925	3.9295	149900.0
2007-11-16 09:00:00	AMZN	Stock	3.925	3.925	3.8315	3.866	34938880.0
2007-11-16 10:00:00	AMZN	Stock	3.8665	3.8895	3.8325	3.8745	16992780.0
2007-11-16 11:00:00	AMZN	Stock	3.875	3.937	3.875	3.9205	17634880.0
2007-11-16 12:00:00	AMZN	Stock	3.9205	3.9385	3.884	3.889	17915180.0
2007-11-16 13:00:00	AMZN	Stock	3.8885	3.906	3.8655	3.882	11584780.0
2007-11-16 14:00:00	AMZN	Stock	3.883	3.9	3.846	3.894	14045920.0
2007-11-16 15:00:00	AMZN	Stock	3.894	3.9495	3.886	3.931	25131460.0
2007-11-16 16:00:00	AMZN	Stock	3.928	3.95	3.8887	3.93	2835440.0

> showing 50 of 40,358 rows — these rows as CSV

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