PREVIEW / stock_1hour / 2005-10-21

all stock 1-hour files

  file:    by_date/stock_1hour/2005/2005-10-21.parquet
  size:    583 KB
  rows:    27,476
  symbols: 2,087

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-21 08:00:00	AAPL	Stock	2.025	2.0354	2.0179	2.0246	1072064.0
2005-10-21 09:00:00	AAPL	Stock	2.0239	2.035	1.9968	2.0057	173745404.0
2005-10-21 10:00:00	AAPL	Stock	2.0057	2.0107	1.9857	1.9918	133320964.0
2005-10-21 11:00:00	AAPL	Stock	1.9918	2.0036	1.9793	1.9886	93054836.0
2005-10-21 12:00:00	AAPL	Stock	1.9886	2.0036	1.9771	2.0015	107440788.0
2005-10-21 13:00:00	AAPL	Stock	2.0014	2.0068	1.9875	1.9914	94552976.0
2005-10-21 14:00:00	AAPL	Stock	1.9914	1.9946	1.9864	1.9886	67021108.0
2005-10-21 15:00:00	AAPL	Stock	1.9889	1.9939	1.9811	1.9868	109566324.0
2005-10-21 16:00:00	AAPL	Stock	1.985	1.9929	1.985	1.99	1406300.0
2005-10-21 17:00:00	AAPL	Stock	1.9893	1.9984	1.9875	1.9879	2976148.0
2005-10-21 18:00:00	AAPL	Stock	1.9864	1.9868	1.9821	1.9821	77700.0
2005-10-21 08:00:00	MSFT	Stock	24.89	24.91	24.86	24.9	69305.0
2005-10-21 09:00:00	MSFT	Stock	24.9	25.0	24.8	24.82	12198211.0
2005-10-21 10:00:00	MSFT	Stock	24.81	24.85	24.63	24.65	11025330.0
2005-10-21 11:00:00	MSFT	Stock	24.66	24.73	24.58	24.62	7610934.0
2005-10-21 12:00:00	MSFT	Stock	24.62	24.79	24.57	24.78	7483800.0
2005-10-21 13:00:00	MSFT	Stock	24.78	24.96	24.73	24.91	9972750.0
2005-10-21 14:00:00	MSFT	Stock	24.91	24.91	24.77	24.81	5274318.0
2005-10-21 15:00:00	MSFT	Stock	24.82	24.83	24.73	24.76	9617493.0
2005-10-21 16:00:00	MSFT	Stock	24.76	24.8	24.75	24.75	2427542.0
2005-10-21 17:00:00	MSFT	Stock	24.78	24.8	24.77	24.8	937490.0
2005-10-21 18:00:00	MSFT	Stock	24.77	24.77	24.74	24.74	8200.0
2005-10-21 08:00:00	NVDA	Stock	0.2654	0.2667	0.2654	0.2667	84000.0
2005-10-21 09:00:00	NVDA	Stock	0.2664	0.27	0.2654	0.2667	33698280.0
2005-10-21 10:00:00	NVDA	Stock	0.2667	0.2692	0.2643	0.2648	53597640.0
2005-10-21 11:00:00	NVDA	Stock	0.2649	0.267	0.2649	0.2665	24964800.0
2005-10-21 12:00:00	NVDA	Stock	0.2664	0.2684	0.2662	0.2684	32930280.0
2005-10-21 13:00:00	NVDA	Stock	0.2685	0.2687	0.2675	0.2685	25693440.0
2005-10-21 14:00:00	NVDA	Stock	0.2684	0.2693	0.2679	0.2682	36065520.0
2005-10-21 15:00:00	NVDA	Stock	0.2682	0.2692	0.2662	0.2667	76844880.0
2005-10-21 16:00:00	NVDA	Stock	0.2664	0.2704	0.2662	0.27	1842000.0
2005-10-21 17:00:00	NVDA	Stock	0.27	0.27	0.2659	0.2676	3580800.0
2005-10-21 08:00:00	AMZN	Stock	2.2845	2.2845	2.2705	2.2705	32000.0
2005-10-21 09:00:00	AMZN	Stock	2.275	2.291	2.2635	2.265	17675880.0
2005-10-21 10:00:00	AMZN	Stock	2.2655	2.289	2.2575	2.2775	15188320.0
2005-10-21 11:00:00	AMZN	Stock	2.2775	2.299	2.271	2.2785	12599080.0
2005-10-21 12:00:00	AMZN	Stock	2.2785	2.302	2.2725	2.3	9689420.0
2005-10-21 13:00:00	AMZN	Stock	2.3	2.3025	2.292	2.2955	6215180.0
2005-10-21 14:00:00	AMZN	Stock	2.295	2.296	2.288	2.2945	7849800.0
2005-10-21 15:00:00	AMZN	Stock	2.2945	2.2985	2.288	2.297	17079880.0
2005-10-21 16:00:00	AMZN	Stock	2.2975	2.301	2.295	2.3005	472660.0
2005-10-21 17:00:00	AMZN	Stock	2.301	2.302	2.294	2.302	56000.0
2005-10-21 18:00:00	AMZN	Stock	2.2975	2.2975	2.2975	2.2975	6780.0
2005-10-21 09:00:00	CL	Stock	26.09	26.255	25.975	26.09	445000.0
2005-10-21 10:00:00	CL	Stock	26.09	26.09	25.895	25.91	500000.0
2005-10-21 11:00:00	CL	Stock	25.915	25.9335	25.815	25.86	584000.0
2005-10-21 12:00:00	CL	Stock	25.86	26.025	25.815	26.025	411400.0
2005-10-21 13:00:00	CL	Stock	26.025	26.1	25.96	26.095	289200.0
2005-10-21 14:00:00	CL	Stock	26.095	26.135	25.995	26.09	302200.0
2005-10-21 15:00:00	CL	Stock	26.085	26.14	26.005	26.05	449200.0

> showing 50 of 27,476 rows — these rows as CSV

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