PREVIEW / stock_1hour / 2001-08-24

all stock 1-hour files

  file:    by_date/stock_1hour/2001/2001-08-24.parquet
  size:    361 KB
  rows:    17,041
  symbols: 1,321

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
2001-08-24 08:00:00	AAPL	Stock	0.3214	0.3232	0.3214	0.3232	61600.0
2001-08-24 09:00:00	AAPL	Stock	0.3236	0.3236	0.3152	0.3173	20720000.0
2001-08-24 10:00:00	AAPL	Stock	0.3177	0.3216	0.3173	0.3202	48389600.0
2001-08-24 11:00:00	AAPL	Stock	0.3204	0.3247	0.3193	0.3241	33689600.0
2001-08-24 12:00:00	AAPL	Stock	0.3232	0.3282	0.3232	0.3257	48608000.0
2001-08-24 13:00:00	AAPL	Stock	0.3257	0.3302	0.3257	0.327	26807200.0
2001-08-24 14:00:00	AAPL	Stock	0.327	0.3293	0.3243	0.327	20496000.0
2001-08-24 15:00:00	AAPL	Stock	0.3268	0.3325	0.3261	0.3316	32211200.0
2001-08-24 16:00:00	AAPL	Stock	0.3314	0.3325	0.3305	0.3316	12420800.0
2001-08-24 17:00:00	AAPL	Stock	0.3316	0.3316	0.3316	0.3316	403200.0
2001-08-24 18:00:00	AAPL	Stock	0.327	0.327	0.327	0.327	16800.0
2001-08-24 08:00:00	MSFT	Stock	30.075	30.075	29.825	29.85	178400.0
2001-08-24 09:00:00	MSFT	Stock	29.86	29.94	29.615	29.78	7319000.0
2001-08-24 10:00:00	MSFT	Stock	29.79	30.59	29.785	30.5	12092800.0
2001-08-24 11:00:00	MSFT	Stock	30.505	30.95	30.45	30.81	7560200.0
2001-08-24 12:00:00	MSFT	Stock	30.815	31.04	30.675	31.015	5022600.0
2001-08-24 13:00:00	MSFT	Stock	31.005	31.14	30.875	31.045	4369800.0
2001-08-24 14:00:00	MSFT	Stock	31.05	31.075	30.75	31.025	4819200.0
2001-08-24 15:00:00	MSFT	Stock	31.01	31.125	30.9	31.02	6233400.0
2001-08-24 16:00:00	MSFT	Stock	31.02	31.06	30.28	31.025	2291200.0
2001-08-24 17:00:00	MSFT	Stock	31.05	31.05	30.995	31.0	59400.0
2001-08-24 18:00:00	MSFT	Stock	31.0	31.0	31.0	31.0	200.0
2001-08-24 08:00:00	NVDA	Stock	0.3508	0.3508	0.3483	0.349	864000.0
2001-08-24 09:00:00	NVDA	Stock	0.3508	0.3517	0.3475	0.3494	90816000.0
2001-08-24 10:00:00	NVDA	Stock	0.3494	0.3545	0.3486	0.3533	179952000.0
2001-08-24 11:00:00	NVDA	Stock	0.3533	0.3557	0.3526	0.3538	89088000.0
2001-08-24 12:00:00	NVDA	Stock	0.3537	0.3591	0.3525	0.3584	74304000.0
2001-08-24 13:00:00	NVDA	Stock	0.3584	0.3625	0.3576	0.3577	125376000.0
2001-08-24 14:00:00	NVDA	Stock	0.3578	0.3583	0.3503	0.3534	165384000.0
2001-08-24 15:00:00	NVDA	Stock	0.3533	0.3577	0.351	0.3554	177000000.0
2001-08-24 16:00:00	NVDA	Stock	0.3552	0.3556	0.3542	0.3545	13536000.0
2001-08-24 17:00:00	NVDA	Stock	0.3553	0.356	0.3545	0.3558	720000.0
2001-08-24 18:00:00	NVDA	Stock	0.3558	0.3558	0.3545	0.3545	48000.0
2001-08-24 08:00:00	AMZN	Stock	0.4825	0.5	0.4825	0.4905	308000.0
2001-08-24 09:00:00	AMZN	Stock	0.4905	0.502	0.4855	0.491	8144000.0
2001-08-24 10:00:00	AMZN	Stock	0.491	0.5015	0.491	0.4955	7006000.0
2001-08-24 11:00:00	AMZN	Stock	0.495	0.501	0.4925	0.4995	6136000.0
2001-08-24 12:00:00	AMZN	Stock	0.5	0.5015	0.497	0.4995	5994000.0
2001-08-24 13:00:00	AMZN	Stock	0.4995	0.5055	0.4995	0.5035	6636000.0
2001-08-24 14:00:00	AMZN	Stock	0.5035	0.51	0.5	0.51	7748000.0
2001-08-24 15:00:00	AMZN	Stock	0.508	0.515	0.507	0.511	11144000.0
2001-08-24 16:00:00	AMZN	Stock	0.5115	0.515	0.5035	0.5115	12720000.0
2001-08-24 17:00:00	AMZN	Stock	0.5115	0.5115	0.5115	0.5115	72000.0
2001-08-24 18:00:00	AMZN	Stock	0.5125	0.5135	0.5125	0.5135	8000.0
2001-08-24 09:00:00	CL	Stock	27.985	27.985	27.835	27.94	294200.0
2001-08-24 10:00:00	CL	Stock	27.935	28.0	27.91	27.91	407800.0
2001-08-24 11:00:00	CL	Stock	27.94	28.03	27.92	28.015	484400.0
2001-08-24 12:00:00	CL	Stock	28.015	28.03	27.95	27.96	146200.0
2001-08-24 13:00:00	CL	Stock	27.96	27.975	27.8	27.8	154200.0
2001-08-24 14:00:00	CL	Stock	27.8	27.985	27.765	27.97	288800.0

> showing 50 of 17,041 rows — these rows as CSV

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