PREVIEW / stock_1hour / 2004-01-13

all stock 1-hour files

  file:    by_date/stock_1hour/2004/2004-01-13.parquet
  size:    524 KB
  rows:    24,044
  symbols: 1,718

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-13 08:00:00	AAPL	Stock	0.4314	0.4402	0.4305	0.438	3814608.0
2004-01-13 09:00:00	AAPL	Stock	0.4384	0.4436	0.4357	0.4382	173312608.0
2004-01-13 10:00:00	AAPL	Stock	0.4379	0.4393	0.4276	0.4336	145461008.0
2004-01-13 11:00:00	AAPL	Stock	0.4336	0.4396	0.4313	0.4316	78185856.0
2004-01-13 12:00:00	AAPL	Stock	0.4313	0.4348	0.4282	0.4314	64855504.0
2004-01-13 13:00:00	AAPL	Stock	0.4314	0.4316	0.4286	0.4289	30815792.0
2004-01-13 14:00:00	AAPL	Stock	0.429	0.432	0.4261	0.432	59463768.0
2004-01-13 15:00:00	AAPL	Stock	0.4319	0.4321	0.4286	0.4307	71685712.0
2004-01-13 16:00:00	AAPL	Stock	0.4307	0.432	0.4293	0.4304	27346368.0
2004-01-13 17:00:00	AAPL	Stock	0.4304	0.4316	0.4293	0.4296	1412264.0
2004-01-13 18:00:00	AAPL	Stock	0.4296	0.4296	0.4296	0.4296	67200.0
2004-01-13 08:00:00	MSFT	Stock	27.57	27.62	26.65	27.56	37110.0
2004-01-13 09:00:00	MSFT	Stock	27.57	27.64	27.5	27.59	6301395.0
2004-01-13 10:00:00	MSFT	Stock	27.6	27.61	27.4	27.4	7988653.0
2004-01-13 11:00:00	MSFT	Stock	27.41	27.46	27.31	27.32	6578823.0
2004-01-13 12:00:00	MSFT	Stock	27.32	27.38	27.29	27.33	5032642.0
2004-01-13 13:00:00	MSFT	Stock	27.33	27.39	27.31	27.37	3920141.0
2004-01-13 14:00:00	MSFT	Stock	27.369	27.41	27.29	27.35	5245947.0
2004-01-13 15:00:00	MSFT	Stock	27.35	27.43	27.26	27.42	8498748.0
2004-01-13 16:00:00	MSFT	Stock	27.43	27.48	27.3015	27.46	5200732.0
2004-01-13 17:00:00	MSFT	Stock	27.46	27.52	27.4247	27.51	61061.0
2004-01-13 18:00:00	MSFT	Stock	27.51	27.51	27.48	27.48	600.0
2004-01-13 09:00:00	NVDA	Stock	0.2142	0.2174	0.2116	0.2128	55481880.0
2004-01-13 10:00:00	NVDA	Stock	0.2127	0.2129	0.2048	0.2048	119731200.0
2004-01-13 11:00:00	NVDA	Stock	0.2048	0.2068	0.2033	0.205	151542480.0
2004-01-13 12:00:00	NVDA	Stock	0.205	0.2076	0.2046	0.2054	101600280.0
2004-01-13 13:00:00	NVDA	Stock	0.2054	0.2058	0.2035	0.2037	92747280.0
2004-01-13 14:00:00	NVDA	Stock	0.2037	0.2038	0.2013	0.2032	128047080.0
2004-01-13 15:00:00	NVDA	Stock	0.2032	0.2042	0.2022	0.2035	169314120.0
2004-01-13 16:00:00	NVDA	Stock	0.2039	0.2043	0.2034	0.2043	6506640.0
2004-01-13 17:00:00	NVDA	Stock	0.2044	0.2044	0.2037	0.2037	576000.0
2004-01-13 18:00:00	NVDA	Stock	0.2037	0.2037	0.2035	0.2035	180000.0
2004-01-13 08:00:00	AMZN	Stock	2.645	2.645	2.645	2.645	4000.0
2004-01-13 09:00:00	AMZN	Stock	2.65	2.6505	2.6205	2.65	29537860.0
2004-01-13 10:00:00	AMZN	Stock	2.65	2.6745	2.638	2.658	42587180.0
2004-01-13 11:00:00	AMZN	Stock	2.6575	2.693	2.65	2.6695	42850620.0
2004-01-13 12:00:00	AMZN	Stock	2.669	2.7055	2.668	2.695	37786680.0
2004-01-13 13:00:00	AMZN	Stock	2.695	2.717	2.69	2.6995	28794380.0
2004-01-13 14:00:00	AMZN	Stock	2.6995	2.7244	2.693	2.7195	35924960.0
2004-01-13 15:00:00	AMZN	Stock	2.72	2.7495	2.6945	2.7415	63147760.0
2004-01-13 16:00:00	AMZN	Stock	2.7405	2.7475	2.7385	2.741	1775100.0
2004-01-13 17:00:00	AMZN	Stock	2.7385	2.7405	2.7385	2.739	317560.0
2004-01-13 18:00:00	AMZN	Stock	2.741	2.7435	2.741	2.7435	6000.0
2004-01-13 09:00:00	CL	Stock	25.375	25.45	25.32	25.385	999600.0
2004-01-13 10:00:00	CL	Stock	25.385	25.405	25.325	25.35	1042400.0
2004-01-13 11:00:00	CL	Stock	25.35	25.365	25.265	25.28	736800.0
2004-01-13 12:00:00	CL	Stock	25.28	25.295	25.215	25.25	734600.0
2004-01-13 13:00:00	CL	Stock	25.245	25.3	25.2	25.25	729800.0
2004-01-13 14:00:00	CL	Stock	25.25	25.3	25.135	25.2	604800.0
2004-01-13 15:00:00	CL	Stock	25.2	25.34	25.19	25.3	1346400.0

> showing 50 of 24,044 rows — these rows as CSV

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