PREVIEW / stock_1hour / 2002-05-01

all stock 1-hour files

  file:    by_date/stock_1hour/2002/2002-05-01.parquet
  size:    404 KB
  rows:    18,933
  symbols: 1,401

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
2002-05-01 08:00:00	AAPL	Stock	0.4334	0.4334	0.4334	0.4334	201600.0
2002-05-01 09:00:00	AAPL	Stock	0.4334	0.4339	0.4246	0.4261	22304800.0
2002-05-01 10:00:00	AAPL	Stock	0.4259	0.4261	0.4177	0.4198	52550400.0
2002-05-01 11:00:00	AAPL	Stock	0.4198	0.4211	0.4186	0.4189	21896000.0
2002-05-01 12:00:00	AAPL	Stock	0.4189	0.4207	0.418	0.4182	11418400.0
2002-05-01 13:00:00	AAPL	Stock	0.4182	0.425	0.4171	0.4229	24113600.0
2002-05-01 14:00:00	AAPL	Stock	0.4229	0.4304	0.422	0.4272	40286400.0
2002-05-01 15:00:00	AAPL	Stock	0.4275	0.4309	0.4252	0.4282	32681600.0
2002-05-01 16:00:00	AAPL	Stock	0.4277	0.4291	0.4234	0.4282	7952000.0
2002-05-01 08:00:00	MSFT	Stock	26.15	26.18	26.105	26.13	24600.0
2002-05-01 09:00:00	MSFT	Stock	26.13	26.15	25.65	25.72	6495200.0
2002-05-01 10:00:00	MSFT	Stock	25.72	25.85	25.33	25.83	17916000.0
2002-05-01 11:00:00	MSFT	Stock	25.82	25.84	25.5	25.775	7983000.0
2002-05-01 12:00:00	MSFT	Stock	25.775	26.035	25.705	25.9	7364200.0
2002-05-01 13:00:00	MSFT	Stock	25.9015	26.231	25.774	26.18	7855600.0
2002-05-01 14:00:00	MSFT	Stock	26.169	26.595	26.145	26.3895	12204200.0
2002-05-01 15:00:00	MSFT	Stock	26.385	26.5195	26.225	26.37	11975400.0
2002-05-01 16:00:00	MSFT	Stock	26.37	26.47	25.9597	26.38	1770400.0
2002-05-01 17:00:00	MSFT	Stock	25.89	26.405	25.89	26.395	42200.0
2002-05-01 18:00:00	MSFT	Stock	26.4	26.425	26.38	26.38	2800.0
2002-05-01 08:00:00	NVDA	Stock	0.2912	0.292	0.2901	0.2901	396000.0
2002-05-01 09:00:00	NVDA	Stock	0.2901	0.2911	0.2802	0.2848	257544000.0
2002-05-01 10:00:00	NVDA	Stock	0.2848	0.285	0.2779	0.2808	279276000.0
2002-05-01 11:00:00	NVDA	Stock	0.2809	0.2846	0.2785	0.2846	126480000.0
2002-05-01 12:00:00	NVDA	Stock	0.2846	0.2892	0.284	0.285	206688000.0
2002-05-01 13:00:00	NVDA	Stock	0.2851	0.295	0.2821	0.2905	284160000.0
2002-05-01 14:00:00	NVDA	Stock	0.2904	0.2967	0.2895	0.2961	218136000.0
2002-05-01 15:00:00	NVDA	Stock	0.2962	0.2994	0.2942	0.2954	301476000.0
2002-05-01 16:00:00	NVDA	Stock	0.2954	0.2967	0.2952	0.2962	29580000.0
2002-05-01 17:00:00	NVDA	Stock	0.2966	0.2966	0.2959	0.2966	348000.0
2002-05-01 18:00:00	NVDA	Stock	0.2959	0.2967	0.2959	0.2967	552000.0
2002-05-01 08:00:00	AMZN	Stock	0.8375	0.8375	0.8345	0.8345	58000.0
2002-05-01 09:00:00	AMZN	Stock	0.8275	0.8335	0.8251	0.8295	16628000.0
2002-05-01 10:00:00	AMZN	Stock	0.8295	0.849	0.825	0.8485	40248000.0
2002-05-01 11:00:00	AMZN	Stock	0.8485	0.8525	0.841	0.844	22342000.0
2002-05-01 12:00:00	AMZN	Stock	0.844	0.845	0.831	0.831	14700000.0
2002-05-01 13:00:00	AMZN	Stock	0.831	0.834	0.821	0.83	18476000.0
2002-05-01 14:00:00	AMZN	Stock	0.8285	0.8425	0.8285	0.8355	14536000.0
2002-05-01 15:00:00	AMZN	Stock	0.8355	0.839	0.8225	0.825	20806000.0
2002-05-01 16:00:00	AMZN	Stock	0.825	0.833	0.8245	0.8275	800000.0
2002-05-01 17:00:00	AMZN	Stock	0.8245	0.8245	0.8245	0.8245	4000.0
2002-05-01 09:00:00	CL	Stock	26.63	26.825	26.63	26.7	476200.0
2002-05-01 10:00:00	CL	Stock	26.705	26.875	26.65	26.69	525800.0
2002-05-01 11:00:00	CL	Stock	26.7	26.775	26.645	26.77	260800.0
2002-05-01 12:00:00	CL	Stock	26.765	26.765	26.715	26.755	481400.0
2002-05-01 13:00:00	CL	Stock	26.76	26.95	26.725	26.905	325600.0
2002-05-01 14:00:00	CL	Stock	26.905	26.91	26.78	26.82	636800.0
2002-05-01 15:00:00	CL	Stock	26.825	26.85	26.75	26.785	863800.0
2002-05-01 16:00:00	CL	Stock	26.785	26.785	26.775	26.775	658400.0

> showing 49 of 18,933 rows — these rows as CSV

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