PREVIEW / stock_1hour / 2006-08-28

all stock 1-hour files

  file:    by_date/stock_1hour/2006/2006-08-28.parquet
  size:    607 KB
  rows:    29,226
  symbols: 2,331

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-08-28 05:00:00	AAPL	Stock	2.4482	2.4482	2.4482	2.4482	28000.0
2006-08-28 08:00:00	AAPL	Stock	2.4546	2.4593	2.4496	2.4554	960120.0
2006-08-28 09:00:00	AAPL	Stock	2.4543	2.455	2.4254	2.4418	117710152.0
2006-08-28 10:00:00	AAPL	Stock	2.4418	2.4439	2.4207	2.4304	144475548.0
2006-08-28 11:00:00	AAPL	Stock	2.4304	2.4364	2.4168	2.4268	70844732.0
2006-08-28 12:00:00	AAPL	Stock	2.4264	2.4271	2.4039	2.4089	82776148.0
2006-08-28 13:00:00	AAPL	Stock	2.4086	2.4154	2.3814	2.3993	142824920.0
2006-08-28 14:00:00	AAPL	Stock	2.3989	2.4011	2.3875	2.3979	73322396.0
2006-08-28 15:00:00	AAPL	Stock	2.3975	2.3996	2.3861	2.3929	88244632.0
2006-08-28 16:00:00	AAPL	Stock	2.3946	2.3954	2.39	2.3929	1354444.0
2006-08-28 17:00:00	AAPL	Stock	2.3929	2.3982	2.3929	2.3964	347312.0
2006-08-28 18:00:00	AAPL	Stock	2.3979	2.3979	2.3936	2.3943	67200.0
2006-08-28 07:00:00	MSFT	Stock	25.83	25.83	25.83	25.83	500.0
2006-08-28 08:00:00	MSFT	Stock	25.83	25.9	25.83	25.85	1550.0
2006-08-28 09:00:00	MSFT	Stock	25.86	25.86	25.69	25.73	4074288.0
2006-08-28 10:00:00	MSFT	Stock	25.73	25.92	25.7	25.86	4464396.0
2006-08-28 11:00:00	MSFT	Stock	25.87	25.92	25.81	25.9	4218650.0
2006-08-28 12:00:00	MSFT	Stock	25.9	26.0	25.87	25.89	5407215.0
2006-08-28 13:00:00	MSFT	Stock	25.89	25.91	25.77	25.88	3129093.0
2006-08-28 14:00:00	MSFT	Stock	25.89	25.93	25.82	25.86	4120409.0
2006-08-28 15:00:00	MSFT	Stock	25.86	25.99	25.85	25.95	6359306.0
2006-08-28 16:00:00	MSFT	Stock	25.95	26.01	25.833	25.99	124316.0
2006-08-28 17:00:00	MSFT	Stock	25.95	25.95	25.855	25.855	1800.0
2006-08-28 18:00:00	MSFT	Stock	25.89	25.98	25.89	25.94	1100.0
2006-08-28 07:00:00	NVDA	Stock	0.45	0.45	0.45	0.45	389880.0
2006-08-28 08:00:00	NVDA	Stock	0.45	0.45	0.4467	0.4473	1524000.0
2006-08-28 09:00:00	NVDA	Stock	0.447	0.4597	0.4467	0.4591	119005440.0
2006-08-28 10:00:00	NVDA	Stock	0.4592	0.4695	0.459	0.4618	215576820.0
2006-08-28 11:00:00	NVDA	Stock	0.4618	0.464	0.4572	0.4605	122014980.0
2006-08-28 12:00:00	NVDA	Stock	0.4603	0.4605	0.4538	0.4558	89406720.0
2006-08-28 13:00:00	NVDA	Stock	0.4558	0.4598	0.454	0.4595	51023760.0
2006-08-28 14:00:00	NVDA	Stock	0.4597	0.4598	0.4552	0.4572	53370000.0
2006-08-28 15:00:00	NVDA	Stock	0.4573	0.4582	0.4537	0.4565	99588360.0
2006-08-28 16:00:00	NVDA	Stock	0.4563	0.4565	0.4548	0.4555	508740.0
2006-08-28 17:00:00	NVDA	Stock	0.4563	0.4592	0.456	0.4563	479040.0
2006-08-28 18:00:00	NVDA	Stock	0.4565	0.4565	0.4565	0.4565	55740.0
2006-08-28 08:00:00	AMZN	Stock	1.4015	1.44	1.4015	1.4215	404280.0
2006-08-28 09:00:00	AMZN	Stock	1.418	1.4275	1.4135	1.4245	14321760.0
2006-08-28 10:00:00	AMZN	Stock	1.4255	1.449	1.4255	1.445	22243700.0
2006-08-28 11:00:00	AMZN	Stock	1.446	1.448	1.4395	1.4464	18589420.0
2006-08-28 12:00:00	AMZN	Stock	1.446	1.449	1.444	1.4455	6849720.0
2006-08-28 13:00:00	AMZN	Stock	1.4455	1.448	1.436	1.448	11292780.0
2006-08-28 14:00:00	AMZN	Stock	1.4475	1.45	1.4415	1.448	11959280.0
2006-08-28 15:00:00	AMZN	Stock	1.448	1.449	1.44	1.4469	30097480.0
2006-08-28 16:00:00	AMZN	Stock	1.4455	1.4475	1.4324	1.4475	258000.0
2006-08-28 17:00:00	AMZN	Stock	1.448	1.448	1.448	1.448	20000.0
2006-08-28 09:00:00	CL	Stock	29.475	29.495	29.39	29.42	317800.0
2006-08-28 10:00:00	CL	Stock	29.405	29.485	29.39	29.455	291800.0
2006-08-28 11:00:00	CL	Stock	29.47	29.5	29.435	29.49	389000.0
2006-08-28 12:00:00	CL	Stock	29.47	29.535	29.45	29.495	270000.0

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

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