PREVIEW / stock_1hour / 2001-04-18

all stock 1-hour files

  file:    by_date/stock_1hour/2001/2001-04-18.parquet
  size:    362 KB
  rows:    16,998
  symbols: 1,292

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-04-18 08:00:00	AAPL	Stock	0.3691	0.3839	0.3686	0.3795	1640800.0
2001-04-18 09:00:00	AAPL	Stock	0.3811	0.3884	0.375	0.388	125529600.0
2001-04-18 10:00:00	AAPL	Stock	0.388	0.4018	0.3836	0.3991	149721600.0
2001-04-18 11:00:00	AAPL	Stock	0.3975	0.4179	0.3946	0.4155	220847200.0
2001-04-18 12:00:00	AAPL	Stock	0.4155	0.42	0.4116	0.4195	84660800.0
2001-04-18 13:00:00	AAPL	Stock	0.4184	0.4264	0.4168	0.4241	90227200.0
2001-04-18 14:00:00	AAPL	Stock	0.4241	0.4263	0.4071	0.4086	113103200.0
2001-04-18 15:00:00	AAPL	Stock	0.4088	0.4136	0.393	0.4068	160759200.0
2001-04-18 16:00:00	AAPL	Stock	0.4061	0.4161	0.3839	0.407	14100800.0
2001-04-18 17:00:00	AAPL	Stock	0.425	0.4821	0.407	0.4643	61448800.0
2001-04-18 18:00:00	AAPL	Stock	0.4643	0.4686	0.4634	0.4675	9016000.0
2001-04-18 08:00:00	MSFT	Stock	30.97	31.995	30.97	31.75	647400.0
2001-04-18 09:00:00	MSFT	Stock	31.7	31.995	31.0	31.86	25226400.0
2001-04-18 10:00:00	MSFT	Stock	31.855	32.75	31.775	32.125	18140200.0
2001-04-18 11:00:00	MSFT	Stock	32.255	32.625	31.91	32.55	35141400.0
2001-04-18 12:00:00	MSFT	Stock	32.555	32.75	32.45	32.685	12101000.0
2001-04-18 13:00:00	MSFT	Stock	32.685	32.935	32.65	32.9	12698000.0
2001-04-18 14:00:00	MSFT	Stock	32.9	33.15	32.795	32.95	16211600.0
2001-04-18 15:00:00	MSFT	Stock	32.95	33.1	32.615	32.745	23607200.0
2001-04-18 16:00:00	MSFT	Stock	32.72	33.485	31.75	33.375	6755800.0
2001-04-18 17:00:00	MSFT	Stock	33.4	33.55	33.34	33.45	197800.0
2001-04-18 18:00:00	MSFT	Stock	33.45	33.5	33.35	33.45	16200.0
2001-04-18 08:00:00	NVDA	Stock	0.3083	0.3147	0.3083	0.3117	4680000.0
2001-04-18 09:00:00	NVDA	Stock	0.3125	0.324	0.3089	0.3238	221640000.0
2001-04-18 10:00:00	NVDA	Stock	0.324	0.3333	0.3201	0.3292	320160000.0
2001-04-18 11:00:00	NVDA	Stock	0.33	0.3354	0.3281	0.3308	355440000.0
2001-04-18 12:00:00	NVDA	Stock	0.3308	0.337	0.3308	0.3336	135024000.0
2001-04-18 13:00:00	NVDA	Stock	0.3335	0.3371	0.332	0.3369	102912000.0
2001-04-18 14:00:00	NVDA	Stock	0.3368	0.3517	0.3347	0.3467	294264000.0
2001-04-18 15:00:00	NVDA	Stock	0.3463	0.3473	0.3169	0.3219	687144000.0
2001-04-18 16:00:00	NVDA	Stock	0.3219	0.3366	0.3207	0.3292	16584000.0
2001-04-18 17:00:00	NVDA	Stock	0.3312	0.3344	0.3275	0.3313	1968000.0
2001-04-18 18:00:00	NVDA	Stock	0.3292	0.3333	0.3292	0.3333	384000.0
2001-04-18 08:00:00	AMZN	Stock	0.758	0.85	0.758	0.781	856000.0
2001-04-18 09:00:00	AMZN	Stock	0.78	0.8025	0.7725	0.801	33552000.0
2001-04-18 10:00:00	AMZN	Stock	0.802	0.85	0.7975	0.846	48500000.0
2001-04-18 11:00:00	AMZN	Stock	0.8515	0.908	0.8435	0.88	91072000.0
2001-04-18 12:00:00	AMZN	Stock	0.88	0.886	0.868	0.872	47096000.0
2001-04-18 13:00:00	AMZN	Stock	0.8715	0.883	0.8525	0.8825	26718000.0
2001-04-18 14:00:00	AMZN	Stock	0.883	0.8975	0.872	0.875	33968000.0
2001-04-18 15:00:00	AMZN	Stock	0.875	0.8765	0.825	0.827	64976000.0
2001-04-18 16:00:00	AMZN	Stock	0.827	0.863	0.8115	0.835	23884000.0
2001-04-18 17:00:00	AMZN	Stock	0.835	0.85	0.82	0.8465	110000.0
2001-04-18 18:00:00	AMZN	Stock	0.847	0.85	0.847	0.85	110000.0
2001-04-18 09:00:00	CL	Stock	26.55	26.6	26.125	26.125	372000.0
2001-04-18 10:00:00	CL	Stock	26.1	26.525	25.95	26.525	417000.0
2001-04-18 11:00:00	CL	Stock	26.525	26.655	26.175	26.35	887400.0
2001-04-18 12:00:00	CL	Stock	26.36	26.385	26.0	26.025	805600.0
2001-04-18 13:00:00	CL	Stock	26.05	26.1	25.75	25.85	1026000.0
2001-04-18 14:00:00	CL	Stock	25.865	25.97	25.775	25.825	734200.0

> showing 50 of 16,998 rows — these rows as CSV

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