PREVIEW / stock_1hour / 2006-11-07

all stock 1-hour files

  file:    by_date/stock_1hour/2006/2006-11-07.parquet
  size:    630 KB
  rows:    29,838
  symbols: 2,426

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
2006-11-07 07:00:00	AAPL	Stock	2.8546	2.8636	2.8546	2.8636	140000.0
2006-11-07 08:00:00	AAPL	Stock	2.8546	2.8671	2.8543	2.8643	1494556.0
2006-11-07 09:00:00	AAPL	Stock	2.8654	2.8796	2.8579	2.8718	72896404.0
2006-11-07 10:00:00	AAPL	Stock	2.8718	2.8825	2.8682	2.8818	95117484.0
2006-11-07 11:00:00	AAPL	Stock	2.8818	2.8921	2.8786	2.8893	60724580.0
2006-11-07 12:00:00	AAPL	Stock	2.8886	2.8929	2.8839	2.8914	46249784.0
2006-11-07 13:00:00	AAPL	Stock	2.8914	2.8921	2.8832	2.8871	44463440.0
2006-11-07 14:00:00	AAPL	Stock	2.8871	2.8879	2.8732	2.8818	83579468.0
2006-11-07 15:00:00	AAPL	Stock	2.8821	2.8907	2.8686	2.875	112907396.0
2006-11-07 16:00:00	AAPL	Stock	2.8754	2.8768	2.8736	2.8739	3765328.0
2006-11-07 17:00:00	AAPL	Stock	2.8739	2.8739	2.8696	2.8696	110348.0
2006-11-07 18:00:00	AAPL	Stock	2.8729	2.8743	2.8714	2.8714	57596.0
2006-11-07 19:00:00	AAPL	Stock	2.8696	2.8714	2.8668	2.8668	86800.0
2006-11-07 07:00:00	MSFT	Stock	28.84	28.84	28.72	28.72	1700.0
2006-11-07 08:00:00	MSFT	Stock	28.78	28.93	28.75	28.91	154090.0
2006-11-07 09:00:00	MSFT	Stock	28.91	28.97	28.8	28.93	6300734.0
2006-11-07 10:00:00	MSFT	Stock	28.92	29.07	28.91	28.97	10656298.0
2006-11-07 11:00:00	MSFT	Stock	28.97	29.07	28.97	28.99	6310306.0
2006-11-07 12:00:00	MSFT	Stock	28.99	29.043	28.95	29.0	4289443.0
2006-11-07 13:00:00	MSFT	Stock	28.99	29.0	28.92	28.95	2764084.0
2006-11-07 14:00:00	MSFT	Stock	28.96	28.99	28.9	28.96	4971216.0
2006-11-07 15:00:00	MSFT	Stock	28.95	28.99	28.88	28.95	12351433.0
2006-11-07 16:00:00	MSFT	Stock	28.95	29.021	28.94	28.95	224219.0
2006-11-07 17:00:00	MSFT	Stock	28.96	28.96	28.95	28.96	3911.0
2006-11-07 18:00:00	MSFT	Stock	28.97	28.97	28.96	28.96	4000.0
2006-11-07 19:00:00	MSFT	Stock	28.99	28.99	28.99	28.99	1000.0
2006-11-07 07:00:00	NVDA	Stock	0.5613	0.5633	0.5613	0.5613	90180.0
2006-11-07 08:00:00	NVDA	Stock	0.563	0.5647	0.5613	0.5647	199320.0
2006-11-07 09:00:00	NVDA	Stock	0.5633	0.5688	0.5608	0.5632	72589140.0
2006-11-07 10:00:00	NVDA	Stock	0.5632	0.5738	0.5632	0.5702	99374640.0
2006-11-07 11:00:00	NVDA	Stock	0.57	0.5732	0.5678	0.572	53319780.0
2006-11-07 12:00:00	NVDA	Stock	0.5718	0.574	0.5712	0.5733	49423560.0
2006-11-07 13:00:00	NVDA	Stock	0.5735	0.5743	0.5708	0.5725	60145500.0
2006-11-07 14:00:00	NVDA	Stock	0.5725	0.5727	0.5645	0.5698	96309000.0
2006-11-07 15:00:00	NVDA	Stock	0.57	0.572	0.5657	0.5682	97304040.0
2006-11-07 16:00:00	NVDA	Stock	0.5678	0.5687	0.5678	0.5682	492000.0
2006-11-07 17:00:00	NVDA	Stock	0.5683	0.5725	0.5683	0.5725	72000.0
2006-11-07 18:00:00	NVDA	Stock	0.5683	0.5683	0.5683	0.5683	60000.0
2006-11-07 19:00:00	NVDA	Stock	0.5705	0.5705	0.5705	0.5705	12000.0
2006-11-07 08:00:00	AMZN	Stock	1.91	1.9245	1.91	1.9225	94400.0
2006-11-07 09:00:00	AMZN	Stock	1.92	1.9245	1.902	1.921	12262440.0
2006-11-07 10:00:00	AMZN	Stock	1.921	1.95	1.921	1.945	38942680.0
2006-11-07 11:00:00	AMZN	Stock	1.9445	1.949	1.94	1.942	27789740.0
2006-11-07 12:00:00	AMZN	Stock	1.942	1.948	1.941	1.947	7889860.0
2006-11-07 13:00:00	AMZN	Stock	1.9465	1.948	1.943	1.9465	6606280.0
2006-11-07 14:00:00	AMZN	Stock	1.9465	1.9475	1.9385	1.941	20994740.0
2006-11-07 15:00:00	AMZN	Stock	1.941	1.946	1.93	1.939	35798940.0
2006-11-07 16:00:00	AMZN	Stock	1.9385	1.9395	1.9294	1.937	213360.0
2006-11-07 17:00:00	AMZN	Stock	1.939	1.939	1.939	1.939	24000.0
2006-11-07 18:00:00	AMZN	Stock	1.9395	1.94	1.9395	1.94	46860.0

> showing 50 of 29,838 rows — these rows as CSV

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