PREVIEW / stock_1hour / 2004-04-08

all stock 1-hour files

  file:    by_date/stock_1hour/2004/2004-04-08.parquet
  size:    504 KB
  rows:    24,108
  symbols: 1,755

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-04-08 08:00:00	AAPL	Stock	0.498	0.5018	0.497	0.4982	106400.0
2004-04-08 09:00:00	AAPL	Stock	0.4988	0.5	0.4929	0.4948	57102192.0
2004-04-08 10:00:00	AAPL	Stock	0.4946	0.4952	0.4886	0.4914	51147320.0
2004-04-08 11:00:00	AAPL	Stock	0.4911	0.492	0.4857	0.4884	25037824.0
2004-04-08 12:00:00	AAPL	Stock	0.4888	0.4909	0.4877	0.4893	10942232.0
2004-04-08 13:00:00	AAPL	Stock	0.4893	0.493	0.4893	0.4923	9502080.0
2004-04-08 14:00:00	AAPL	Stock	0.4925	0.4925	0.4893	0.4909	13795656.0
2004-04-08 15:00:00	AAPL	Stock	0.4911	0.4921	0.4893	0.4916	28411544.0
2004-04-08 16:00:00	AAPL	Stock	0.492	0.4982	0.4884	0.4916	1565032.0
2004-04-08 17:00:00	AAPL	Stock	0.4916	0.4916	0.4916	0.4916	3355800.0
2004-04-08 08:00:00	MSFT	Stock	25.9	25.9	25.8	25.85	124635.0
2004-04-08 09:00:00	MSFT	Stock	25.85	25.86	25.58	25.75	5620675.0
2004-04-08 10:00:00	MSFT	Stock	25.74	25.78	25.56	25.71	6384833.0
2004-04-08 11:00:00	MSFT	Stock	25.71	25.72	25.56	25.59	4502086.0
2004-04-08 12:00:00	MSFT	Stock	25.59	25.61	25.52	25.53	4039578.0
2004-04-08 13:00:00	MSFT	Stock	25.52	25.6	25.51	25.57	2275158.0
2004-04-08 14:00:00	MSFT	Stock	25.57	25.57	25.4	25.47	6446777.0
2004-04-08 15:00:00	MSFT	Stock	25.48	25.52	25.36	25.49	9491077.0
2004-04-08 16:00:00	MSFT	Stock	25.48	25.8	25.44	25.47	4249335.0
2004-04-08 17:00:00	MSFT	Stock	25.48	25.49	25.45	25.48	436732.0
2004-04-08 18:00:00	MSFT	Stock	25.48	25.5	25.48	25.49	2750.0
2004-04-08 08:00:00	NVDA	Stock	0.2217	0.2268	0.2197	0.2208	974400.0
2004-04-08 09:00:00	NVDA	Stock	0.2208	0.222	0.2192	0.2207	86840280.0
2004-04-08 10:00:00	NVDA	Stock	0.2208	0.2215	0.2198	0.2212	70758240.0
2004-04-08 11:00:00	NVDA	Stock	0.2212	0.2227	0.2202	0.2227	54775200.0
2004-04-08 12:00:00	NVDA	Stock	0.2227	0.225	0.2225	0.2235	58704600.0
2004-04-08 13:00:00	NVDA	Stock	0.2235	0.2242	0.2227	0.2228	20900280.0
2004-04-08 14:00:00	NVDA	Stock	0.2228	0.2228	0.2204	0.2221	49737960.0
2004-04-08 15:00:00	NVDA	Stock	0.2222	0.2234	0.2205	0.2228	90962640.0
2004-04-08 16:00:00	NVDA	Stock	0.2225	0.2228	0.2217	0.2225	1022880.0
2004-04-08 17:00:00	NVDA	Stock	0.2226	0.2226	0.2225	0.2226	2583000.0
2004-04-08 08:00:00	AMZN	Stock	2.3575	2.389	2.3575	2.3885	651660.0
2004-04-08 09:00:00	AMZN	Stock	2.3885	2.3925	2.357	2.367	34836340.0
2004-04-08 10:00:00	AMZN	Stock	2.367	2.375	2.35	2.368	25771920.0
2004-04-08 11:00:00	AMZN	Stock	2.3675	2.373	2.354	2.373	12972300.0
2004-04-08 12:00:00	AMZN	Stock	2.373	2.391	2.37	2.3875	18923880.0
2004-04-08 13:00:00	AMZN	Stock	2.3875	2.3985	2.3865	2.393	12382360.0
2004-04-08 14:00:00	AMZN	Stock	2.393	2.395	2.3825	2.3845	15987840.0
2004-04-08 15:00:00	AMZN	Stock	2.385	2.4075	2.3825	2.405	27831440.0
2004-04-08 16:00:00	AMZN	Stock	2.405	2.414	2.37	2.4055	12457800.0
2004-04-08 17:00:00	AMZN	Stock	2.405	2.406	2.405	2.405	652400.0
2004-04-08 09:00:00	CL	Stock	27.275	27.475	27.185	27.445	395800.0
2004-04-08 10:00:00	CL	Stock	27.45	27.45	27.27	27.285	376600.0
2004-04-08 11:00:00	CL	Stock	27.285	27.425	27.205	27.3	620400.0
2004-04-08 12:00:00	CL	Stock	27.3	27.305	27.205	27.235	304800.0
2004-04-08 13:00:00	CL	Stock	27.21	27.225	27.125	27.145	462600.0
2004-04-08 14:00:00	CL	Stock	27.145	27.165	27.05	27.055	242600.0
2004-04-08 15:00:00	CL	Stock	27.06	27.195	27.04	27.135	594200.0
2004-04-08 16:00:00	CL	Stock	27.135	27.135	27.1225	27.135	40600.0

> showing 49 of 24,108 rows — these rows as CSV

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