PREVIEW / stock_1hour / 2001-08-22

all stock 1-hour files

  file:    by_date/stock_1hour/2001/2001-08-22.parquet
  size:    366 KB
  rows:    17,245
  symbols: 1,336

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-22 08:00:00	AAPL	Stock	0.3214	0.3221	0.32	0.3221	229600.0
2001-08-22 09:00:00	AAPL	Stock	0.3216	0.3232	0.3173	0.3213	19712000.0
2001-08-22 10:00:00	AAPL	Stock	0.3218	0.3232	0.3191	0.3196	20770400.0
2001-08-22 11:00:00	AAPL	Stock	0.3195	0.3218	0.3145	0.3213	23576000.0
2001-08-22 12:00:00	AAPL	Stock	0.3211	0.3215	0.317	0.3177	16329600.0
2001-08-22 13:00:00	AAPL	Stock	0.3177	0.3195	0.3145	0.3161	20680800.0
2001-08-22 14:00:00	AAPL	Stock	0.3161	0.3236	0.3155	0.3227	26353600.0
2001-08-22 15:00:00	AAPL	Stock	0.3227	0.3259	0.3205	0.3254	21627200.0
2001-08-22 16:00:00	AAPL	Stock	0.3254	0.3259	0.3216	0.3252	5292000.0
2001-08-22 18:00:00	AAPL	Stock	0.3245	0.3245	0.3245	0.3245	11200.0
2001-08-22 08:00:00	MSFT	Stock	30.6	30.765	30.3975	30.675	331000.0
2001-08-22 09:00:00	MSFT	Stock	30.765	30.765	30.225	30.325	7895800.0
2001-08-22 10:00:00	MSFT	Stock	30.365	30.4	29.81	29.81	14795800.0
2001-08-22 11:00:00	MSFT	Stock	29.805	30.0	29.675	29.95	9466600.0
2001-08-22 12:00:00	MSFT	Stock	29.95	30.055	29.85	29.875	5588400.0
2001-08-22 13:00:00	MSFT	Stock	29.875	29.89	29.615	29.625	5626600.0
2001-08-22 14:00:00	MSFT	Stock	29.63	30.375	29.54	30.345	9699400.0
2001-08-22 15:00:00	MSFT	Stock	30.345	30.48	30.05	30.32	8088600.0
2001-08-22 16:00:00	MSFT	Stock	30.325	30.5645	30.043	30.395	2079000.0
2001-08-22 17:00:00	MSFT	Stock	30.395	30.4	30.365	30.4	4000.0
2001-08-22 08:00:00	NVDA	Stock	0.3458	0.3481	0.3438	0.3458	3456000.0
2001-08-22 09:00:00	NVDA	Stock	0.3458	0.3467	0.3372	0.3421	185208000.0
2001-08-22 10:00:00	NVDA	Stock	0.3421	0.3448	0.3358	0.338	272736000.0
2001-08-22 11:00:00	NVDA	Stock	0.338	0.3417	0.3344	0.3409	171552000.0
2001-08-22 12:00:00	NVDA	Stock	0.3409	0.3441	0.34	0.3419	81312000.0
2001-08-22 13:00:00	NVDA	Stock	0.3419	0.3427	0.3379	0.338	62400000.0
2001-08-22 14:00:00	NVDA	Stock	0.3379	0.351	0.3365	0.351	218736000.0
2001-08-22 15:00:00	NVDA	Stock	0.351	0.3535	0.3485	0.3533	249288000.0
2001-08-22 16:00:00	NVDA	Stock	0.3535	0.3552	0.3525	0.3552	16776000.0
2001-08-22 17:00:00	NVDA	Stock	0.3545	0.3551	0.3542	0.3542	168000.0
2001-08-22 18:00:00	NVDA	Stock	0.3542	0.3542	0.3541	0.3541	48000.0
2001-08-22 08:00:00	AMZN	Stock	0.4942	0.51	0.4942	0.5085	292000.0
2001-08-22 09:00:00	AMZN	Stock	0.505	0.5095	0.4925	0.495	11992000.0
2001-08-22 10:00:00	AMZN	Stock	0.495	0.4966	0.485	0.4895	10170000.0
2001-08-22 11:00:00	AMZN	Stock	0.4875	0.4885	0.4794	0.4885	8306000.0
2001-08-22 12:00:00	AMZN	Stock	0.488	0.4965	0.488	0.493	6192000.0
2001-08-22 13:00:00	AMZN	Stock	0.493	0.5	0.491	0.4915	6344000.0
2001-08-22 14:00:00	AMZN	Stock	0.4915	0.505	0.4865	0.5035	14474000.0
2001-08-22 15:00:00	AMZN	Stock	0.5035	0.5115	0.4995	0.5095	11576000.0
2001-08-22 16:00:00	AMZN	Stock	0.51	0.5125	0.505	0.511	2078000.0
2001-08-22 17:00:00	AMZN	Stock	0.511	0.511	0.511	0.511	44000.0
2001-08-22 18:00:00	AMZN	Stock	0.5105	0.511	0.5105	0.511	10000.0
2001-08-22 09:00:00	CL	Stock	27.85	27.875	27.67	27.695	351200.0
2001-08-22 10:00:00	CL	Stock	27.695	27.81	27.555	27.76	413600.0
2001-08-22 11:00:00	CL	Stock	27.765	27.975	27.755	27.975	352600.0
2001-08-22 12:00:00	CL	Stock	27.97	28.01	27.85	27.995	417800.0
2001-08-22 13:00:00	CL	Stock	28.0	28.005	27.825	27.85	243000.0
2001-08-22 14:00:00	CL	Stock	27.86	28.2	27.85	28.125	470000.0
2001-08-22 15:00:00	CL	Stock	28.1	28.2	28.055	28.09	727800.0
2001-08-22 16:00:00	CL	Stock	28.1	28.1	28.095	28.1	81600.0

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

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