PREVIEW / stock_1hour / 2003-06-05

all stock 1-hour files

  file:    by_date/stock_1hour/2003/2003-06-05.parquet
  size:    459 KB
  rows:    21,796
  symbols: 1,588

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-06-05 08:00:00	AAPL	Stock	0.3098	0.3113	0.3098	0.3113	67200.0
2003-06-05 09:00:00	AAPL	Stock	0.3111	0.3168	0.3111	0.3129	18369176.0
2003-06-05 10:00:00	AAPL	Stock	0.313	0.3139	0.3095	0.3116	30889768.0
2003-06-05 11:00:00	AAPL	Stock	0.3114	0.3127	0.3105	0.3116	19077128.0
2003-06-05 12:00:00	AAPL	Stock	0.3116	0.313	0.3107	0.3121	21752248.0
2003-06-05 13:00:00	AAPL	Stock	0.3123	0.3129	0.3107	0.3116	16027872.0
2003-06-05 14:00:00	AAPL	Stock	0.3113	0.3163	0.3105	0.3159	20467496.0
2003-06-05 15:00:00	AAPL	Stock	0.3157	0.3161	0.312	0.3159	40885096.0
2003-06-05 16:00:00	AAPL	Stock	0.3157	0.3157	0.3143	0.315	15080800.0
2003-06-05 17:00:00	AAPL	Stock	0.315	0.315	0.315	0.315	156800.0
2003-06-05 08:00:00	MSFT	Stock	24.65	24.96	24.41	24.529	474399.0
2003-06-05 09:00:00	MSFT	Stock	24.5	24.549	24.32	24.355	18413018.0
2003-06-05 10:00:00	MSFT	Stock	24.353	24.41	24.24	24.275	17251392.0
2003-06-05 11:00:00	MSFT	Stock	24.27	24.301	24.047	24.15	15401627.0
2003-06-05 12:00:00	MSFT	Stock	24.14	24.24	24.12	24.195	11202484.0
2003-06-05 13:00:00	MSFT	Stock	24.2	24.2	24.05	24.07	10736202.0
2003-06-05 14:00:00	MSFT	Stock	24.07	24.16	24.009	24.12	10565958.0
2003-06-05 15:00:00	MSFT	Stock	24.12	24.17	24.049	24.11	18845321.0
2003-06-05 16:00:00	MSFT	Stock	24.109	24.2071	23.98	24.07	1354516.0
2003-06-05 17:00:00	MSFT	Stock	24.0	24.12	24.0	24.11	342663.0
2003-06-05 18:00:00	MSFT	Stock	24.12	24.36	24.11	24.36	203896.0
2003-06-05 08:00:00	NVDA	Stock	0.2142	0.2142	0.2092	0.2125	1332000.0
2003-06-05 09:00:00	NVDA	Stock	0.2125	0.2128	0.2096	0.2117	143067240.0
2003-06-05 10:00:00	NVDA	Stock	0.2117	0.2207	0.2104	0.2187	340170000.0
2003-06-05 11:00:00	NVDA	Stock	0.2187	0.2197	0.2167	0.2187	144768120.0
2003-06-05 12:00:00	NVDA	Stock	0.2186	0.2202	0.2173	0.2195	91479360.0
2003-06-05 13:00:00	NVDA	Stock	0.2195	0.2202	0.2173	0.2181	71576640.0
2003-06-05 14:00:00	NVDA	Stock	0.2181	0.2192	0.2168	0.2191	66820800.0
2003-06-05 15:00:00	NVDA	Stock	0.2191	0.2222	0.2182	0.2214	213768120.0
2003-06-05 16:00:00	NVDA	Stock	0.2212	0.2218	0.2195	0.2216	34544160.0
2003-06-05 17:00:00	NVDA	Stock	0.2192	0.2223	0.2192	0.2221	2283120.0
2003-06-05 18:00:00	NVDA	Stock	0.2223	0.2248	0.2167	0.2244	3395040.0
2003-06-05 08:00:00	AMZN	Stock	1.765	1.7695	1.7435	1.75	322000.0
2003-06-05 09:00:00	AMZN	Stock	1.7455	1.76	1.734	1.7438	24133460.0
2003-06-05 10:00:00	AMZN	Stock	1.744	1.7625	1.7305	1.75	38500880.0
2003-06-05 11:00:00	AMZN	Stock	1.7495	1.7545	1.7451	1.7505	11679540.0
2003-06-05 12:00:00	AMZN	Stock	1.751	1.765	1.7495	1.761	12402340.0
2003-06-05 13:00:00	AMZN	Stock	1.76	1.772	1.759	1.7645	11199160.0
2003-06-05 14:00:00	AMZN	Stock	1.7645	1.78	1.762	1.7766	12256080.0
2003-06-05 15:00:00	AMZN	Stock	1.7775	1.792	1.775	1.777	18830240.0
2003-06-05 16:00:00	AMZN	Stock	1.777	1.7815	1.7725	1.7725	934000.0
2003-06-05 17:00:00	AMZN	Stock	1.775	1.7775	1.769	1.776	210400.0
2003-06-05 18:00:00	AMZN	Stock	1.78	1.79	1.78	1.789	188000.0
2003-06-05 09:00:00	CL	Stock	29.6	29.765	29.6	29.74	174000.0
2003-06-05 10:00:00	CL	Stock	29.74	29.74	29.535	29.54	383400.0
2003-06-05 11:00:00	CL	Stock	29.535	29.585	29.46	29.465	340000.0
2003-06-05 12:00:00	CL	Stock	29.47	29.65	29.43	29.64	512200.0
2003-06-05 13:00:00	CL	Stock	29.635	29.68	29.425	29.425	434200.0
2003-06-05 14:00:00	CL	Stock	29.43	29.5	29.38	29.48	641600.0
2003-06-05 15:00:00	CL	Stock	29.485	29.56	29.425	29.55	593800.0

> showing 50 of 21,796 rows — these rows as CSV

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