PREVIEW / stock_1hour / 2002-02-14

all stock 1-hour files

  file:    by_date/stock_1hour/2002/2002-02-14.parquet
  size:    390 KB
  rows:    18,599
  symbols: 1,393

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-02-14 08:00:00	AAPL	Stock	0.447	0.4471	0.447	0.4471	448000.0
2002-02-14 09:00:00	AAPL	Stock	0.448	0.4505	0.445	0.4473	30839200.0
2002-02-14 10:00:00	AAPL	Stock	0.4471	0.45	0.4457	0.4463	49134400.0
2002-02-14 11:00:00	AAPL	Stock	0.447	0.4473	0.4384	0.4441	26863200.0
2002-02-14 12:00:00	AAPL	Stock	0.4441	0.4445	0.44	0.4427	22103200.0
2002-02-14 13:00:00	AAPL	Stock	0.4429	0.4457	0.442	0.4423	17623200.0
2002-02-14 14:00:00	AAPL	Stock	0.4425	0.4438	0.4393	0.4395	27742400.0
2002-02-14 15:00:00	AAPL	Stock	0.4395	0.4409	0.4354	0.4395	55664000.0
2002-02-14 16:00:00	AAPL	Stock	0.4395	0.4463	0.4375	0.4375	18351200.0
2002-02-14 17:00:00	AAPL	Stock	0.4375	0.4395	0.4375	0.4377	431200.0
2002-02-14 08:00:00	MSFT	Stock	31.0	31.15	30.9125	31.025	178400.0
2002-02-14 09:00:00	MSFT	Stock	31.005	31.13	30.83	30.915	6959200.0
2002-02-14 10:00:00	MSFT	Stock	30.915	31.22	30.885	31.155	11546200.0
2002-02-14 11:00:00	MSFT	Stock	31.15	31.195	31.055	31.135	4394000.0
2002-02-14 12:00:00	MSFT	Stock	31.14	31.37	31.0855	31.325	6003400.0
2002-02-14 13:00:00	MSFT	Stock	31.3298	31.495	31.185	31.2155	7017000.0
2002-02-14 14:00:00	MSFT	Stock	31.23	31.24	30.78	30.88	10774000.0
2002-02-14 15:00:00	MSFT	Stock	30.89	30.955	30.66	30.835	7443000.0
2002-02-14 16:00:00	MSFT	Stock	30.835	31.0836	30.625	30.75	1712400.0
2002-02-14 17:00:00	MSFT	Stock	30.75	30.84	30.75	30.755	204200.0
2002-02-14 18:00:00	MSFT	Stock	30.755	30.79	30.755	30.79	1200.0
2002-02-14 08:00:00	NVDA	Stock	0.5154	0.5154	0.5133	0.5152	804000.0
2002-02-14 09:00:00	NVDA	Stock	0.5153	0.5258	0.5146	0.5229	187032000.0
2002-02-14 10:00:00	NVDA	Stock	0.5227	0.5287	0.5207	0.5263	171108000.0
2002-02-14 11:00:00	NVDA	Stock	0.5263	0.5279	0.5202	0.5256	95880000.0
2002-02-14 12:00:00	NVDA	Stock	0.5256	0.528	0.5226	0.526	65544000.0
2002-02-14 13:00:00	NVDA	Stock	0.526	0.5283	0.5231	0.5247	72708000.0
2002-02-14 14:00:00	NVDA	Stock	0.5246	0.525	0.5179	0.523	127188000.0
2002-02-14 15:00:00	NVDA	Stock	0.523	0.5242	0.5095	0.5186	343644000.0
2002-02-14 16:00:00	NVDA	Stock	0.5188	0.5245	0.5129	0.5233	20100000.0
2002-02-14 17:00:00	NVDA	Stock	0.525	0.5292	0.4583	0.4659	112332000.0
2002-02-14 18:00:00	NVDA	Stock	0.4665	0.47	0.4572	0.4583	77316000.0
2002-02-14 08:00:00	AMZN	Stock	0.6695	0.6715	0.668	0.669	222000.0
2002-02-14 09:00:00	AMZN	Stock	0.668	0.693	0.665	0.687	31818000.0
2002-02-14 10:00:00	AMZN	Stock	0.687	0.7125	0.683	0.7085	47084000.0
2002-02-14 11:00:00	AMZN	Stock	0.7075	0.713	0.705	0.7095	19642000.0
2002-02-14 12:00:00	AMZN	Stock	0.7095	0.7105	0.7025	0.7025	10868000.0
2002-02-14 13:00:00	AMZN	Stock	0.702	0.7065	0.6945	0.695	12362000.0
2002-02-14 14:00:00	AMZN	Stock	0.6955	0.7	0.6935	0.6945	23940000.0
2002-02-14 15:00:00	AMZN	Stock	0.695	0.7075	0.691	0.694	25226000.0
2002-02-14 16:00:00	AMZN	Stock	0.694	0.701	0.6915	0.6945	9788000.0
2002-02-14 17:00:00	AMZN	Stock	0.694	0.6945	0.694	0.6945	12000.0
2002-02-14 09:00:00	CL	Stock	27.375	27.465	27.3	27.35	259400.0
2002-02-14 10:00:00	CL	Stock	27.36	27.595	27.36	27.57	398600.0
2002-02-14 11:00:00	CL	Stock	27.57	27.61	27.5	27.505	231600.0
2002-02-14 12:00:00	CL	Stock	27.505	27.545	27.45	27.495	133600.0
2002-02-14 13:00:00	CL	Stock	27.48	27.485	27.355	27.37	141800.0
2002-02-14 14:00:00	CL	Stock	27.4	27.525	27.3	27.42	337800.0
2002-02-14 15:00:00	CL	Stock	27.41	27.525	27.355	27.525	448800.0
2002-02-14 16:00:00	CL	Stock	27.515	27.52	27.45	27.52	272000.0

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

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