PREVIEW / stock_1hour / 2001-11-05

all stock 1-hour files

  file:    by_date/stock_1hour/2001/2001-11-05.parquet
  size:    378 KB
  rows:    18,126
  symbols: 1,353

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-11-05 08:00:00	AAPL	Stock	0.333	0.3348	0.333	0.3348	145600.0
2001-11-05 09:00:00	AAPL	Stock	0.3338	0.34	0.3334	0.3357	23671200.0
2001-11-05 10:00:00	AAPL	Stock	0.3355	0.3391	0.3323	0.3389	36248800.0
2001-11-05 11:00:00	AAPL	Stock	0.3388	0.3438	0.3386	0.3421	38617600.0
2001-11-05 12:00:00	AAPL	Stock	0.3421	0.3438	0.3379	0.3409	30839200.0
2001-11-05 13:00:00	AAPL	Stock	0.3409	0.342	0.3389	0.34	19544000.0
2001-11-05 14:00:00	AAPL	Stock	0.3398	0.3427	0.3391	0.3423	19997600.0
2001-11-05 15:00:00	AAPL	Stock	0.3423	0.3429	0.3389	0.3423	36383200.0
2001-11-05 16:00:00	AAPL	Stock	0.3421	0.3436	0.3386	0.3405	6238400.0
2001-11-05 17:00:00	AAPL	Stock	0.3427	0.3429	0.3405	0.3429	72800.0
2001-11-05 08:00:00	MSFT	Stock	30.71	30.97	30.71	30.825	90600.0
2001-11-05 09:00:00	MSFT	Stock	30.825	31.365	30.825	31.3	8091800.0
2001-11-05 10:00:00	MSFT	Stock	31.275	31.54	31.2	31.43	9227600.0
2001-11-05 11:00:00	MSFT	Stock	31.435	31.67	31.38	31.4	6871400.0
2001-11-05 12:00:00	MSFT	Stock	31.4	31.75	31.325	31.73	6213400.0
2001-11-05 13:00:00	MSFT	Stock	31.735	32.015	31.685	31.885	8509600.0
2001-11-05 14:00:00	MSFT	Stock	31.88	32.0005	31.785	31.885	8793200.0
2001-11-05 15:00:00	MSFT	Stock	31.885	31.905	31.525	31.634	13682200.0
2001-11-05 16:00:00	MSFT	Stock	31.63	32.0	31.57	31.97	2989200.0
2001-11-05 17:00:00	MSFT	Stock	31.95	32.0	31.635	31.875	43800.0
2001-11-05 18:00:00	MSFT	Stock	31.88	31.895	31.85	31.85	9600.0
2001-11-05 08:00:00	NVDA	Stock	0.3966	0.4	0.3953	0.3953	1140000.0
2001-11-05 09:00:00	NVDA	Stock	0.4	0.4108	0.3967	0.4068	145500000.0
2001-11-05 10:00:00	NVDA	Stock	0.4067	0.4105	0.4038	0.4053	139584000.0
2001-11-05 11:00:00	NVDA	Stock	0.4052	0.4098	0.4	0.4012	90900000.0
2001-11-05 12:00:00	NVDA	Stock	0.4013	0.4051	0.3996	0.4013	73776000.0
2001-11-05 13:00:00	NVDA	Stock	0.401	0.4017	0.3942	0.3975	137088000.0
2001-11-05 14:00:00	NVDA	Stock	0.3971	0.3997	0.392	0.3984	100200000.0
2001-11-05 15:00:00	NVDA	Stock	0.3984	0.4025	0.3939	0.394	196128000.0
2001-11-05 16:00:00	NVDA	Stock	0.394	0.4	0.3939	0.3992	16944000.0
2001-11-05 17:00:00	NVDA	Stock	0.3992	0.4017	0.3945	0.3945	1104000.0
2001-11-05 18:00:00	NVDA	Stock	0.3992	0.3992	0.3992	0.3992	360000.0
2001-11-05 08:00:00	AMZN	Stock	0.343	0.3525	0.3425	0.3505	462000.0
2001-11-05 09:00:00	AMZN	Stock	0.3505	0.3555	0.35	0.3525	21910000.0
2001-11-05 10:00:00	AMZN	Stock	0.354	0.36	0.351	0.3546	23784000.0
2001-11-05 11:00:00	AMZN	Stock	0.3545	0.357	0.353	0.355	13392000.0
2001-11-05 12:00:00	AMZN	Stock	0.355	0.3555	0.3505	0.3515	8532000.0
2001-11-05 13:00:00	AMZN	Stock	0.352	0.355	0.35	0.3545	9594000.0
2001-11-05 14:00:00	AMZN	Stock	0.3545	0.356	0.348	0.352	14136000.0
2001-11-05 15:00:00	AMZN	Stock	0.351	0.354	0.348	0.3495	20216000.0
2001-11-05 16:00:00	AMZN	Stock	0.3515	0.355	0.3475	0.355	5886000.0
2001-11-05 17:00:00	AMZN	Stock	0.3545	0.3585	0.3495	0.3495	394000.0
2001-11-05 18:00:00	AMZN	Stock	0.354	0.3575	0.354	0.3575	34000.0
2001-11-05 09:00:00	CL	Stock	29.375	29.47	29.375	29.455	376600.0
2001-11-05 10:00:00	CL	Stock	29.47	29.565	29.35	29.4	363600.0
2001-11-05 11:00:00	CL	Stock	29.4	29.405	29.175	29.18	296200.0
2001-11-05 12:00:00	CL	Stock	29.175	29.2	29.135	29.2	270200.0
2001-11-05 13:00:00	CL	Stock	29.2	29.37	29.165	29.335	275400.0
2001-11-05 14:00:00	CL	Stock	29.345	29.345	29.15	29.225	328400.0
2001-11-05 15:00:00	CL	Stock	29.225	29.295	29.16	29.25	689600.0

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

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