PREVIEW / stock_1hour / 2004-04-15

all stock 1-hour files

  file:    by_date/stock_1hour/2004/2004-04-15.parquet
  size:    514 KB
  rows:    23,926
  symbols: 1,753

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-15 08:00:00	AAPL	Stock	0.5232	0.53	0.507	0.5089	20651904.0
2004-04-15 09:00:00	AAPL	Stock	0.5104	0.525	0.5095	0.5225	303538872.0
2004-04-15 10:00:00	AAPL	Stock	0.5229	0.5282	0.5154	0.518	310542344.0
2004-04-15 11:00:00	AAPL	Stock	0.5182	0.5186	0.5029	0.5134	183168384.0
2004-04-15 12:00:00	AAPL	Stock	0.5138	0.5155	0.5061	0.5125	99578752.0
2004-04-15 13:00:00	AAPL	Stock	0.5125	0.5168	0.5107	0.5139	104569248.0
2004-04-15 14:00:00	AAPL	Stock	0.5141	0.5257	0.5138	0.5255	120622376.0
2004-04-15 15:00:00	AAPL	Stock	0.525	0.5268	0.52	0.5238	123375056.0
2004-04-15 16:00:00	AAPL	Stock	0.5246	0.525	0.5171	0.518	9112768.0
2004-04-15 17:00:00	AAPL	Stock	0.5182	0.523	0.5161	0.5182	1684536.0
2004-04-15 18:00:00	AAPL	Stock	0.5182	0.5188	0.5171	0.5171	106400.0
2004-04-15 08:00:00	MSFT	Stock	25.57	25.6	25.55	25.56	25135.0
2004-04-15 09:00:00	MSFT	Stock	25.56	25.73	25.53	25.68	4624590.0
2004-04-15 10:00:00	MSFT	Stock	25.69	25.73	25.55	25.59	8477554.0
2004-04-15 11:00:00	MSFT	Stock	25.6	25.61	25.44	25.49	6958348.0
2004-04-15 12:00:00	MSFT	Stock	25.48	25.51	25.37	25.47	6709606.0
2004-04-15 13:00:00	MSFT	Stock	25.47	25.48	25.13	25.17	8895841.0
2004-04-15 14:00:00	MSFT	Stock	25.17	25.33	25.11	25.29	5620263.0
2004-04-15 15:00:00	MSFT	Stock	25.29	25.34	25.16	25.24	7327696.0
2004-04-15 16:00:00	MSFT	Stock	25.25	25.42	25.05	25.05	6295732.0
2004-04-15 17:00:00	MSFT	Stock	25.06	25.2	25.0	25.08	203691.0
2004-04-15 18:00:00	MSFT	Stock	25.1	25.4491	25.08	25.1	92613.0
2004-04-15 08:00:00	NVDA	Stock	0.2152	0.2152	0.2152	0.2152	708000.0
2004-04-15 09:00:00	NVDA	Stock	0.2137	0.215	0.2092	0.2116	46083360.0
2004-04-15 10:00:00	NVDA	Stock	0.2113	0.2122	0.2037	0.204	132042960.0
2004-04-15 11:00:00	NVDA	Stock	0.2041	0.2062	0.204	0.2061	83067960.0
2004-04-15 12:00:00	NVDA	Stock	0.2061	0.2069	0.2037	0.2046	68498400.0
2004-04-15 13:00:00	NVDA	Stock	0.205	0.2052	0.2027	0.2029	63472320.0
2004-04-15 14:00:00	NVDA	Stock	0.2028	0.2042	0.2025	0.2037	72057480.0
2004-04-15 15:00:00	NVDA	Stock	0.2036	0.2052	0.2027	0.2037	108887400.0
2004-04-15 16:00:00	NVDA	Stock	0.2037	0.2046	0.2017	0.2042	4376040.0
2004-04-15 17:00:00	NVDA	Stock	0.2028	0.2033	0.2017	0.2017	1989360.0
2004-04-15 18:00:00	NVDA	Stock	0.2017	0.2017	0.2013	0.2013	168000.0
2004-04-15 08:00:00	AMZN	Stock	2.345	2.36	2.345	2.354	20000.0
2004-04-15 09:00:00	AMZN	Stock	2.3515	2.3515	2.322	2.329	10838860.0
2004-04-15 10:00:00	AMZN	Stock	2.33	2.3655	2.3	2.348	19215780.0
2004-04-15 11:00:00	AMZN	Stock	2.3475	2.38	2.3475	2.3615	16340280.0
2004-04-15 12:00:00	AMZN	Stock	2.3625	2.3665	2.353	2.3615	8606280.0
2004-04-15 13:00:00	AMZN	Stock	2.361	2.3615	2.3415	2.345	6321640.0
2004-04-15 14:00:00	AMZN	Stock	2.3455	2.3625	2.3335	2.361	10760220.0
2004-04-15 15:00:00	AMZN	Stock	2.3605	2.3685	2.347	2.352	7390260.0
2004-04-15 16:00:00	AMZN	Stock	2.3515	2.356	2.3385	2.339	475900.0
2004-04-15 17:00:00	AMZN	Stock	2.324	2.3495	2.321	2.3215	236480.0
2004-04-15 18:00:00	AMZN	Stock	2.321	2.321	2.321	2.321	20000.0
2004-04-15 09:00:00	CL	Stock	27.525	27.575	27.45	27.54	381800.0
2004-04-15 10:00:00	CL	Stock	27.55	27.65	27.45	27.62	655200.0
2004-04-15 11:00:00	CL	Stock	27.62	27.63	27.575	27.625	457800.0
2004-04-15 12:00:00	CL	Stock	27.63	27.77	27.625	27.725	608600.0
2004-04-15 13:00:00	CL	Stock	27.725	27.73	27.665	27.68	248200.0
2004-04-15 14:00:00	CL	Stock	27.675	27.79	27.66	27.79	492600.0

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

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