PREVIEW / stock_1hour / 2004-11-01

all stock 1-hour files

  file:    by_date/stock_1hour/2004/2004-11-01.parquet
  size:    526 KB
  rows:    24,602
  symbols: 1,865

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
2004-11-01 08:00:00	AAPL	Stock	0.9358	0.9552	0.9357	0.95	11591216.0
2004-11-01 09:00:00	AAPL	Stock	0.9489	0.9511	0.9341	0.9386	99438472.0
2004-11-01 10:00:00	AAPL	Stock	0.9388	0.9438	0.9323	0.9438	100045232.0
2004-11-01 11:00:00	AAPL	Stock	0.9432	0.945	0.9384	0.942	69108368.0
2004-11-01 12:00:00	AAPL	Stock	0.942	0.9432	0.9375	0.9389	43828512.0
2004-11-01 13:00:00	AAPL	Stock	0.9389	0.94	0.9368	0.9395	48520976.0
2004-11-01 14:00:00	AAPL	Stock	0.9393	0.9411	0.9293	0.935	101341016.0
2004-11-01 15:00:00	AAPL	Stock	0.935	0.9404	0.9325	0.9348	101292184.0
2004-11-01 16:00:00	AAPL	Stock	0.9348	0.9368	0.9323	0.9366	5794320.0
2004-11-01 17:00:00	AAPL	Stock	0.9357	0.9407	0.9355	0.9357	1052800.0
2004-11-01 18:00:00	AAPL	Stock	0.9357	0.9357	0.9357	0.9357	5600.0
2004-11-01 08:00:00	MSFT	Stock	27.97	28.07	27.97	28.03	17776.0
2004-11-01 09:00:00	MSFT	Stock	28.05	28.19	27.94	28.11	7218413.0
2004-11-01 10:00:00	MSFT	Stock	28.11	28.15	27.99	28.08	9530833.0
2004-11-01 11:00:00	MSFT	Stock	28.08	28.25	28.07	28.22	9909577.0
2004-11-01 12:00:00	MSFT	Stock	28.22	28.28	28.15	28.21	6127976.0
2004-11-01 13:00:00	MSFT	Stock	28.21	28.23	27.96	27.999	14351601.0
2004-11-01 14:00:00	MSFT	Stock	27.9998	28.12	27.9799	28.06	7362519.0
2004-11-01 15:00:00	MSFT	Stock	28.05	28.1	27.99	28.1	9278887.0
2004-11-01 16:00:00	MSFT	Stock	28.1	28.12	28.03	28.06	2991655.0
2004-11-01 17:00:00	MSFT	Stock	28.07	28.135	28.07	28.12	34514.0
2004-11-01 09:00:00	NVDA	Stock	0.121	0.1226	0.1205	0.1213	69052200.0
2004-11-01 10:00:00	NVDA	Stock	0.1212	0.1216	0.121	0.1212	69309720.0
2004-11-01 11:00:00	NVDA	Stock	0.1212	0.1222	0.1207	0.1209	56205360.0
2004-11-01 12:00:00	NVDA	Stock	0.1209	0.1222	0.1207	0.1218	48374160.0
2004-11-01 13:00:00	NVDA	Stock	0.1217	0.1222	0.1207	0.1222	71061480.0
2004-11-01 14:00:00	NVDA	Stock	0.1222	0.1225	0.1215	0.1224	90089400.0
2004-11-01 15:00:00	NVDA	Stock	0.1223	0.1232	0.1221	0.123	231954120.0
2004-11-01 16:00:00	NVDA	Stock	0.1227	0.1232	0.1208	0.1212	6709080.0
2004-11-01 17:00:00	NVDA	Stock	0.1212	0.1221	0.1212	0.1221	1080000.0
2004-11-01 18:00:00	NVDA	Stock	0.1222	0.1222	0.1221	0.1221	120000.0
2004-11-01 08:00:00	AMZN	Stock	1.709	1.7225	1.709	1.7225	11000.0
2004-11-01 09:00:00	AMZN	Stock	1.7125	1.727	1.709	1.718	10566200.0
2004-11-01 10:00:00	AMZN	Stock	1.7175	1.729	1.7075	1.723	14511140.0
2004-11-01 11:00:00	AMZN	Stock	1.7225	1.7535	1.7225	1.744	25219920.0
2004-11-01 12:00:00	AMZN	Stock	1.7435	1.7576	1.741	1.7545	16889280.0
2004-11-01 13:00:00	AMZN	Stock	1.7535	1.754	1.7415	1.747	14550460.0
2004-11-01 14:00:00	AMZN	Stock	1.7475	1.7535	1.7425	1.7505	12010260.0
2004-11-01 15:00:00	AMZN	Stock	1.7505	1.7545	1.741	1.751	25643660.0
2004-11-01 16:00:00	AMZN	Stock	1.751	1.755	1.7465	1.755	2099720.0
2004-11-01 17:00:00	AMZN	Stock	1.75	1.755	1.7352	1.755	198000.0
2004-11-01 18:00:00	AMZN	Stock	1.7475	1.7515	1.7475	1.7515	12000.0
2004-11-01 09:00:00	CL	Stock	22.31	22.36	22.29	22.325	527000.0
2004-11-01 10:00:00	CL	Stock	22.325	22.35	22.27	22.335	1142600.0
2004-11-01 11:00:00	CL	Stock	22.335	22.4	22.32	22.375	770200.0
2004-11-01 12:00:00	CL	Stock	22.375	22.42	22.35	22.37	490000.0
2004-11-01 13:00:00	CL	Stock	22.375	22.43	22.36	22.42	840800.0
2004-11-01 14:00:00	CL	Stock	22.42	22.495	22.405	22.415	585000.0
2004-11-01 15:00:00	CL	Stock	22.41	22.41	22.295	22.35	2103200.0
2004-11-01 16:00:00	CL	Stock	22.345	22.35	22.345	22.35	13600.0

> showing 50 of 24,602 rows — these rows as CSV

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