PREVIEW / stock_1hour / 2006-04-10

all stock 1-hour files

  file:    by_date/stock_1hour/2006/2006-04-10.parquet
  size:    599 KB
  rows:    28,347
  symbols: 2,225

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-04-10 06:00:00	AAPL	Stock	2.5054	2.5054	2.5054	2.5054	2800.0
2006-04-10 08:00:00	AAPL	Stock	2.4964	2.5075	2.4954	2.5036	1996260.0
2006-04-10 09:00:00	AAPL	Stock	2.5036	2.5214	2.495	2.4982	127564472.0
2006-04-10 10:00:00	AAPL	Stock	2.4982	2.5332	2.4964	2.5118	179660908.0
2006-04-10 11:00:00	AAPL	Stock	2.5118	2.5139	2.4879	2.495	120441664.0
2006-04-10 12:00:00	AAPL	Stock	2.495	2.5054	2.4746	2.4807	108874416.0
2006-04-10 13:00:00	AAPL	Stock	2.4811	2.485	2.4546	2.4596	114266852.0
2006-04-10 14:00:00	AAPL	Stock	2.4596	2.4671	2.4446	2.4554	113755376.0
2006-04-10 15:00:00	AAPL	Stock	2.455	2.4614	2.4496	2.4511	122617880.0
2006-04-10 16:00:00	AAPL	Stock	2.4507	2.4556	2.4457	2.4504	2042684.0
2006-04-10 17:00:00	AAPL	Stock	2.4504	2.4504	2.4471	2.4475	799932.0
2006-04-10 18:00:00	AAPL	Stock	2.4475	2.4833	2.4471	2.4482	323596.0
2006-04-10 06:00:00	MSFT	Stock	27.25	27.25	27.25	27.25	1000.0
2006-04-10 07:00:00	MSFT	Stock	27.24	27.24	27.24	27.24	100.0
2006-04-10 08:00:00	MSFT	Stock	27.24	27.25	27.2	27.22	21481.0
2006-04-10 09:00:00	MSFT	Stock	27.21	27.4	27.2	27.25	4076071.0
2006-04-10 10:00:00	MSFT	Stock	27.25	27.37	27.25	27.28	5478462.0
2006-04-10 11:00:00	MSFT	Stock	27.28	27.42	27.26	27.37	6945142.0
2006-04-10 12:00:00	MSFT	Stock	27.37	27.44	27.31	27.33	4444859.0
2006-04-10 13:00:00	MSFT	Stock	27.33	27.41	27.3	27.32	3741298.0
2006-04-10 14:00:00	MSFT	Stock	27.32	27.35	27.25	27.29	4098167.0
2006-04-10 15:00:00	MSFT	Stock	27.29	27.35	27.26	27.28	7651371.0
2006-04-10 16:00:00	MSFT	Stock	27.29	27.331	27.28	27.29	2045837.0
2006-04-10 17:00:00	MSFT	Stock	27.28	27.33	27.28	27.33	614.0
2006-04-10 18:00:00	MSFT	Stock	27.32	27.32	27.32	27.32	300.0
2006-04-10 08:00:00	NVDA	Stock	0.5102	0.525	0.5088	0.5088	234600.0
2006-04-10 09:00:00	NVDA	Stock	0.5083	0.5097	0.5025	0.5055	74892000.0
2006-04-10 10:00:00	NVDA	Stock	0.5055	0.5107	0.5042	0.5092	96562500.0
2006-04-10 11:00:00	NVDA	Stock	0.5092	0.5095	0.5062	0.5067	51314220.0
2006-04-10 12:00:00	NVDA	Stock	0.5065	0.5075	0.5042	0.505	39996780.0
2006-04-10 13:00:00	NVDA	Stock	0.505	0.5061	0.5017	0.5018	73519800.0
2006-04-10 14:00:00	NVDA	Stock	0.5017	0.5018	0.4962	0.4985	125757480.0
2006-04-10 15:00:00	NVDA	Stock	0.4985	0.5018	0.4978	0.4998	155793240.0
2006-04-10 16:00:00	NVDA	Stock	0.5	0.502	0.4978	0.5005	4771620.0
2006-04-10 17:00:00	NVDA	Stock	0.5	0.5017	0.5	0.5015	442200.0
2006-04-10 18:00:00	NVDA	Stock	0.5007	0.5007	0.5007	0.5007	6000.0
2006-04-10 08:00:00	AMZN	Stock	1.8695	1.8695	1.8695	1.8695	6000.0
2006-04-10 09:00:00	AMZN	Stock	1.8555	1.864	1.834	1.8375	7403660.0
2006-04-10 10:00:00	AMZN	Stock	1.8375	1.839	1.8295	1.831	12216300.0
2006-04-10 11:00:00	AMZN	Stock	1.831	1.835	1.824	1.8335	16560180.0
2006-04-10 12:00:00	AMZN	Stock	1.8335	1.8385	1.82	1.8205	9472440.0
2006-04-10 13:00:00	AMZN	Stock	1.8205	1.8285	1.82	1.8245	6946080.0
2006-04-10 14:00:00	AMZN	Stock	1.8245	1.825	1.811	1.8125	15488420.0
2006-04-10 15:00:00	AMZN	Stock	1.8125	1.835	1.812	1.8305	23907940.0
2006-04-10 16:00:00	AMZN	Stock	1.8315	1.833	1.822	1.8305	104860.0
2006-04-10 18:00:00	AMZN	Stock	1.83	1.83	1.83	1.83	10000.0
2006-04-10 09:00:00	CL	Stock	28.65	28.75	28.6	28.675	250800.0
2006-04-10 10:00:00	CL	Stock	28.655	28.71	28.575	28.665	368400.0
2006-04-10 11:00:00	CL	Stock	28.665	28.81	28.65	28.81	218800.0
2006-04-10 12:00:00	CL	Stock	28.81	28.845	28.74	28.76	246400.0

> showing 50 of 28,347 rows — these rows as CSV

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