PREVIEW / stock_1hour / 2004-01-29

all stock 1-hour files

  file:    by_date/stock_1hour/2004/2004-01-29.parquet
  size:    511 KB
  rows:    23,287
  symbols: 1,715

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-29 08:00:00	AAPL	Stock	0.4036	0.4059	0.4032	0.4054	299488.0
2004-01-29 09:00:00	AAPL	Stock	0.4059	0.4071	0.4016	0.4041	18562600.0
2004-01-29 10:00:00	AAPL	Stock	0.4041	0.4059	0.3995	0.4023	38056480.0
2004-01-29 11:00:00	AAPL	Stock	0.4025	0.4027	0.3995	0.4005	22593424.0
2004-01-29 12:00:00	AAPL	Stock	0.4005	0.4018	0.3984	0.4011	11151728.0
2004-01-29 13:00:00	AAPL	Stock	0.4007	0.4009	0.3966	0.3975	21480256.0
2004-01-29 14:00:00	AAPL	Stock	0.3975	0.405	0.3963	0.4043	36433600.0
2004-01-29 15:00:00	AAPL	Stock	0.4041	0.4061	0.4009	0.4046	53071704.0
2004-01-29 16:00:00	AAPL	Stock	0.4046	0.4061	0.4036	0.4036	4066048.0
2004-01-29 17:00:00	AAPL	Stock	0.405	0.405	0.405	0.405	18144.0
2004-01-29 18:00:00	AAPL	Stock	0.4036	0.4036	0.4036	0.4036	5600.0
2004-01-29 08:00:00	MSFT	Stock	27.71	27.85	27.69	27.73	82300.0
2004-01-29 09:00:00	MSFT	Stock	27.72	27.91	27.69	27.76	7256965.0
2004-01-29 10:00:00	MSFT	Stock	27.76	27.94	27.71	27.85	8840883.0
2004-01-29 11:00:00	MSFT	Stock	27.86	27.91	27.7	27.7	8309216.0
2004-01-29 12:00:00	MSFT	Stock	27.7	27.83	27.65	27.82	6103976.0
2004-01-29 13:00:00	MSFT	Stock	27.82	27.82	27.57	27.65	7163603.0
2004-01-29 14:00:00	MSFT	Stock	27.66	27.9	27.6	27.87	8831839.0
2004-01-29 15:00:00	MSFT	Stock	27.87	27.95	27.73	27.92	12309343.0
2004-01-29 16:00:00	MSFT	Stock	27.91	27.93	27.78	27.9	1208743.0
2004-01-29 17:00:00	MSFT	Stock	27.9	27.92	27.87	27.91	17811.0
2004-01-29 18:00:00	MSFT	Stock	27.87	27.92	27.87	27.92	700.0
2004-01-29 08:00:00	NVDA	Stock	0.1881	0.1882	0.1881	0.1881	108000.0
2004-01-29 09:00:00	NVDA	Stock	0.1881	0.1896	0.185	0.1867	64237080.0
2004-01-29 10:00:00	NVDA	Stock	0.1867	0.1867	0.1804	0.1814	145412040.0
2004-01-29 11:00:00	NVDA	Stock	0.1812	0.1817	0.1793	0.1794	88112880.0
2004-01-29 12:00:00	NVDA	Stock	0.1793	0.1813	0.1783	0.1813	89429160.0
2004-01-29 13:00:00	NVDA	Stock	0.1813	0.1817	0.1762	0.1772	124106400.0
2004-01-29 14:00:00	NVDA	Stock	0.1775	0.1832	0.1775	0.183	129708720.0
2004-01-29 15:00:00	NVDA	Stock	0.183	0.1846	0.1818	0.1826	117788520.0
2004-01-29 16:00:00	NVDA	Stock	0.1826	0.1837	0.1826	0.1833	3975840.0
2004-01-29 17:00:00	NVDA	Stock	0.1826	0.1826	0.1826	0.1826	17280.0
2004-01-29 18:00:00	NVDA	Stock	0.1832	0.1833	0.1832	0.1833	480000.0
2004-01-29 08:00:00	AMZN	Stock	2.5988	2.6075	2.598	2.603	460720.0
2004-01-29 09:00:00	AMZN	Stock	2.603	2.6175	2.55	2.5735	37793780.0
2004-01-29 10:00:00	AMZN	Stock	2.5745	2.5755	2.5195	2.5295	46358880.0
2004-01-29 11:00:00	AMZN	Stock	2.528	2.548	2.5085	2.5085	33179180.0
2004-01-29 12:00:00	AMZN	Stock	2.509	2.5265	2.4795	2.4835	40340460.0
2004-01-29 13:00:00	AMZN	Stock	2.4835	2.4855	2.43	2.435	72346120.0
2004-01-29 14:00:00	AMZN	Stock	2.435	2.472	2.43	2.462	98219100.0
2004-01-29 15:00:00	AMZN	Stock	2.4622	2.4825	2.441	2.4565	104071800.0
2004-01-29 16:00:00	AMZN	Stock	2.4575	2.4635	2.453	2.461	1810880.0
2004-01-29 17:00:00	AMZN	Stock	2.464	2.464	2.462	2.4635	240000.0
2004-01-29 18:00:00	AMZN	Stock	2.4625	2.4625	2.46	2.46	58000.0
2004-01-29 09:00:00	CL	Stock	25.525	25.58	25.5	25.52	586000.0
2004-01-29 10:00:00	CL	Stock	25.525	25.695	25.5	25.645	1209800.0
2004-01-29 11:00:00	CL	Stock	25.645	25.73	25.61	25.66	1008000.0
2004-01-29 12:00:00	CL	Stock	25.655	25.675	25.625	25.635	394200.0
2004-01-29 13:00:00	CL	Stock	25.64	25.745	25.635	25.745	419000.0
2004-01-29 14:00:00	CL	Stock	25.735	25.96	25.73	25.92	1112200.0

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

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