PREVIEW / stock_1hour / 2003-07-07

all stock 1-hour files

  file:    by_date/stock_1hour/2003/2003-07-07.parquet
  size:    474 KB
  rows:    22,790
  symbols: 1,587

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
2003-07-07 09:00:00	AAPL	Stock	0.3464	0.3509	0.3416	0.3505	23265704.0
2003-07-07 10:00:00	AAPL	Stock	0.3505	0.3571	0.3489	0.357	62366304.0
2003-07-07 11:00:00	AAPL	Stock	0.3568	0.358	0.3554	0.3577	42644560.0
2003-07-07 12:00:00	AAPL	Stock	0.3577	0.3604	0.3566	0.3568	32781672.0
2003-07-07 13:00:00	AAPL	Stock	0.3568	0.358	0.3554	0.3579	20027728.0
2003-07-07 14:00:00	AAPL	Stock	0.3579	0.3591	0.3564	0.3579	17676848.0
2003-07-07 15:00:00	AAPL	Stock	0.3579	0.358	0.3525	0.3548	54422704.0
2003-07-07 16:00:00	AAPL	Stock	0.3543	0.3571	0.3543	0.355	10410400.0
2003-07-07 17:00:00	AAPL	Stock	0.355	0.356	0.3548	0.356	4620000.0
2003-07-07 08:00:00	MSFT	Stock	27.21	27.52	26.5	27.12	648600.0
2003-07-07 09:00:00	MSFT	Stock	27.12	27.45	26.985	27.42	18945182.0
2003-07-07 10:00:00	MSFT	Stock	27.42	27.53	27.341	27.47	15515294.0
2003-07-07 11:00:00	MSFT	Stock	27.47	27.551	27.4	27.47	9610732.0
2003-07-07 12:00:00	MSFT	Stock	27.47	27.53	27.41	27.4501	7063207.0
2003-07-07 13:00:00	MSFT	Stock	27.46	27.48	27.38	27.42	6226595.0
2003-07-07 14:00:00	MSFT	Stock	27.43	27.52	27.42	27.51	7610804.0
2003-07-07 15:00:00	MSFT	Stock	27.52	27.54	27.38	27.41	12106348.0
2003-07-07 16:00:00	MSFT	Stock	27.38	27.54	27.37	27.43	1683324.0
2003-07-07 17:00:00	MSFT	Stock	27.47	27.5003	27.3773	27.47	451324.0
2003-07-07 18:00:00	MSFT	Stock	27.47	27.51	27.24	27.49	8900.0
2003-07-07 08:00:00	NVDA	Stock	0.1996	0.2	0.1996	0.2	300000.0
2003-07-07 09:00:00	NVDA	Stock	0.2008	0.2057	0.1985	0.2051	183939480.0
2003-07-07 10:00:00	NVDA	Stock	0.205	0.2077	0.2045	0.2058	156738720.0
2003-07-07 11:00:00	NVDA	Stock	0.2057	0.2065	0.2042	0.2048	79979280.0
2003-07-07 12:00:00	NVDA	Stock	0.2048	0.2066	0.2047	0.2051	53541000.0
2003-07-07 13:00:00	NVDA	Stock	0.2052	0.2071	0.2047	0.2069	51212520.0
2003-07-07 14:00:00	NVDA	Stock	0.2069	0.2098	0.2068	0.2091	97704720.0
2003-07-07 15:00:00	NVDA	Stock	0.2091	0.2095	0.2067	0.2087	120759840.0
2003-07-07 16:00:00	NVDA	Stock	0.2087	0.2092	0.2079	0.2084	30498000.0
2003-07-07 17:00:00	NVDA	Stock	0.2084	0.2087	0.2074	0.2074	10971600.0
2003-07-07 18:00:00	NVDA	Stock	0.2083	0.2085	0.2083	0.2085	110400.0
2003-07-07 08:00:00	AMZN	Stock	1.909	1.92	1.909	1.914	152000.0
2003-07-07 09:00:00	AMZN	Stock	1.915	1.919	1.8975	1.9055	18458140.0
2003-07-07 10:00:00	AMZN	Stock	1.9055	1.9145	1.8975	1.902	23319560.0
2003-07-07 11:00:00	AMZN	Stock	1.903	1.9075	1.8975	1.8995	10518040.0
2003-07-07 12:00:00	AMZN	Stock	1.8995	1.9175	1.8995	1.908	11787240.0
2003-07-07 13:00:00	AMZN	Stock	1.9085	1.9225	1.9045	1.9215	12783240.0
2003-07-07 14:00:00	AMZN	Stock	1.9215	1.94	1.9205	1.94	15053700.0
2003-07-07 15:00:00	AMZN	Stock	1.94	1.955	1.935	1.948	28915860.0
2003-07-07 16:00:00	AMZN	Stock	1.9495	1.9525	1.932	1.9515	3918120.0
2003-07-07 17:00:00	AMZN	Stock	1.95	1.9524	1.9295	1.9295	460000.0
2003-07-07 18:00:00	AMZN	Stock	1.9492	1.955	1.949	1.9515	1186640.0
2003-07-07 09:00:00	CL	Stock	28.935	29.075	28.93	29.065	433400.0
2003-07-07 10:00:00	CL	Stock	29.055	29.13	29.02	29.075	590200.0
2003-07-07 11:00:00	CL	Stock	29.05	29.09	29.02	29.04	862000.0
2003-07-07 12:00:00	CL	Stock	29.04	29.08	29.03	29.04	540600.0
2003-07-07 13:00:00	CL	Stock	29.04	29.065	29.03	29.05	228000.0
2003-07-07 14:00:00	CL	Stock	29.05	29.06	29.0	29.0	302600.0
2003-07-07 15:00:00	CL	Stock	29.005	29.025	28.98	29.01	572000.0
2003-07-07 16:00:00	CL	Stock	29.01	29.01	28.99	29.0	149000.0

> showing 50 of 22,790 rows — these rows as CSV

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