PREVIEW / stock_1hour / 2002-05-17

all stock 1-hour files

  file:    by_date/stock_1hour/2002/2002-05-17.parquet
  size:    413 KB
  rows:    18,864
  symbols: 1,416

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-17 08:00:00	AAPL	Stock	0.4496	0.458	0.4496	0.458	347200.0
2002-05-17 09:00:00	AAPL	Stock	0.4577	0.4604	0.4514	0.4534	52141600.0
2002-05-17 10:00:00	AAPL	Stock	0.4537	0.457	0.4423	0.4468	38315200.0
2002-05-17 11:00:00	AAPL	Stock	0.447	0.4502	0.4416	0.4416	25317600.0
2002-05-17 12:00:00	AAPL	Stock	0.4414	0.4455	0.4402	0.442	19555200.0
2002-05-17 13:00:00	AAPL	Stock	0.4421	0.4436	0.4395	0.4404	21957600.0
2002-05-17 14:00:00	AAPL	Stock	0.4402	0.4445	0.4398	0.4425	14739200.0
2002-05-17 15:00:00	AAPL	Stock	0.4425	0.4473	0.442	0.4466	43780800.0
2002-05-17 16:00:00	AAPL	Stock	0.4468	0.4475	0.4431	0.4466	6602400.0
2002-05-17 17:00:00	AAPL	Stock	0.4466	0.4466	0.4466	0.4466	1036000.0
2002-05-17 08:00:00	MSFT	Stock	28.15	28.25	27.88	28.125	97400.0
2002-05-17 09:00:00	MSFT	Stock	28.13	28.18	27.78	28.0	11438800.0
2002-05-17 10:00:00	MSFT	Stock	28.01	28.2	27.675	27.825	9708000.0
2002-05-17 11:00:00	MSFT	Stock	27.83	27.905	27.665	27.685	5799000.0
2002-05-17 12:00:00	MSFT	Stock	27.69	27.875	27.665	27.775	3760400.0
2002-05-17 13:00:00	MSFT	Stock	27.765	27.85	27.64	27.695	3656600.0
2002-05-17 14:00:00	MSFT	Stock	27.69	27.796	27.635	27.73	3543000.0
2002-05-17 15:00:00	MSFT	Stock	27.7255	28.065	27.705	28.025	9380600.0
2002-05-17 16:00:00	MSFT	Stock	28.025	28.055	27.845	28.015	3802000.0
2002-05-17 17:00:00	MSFT	Stock	28.0	28.0498	28.0	28.015	290400.0
2002-05-17 18:00:00	MSFT	Stock	28.0	28.0	27.955	28.0	800.0
2002-05-17 08:00:00	NVDA	Stock	0.325	0.3317	0.3173	0.3266	4644000.0
2002-05-17 09:00:00	NVDA	Stock	0.3266	0.3266	0.3169	0.3222	187116000.0
2002-05-17 10:00:00	NVDA	Stock	0.3237	0.325	0.3182	0.3212	209988000.0
2002-05-17 11:00:00	NVDA	Stock	0.3211	0.3224	0.3187	0.3187	62688000.0
2002-05-17 12:00:00	NVDA	Stock	0.3189	0.3258	0.3186	0.324	94656000.0
2002-05-17 13:00:00	NVDA	Stock	0.324	0.3258	0.3212	0.3219	103872000.0
2002-05-17 14:00:00	NVDA	Stock	0.3219	0.324	0.3213	0.3234	52596000.0
2002-05-17 15:00:00	NVDA	Stock	0.3236	0.3273	0.3233	0.3263	155604000.0
2002-05-17 16:00:00	NVDA	Stock	0.3264	0.327	0.3229	0.327	27024000.0
2002-05-17 17:00:00	NVDA	Stock	0.3269	0.3269	0.3258	0.3258	1704000.0
2002-05-17 18:00:00	NVDA	Stock	0.3267	0.3267	0.3267	0.3267	60000.0
2002-05-17 08:00:00	AMZN	Stock	0.995	1.009	0.991	1.0	278000.0
2002-05-17 09:00:00	AMZN	Stock	1.0	1.005	0.9815	0.9865	17856000.0
2002-05-17 10:00:00	AMZN	Stock	0.9864	0.99	0.9675	0.9779	19274000.0
2002-05-17 11:00:00	AMZN	Stock	0.978	0.979	0.95	0.95	13808000.0
2002-05-17 12:00:00	AMZN	Stock	0.95	0.9665	0.95	0.9575	18642000.0
2002-05-17 13:00:00	AMZN	Stock	0.957	0.9575	0.942	0.9475	16456000.0
2002-05-17 14:00:00	AMZN	Stock	0.9475	0.953	0.9405	0.948	12234000.0
2002-05-17 15:00:00	AMZN	Stock	0.948	0.9625	0.9475	0.9575	21700000.0
2002-05-17 16:00:00	AMZN	Stock	0.957	0.964	0.9545	0.9545	2346000.0
2002-05-17 17:00:00	AMZN	Stock	0.9525	0.958	0.9525	0.958	166000.0
2002-05-17 18:00:00	AMZN	Stock	0.955	0.955	0.95	0.95	38000.0
2002-05-17 09:00:00	CL	Stock	27.75	27.85	27.7	27.705	374800.0
2002-05-17 10:00:00	CL	Stock	27.71	27.71	27.405	27.455	637800.0
2002-05-17 11:00:00	CL	Stock	27.45	27.49	27.34	27.35	486800.0
2002-05-17 12:00:00	CL	Stock	27.35	27.475	27.325	27.325	199600.0
2002-05-17 13:00:00	CL	Stock	27.325	27.41	27.29	27.335	233200.0
2002-05-17 14:00:00	CL	Stock	27.34	27.44	27.335	27.42	358400.0
2002-05-17 15:00:00	CL	Stock	27.44	27.535	27.4	27.525	687200.0

> showing 50 of 18,864 rows — these rows as CSV

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