PREVIEW / stock_1hour / 2005-10-10

all stock 1-hour files

  file:    by_date/stock_1hour/2005/2005-10-10.parquet
  size:    555 KB
  rows:    26,731
  symbols: 2,073

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
2005-10-10 07:00:00	AAPL	Stock	1.8464	1.8464	1.8411	1.8411	28000.0
2005-10-10 08:00:00	AAPL	Stock	1.8429	1.8568	1.8429	1.8471	1111712.0
2005-10-10 09:00:00	AAPL	Stock	1.8475	1.8593	1.81	1.8171	89998412.0
2005-10-10 10:00:00	AAPL	Stock	1.8168	1.8346	1.8132	1.8225	74758012.0
2005-10-10 11:00:00	AAPL	Stock	1.8225	1.8321	1.8204	1.8229	59343228.0
2005-10-10 12:00:00	AAPL	Stock	1.8225	1.8414	1.8221	1.8343	68170284.0
2005-10-10 13:00:00	AAPL	Stock	1.8343	1.8364	1.815	1.8179	39447744.0
2005-10-10 14:00:00	AAPL	Stock	1.8182	1.8196	1.8018	1.8089	73096520.0
2005-10-10 15:00:00	AAPL	Stock	1.8089	1.8161	1.7957	1.7979	90816404.0
2005-10-10 16:00:00	AAPL	Stock	1.7975	1.7989	1.7893	1.7936	2870840.0
2005-10-10 17:00:00	AAPL	Stock	1.7979	1.8054	1.7964	1.8	666456.0
2005-10-10 18:00:00	AAPL	Stock	1.7993	1.805	1.7964	1.8018	302652.0
2005-10-10 07:00:00	MSFT	Stock	24.7	24.7	24.7	24.7	1700.0
2005-10-10 08:00:00	MSFT	Stock	24.69	24.96	24.67	24.69	51478.0
2005-10-10 09:00:00	MSFT	Stock	24.7	24.72	24.5	24.57	4890095.0
2005-10-10 10:00:00	MSFT	Stock	24.57	24.601	24.39	24.43	10930932.0
2005-10-10 11:00:00	MSFT	Stock	24.43	24.5	24.35	24.422	5290579.0
2005-10-10 12:00:00	MSFT	Stock	24.43	24.53	24.43	24.5	5875779.0
2005-10-10 13:00:00	MSFT	Stock	24.5	24.6	24.49	24.55	4709151.0
2005-10-10 14:00:00	MSFT	Stock	24.55	24.56	24.39	24.46	7073590.0
2005-10-10 15:00:00	MSFT	Stock	24.46	24.5	24.4	24.46	8364547.0
2005-10-10 16:00:00	MSFT	Stock	24.45	24.49	24.41	24.44	301013.0
2005-10-10 17:00:00	MSFT	Stock	24.46	24.5	24.4	24.44	126669.0
2005-10-10 18:00:00	MSFT	Stock	24.44	24.44	24.43	24.43	13250.0
2005-10-10 08:00:00	NVDA	Stock	0.2792	0.28	0.2742	0.2752	1303200.0
2005-10-10 09:00:00	NVDA	Stock	0.2755	0.2774	0.2714	0.2725	30432960.0
2005-10-10 10:00:00	NVDA	Stock	0.2724	0.2727	0.2704	0.2715	92022000.0
2005-10-10 11:00:00	NVDA	Stock	0.2715	0.2724	0.2699	0.2712	77349240.0
2005-10-10 12:00:00	NVDA	Stock	0.2714	0.2727	0.2708	0.2723	46629360.0
2005-10-10 13:00:00	NVDA	Stock	0.2722	0.2727	0.2703	0.2714	47598000.0
2005-10-10 14:00:00	NVDA	Stock	0.2715	0.2716	0.2686	0.2692	56878200.0
2005-10-10 15:00:00	NVDA	Stock	0.2692	0.2703	0.2684	0.2689	92871000.0
2005-10-10 16:00:00	NVDA	Stock	0.2686	0.2686	0.2668	0.2668	1161600.0
2005-10-10 17:00:00	NVDA	Stock	0.2667	0.2671	0.2667	0.2667	782400.0
2005-10-10 18:00:00	NVDA	Stock	0.2692	0.2692	0.2692	0.2692	12000.0
2005-10-10 09:00:00	AMZN	Stock	2.1815	2.212	2.1765	2.2015	9021060.0
2005-10-10 10:00:00	AMZN	Stock	2.201	2.2075	2.1805	2.1985	15586340.0
2005-10-10 11:00:00	AMZN	Stock	2.1965	2.2085	2.1965	2.2035	9317900.0
2005-10-10 12:00:00	AMZN	Stock	2.2045	2.219	2.2025	2.21	7890400.0
2005-10-10 13:00:00	AMZN	Stock	2.21	2.2105	2.185	2.19	6657060.0
2005-10-10 14:00:00	AMZN	Stock	2.1895	2.1905	2.179	2.186	11173900.0
2005-10-10 15:00:00	AMZN	Stock	2.1865	2.194	2.1805	2.188	12714480.0
2005-10-10 16:00:00	AMZN	Stock	2.1885	2.2015	2.1865	2.2015	127240.0
2005-10-10 17:00:00	AMZN	Stock	2.19	2.19	2.19	2.19	20000.0
2005-10-10 18:00:00	AMZN	Stock	2.1925	2.1925	2.188	2.188	22720.0
2005-10-10 09:00:00	CL	Stock	26.25	26.35	26.19	26.25	311800.0
2005-10-10 10:00:00	CL	Stock	26.25	26.395	26.24	26.3	685000.0
2005-10-10 11:00:00	CL	Stock	26.295	26.345	26.25	26.28	421400.0
2005-10-10 12:00:00	CL	Stock	26.275	26.35	26.26	26.3	333800.0
2005-10-10 13:00:00	CL	Stock	26.3	26.3	26.25	26.275	266200.0

> showing 50 of 26,731 rows — these rows as CSV

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