PREVIEW / stock_1hour / 2004-01-14

all stock 1-hour files

  file:    by_date/stock_1hour/2004/2004-01-14.parquet
  size:    509 KB
  rows:    23,196
  symbols: 1,709

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-14 08:00:00	AAPL	Stock	0.4357	0.4373	0.4341	0.4373	694400.0
2004-01-14 09:00:00	AAPL	Stock	0.4373	0.4382	0.4334	0.4347	83943888.0
2004-01-14 10:00:00	AAPL	Stock	0.4347	0.4352	0.4293	0.4296	73108616.0
2004-01-14 11:00:00	AAPL	Stock	0.4295	0.4325	0.428	0.4284	66005016.0
2004-01-14 12:00:00	AAPL	Stock	0.4284	0.4289	0.4246	0.4268	53883312.0
2004-01-14 13:00:00	AAPL	Stock	0.4268	0.4295	0.4254	0.4284	42581112.0
2004-01-14 14:00:00	AAPL	Stock	0.4286	0.433	0.4281	0.4321	68685680.0
2004-01-14 15:00:00	AAPL	Stock	0.4321	0.4339	0.4314	0.4314	139097840.0
2004-01-14 16:00:00	AAPL	Stock	0.4314	0.4371	0.393	0.4093	55355608.0
2004-01-14 17:00:00	AAPL	Stock	0.4089	0.4325	0.4071	0.4093	10436160.0
2004-01-14 18:00:00	AAPL	Stock	0.4093	0.4098	0.408	0.408	890400.0
2004-01-14 08:00:00	MSFT	Stock	27.57	27.58	27.5	27.58	31310.0
2004-01-14 09:00:00	MSFT	Stock	27.58	27.58	27.43	27.5	4565830.0
2004-01-14 10:00:00	MSFT	Stock	27.5	27.6	27.49	27.55	5371665.0
2004-01-14 11:00:00	MSFT	Stock	27.56	27.62	27.51	27.56	6347745.0
2004-01-14 12:00:00	MSFT	Stock	27.55	27.61	27.54	27.57	3931894.0
2004-01-14 13:00:00	MSFT	Stock	27.56	27.61	27.53	27.57	2987654.0
2004-01-14 14:00:00	MSFT	Stock	27.57	27.65	27.55	27.63	5618428.0
2004-01-14 15:00:00	MSFT	Stock	27.62	27.73	27.6	27.7	11515458.0
2004-01-14 16:00:00	MSFT	Stock	27.7	27.78	27.4	27.4	1762896.0
2004-01-14 17:00:00	MSFT	Stock	27.4	27.7	27.35	27.44	186737.0
2004-01-14 18:00:00	MSFT	Stock	27.44	27.48	27.43	27.45	12695.0
2004-01-14 08:00:00	NVDA	Stock	0.2044	0.2054	0.204	0.2042	1213680.0
2004-01-14 09:00:00	NVDA	Stock	0.2052	0.2075	0.2037	0.2057	98359560.0
2004-01-14 10:00:00	NVDA	Stock	0.2057	0.2073	0.2033	0.2041	102794160.0
2004-01-14 11:00:00	NVDA	Stock	0.2041	0.2058	0.2038	0.2049	39476520.0
2004-01-14 12:00:00	NVDA	Stock	0.2049	0.205	0.2002	0.2015	92427360.0
2004-01-14 13:00:00	NVDA	Stock	0.2015	0.2033	0.2009	0.2023	51855840.0
2004-01-14 14:00:00	NVDA	Stock	0.2024	0.2045	0.2017	0.2036	39416160.0
2004-01-14 15:00:00	NVDA	Stock	0.2036	0.2047	0.2019	0.2025	106477800.0
2004-01-14 16:00:00	NVDA	Stock	0.2022	0.2033	0.1992	0.1992	5310000.0
2004-01-14 17:00:00	NVDA	Stock	0.1997	0.2022	0.1992	0.1992	1350600.0
2004-01-14 18:00:00	NVDA	Stock	0.1997	0.1997	0.1997	0.1997	180000.0
2004-01-14 08:00:00	AMZN	Stock	2.74	2.75	2.74	2.745	154000.0
2004-01-14 09:00:00	AMZN	Stock	2.743	2.745	2.7075	2.722	24832960.0
2004-01-14 10:00:00	AMZN	Stock	2.722	2.754	2.7125	2.7475	41011860.0
2004-01-14 11:00:00	AMZN	Stock	2.7475	2.7735	2.729	2.7335	37612540.0
2004-01-14 12:00:00	AMZN	Stock	2.733	2.7485	2.729	2.745	17228020.0
2004-01-14 13:00:00	AMZN	Stock	2.7455	2.7675	2.74	2.763	16878180.0
2004-01-14 14:00:00	AMZN	Stock	2.763	2.7905	2.7625	2.785	27547520.0
2004-01-14 15:00:00	AMZN	Stock	2.7845	2.7995	2.78	2.7905	42378780.0
2004-01-14 16:00:00	AMZN	Stock	2.79	2.795	2.714	2.74	7342760.0
2004-01-14 17:00:00	AMZN	Stock	2.74	2.7952	2.7375	2.757	2199880.0
2004-01-14 18:00:00	AMZN	Stock	2.7575	2.762	2.745	2.7475	398000.0
2004-01-14 09:00:00	CL	Stock	25.425	25.46	25.345	25.38	660800.0
2004-01-14 10:00:00	CL	Stock	25.38	25.425	25.04	25.135	1059200.0
2004-01-14 11:00:00	CL	Stock	25.14	25.2345	25.05	25.12	1041800.0
2004-01-14 12:00:00	CL	Stock	25.12	25.16	25.05	25.125	546200.0
2004-01-14 13:00:00	CL	Stock	25.11	25.2	25.105	25.15	551400.0
2004-01-14 14:00:00	CL	Stock	25.155	25.19	25.075	25.135	1077200.0

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

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