PREVIEW / stock_1hour / 2002-01-24

all stock 1-hour files

  file:    by_date/stock_1hour/2002/2002-01-24.parquet
  size:    383 KB
  rows:    18,311
  symbols: 1,341

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
2002-01-24 08:00:00	AAPL	Stock	0.411	0.4125	0.411	0.4125	1192800.0
2002-01-24 09:00:00	AAPL	Stock	0.4125	0.417	0.4088	0.4139	39289600.0
2002-01-24 10:00:00	AAPL	Stock	0.4139	0.4198	0.4127	0.4189	68936000.0
2002-01-24 11:00:00	AAPL	Stock	0.4184	0.4188	0.4152	0.417	34176800.0
2002-01-24 12:00:00	AAPL	Stock	0.4161	0.4182	0.4148	0.4161	16133600.0
2002-01-24 13:00:00	AAPL	Stock	0.4161	0.4177	0.4145	0.4146	21442400.0
2002-01-24 14:00:00	AAPL	Stock	0.4146	0.4171	0.4136	0.4166	34031200.0
2002-01-24 15:00:00	AAPL	Stock	0.4166	0.4179	0.4143	0.4146	39704000.0
2002-01-24 16:00:00	AAPL	Stock	0.4145	0.4165	0.4102	0.4145	67216800.0
2002-01-24 17:00:00	AAPL	Stock	0.4145	0.4145	0.408	0.4145	4088000.0
2002-01-24 08:00:00	MSFT	Stock	32.225	32.345	31.87	32.17	149200.0
2002-01-24 09:00:00	MSFT	Stock	32.15	32.3805	31.9	32.26	8974000.0
2002-01-24 10:00:00	MSFT	Stock	32.255	32.455	31.94	32.33	13517200.0
2002-01-24 11:00:00	MSFT	Stock	32.3295	32.59	32.29	32.485	14870600.0
2002-01-24 12:00:00	MSFT	Stock	32.485	32.535	32.3	32.47	7524200.0
2002-01-24 13:00:00	MSFT	Stock	32.475	32.475	32.1	32.1	7119200.0
2002-01-24 14:00:00	MSFT	Stock	32.175	32.345	31.975	32.245	11942400.0
2002-01-24 15:00:00	MSFT	Stock	32.245	32.455	32.245	32.325	11977800.0
2002-01-24 16:00:00	MSFT	Stock	32.335	32.4395	32.06	32.3	4829600.0
2002-01-24 17:00:00	MSFT	Stock	32.21	32.3	32.155	32.22	595400.0
2002-01-24 18:00:00	MSFT	Stock	32.2994	32.2994	32.22	32.22	74200.0
2002-01-24 08:00:00	NVDA	Stock	0.5296	0.5361	0.5296	0.5342	1020000.0
2002-01-24 09:00:00	NVDA	Stock	0.535	0.5365	0.5221	0.527	113016000.0
2002-01-24 10:00:00	NVDA	Stock	0.527	0.531	0.5224	0.5277	136320000.0
2002-01-24 11:00:00	NVDA	Stock	0.5279	0.5303	0.525	0.5296	60372000.0
2002-01-24 12:00:00	NVDA	Stock	0.5296	0.5512	0.5292	0.5454	230400000.0
2002-01-24 13:00:00	NVDA	Stock	0.5452	0.5477	0.5383	0.5404	132204000.0
2002-01-24 14:00:00	NVDA	Stock	0.54	0.551	0.5395	0.5481	143028000.0
2002-01-24 15:00:00	NVDA	Stock	0.5481	0.5525	0.5417	0.547	214032000.0
2002-01-24 16:00:00	NVDA	Stock	0.547	0.5493	0.5387	0.547	32736000.0
2002-01-24 17:00:00	NVDA	Stock	0.547	0.547	0.5437	0.5442	2796000.0
2002-01-24 18:00:00	NVDA	Stock	0.5435	0.5435	0.535	0.5435	456000.0
2002-01-24 08:00:00	AMZN	Stock	0.6275	0.645	0.625	0.6425	1254000.0
2002-01-24 09:00:00	AMZN	Stock	0.64	0.673	0.635	0.669	72952000.0
2002-01-24 10:00:00	AMZN	Stock	0.6695	0.685	0.6665	0.681	94426000.0
2002-01-24 11:00:00	AMZN	Stock	0.6805	0.686	0.6775	0.686	51252000.0
2002-01-24 12:00:00	AMZN	Stock	0.685	0.6875	0.6795	0.683	42200000.0
2002-01-24 13:00:00	AMZN	Stock	0.683	0.686	0.6725	0.6725	33326000.0
2002-01-24 14:00:00	AMZN	Stock	0.6725	0.6835	0.6645	0.683	48502000.0
2002-01-24 15:00:00	AMZN	Stock	0.6835	0.703	0.6795	0.7005	87952000.0
2002-01-24 16:00:00	AMZN	Stock	0.7005	0.7025	0.6781	0.695	6590000.0
2002-01-24 17:00:00	AMZN	Stock	0.7005	0.7005	0.6875	0.6875	1202000.0
2002-01-24 18:00:00	AMZN	Stock	0.687	0.687	0.6855	0.6855	182000.0
2002-01-24 09:00:00	CL	Stock	28.125	28.225	28.06	28.075	153400.0
2002-01-24 10:00:00	CL	Stock	28.09	28.175	27.925	28.1	396600.0
2002-01-24 11:00:00	CL	Stock	28.055	28.18	28.05	28.16	263800.0
2002-01-24 12:00:00	CL	Stock	28.17	28.19	28.085	28.14	278400.0
2002-01-24 13:00:00	CL	Stock	28.13	28.145	28.015	28.06	340000.0
2002-01-24 14:00:00	CL	Stock	28.06	28.1	28.05	28.065	124200.0
2002-01-24 15:00:00	CL	Stock	28.065	28.09	27.945	27.975	755400.0

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

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