PREVIEW / stock_1hour / 2004-04-20

all stock 1-hour files

  file:    by_date/stock_1hour/2004/2004-04-20.parquet
  size:    519 KB
  rows:    24,587
  symbols: 1,752

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-20 08:00:00	AAPL	Stock	0.5082	0.5082	0.5063	0.5075	388080.0
2004-04-20 09:00:00	AAPL	Stock	0.5063	0.5088	0.5029	0.5061	41887664.0
2004-04-20 10:00:00	AAPL	Stock	0.5061	0.5063	0.5027	0.5036	51675456.0
2004-04-20 11:00:00	AAPL	Stock	0.5036	0.5045	0.4993	0.502	65162944.0
2004-04-20 12:00:00	AAPL	Stock	0.5021	0.5057	0.5011	0.5046	29247624.0
2004-04-20 13:00:00	AAPL	Stock	0.5046	0.5046	0.5027	0.5036	18262384.0
2004-04-20 14:00:00	AAPL	Stock	0.5034	0.5036	0.5004	0.5004	36198624.0
2004-04-20 15:00:00	AAPL	Stock	0.5004	0.5013	0.4921	0.4938	89209064.0
2004-04-20 16:00:00	AAPL	Stock	0.4938	0.5019	0.4929	0.5019	3799264.0
2004-04-20 17:00:00	AAPL	Stock	0.4961	0.4961	0.493	0.493	72856.0
2004-04-20 08:00:00	MSFT	Stock	25.535	25.67	25.53	25.65	83850.0
2004-04-20 09:00:00	MSFT	Stock	25.69	25.78	25.53	25.78	6487500.0
2004-04-20 10:00:00	MSFT	Stock	25.77	25.84	25.7	25.8	8855153.0
2004-04-20 11:00:00	MSFT	Stock	25.8	25.81	25.69	25.74	8513992.0
2004-04-20 12:00:00	MSFT	Stock	25.74	25.84	25.74	25.8	5402292.0
2004-04-20 13:00:00	MSFT	Stock	25.79	25.88	25.75	25.83	5074717.0
2004-04-20 14:00:00	MSFT	Stock	25.84	25.841	25.56	25.6	9765577.0
2004-04-20 15:00:00	MSFT	Stock	25.6	25.67	25.31	25.31	12343756.0
2004-04-20 16:00:00	MSFT	Stock	25.32	25.7196	25.28	25.7196	1765105.0
2004-04-20 17:00:00	MSFT	Stock	25.46	25.48	25.3227	25.42	29816.0
2004-04-20 18:00:00	MSFT	Stock	25.43	25.43	25.43	25.43	1800.0
2004-04-20 09:00:00	NVDA	Stock	0.1965	0.1987	0.1954	0.1987	51016680.0
2004-04-20 10:00:00	NVDA	Stock	0.1988	0.1992	0.1942	0.1942	94383120.0
2004-04-20 11:00:00	NVDA	Stock	0.1942	0.1949	0.1925	0.1925	64680720.0
2004-04-20 12:00:00	NVDA	Stock	0.1926	0.1947	0.1926	0.1937	32849280.0
2004-04-20 13:00:00	NVDA	Stock	0.1937	0.1954	0.1936	0.1946	62824680.0
2004-04-20 14:00:00	NVDA	Stock	0.1947	0.1949	0.1917	0.1917	47017800.0
2004-04-20 15:00:00	NVDA	Stock	0.1917	0.1926	0.1881	0.1881	138577680.0
2004-04-20 16:00:00	NVDA	Stock	0.1881	0.19	0.1881	0.19	4447800.0
2004-04-20 17:00:00	NVDA	Stock	0.1906	0.1911	0.1882	0.1882	182280.0
2004-04-20 18:00:00	NVDA	Stock	0.1904	0.1904	0.1883	0.1887	138000.0
2004-04-20 08:00:00	AMZN	Stock	2.4325	2.4325	2.38	2.3885	193000.0
2004-04-20 09:00:00	AMZN	Stock	2.3885	2.3945	2.3515	2.37	26954040.0
2004-04-20 10:00:00	AMZN	Stock	2.369	2.3775	2.3205	2.344	36549700.0
2004-04-20 11:00:00	AMZN	Stock	2.3435	2.36	2.3265	2.3285	22450440.0
2004-04-20 12:00:00	AMZN	Stock	2.3285	2.331	2.288	2.2895	19665380.0
2004-04-20 13:00:00	AMZN	Stock	2.2895	2.3085	2.281	2.3009	17377180.0
2004-04-20 14:00:00	AMZN	Stock	2.301	2.305	2.2825	2.2885	13858820.0
2004-04-20 15:00:00	AMZN	Stock	2.2885	2.2895	2.259	2.2615	34455460.0
2004-04-20 16:00:00	AMZN	Stock	2.2615	2.33	2.25	2.2565	1242660.0
2004-04-20 17:00:00	AMZN	Stock	2.2595	2.2645	2.25	2.2645	470760.0
2004-04-20 18:00:00	AMZN	Stock	2.267	2.2675	2.267	2.267	102200.0
2004-04-20 09:00:00	CL	Stock	28.225	28.305	28.175	28.285	310000.0
2004-04-20 10:00:00	CL	Stock	28.285	28.425	28.175	28.37	634800.0
2004-04-20 11:00:00	CL	Stock	28.37	28.435	28.37	28.4	596000.0
2004-04-20 12:00:00	CL	Stock	28.4	28.495	28.4	28.48	503400.0
2004-04-20 13:00:00	CL	Stock	28.48	28.485	28.375	28.465	578000.0
2004-04-20 14:00:00	CL	Stock	28.465	28.475	28.325	28.37	474200.0
2004-04-20 15:00:00	CL	Stock	28.36	28.41	28.285	28.29	1231200.0
2004-04-20 16:00:00	CL	Stock	28.305	28.32	28.305	28.305	7200.0

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

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