PREVIEW / stock_1hour / 2004-09-09

all stock 1-hour files

  file:    by_date/stock_1hour/2004/2004-09-09.parquet
  size:    494 KB
  rows:    23,393
  symbols: 1,829

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-09-09 08:00:00	AAPL	Stock	0.6366	0.642	0.632	0.642	2062032.0
2004-09-09 09:00:00	AAPL	Stock	0.6429	0.6491	0.6404	0.6434	71201760.0
2004-09-09 10:00:00	AAPL	Stock	0.6432	0.6446	0.6395	0.6402	58321088.0
2004-09-09 11:00:00	AAPL	Stock	0.6402	0.6407	0.6354	0.6364	48841072.0
2004-09-09 12:00:00	AAPL	Stock	0.6363	0.6375	0.63	0.6327	85337000.0
2004-09-09 13:00:00	AAPL	Stock	0.6327	0.6375	0.6323	0.635	45337992.0
2004-09-09 14:00:00	AAPL	Stock	0.6352	0.64	0.6345	0.6395	43764168.0
2004-09-09 15:00:00	AAPL	Stock	0.6396	0.6402	0.6352	0.6375	91187544.0
2004-09-09 16:00:00	AAPL	Stock	0.6373	0.6375	0.6373	0.6375	1849456.0
2004-09-09 17:00:00	AAPL	Stock	0.6375	0.6375	0.6364	0.6375	714840.0
2004-09-09 18:00:00	AAPL	Stock	0.6363	0.6363	0.6363	0.6363	47600.0
2004-09-09 08:00:00	MSFT	Stock	26.86	27.33	26.86	27.26	19128.0
2004-09-09 09:00:00	MSFT	Stock	27.3	27.47	27.26	27.42	8061673.0
2004-09-09 10:00:00	MSFT	Stock	27.42	27.43	27.26	27.29	11300322.0
2004-09-09 11:00:00	MSFT	Stock	27.299	27.3	27.2	27.23	5418266.0
2004-09-09 12:00:00	MSFT	Stock	27.23	27.29	27.18	27.28	6960327.0
2004-09-09 13:00:00	MSFT	Stock	27.28	27.4	27.25	27.31	8353044.0
2004-09-09 14:00:00	MSFT	Stock	27.32	27.4	27.25	27.37	8193021.0
2004-09-09 15:00:00	MSFT	Stock	27.38	27.39	27.28	27.28	6333572.0
2004-09-09 16:00:00	MSFT	Stock	27.27	27.31	27.25	27.27	927607.0
2004-09-09 17:00:00	MSFT	Stock	27.28	27.3	27.27	27.3	78024.0
2004-09-09 18:00:00	MSFT	Stock	27.3	27.3	27.28	27.3	1100.0
2004-09-09 08:00:00	NVDA	Stock	0.103	0.1042	0.103	0.1042	552000.0
2004-09-09 09:00:00	NVDA	Stock	0.1042	0.109	0.1027	0.1089	230030160.0
2004-09-09 10:00:00	NVDA	Stock	0.1089	0.1089	0.1065	0.1071	172904280.0
2004-09-09 11:00:00	NVDA	Stock	0.1072	0.1077	0.1066	0.1075	109107120.0
2004-09-09 12:00:00	NVDA	Stock	0.1074	0.1096	0.1069	0.1096	133025040.0
2004-09-09 13:00:00	NVDA	Stock	0.1096	0.1122	0.1092	0.1114	215936880.0
2004-09-09 14:00:00	NVDA	Stock	0.1114	0.1147	0.1114	0.1142	211192680.0
2004-09-09 15:00:00	NVDA	Stock	0.1142	0.1142	0.112	0.1129	204155520.0
2004-09-09 16:00:00	NVDA	Stock	0.1129	0.1132	0.1127	0.1132	2496960.0
2004-09-09 17:00:00	NVDA	Stock	0.113	0.1132	0.1127	0.1132	315000.0
2004-09-09 18:00:00	NVDA	Stock	0.1132	0.1132	0.1127	0.1132	228000.0
2004-09-09 08:00:00	AMZN	Stock	1.9	1.9	1.8985	1.9	100000.0
2004-09-09 09:00:00	AMZN	Stock	1.9025	1.9135	1.88	1.891	22516380.0
2004-09-09 10:00:00	AMZN	Stock	1.8895	1.906	1.8735	1.882	26285460.0
2004-09-09 11:00:00	AMZN	Stock	1.882	1.8825	1.868	1.8755	19212420.0
2004-09-09 12:00:00	AMZN	Stock	1.876	1.881	1.869	1.878	10656740.0
2004-09-09 13:00:00	AMZN	Stock	1.8785	1.8975	1.8755	1.894	16037920.0
2004-09-09 14:00:00	AMZN	Stock	1.8945	1.9155	1.89	1.914	17624660.0
2004-09-09 15:00:00	AMZN	Stock	1.914	1.915	1.8975	1.9035	16114700.0
2004-09-09 16:00:00	AMZN	Stock	1.9035	1.9035	1.8985	1.9025	2886500.0
2004-09-09 17:00:00	AMZN	Stock	1.903	1.9035	1.9025	1.9025	305300.0
2004-09-09 09:00:00	CL	Stock	27.325	27.33	27.18	27.19	153600.0
2004-09-09 10:00:00	CL	Stock	27.175	27.235	27.115	27.125	292800.0
2004-09-09 11:00:00	CL	Stock	27.125	27.145	27.07	27.115	255800.0
2004-09-09 12:00:00	CL	Stock	27.11	27.19	27.105	27.155	255600.0
2004-09-09 13:00:00	CL	Stock	27.165	27.17	27.095	27.12	191600.0
2004-09-09 14:00:00	CL	Stock	27.13	27.215	27.115	27.195	250000.0
2004-09-09 15:00:00	CL	Stock	27.195	27.21	27.09	27.115	278200.0

> showing 50 of 23,393 rows — these rows as CSV

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