PREVIEW / stock_1hour / 2004-10-19

all stock 1-hour files

  file:    by_date/stock_1hour/2004/2004-10-19.parquet
  size:    522 KB
  rows:    24,239
  symbols: 1,842

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-10-19 08:00:00	AAPL	Stock	0.8616	0.8625	0.8543	0.858	4644640.0
2004-10-19 09:00:00	AAPL	Stock	0.858	0.8614	0.8496	0.8509	113371328.0
2004-10-19 10:00:00	AAPL	Stock	0.8511	0.8634	0.8507	0.8566	162016512.0
2004-10-19 11:00:00	AAPL	Stock	0.8571	0.8602	0.8491	0.857	106938328.0
2004-10-19 12:00:00	AAPL	Stock	0.8563	0.8611	0.8509	0.8554	82414808.0
2004-10-19 13:00:00	AAPL	Stock	0.855	0.863	0.8527	0.8582	80763816.0
2004-10-19 14:00:00	AAPL	Stock	0.8582	0.8584	0.8471	0.8491	114187696.0
2004-10-19 15:00:00	AAPL	Stock	0.8491	0.852	0.8448	0.8457	113528632.0
2004-10-19 16:00:00	AAPL	Stock	0.8457	0.8483	0.8457	0.8483	5890024.0
2004-10-19 17:00:00	AAPL	Stock	0.8468	0.8547	0.8468	0.8547	1030568.0
2004-10-19 18:00:00	AAPL	Stock	0.8463	0.8482	0.8461	0.8482	246288.0
2004-10-19 08:00:00	MSFT	Stock	28.54	28.69	28.41	28.6	197167.0
2004-10-19 09:00:00	MSFT	Stock	28.62	28.66	28.42	28.5	8103052.0
2004-10-19 10:00:00	MSFT	Stock	28.5	28.58	28.37	28.38	9438577.0
2004-10-19 11:00:00	MSFT	Stock	28.38	28.41	28.29	28.35	8111870.0
2004-10-19 12:00:00	MSFT	Stock	28.35	28.5	28.35	28.46	5272887.0
2004-10-19 13:00:00	MSFT	Stock	28.45	28.5	28.28	28.3	6928425.0
2004-10-19 14:00:00	MSFT	Stock	28.29	28.36	28.25	28.31	6118978.0
2004-10-19 15:00:00	MSFT	Stock	28.32	28.39	28.18	28.18	9739806.0
2004-10-19 16:00:00	MSFT	Stock	28.18	28.41	28.15	28.19	939272.0
2004-10-19 17:00:00	MSFT	Stock	28.2	28.23	28.18	28.21	12900.0
2004-10-19 18:00:00	MSFT	Stock	28.21	28.21	28.18	28.19	15705.0
2004-10-19 08:00:00	NVDA	Stock	0.115	0.1158	0.115	0.1151	237000.0
2004-10-19 09:00:00	NVDA	Stock	0.1152	0.1172	0.1142	0.1166	109148640.0
2004-10-19 10:00:00	NVDA	Stock	0.1165	0.1176	0.1165	0.1168	124136520.0
2004-10-19 11:00:00	NVDA	Stock	0.1167	0.1172	0.1159	0.1164	63347640.0
2004-10-19 12:00:00	NVDA	Stock	0.1163	0.1167	0.1158	0.1161	28605600.0
2004-10-19 13:00:00	NVDA	Stock	0.1162	0.1166	0.115	0.1153	48868200.0
2004-10-19 14:00:00	NVDA	Stock	0.1153	0.1155	0.1134	0.1138	61131600.0
2004-10-19 15:00:00	NVDA	Stock	0.1137	0.1141	0.1122	0.1129	168437400.0
2004-10-19 16:00:00	NVDA	Stock	0.1129	0.1137	0.1121	0.1125	7268760.0
2004-10-19 17:00:00	NVDA	Stock	0.1131	0.1131	0.1122	0.1122	1128000.0
2004-10-19 18:00:00	NVDA	Stock	0.1122	0.1131	0.1122	0.1131	72240.0
2004-10-19 08:00:00	AMZN	Stock	1.975	1.9855	1.9635	1.984	152400.0
2004-10-19 09:00:00	AMZN	Stock	1.9815	1.9925	1.95	1.9625	26019660.0
2004-10-19 10:00:00	AMZN	Stock	1.9645	1.982	1.959	1.965	24138480.0
2004-10-19 11:00:00	AMZN	Stock	1.965	1.9665	1.9435	1.952	20394080.0
2004-10-19 12:00:00	AMZN	Stock	1.9525	1.9605	1.9475	1.951	18064720.0
2004-10-19 13:00:00	AMZN	Stock	1.9505	1.952	1.9374	1.938	17356780.0
2004-10-19 14:00:00	AMZN	Stock	1.9375	1.938	1.913	1.914	31524520.0
2004-10-19 15:00:00	AMZN	Stock	1.914	1.924	1.9085	1.9145	30712940.0
2004-10-19 16:00:00	AMZN	Stock	1.9145	1.9448	1.9135	1.915	2181220.0
2004-10-19 17:00:00	AMZN	Stock	1.915	1.9165	1.91	1.9125	154000.0
2004-10-19 18:00:00	AMZN	Stock	1.9125	1.9165	1.9055	1.9165	84220.0
2004-10-19 09:00:00	CL	Stock	21.96	21.965	21.805	21.845	958000.0
2004-10-19 10:00:00	CL	Stock	21.845	21.9	21.81	21.88	1495000.0
2004-10-19 11:00:00	CL	Stock	21.88	21.885	21.755	21.785	1311400.0
2004-10-19 12:00:00	CL	Stock	21.79	21.825	21.78	21.795	922200.0
2004-10-19 13:00:00	CL	Stock	21.795	21.8	21.59	21.66	1355800.0
2004-10-19 14:00:00	CL	Stock	21.655	21.69	21.525	21.535	2275800.0

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

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