PREVIEW / stock_1hour / 2002-03-14

all stock 1-hour files

  file:    by_date/stock_1hour/2002/2002-03-14.parquet
  size:    391 KB
  rows:    18,295
  symbols: 1,395

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-03-14 08:00:00	AAPL	Stock	0.4373	0.4374	0.4361	0.4364	862400.0
2002-03-14 09:00:00	AAPL	Stock	0.4366	0.4393	0.4338	0.4359	29831200.0
2002-03-14 10:00:00	AAPL	Stock	0.4357	0.4359	0.4264	0.4321	58559200.0
2002-03-14 11:00:00	AAPL	Stock	0.4321	0.4361	0.4309	0.4354	16553600.0
2002-03-14 12:00:00	AAPL	Stock	0.4354	0.4364	0.4323	0.4339	15103200.0
2002-03-14 13:00:00	AAPL	Stock	0.4336	0.4352	0.4336	0.4345	14884800.0
2002-03-14 14:00:00	AAPL	Stock	0.4345	0.4366	0.433	0.4357	22876000.0
2002-03-14 15:00:00	AAPL	Stock	0.4359	0.4375	0.4338	0.4363	36562400.0
2002-03-14 16:00:00	AAPL	Stock	0.4364	0.4379	0.4357	0.4377	7212800.0
2002-03-14 17:00:00	AAPL	Stock	0.4363	0.4424	0.4363	0.4424	168000.0
2002-03-14 08:00:00	MSFT	Stock	31.075	31.1505	31.025	31.055	85400.0
2002-03-14 09:00:00	MSFT	Stock	31.08	31.12	30.865	30.9122	5500200.0
2002-03-14 10:00:00	MSFT	Stock	30.91	30.9595	30.75	30.8145	9745400.0
2002-03-14 11:00:00	MSFT	Stock	30.81	30.895	30.765	30.815	5150000.0
2002-03-14 12:00:00	MSFT	Stock	30.815	30.835	30.6	30.7	5005800.0
2002-03-14 13:00:00	MSFT	Stock	30.7	30.74	30.555	30.61	3982000.0
2002-03-14 14:00:00	MSFT	Stock	30.615	30.725	30.54	30.7	7392800.0
2002-03-14 15:00:00	MSFT	Stock	30.705	30.745	30.555	30.605	9503400.0
2002-03-14 16:00:00	MSFT	Stock	30.6065	30.7461	30.5	30.59	2234400.0
2002-03-14 17:00:00	MSFT	Stock	30.59	31.0386	30.4	30.4	88800.0
2002-03-14 18:00:00	MSFT	Stock	30.4	30.5	30.4	30.49	3000.0
2002-03-14 08:00:00	NVDA	Stock	0.4459	0.4459	0.4433	0.4433	1200000.0
2002-03-14 09:00:00	NVDA	Stock	0.4426	0.4467	0.4318	0.4324	232428000.0
2002-03-14 10:00:00	NVDA	Stock	0.4324	0.4373	0.4296	0.4343	247032000.0
2002-03-14 11:00:00	NVDA	Stock	0.4343	0.44	0.4329	0.4361	134028000.0
2002-03-14 12:00:00	NVDA	Stock	0.4361	0.4361	0.4309	0.4325	62520000.0
2002-03-14 13:00:00	NVDA	Stock	0.4325	0.4332	0.4304	0.4317	75180000.0
2002-03-14 14:00:00	NVDA	Stock	0.4317	0.4325	0.428	0.4306	102984000.0
2002-03-14 15:00:00	NVDA	Stock	0.4311	0.4323	0.421	0.4219	211584000.0
2002-03-14 16:00:00	NVDA	Stock	0.4217	0.425	0.4213	0.4248	20208000.0
2002-03-14 17:00:00	NVDA	Stock	0.4247	0.4278	0.4219	0.4241	636000.0
2002-03-14 18:00:00	NVDA	Stock	0.4241	0.4246	0.4234	0.4234	252000.0
2002-03-14 08:00:00	AMZN	Stock	0.788	0.79	0.751	0.7885	1456000.0
2002-03-14 09:00:00	AMZN	Stock	0.7515	0.7885	0.7275	0.73	99586000.0
2002-03-14 10:00:00	AMZN	Stock	0.734	0.7505	0.728	0.739	61324000.0
2002-03-14 11:00:00	AMZN	Stock	0.7395	0.7465	0.7385	0.743	16774000.0
2002-03-14 12:00:00	AMZN	Stock	0.743	0.746	0.7375	0.7419	11564000.0
2002-03-14 13:00:00	AMZN	Stock	0.7419	0.7455	0.739	0.74	15126000.0
2002-03-14 14:00:00	AMZN	Stock	0.7395	0.7405	0.717	0.7195	46286000.0
2002-03-14 15:00:00	AMZN	Stock	0.7205	0.7255	0.714	0.7245	29278000.0
2002-03-14 16:00:00	AMZN	Stock	0.725	0.7369	0.7235	0.73	6620000.0
2002-03-14 17:00:00	AMZN	Stock	0.724	0.7341	0.7225	0.7225	100000.0
2002-03-14 09:00:00	CL	Stock	27.4	27.4	27.275	27.325	197800.0
2002-03-14 10:00:00	CL	Stock	27.325	27.365	27.28	27.345	243600.0
2002-03-14 11:00:00	CL	Stock	27.335	27.415	27.325	27.395	314000.0
2002-03-14 12:00:00	CL	Stock	27.395	27.455	27.35	27.4	241400.0
2002-03-14 13:00:00	CL	Stock	27.41	27.45	27.255	27.27	436200.0
2002-03-14 14:00:00	CL	Stock	27.265	27.325	27.25	27.28	365000.0
2002-03-14 15:00:00	CL	Stock	27.285	27.325	27.25	27.275	418000.0
2002-03-14 16:00:00	CL	Stock	27.275	27.32	27.215	27.275	205400.0

> showing 50 of 18,295 rows — these rows as CSV

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