PREVIEW / stock_1hour / 2006-11-14

all stock 1-hour files

  file:    by_date/stock_1hour/2006/2006-11-14.parquet
  size:    636 KB
  rows:    30,282
  symbols: 2,445

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-14 07:00:00	AAPL	Stock	3.0054	3.0054	2.9964	2.9964	100800.0
2006-11-14 08:00:00	AAPL	Stock	3.0036	3.0336	2.9982	3.0279	2592828.0
2006-11-14 09:00:00	AAPL	Stock	3.0261	3.0514	3.0179	3.0329	83021848.0
2006-11-14 10:00:00	AAPL	Stock	3.0325	3.0357	2.9964	3.0089	135280600.0
2006-11-14 11:00:00	AAPL	Stock	3.0092	3.0286	3.0	3.0225	74222820.0
2006-11-14 12:00:00	AAPL	Stock	3.0225	3.0229	3.0036	3.0159	55254444.0
2006-11-14 13:00:00	AAPL	Stock	3.0157	3.0243	3.0075	3.0114	61397616.0
2006-11-14 14:00:00	AAPL	Stock	3.0114	3.0321	3.0106	3.0301	54544000.0
2006-11-14 15:00:00	AAPL	Stock	3.0304	3.0357	3.0264	3.0357	103988360.0
2006-11-14 16:00:00	AAPL	Stock	3.0346	3.0421	3.0332	3.0343	4947012.0
2006-11-14 17:00:00	AAPL	Stock	3.035	3.0357	3.0343	3.0357	161364.0
2006-11-14 18:00:00	AAPL	Stock	3.0332	3.0332	3.0321	3.0321	170016.0
2006-11-14 19:00:00	AAPL	Stock	3.0321	3.0336	3.0289	3.0321	412608.0
2006-11-14 07:00:00	MSFT	Stock	29.35	29.35	29.22	29.22	200.0
2006-11-14 08:00:00	MSFT	Stock	29.34	29.38	29.32	29.35	147465.0
2006-11-14 09:00:00	MSFT	Stock	29.33	29.42	29.24	29.34	8206749.0
2006-11-14 10:00:00	MSFT	Stock	29.332	29.34	29.24	29.28	6460093.0
2006-11-14 11:00:00	MSFT	Stock	29.28	29.28	29.15	29.162	6285433.0
2006-11-14 12:00:00	MSFT	Stock	29.16	29.2	29.07	29.2	6494274.0
2006-11-14 13:00:00	MSFT	Stock	29.19	29.24	29.11	29.14	5770071.0
2006-11-14 14:00:00	MSFT	Stock	29.131	29.25	29.11	29.25	7622193.0
2006-11-14 15:00:00	MSFT	Stock	29.25	29.27	29.19	29.22	9664007.0
2006-11-14 16:00:00	MSFT	Stock	29.22	29.24	29.14	29.14	1457563.0
2006-11-14 17:00:00	MSFT	Stock	29.15	29.19	29.14	29.15	5976.0
2006-11-14 18:00:00	MSFT	Stock	29.17	29.19	29.17	29.17	1075.0
2006-11-14 19:00:00	MSFT	Stock	29.17	29.17	29.15	29.15	2825.0
2006-11-14 08:00:00	NVDA	Stock	0.608	0.608	0.6002	0.6043	935820.0
2006-11-14 09:00:00	NVDA	Stock	0.605	0.6068	0.5912	0.5925	81676500.0
2006-11-14 10:00:00	NVDA	Stock	0.5923	0.5953	0.585	0.592	95630040.0
2006-11-14 11:00:00	NVDA	Stock	0.5922	0.5962	0.5903	0.5925	68228160.0
2006-11-14 12:00:00	NVDA	Stock	0.5925	0.6005	0.5908	0.6002	65669220.0
2006-11-14 13:00:00	NVDA	Stock	0.6002	0.604	0.5972	0.598	107108280.0
2006-11-14 14:00:00	NVDA	Stock	0.598	0.6008	0.5958	0.6006	64244340.0
2006-11-14 15:00:00	NVDA	Stock	0.6005	0.6072	0.6003	0.606	120364500.0
2006-11-14 16:00:00	NVDA	Stock	0.6065	0.6065	0.6053	0.6053	3114540.0
2006-11-14 17:00:00	NVDA	Stock	0.6058	0.6062	0.6058	0.6062	774480.0
2006-11-14 18:00:00	NVDA	Stock	0.6062	0.6062	0.6062	0.6062	60000.0
2006-11-14 19:00:00	NVDA	Stock	0.606	0.6077	0.606	0.606	113520.0
2006-11-14 08:00:00	AMZN	Stock	2.005	2.0175	1.9915	2.0145	301500.0
2006-11-14 09:00:00	AMZN	Stock	2.0125	2.024	2.0	2.0155	29970560.0
2006-11-14 10:00:00	AMZN	Stock	2.016	2.025	1.981	2.002	35246480.0
2006-11-14 11:00:00	AMZN	Stock	2.002	2.005	1.995	2.0035	18868580.0
2006-11-14 12:00:00	AMZN	Stock	2.0035	2.0135	1.997	2.012	11896200.0
2006-11-14 13:00:00	AMZN	Stock	2.0115	2.0305	2.011	2.022	22226300.0
2006-11-14 14:00:00	AMZN	Stock	2.0215	2.049	2.019	2.047	25685080.0
2006-11-14 15:00:00	AMZN	Stock	2.047	2.0835	2.0465	2.0755	69194020.0
2006-11-14 16:00:00	AMZN	Stock	2.0765	2.095	2.072	2.08	1167500.0
2006-11-14 17:00:00	AMZN	Stock	2.08	2.0845	2.077	2.077	75500.0
2006-11-14 18:00:00	AMZN	Stock	2.0775	2.0845	2.077	2.0845	38000.0
2006-11-14 19:00:00	AMZN	Stock	2.078	2.078	2.078	2.078	12000.0

> showing 50 of 30,282 rows — these rows as CSV

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