PREVIEW / stock_1hour / 2001-08-17

all stock 1-hour files

  file:    by_date/stock_1hour/2001/2001-08-17.parquet
  size:    354 KB
  rows:    17,145
  symbols: 1,322

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-17 08:00:00	AAPL	Stock	0.3223	0.3223	0.3223	0.3223	16800.0
2001-08-17 09:00:00	AAPL	Stock	0.3311	0.3311	0.3214	0.3246	31701600.0
2001-08-17 10:00:00	AAPL	Stock	0.3246	0.3261	0.3213	0.3227	47700800.0
2001-08-17 11:00:00	AAPL	Stock	0.3225	0.3261	0.3223	0.3246	17640000.0
2001-08-17 12:00:00	AAPL	Stock	0.3245	0.3261	0.323	0.3234	9581600.0
2001-08-17 13:00:00	AAPL	Stock	0.3234	0.3275	0.3232	0.3252	12264000.0
2001-08-17 14:00:00	AAPL	Stock	0.325	0.327	0.3236	0.3252	16648800.0
2001-08-17 15:00:00	AAPL	Stock	0.3254	0.3264	0.3214	0.3227	47689600.0
2001-08-17 16:00:00	AAPL	Stock	0.3229	0.3263	0.3221	0.3227	15696800.0
2001-08-17 17:00:00	AAPL	Stock	0.3216	0.3216	0.3216	0.3216	22400.0
2001-08-17 18:00:00	AAPL	Stock	0.323	0.323	0.323	0.323	5600.0
2001-08-17 08:00:00	MSFT	Stock	32.175	32.31	31.875	31.95	181000.0
2001-08-17 09:00:00	MSFT	Stock	31.95	32.065	31.87	31.945	7565400.0
2001-08-17 10:00:00	MSFT	Stock	31.95	31.97	31.26	31.495	11396000.0
2001-08-17 11:00:00	MSFT	Stock	31.5	31.575	31.39	31.44	3058200.0
2001-08-17 12:00:00	MSFT	Stock	31.435	31.57	31.36	31.36	4209800.0
2001-08-17 13:00:00	MSFT	Stock	31.36	31.43	31.185	31.285	4152200.0
2001-08-17 14:00:00	MSFT	Stock	31.285	31.315	31.025	31.03	3807800.0
2001-08-17 15:00:00	MSFT	Stock	31.035	31.17	30.75	30.935	12804400.0
2001-08-17 16:00:00	MSFT	Stock	30.935	31.26	30.81	30.96	2113800.0
2001-08-17 17:00:00	MSFT	Stock	30.975	31.025	30.95	31.02	22000.0
2001-08-17 18:00:00	MSFT	Stock	31.025	31.025	30.995	30.995	2400.0
2001-08-17 08:00:00	NVDA	Stock	0.3731	0.3731	0.3646	0.365	3072000.0
2001-08-17 09:00:00	NVDA	Stock	0.3652	0.3685	0.3636	0.3642	203160000.0
2001-08-17 10:00:00	NVDA	Stock	0.3636	0.3644	0.3548	0.3609	255216000.0
2001-08-17 11:00:00	NVDA	Stock	0.3613	0.3619	0.3578	0.3604	121008000.0
2001-08-17 12:00:00	NVDA	Stock	0.3605	0.3608	0.3563	0.3574	122280000.0
2001-08-17 13:00:00	NVDA	Stock	0.3575	0.3578	0.3529	0.3534	193512000.0
2001-08-17 14:00:00	NVDA	Stock	0.3533	0.3552	0.3518	0.3533	322728000.0
2001-08-17 15:00:00	NVDA	Stock	0.3535	0.3542	0.3461	0.349	345888000.0
2001-08-17 16:00:00	NVDA	Stock	0.3484	0.3565	0.3461	0.348	23376000.0
2001-08-17 17:00:00	NVDA	Stock	0.349	0.3496	0.3483	0.3496	552000.0
2001-08-17 18:00:00	NVDA	Stock	0.3489	0.3538	0.3489	0.3538	72000.0
2001-08-17 08:00:00	AMZN	Stock	0.491	0.491	0.48	0.482	72000.0
2001-08-17 09:00:00	AMZN	Stock	0.48	0.4825	0.4725	0.477	9946000.0
2001-08-17 10:00:00	AMZN	Stock	0.477	0.4825	0.474	0.475	10694000.0
2001-08-17 11:00:00	AMZN	Stock	0.4745	0.492	0.4745	0.489	14708000.0
2001-08-17 12:00:00	AMZN	Stock	0.4895	0.5045	0.487	0.5015	14394000.0
2001-08-17 13:00:00	AMZN	Stock	0.5015	0.5045	0.4875	0.49	8544000.0
2001-08-17 14:00:00	AMZN	Stock	0.4895	0.4975	0.485	0.495	7290000.0
2001-08-17 15:00:00	AMZN	Stock	0.4945	0.501	0.489	0.4985	15436000.0
2001-08-17 16:00:00	AMZN	Stock	0.4985	0.505	0.4755	0.4995	23202000.0
2001-08-17 17:00:00	AMZN	Stock	0.4995	0.5	0.4995	0.5	28000.0
2001-08-17 18:00:00	AMZN	Stock	0.5	0.5	0.5	0.5	10000.0
2001-08-17 09:00:00	CL	Stock	27.725	27.8	27.55	27.61	399400.0
2001-08-17 10:00:00	CL	Stock	27.61	27.705	27.555	27.665	323400.0
2001-08-17 11:00:00	CL	Stock	27.67	27.825	27.655	27.82	251000.0
2001-08-17 12:00:00	CL	Stock	27.815	27.9	27.775	27.88	161600.0
2001-08-17 13:00:00	CL	Stock	27.895	27.895	27.77	27.77	179800.0
2001-08-17 14:00:00	CL	Stock	27.765	27.775	27.595	27.6	284400.0

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

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