PREVIEW / stock_1hour / 2002-05-15

all stock 1-hour files

  file:    by_date/stock_1hour/2002/2002-05-15.parquet
  size:    420 KB
  rows:    19,397
  symbols: 1,420

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-15 08:00:00	AAPL	Stock	0.4552	0.458	0.4552	0.4554	352800.0
2002-05-15 09:00:00	AAPL	Stock	0.4527	0.4532	0.4436	0.4466	60127200.0
2002-05-15 10:00:00	AAPL	Stock	0.4465	0.4486	0.4457	0.4471	31516800.0
2002-05-15 11:00:00	AAPL	Stock	0.4468	0.4634	0.4468	0.4545	72184000.0
2002-05-15 12:00:00	AAPL	Stock	0.4545	0.4563	0.4486	0.455	20893600.0
2002-05-15 13:00:00	AAPL	Stock	0.4554	0.4639	0.4539	0.4623	48529600.0
2002-05-15 14:00:00	AAPL	Stock	0.463	0.4638	0.4491	0.4529	47079200.0
2002-05-15 15:00:00	AAPL	Stock	0.4529	0.4536	0.4473	0.4514	36573600.0
2002-05-15 16:00:00	AAPL	Stock	0.4513	0.457	0.4496	0.4545	2525600.0
2002-05-15 17:00:00	AAPL	Stock	0.4536	0.4571	0.4514	0.4514	1265600.0
2002-05-15 08:00:00	MSFT	Stock	27.63	27.73	27.375	27.375	160000.0
2002-05-15 09:00:00	MSFT	Stock	27.37	27.47	26.93	27.0995	8427800.0
2002-05-15 10:00:00	MSFT	Stock	27.105	27.44	27.055	27.245	10448000.0
2002-05-15 11:00:00	MSFT	Stock	27.245	27.69	27.245	27.55	8454800.0
2002-05-15 12:00:00	MSFT	Stock	27.55	27.7	27.32	27.635	5858200.0
2002-05-15 13:00:00	MSFT	Stock	27.635	28.0145	27.61	27.95	8626000.0
2002-05-15 14:00:00	MSFT	Stock	27.94	28.22	27.41	27.55	13179000.0
2002-05-15 15:00:00	MSFT	Stock	27.55	27.6235	27.315	27.34	10287600.0
2002-05-15 16:00:00	MSFT	Stock	27.35	27.6757	27.33	27.55	1808600.0
2002-05-15 17:00:00	MSFT	Stock	27.4	27.425	27.35	27.375	200400.0
2002-05-15 08:00:00	NVDA	Stock	0.3083	0.3142	0.3033	0.3054	2232000.0
2002-05-15 09:00:00	NVDA	Stock	0.3042	0.3097	0.3007	0.3038	197136000.0
2002-05-15 10:00:00	NVDA	Stock	0.3036	0.3162	0.3031	0.3093	339720000.0
2002-05-15 11:00:00	NVDA	Stock	0.3093	0.3146	0.3092	0.3121	170760000.0
2002-05-15 12:00:00	NVDA	Stock	0.3122	0.3188	0.3106	0.3182	138048000.0
2002-05-15 13:00:00	NVDA	Stock	0.3182	0.3217	0.3171	0.3197	161568000.0
2002-05-15 14:00:00	NVDA	Stock	0.3197	0.3209	0.3083	0.3152	188460000.0
2002-05-15 15:00:00	NVDA	Stock	0.3152	0.3177	0.312	0.3156	232020000.0
2002-05-15 16:00:00	NVDA	Stock	0.3161	0.3164	0.3123	0.3123	21996000.0
2002-05-15 17:00:00	NVDA	Stock	0.3175	0.3229	0.3123	0.3171	11208000.0
2002-05-15 18:00:00	NVDA	Stock	0.3167	0.3171	0.3167	0.3171	96000.0
2002-05-15 08:00:00	AMZN	Stock	0.95	0.9515	0.939	0.939	150000.0
2002-05-15 09:00:00	AMZN	Stock	0.9375	0.95	0.9175	0.945	34270000.0
2002-05-15 10:00:00	AMZN	Stock	0.9425	0.974	0.9425	0.9685	47466000.0
2002-05-15 11:00:00	AMZN	Stock	0.969	0.9765	0.9635	0.967	19938000.0
2002-05-15 12:00:00	AMZN	Stock	0.9675	0.979	0.963	0.974	12188000.0
2002-05-15 13:00:00	AMZN	Stock	0.975	0.9945	0.972	0.992	21830000.0
2002-05-15 14:00:00	AMZN	Stock	0.993	1.02	0.991	0.9945	69502000.0
2002-05-15 15:00:00	AMZN	Stock	0.995	1.0015	0.9875	0.997	37368000.0
2002-05-15 16:00:00	AMZN	Stock	0.998	1.0	0.934	0.9965	2862000.0
2002-05-15 17:00:00	AMZN	Stock	0.999	0.999	0.9895	0.9895	270000.0
2002-05-15 18:00:00	AMZN	Stock	0.995	0.997	0.995	0.997	34000.0
2002-05-15 09:00:00	CL	Stock	27.75	27.85	27.65	27.7	369800.0
2002-05-15 10:00:00	CL	Stock	27.71	27.71	27.565	27.625	395400.0
2002-05-15 11:00:00	CL	Stock	27.625	27.74	27.585	27.68	426600.0
2002-05-15 12:00:00	CL	Stock	27.705	27.705	27.57	27.66	301600.0
2002-05-15 13:00:00	CL	Stock	27.66	27.84	27.585	27.79	341200.0
2002-05-15 14:00:00	CL	Stock	27.79	27.85	27.53	27.6	361600.0
2002-05-15 15:00:00	CL	Stock	27.62	27.765	27.575	27.75	741600.0
2002-05-15 16:00:00	CL	Stock	27.75	27.755	27.68	27.68	190200.0

> showing 50 of 19,397 rows — these rows as CSV

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