PREVIEW / stock_1hour / 2002-11-18

all stock 1-hour files

  file:    by_date/stock_1hour/2002/2002-11-18.parquet
  size:    428 KB
  rows:    20,254
  symbols: 1,514

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
2002-11-18 09:00:00	AAPL	Stock	0.2864	0.2893	0.2821	0.2825	22348480.0
2002-11-18 10:00:00	AAPL	Stock	0.2825	0.2879	0.2823	0.2861	31799992.0
2002-11-18 11:00:00	AAPL	Stock	0.2861	0.2864	0.2825	0.2839	13652240.0
2002-11-18 12:00:00	AAPL	Stock	0.2839	0.2871	0.2821	0.2866	10192336.0
2002-11-18 13:00:00	AAPL	Stock	0.2865	0.2875	0.2846	0.287	9794624.0
2002-11-18 14:00:00	AAPL	Stock	0.287	0.2873	0.282	0.2821	14847728.0
2002-11-18 15:00:00	AAPL	Stock	0.2821	0.2829	0.2771	0.2809	26653648.0
2002-11-18 16:00:00	AAPL	Stock	0.2779	0.2809	0.2714	0.2788	9325064.0
2002-11-18 17:00:00	AAPL	Stock	0.2795	0.2795	0.2795	0.2795	1792000.0
2002-11-18 18:00:00	AAPL	Stock	0.2788	0.2788	0.2788	0.2788	22400.0
2002-11-18 08:00:00	MSFT	Stock	28.435	28.545	28.325	28.535	146424.0
2002-11-18 09:00:00	MSFT	Stock	28.535	28.59	28.265	28.315	9807742.0
2002-11-18 10:00:00	MSFT	Stock	28.31	28.485	28.26	28.44	8753126.0
2002-11-18 11:00:00	MSFT	Stock	28.445	28.47	28.19	28.28	7146752.0
2002-11-18 12:00:00	MSFT	Stock	28.285	28.355	28.22	28.3195	4183594.0
2002-11-18 13:00:00	MSFT	Stock	28.32	28.45	28.29	28.45	4040980.0
2002-11-18 14:00:00	MSFT	Stock	28.445	28.455	28.15	28.185	6838502.0
2002-11-18 15:00:00	MSFT	Stock	28.19	28.23	27.885	27.92	11163226.0
2002-11-18 16:00:00	MSFT	Stock	27.92	28.0	27.855	27.89	2081770.0
2002-11-18 17:00:00	MSFT	Stock	27.86	27.925	27.805	27.9	316642.0
2002-11-18 18:00:00	MSFT	Stock	27.885	27.9	27.875	27.9	1400.0
2002-11-18 08:00:00	NVDA	Stock	0.1167	0.1209	0.1142	0.1197	12546120.0
2002-11-18 09:00:00	NVDA	Stock	0.1199	0.1231	0.1173	0.1173	397823400.0
2002-11-18 10:00:00	NVDA	Stock	0.1173	0.12	0.1167	0.1194	340566360.0
2002-11-18 11:00:00	NVDA	Stock	0.1193	0.1199	0.1169	0.1181	195776880.0
2002-11-18 12:00:00	NVDA	Stock	0.1179	0.1202	0.1169	0.12	169145880.0
2002-11-18 13:00:00	NVDA	Stock	0.12	0.1207	0.1196	0.1202	147703440.0
2002-11-18 14:00:00	NVDA	Stock	0.1203	0.1206	0.1184	0.1186	171899280.0
2002-11-18 15:00:00	NVDA	Stock	0.1187	0.119	0.1161	0.1163	367786800.0
2002-11-18 16:00:00	NVDA	Stock	0.1164	0.119	0.1159	0.1167	70375200.0
2002-11-18 17:00:00	NVDA	Stock	0.1172	0.1172	0.1164	0.1171	2289360.0
2002-11-18 18:00:00	NVDA	Stock	0.117	0.117	0.1167	0.1167	541200.0
2002-11-18 08:00:00	AMZN	Stock	1.1098	1.125	1.1098	1.1245	562300.0
2002-11-18 09:00:00	AMZN	Stock	1.122	1.143	1.12	1.132	54310640.0
2002-11-18 10:00:00	AMZN	Stock	1.1325	1.187	1.13	1.181	120448420.0
2002-11-18 11:00:00	AMZN	Stock	1.181	1.1835	1.151	1.157	100533260.0
2002-11-18 12:00:00	AMZN	Stock	1.1565	1.165	1.156	1.1605	51606140.0
2002-11-18 13:00:00	AMZN	Stock	1.1605	1.165	1.158	1.1605	37589500.0
2002-11-18 14:00:00	AMZN	Stock	1.1605	1.162	1.125	1.13	51293720.0
2002-11-18 15:00:00	AMZN	Stock	1.13	1.138	1.1075	1.1182	63275360.0
2002-11-18 16:00:00	AMZN	Stock	1.1195	1.231	1.115	1.122	6396680.0
2002-11-18 17:00:00	AMZN	Stock	1.122	1.122	1.116	1.12	782740.0
2002-11-18 18:00:00	AMZN	Stock	1.118	1.125	1.115	1.115	14000.0
2002-11-18 09:00:00	CL	Stock	26.575	26.575	26.275	26.305	294000.0
2002-11-18 10:00:00	CL	Stock	26.305	26.54	26.305	26.38	352800.0
2002-11-18 11:00:00	CL	Stock	26.385	26.495	26.36	26.45	206200.0
2002-11-18 12:00:00	CL	Stock	26.455	26.49	26.435	26.46	230000.0
2002-11-18 13:00:00	CL	Stock	26.455	26.67	26.455	26.585	316200.0
2002-11-18 14:00:00	CL	Stock	26.58	26.58	26.39	26.43	283400.0
2002-11-18 15:00:00	CL	Stock	26.42	26.465	26.35	26.37	357600.0

> showing 50 of 20,254 rows — these rows as CSV

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