PREVIEW / stock_1hour / 2004-01-15

all stock 1-hour files

  file:    by_date/stock_1hour/2004/2004-01-15.parquet
  size:    499 KB
  rows:    23,056
  symbols: 1,708

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-01-15 08:00:00	AAPL	Stock	0.4107	0.413	0.408	0.4089	7218680.0
2004-01-15 09:00:00	AAPL	Stock	0.4088	0.4127	0.4046	0.4048	205918160.0
2004-01-15 10:00:00	AAPL	Stock	0.4048	0.4134	0.4018	0.4107	235324432.0
2004-01-15 11:00:00	AAPL	Stock	0.4105	0.4134	0.4071	0.4127	135252040.0
2004-01-15 12:00:00	AAPL	Stock	0.4127	0.4179	0.41	0.4165	130629240.0
2004-01-15 13:00:00	AAPL	Stock	0.4166	0.4171	0.4134	0.4139	60551288.0
2004-01-15 14:00:00	AAPL	Stock	0.4139	0.4143	0.4089	0.4098	76805624.0
2004-01-15 15:00:00	AAPL	Stock	0.4098	0.4114	0.4071	0.4077	124897808.0
2004-01-15 16:00:00	AAPL	Stock	0.4077	0.4088	0.4071	0.408	7649208.0
2004-01-15 17:00:00	AAPL	Stock	0.408	0.4086	0.408	0.408	378000.0
2004-01-15 18:00:00	AAPL	Stock	0.4086	0.4093	0.408	0.4082	140000.0
2004-01-15 08:00:00	MSFT	Stock	27.7	27.7	27.53	27.63	161500.0
2004-01-15 09:00:00	MSFT	Stock	27.62	27.67	27.54	27.58	7314500.0
2004-01-15 10:00:00	MSFT	Stock	27.57	27.64	27.42	27.46	9111142.0
2004-01-15 11:00:00	MSFT	Stock	27.46	27.62	27.43	27.55	5798069.0
2004-01-15 12:00:00	MSFT	Stock	27.55	27.67	27.5	27.58	8525433.0
2004-01-15 13:00:00	MSFT	Stock	27.58	27.71	27.56	27.68	5898720.0
2004-01-15 14:00:00	MSFT	Stock	27.68	27.7	27.57	27.64	7486846.0
2004-01-15 15:00:00	MSFT	Stock	27.65	27.66	27.54	27.55	9830016.0
2004-01-15 16:00:00	MSFT	Stock	27.54	27.61	27.5	27.55	1142759.0
2004-01-15 17:00:00	MSFT	Stock	27.57	27.59	27.55	27.58	14167.0
2004-01-15 18:00:00	MSFT	Stock	27.58	27.6	27.55	27.55	20500.0
2004-01-15 08:00:00	NVDA	Stock	0.1995	0.2007	0.1995	0.2007	354000.0
2004-01-15 09:00:00	NVDA	Stock	0.2007	0.2022	0.197	0.1992	125286720.0
2004-01-15 10:00:00	NVDA	Stock	0.1992	0.2017	0.1983	0.1997	121133160.0
2004-01-15 11:00:00	NVDA	Stock	0.1997	0.2041	0.1996	0.2018	74682720.0
2004-01-15 12:00:00	NVDA	Stock	0.2016	0.2036	0.2007	0.2028	76662120.0
2004-01-15 13:00:00	NVDA	Stock	0.2028	0.2037	0.2022	0.2029	53600640.0
2004-01-15 14:00:00	NVDA	Stock	0.2029	0.2035	0.2015	0.2025	63450960.0
2004-01-15 15:00:00	NVDA	Stock	0.2025	0.2035	0.2015	0.2021	71337480.0
2004-01-15 16:00:00	NVDA	Stock	0.2021	0.2032	0.2021	0.2024	1207800.0
2004-01-15 17:00:00	NVDA	Stock	0.2025	0.2026	0.2024	0.2024	189960.0
2004-01-15 18:00:00	NVDA	Stock	0.2027	0.2027	0.2027	0.2027	12000.0
2004-01-15 08:00:00	AMZN	Stock	2.7475	2.7724	2.7455	2.7724	261400.0
2004-01-15 09:00:00	AMZN	Stock	2.7724	2.7725	2.731	2.745	31264080.0
2004-01-15 10:00:00	AMZN	Stock	2.745	2.775	2.7425	2.7705	35483720.0
2004-01-15 11:00:00	AMZN	Stock	2.7715	2.7945	2.762	2.789	23546120.0
2004-01-15 12:00:00	AMZN	Stock	2.7885	2.839	2.775	2.8235	61853600.0
2004-01-15 13:00:00	AMZN	Stock	2.8235	2.836	2.815	2.831	26447140.0
2004-01-15 14:00:00	AMZN	Stock	2.831	2.834	2.812	2.8145	19464400.0
2004-01-15 15:00:00	AMZN	Stock	2.8145	2.8175	2.7875	2.8035	40106780.0
2004-01-15 16:00:00	AMZN	Stock	2.8075	2.8235	2.795	2.823	1271660.0
2004-01-15 17:00:00	AMZN	Stock	2.8195	2.824	2.8195	2.8235	62780.0
2004-01-15 18:00:00	AMZN	Stock	2.824	2.8255	2.824	2.825	154000.0
2004-01-15 09:00:00	CL	Stock	25.26	25.3	25.2	25.26	470400.0
2004-01-15 10:00:00	CL	Stock	25.26	25.475	25.24	25.42	1520000.0
2004-01-15 11:00:00	CL	Stock	25.395	25.455	25.39	25.415	1120600.0
2004-01-15 12:00:00	CL	Stock	25.425	25.465	25.38	25.435	657000.0
2004-01-15 13:00:00	CL	Stock	25.44	25.55	25.35	25.5	580800.0
2004-01-15 14:00:00	CL	Stock	25.5	25.565	25.45	25.52	765400.0

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

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