PREVIEW / stock_1hour / 2007-11-07

all stock 1-hour files

  file:    by_date/stock_1hour/2007/2007-11-07.parquet
  size:    822 KB
  rows:    40,578
  symbols: 3,210

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-07 04:00:00	AAPL	Stock	6.8132	6.8132	6.795	6.795	21280.0
2007-11-07 05:00:00	AAPL	Stock	6.7957	6.7957	6.7857	6.7857	19600.0
2007-11-07 06:00:00	AAPL	Stock	6.7929	6.7929	6.7857	6.7857	22400.0
2007-11-07 07:00:00	AAPL	Stock	6.7857	6.8032	6.7454	6.7857	1040172.0
2007-11-07 08:00:00	AAPL	Stock	6.7807	6.8104	6.7664	6.8054	7569464.0
2007-11-07 09:00:00	AAPL	Stock	6.8054	6.8404	6.775	6.8286	136840844.0
2007-11-07 10:00:00	AAPL	Stock	6.8286	6.8814	6.7961	6.8266	195700204.0
2007-11-07 11:00:00	AAPL	Stock	6.8268	6.8429	6.7857	6.8336	111542928.0
2007-11-07 12:00:00	AAPL	Stock	6.8339	6.8339	6.7846	6.789	96598572.0
2007-11-07 13:00:00	AAPL	Stock	6.7893	6.8061	6.7436	6.7593	136696112.0
2007-11-07 14:00:00	AAPL	Stock	6.7596	6.8	6.75	6.7715	108641708.0
2007-11-07 15:00:00	AAPL	Stock	6.7714	6.7954	6.6475	6.6611	177325540.0
2007-11-07 16:00:00	AAPL	Stock	6.6611	6.8225	6.5893	6.5964	17479476.0
2007-11-07 17:00:00	AAPL	Stock	6.5929	6.7918	6.5536	6.5821	3628240.0
2007-11-07 18:00:00	AAPL	Stock	6.585	6.7942	6.5736	6.7942	829668.0
2007-11-07 19:00:00	AAPL	Stock	6.5804	6.6143	6.5804	6.5964	362656.0
2007-11-07 05:00:00	MSFT	Stock	35.92	35.92	35.92	35.92	1000.0
2007-11-07 06:00:00	MSFT	Stock	35.9	35.91	35.9	35.91	1700.0
2007-11-07 07:00:00	MSFT	Stock	36.01	36.11	35.93	36.03	8300.0
2007-11-07 08:00:00	MSFT	Stock	36.41	36.41	36.0	36.07	338686.0
2007-11-07 09:00:00	MSFT	Stock	36.1	36.16	36.0	36.07	6794042.0
2007-11-07 10:00:00	MSFT	Stock	36.07	36.1	35.89	35.92	11497643.0
2007-11-07 11:00:00	MSFT	Stock	35.92	36.15	35.84	36.111	9111921.0
2007-11-07 12:00:00	MSFT	Stock	36.11	36.12	35.94	36.03	8403540.0
2007-11-07 13:00:00	MSFT	Stock	36.03	36.03	35.81	35.86	8726974.0
2007-11-07 14:00:00	MSFT	Stock	35.86	35.95	35.8	35.87	8671201.0
2007-11-07 15:00:00	MSFT	Stock	35.87	35.94	35.45	35.52	17798922.0
2007-11-07 16:00:00	MSFT	Stock	35.5	36.09	34.91	34.92	3457389.0
2007-11-07 17:00:00	MSFT	Stock	34.95	35.5	34.9	35.05	70646.0
2007-11-07 18:00:00	MSFT	Stock	35.05	35.965	35.05	35.965	23904.0
2007-11-07 19:00:00	MSFT	Stock	35.1	35.19	35.08	35.08	4190.0
2007-11-07 08:00:00	NVDA	Stock	0.945	0.945	0.9355	0.9378	298000.0
2007-11-07 09:00:00	NVDA	Stock	0.9375	0.947	0.935	0.9428	38898600.0
2007-11-07 10:00:00	NVDA	Stock	0.9425	0.9508	0.9312	0.9312	59706400.0
2007-11-07 11:00:00	NVDA	Stock	0.9315	0.9322	0.9075	0.9082	72469520.0
2007-11-07 12:00:00	NVDA	Stock	0.908	0.9102	0.895	0.8973	72134760.0
2007-11-07 13:00:00	NVDA	Stock	0.8973	0.9072	0.8965	0.9028	57242680.0
2007-11-07 14:00:00	NVDA	Stock	0.9025	0.919	0.9012	0.9102	74658120.0
2007-11-07 15:00:00	NVDA	Stock	0.9105	0.9165	0.8998	0.9025	143065040.0
2007-11-07 16:00:00	NVDA	Stock	0.9004	0.9164	0.9	0.9015	21524680.0
2007-11-07 17:00:00	NVDA	Stock	0.9025	0.9038	0.895	0.895	559760.0
2007-11-07 18:00:00	NVDA	Stock	0.894	0.916	0.8875	0.916	9370320.0
2007-11-07 19:00:00	NVDA	Stock	0.894	0.894	0.8912	0.8912	38000.0
2007-11-07 05:00:00	AMZN	Stock	4.325	4.325	4.325	4.325	2000.0
2007-11-07 07:00:00	AMZN	Stock	4.3125	4.3125	4.3125	4.3125	2000.0
2007-11-07 08:00:00	AMZN	Stock	4.325	4.341	4.2885	4.3345	370500.0
2007-11-07 09:00:00	AMZN	Stock	4.32	4.379	4.308	4.378	18100100.0
2007-11-07 10:00:00	AMZN	Stock	4.3768	4.4495	4.3745	4.4125	32385180.0
2007-11-07 11:00:00	AMZN	Stock	4.412	4.458	4.406	4.429	17758840.0
2007-11-07 12:00:00	AMZN	Stock	4.43	4.43	4.3845	4.3903	17953800.0

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

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