PREVIEW / stock_1hour / 2003-07-09

all stock 1-hour files

  file:    by_date/stock_1hour/2003/2003-07-09.parquet
  size:    484 KB
  rows:    22,916
  symbols: 1,586

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-09 08:00:00	AAPL	Stock	0.3588	0.3607	0.3588	0.3607	117600.0
2003-07-09 09:00:00	AAPL	Stock	0.3613	0.3652	0.3604	0.3616	33114760.0
2003-07-09 10:00:00	AAPL	Stock	0.3618	0.365	0.3577	0.3577	30588320.0
2003-07-09 11:00:00	AAPL	Stock	0.3577	0.3621	0.3573	0.3609	30093728.0
2003-07-09 12:00:00	AAPL	Stock	0.3604	0.3605	0.358	0.3595	18745104.0
2003-07-09 13:00:00	AAPL	Stock	0.3595	0.3602	0.358	0.3593	15431360.0
2003-07-09 14:00:00	AAPL	Stock	0.3593	0.3605	0.358	0.3604	21036064.0
2003-07-09 15:00:00	AAPL	Stock	0.3604	0.3609	0.3555	0.3557	38517248.0
2003-07-09 16:00:00	AAPL	Stock	0.3557	0.3582	0.3546	0.3552	5292000.0
2003-07-09 17:00:00	AAPL	Stock	0.3554	0.361	0.3545	0.3571	151200.0
2003-07-09 18:00:00	AAPL	Stock	0.3552	0.3552	0.3552	0.3552	196000.0
2003-07-09 08:00:00	MSFT	Stock	27.45	27.6	27.28	27.54	376832.0
2003-07-09 09:00:00	MSFT	Stock	27.51	27.7	27.5	27.54	8957208.0
2003-07-09 10:00:00	MSFT	Stock	27.54	27.68	27.35	27.38	9954853.0
2003-07-09 11:00:00	MSFT	Stock	27.38	27.501	27.33	27.36	6159782.0
2003-07-09 12:00:00	MSFT	Stock	27.36	27.37	27.248	27.284	7000926.0
2003-07-09 13:00:00	MSFT	Stock	27.28	27.36	27.27	27.34	4166159.0
2003-07-09 14:00:00	MSFT	Stock	27.34	27.57	27.33	27.52	7634638.0
2003-07-09 15:00:00	MSFT	Stock	27.52	27.69	27.34	27.48	10415879.0
2003-07-09 16:00:00	MSFT	Stock	27.48	27.56	27.35	27.4	1148268.0
2003-07-09 17:00:00	MSFT	Stock	27.4	27.41	27.37	27.4	41444.0
2003-07-09 18:00:00	MSFT	Stock	27.31	27.49	27.31	27.49	94146.0
2003-07-09 08:00:00	NVDA	Stock	0.2054	0.2094	0.2054	0.2094	612000.0
2003-07-09 09:00:00	NVDA	Stock	0.2054	0.2099	0.2054	0.2083	97424880.0
2003-07-09 10:00:00	NVDA	Stock	0.2085	0.2146	0.2079	0.2087	169179000.0
2003-07-09 11:00:00	NVDA	Stock	0.2086	0.2108	0.2083	0.209	85112520.0
2003-07-09 12:00:00	NVDA	Stock	0.2088	0.2098	0.2076	0.2095	61339320.0
2003-07-09 13:00:00	NVDA	Stock	0.2095	0.2107	0.2095	0.2107	48473280.0
2003-07-09 14:00:00	NVDA	Stock	0.2104	0.2142	0.2104	0.2141	89231880.0
2003-07-09 15:00:00	NVDA	Stock	0.2137	0.2146	0.2109	0.2111	137734560.0
2003-07-09 16:00:00	NVDA	Stock	0.2112	0.213	0.2096	0.2096	8260800.0
2003-07-09 17:00:00	NVDA	Stock	0.2102	0.2102	0.2075	0.2075	738000.0
2003-07-09 08:00:00	AMZN	Stock	2.0	2.0235	2.0	2.015	163700.0
2003-07-09 09:00:00	AMZN	Stock	2.0215	2.029	2.001	2.002	30333860.0
2003-07-09 10:00:00	AMZN	Stock	2.002	2.015	1.994	1.9945	32369780.0
2003-07-09 11:00:00	AMZN	Stock	1.995	2.0065	1.9935	1.9985	14430600.0
2003-07-09 12:00:00	AMZN	Stock	1.9985	2.004	1.995	2.0015	9775480.0
2003-07-09 13:00:00	AMZN	Stock	2.002	2.0075	2.0	2.002	7205260.0
2003-07-09 14:00:00	AMZN	Stock	2.0015	2.0355	2.0015	2.0275	23361440.0
2003-07-09 15:00:00	AMZN	Stock	2.028	2.0365	2.013	2.024	21809840.0
2003-07-09 16:00:00	AMZN	Stock	2.024	2.0315	1.9685	1.9685	4574620.0
2003-07-09 17:00:00	AMZN	Stock	1.9675	2.03	1.955	1.965	1216580.0
2003-07-09 18:00:00	AMZN	Stock	1.965	2.03	1.9625	1.965	191400.0
2003-07-09 09:00:00	CL	Stock	28.9	29.0	28.85	28.975	259200.0
2003-07-09 10:00:00	CL	Stock	28.97	29.0	28.78	28.81	343800.0
2003-07-09 11:00:00	CL	Stock	28.815	28.88	28.735	28.74	313000.0
2003-07-09 12:00:00	CL	Stock	28.74	28.765	28.675	28.765	252000.0
2003-07-09 13:00:00	CL	Stock	28.765	28.8	28.73	28.795	219600.0
2003-07-09 14:00:00	CL	Stock	28.8	28.87	28.795	28.855	638400.0
2003-07-09 15:00:00	CL	Stock	28.85	28.9	28.795	28.815	877400.0

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

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