PREVIEW / stock_1hour / 2005-10-05

all stock 1-hour files

  file:    by_date/stock_1hour/2005/2005-10-05.parquet
  size:    585 KB
  rows:    28,158
  symbols: 2,083

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-05 08:00:00	AAPL	Stock	1.9411	1.9696	1.9339	1.9429	3285548.0
2005-10-05 09:00:00	AAPL	Stock	1.9429	1.9446	1.9204	1.9275	66780616.0
2005-10-05 10:00:00	AAPL	Stock	1.9275	1.9286	1.9039	1.9257	102332944.0
2005-10-05 11:00:00	AAPL	Stock	1.9254	1.9318	1.9057	1.9104	85879388.0
2005-10-05 12:00:00	AAPL	Stock	1.9104	1.9114	1.8889	1.8946	112894936.0
2005-10-05 13:00:00	AAPL	Stock	1.8946	1.91	1.8911	1.8971	53631312.0
2005-10-05 14:00:00	AAPL	Stock	1.8971	1.9196	1.8954	1.9032	60356716.0
2005-10-05 15:00:00	AAPL	Stock	1.9029	1.9029	1.8843	1.8843	115802204.0
2005-10-05 16:00:00	AAPL	Stock	1.8857	1.8893	1.8825	1.8857	2093056.0
2005-10-05 17:00:00	AAPL	Stock	1.8861	1.8981	1.8861	1.8893	560028.0
2005-10-05 18:00:00	AAPL	Stock	1.8843	1.8911	1.8843	1.8857	141400.0
2005-10-05 08:00:00	MSFT	Stock	25.04	25.1	24.95	24.98	105320.0
2005-10-05 09:00:00	MSFT	Stock	25.05	25.08	24.88	24.91	7026029.0
2005-10-05 10:00:00	MSFT	Stock	24.91	24.92	24.76	24.91	12302253.0
2005-10-05 11:00:00	MSFT	Stock	24.91	24.91	24.78	24.82	8684631.0
2005-10-05 12:00:00	MSFT	Stock	24.83	24.93	24.79	24.908	6369518.0
2005-10-05 13:00:00	MSFT	Stock	24.9	24.97	24.84	24.852	7250389.0
2005-10-05 14:00:00	MSFT	Stock	24.85	24.96	24.83	24.84	7388500.0
2005-10-05 15:00:00	MSFT	Stock	24.84	24.89	24.68	24.68	22616502.0
2005-10-05 16:00:00	MSFT	Stock	24.68	24.8	24.67	24.7	365639.0
2005-10-05 17:00:00	MSFT	Stock	24.7	24.71	24.7	24.71	15455.0
2005-10-05 18:00:00	MSFT	Stock	24.7	24.71	24.67	24.69	5905.0
2005-10-05 08:00:00	NVDA	Stock	0.2917	0.2917	0.291	0.2912	132000.0
2005-10-05 09:00:00	NVDA	Stock	0.2903	0.2903	0.2857	0.2863	59024640.0
2005-10-05 10:00:00	NVDA	Stock	0.2863	0.2863	0.2806	0.2812	144634560.0
2005-10-05 11:00:00	NVDA	Stock	0.2811	0.2815	0.2787	0.2792	80094120.0
2005-10-05 12:00:00	NVDA	Stock	0.2792	0.2833	0.2783	0.282	67643880.0
2005-10-05 13:00:00	NVDA	Stock	0.2822	0.2831	0.2811	0.2812	50181240.0
2005-10-05 14:00:00	NVDA	Stock	0.2813	0.2833	0.28	0.2812	56020440.0
2005-10-05 15:00:00	NVDA	Stock	0.2812	0.2824	0.2796	0.2799	92731320.0
2005-10-05 16:00:00	NVDA	Stock	0.2802	0.2802	0.2793	0.2801	1472040.0
2005-10-05 17:00:00	NVDA	Stock	0.2808	0.2808	0.2801	0.2808	1664400.0
2005-10-05 09:00:00	AMZN	Stock	2.245	2.2645	2.241	2.246	10629860.0
2005-10-05 10:00:00	AMZN	Stock	2.2455	2.2575	2.223	2.257	13230220.0
2005-10-05 11:00:00	AMZN	Stock	2.2565	2.2567	2.205	2.2125	16336160.0
2005-10-05 12:00:00	AMZN	Stock	2.213	2.22	2.1945	2.198	15226660.0
2005-10-05 13:00:00	AMZN	Stock	2.199	2.2325	2.198	2.2155	17539700.0
2005-10-05 14:00:00	AMZN	Stock	2.215	2.2525	2.2105	2.2415	17157280.0
2005-10-05 15:00:00	AMZN	Stock	2.2415	2.242	2.2155	2.2205	28134940.0
2005-10-05 16:00:00	AMZN	Stock	2.2215	2.2255	2.2125	2.225	418000.0
2005-10-05 17:00:00	AMZN	Stock	2.223	2.2245	2.223	2.2245	2016000.0
2005-10-05 18:00:00	AMZN	Stock	2.2245	2.225	2.2245	2.225	23000.0
2005-10-05 08:00:00	CL	Stock	26.515	26.515	26.515	26.515	600.0
2005-10-05 09:00:00	CL	Stock	26.33	26.405	26.26	26.355	363000.0
2005-10-05 10:00:00	CL	Stock	26.345	26.395	26.275	26.335	486200.0
2005-10-05 11:00:00	CL	Stock	26.315	26.49	26.28	26.36	336800.0
2005-10-05 12:00:00	CL	Stock	26.36	26.4	26.325	26.385	199000.0
2005-10-05 13:00:00	CL	Stock	26.385	26.435	26.34	26.395	215800.0
2005-10-05 14:00:00	CL	Stock	26.39	26.41	26.305	26.305	460600.0
2005-10-05 15:00:00	CL	Stock	26.305	26.375	26.205	26.205	980600.0

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

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