PREVIEW / stock_1hour / 2004-11-05

all stock 1-hour files

  file:    by_date/stock_1hour/2004/2004-11-05.parquet
  size:    528 KB
  rows:    24,907
  symbols: 1,868

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-11-05 08:00:00	AAPL	Stock	0.9696	0.9857	0.967	0.9857	7056672.0
2004-11-05 09:00:00	AAPL	Stock	0.9857	0.9857	0.9586	0.9696	159966912.0
2004-11-05 10:00:00	AAPL	Stock	0.9696	0.973	0.9589	0.9598	184506952.0
2004-11-05 11:00:00	AAPL	Stock	0.9596	0.9611	0.9332	0.9334	299993736.0
2004-11-05 12:00:00	AAPL	Stock	0.9334	0.9505	0.9293	0.9488	144056752.0
2004-11-05 13:00:00	AAPL	Stock	0.9491	0.9523	0.945	0.9495	78407112.0
2004-11-05 14:00:00	AAPL	Stock	0.9493	0.9668	0.9488	0.9641	129669904.0
2004-11-05 15:00:00	AAPL	Stock	0.9641	0.9777	0.9634	0.9766	169739528.0
2004-11-05 16:00:00	AAPL	Stock	0.9766	0.98	0.9757	0.9786	7608888.0
2004-11-05 17:00:00	AAPL	Stock	0.9795	0.9798	0.9771	0.9782	1391824.0
2004-11-05 18:00:00	AAPL	Stock	0.9796	0.9796	0.9782	0.9784	179200.0
2004-11-05 08:00:00	MSFT	Stock	29.06	29.45	29.02	29.27	283220.0
2004-11-05 09:00:00	MSFT	Stock	29.28	29.31	29.0	29.24	15168842.0
2004-11-05 10:00:00	MSFT	Stock	29.24	29.3	29.16	29.24	13076170.0
2004-11-05 11:00:00	MSFT	Stock	29.24	29.26	29.05	29.09	14881786.0
2004-11-05 12:00:00	MSFT	Stock	29.09	29.23	29.03	29.22	6250945.0
2004-11-05 13:00:00	MSFT	Stock	29.22	29.31	29.2	29.25	8841122.0
2004-11-05 14:00:00	MSFT	Stock	29.24	29.26	29.11	29.17	9263875.0
2004-11-05 15:00:00	MSFT	Stock	29.17	29.27	29.11	29.24	13683861.0
2004-11-05 16:00:00	MSFT	Stock	29.25	29.36	29.1979	29.32	6247285.0
2004-11-05 17:00:00	MSFT	Stock	29.31	29.33	28.99	29.3	404263.0
2004-11-05 18:00:00	MSFT	Stock	29.32	29.32	29.31	29.31	400.0
2004-11-05 08:00:00	NVDA	Stock	0.1432	0.1458	0.1402	0.145	115564440.0
2004-11-05 09:00:00	NVDA	Stock	0.145	0.1564	0.1297	0.1555	1276236360.0
2004-11-05 10:00:00	NVDA	Stock	0.1555	0.1558	0.1466	0.148	972472800.0
2004-11-05 11:00:00	NVDA	Stock	0.148	0.149	0.1462	0.1487	467623920.0
2004-11-05 12:00:00	NVDA	Stock	0.1487	0.1496	0.1477	0.1486	235760160.0
2004-11-05 13:00:00	NVDA	Stock	0.1486	0.1489	0.1457	0.1473	161174040.0
2004-11-05 14:00:00	NVDA	Stock	0.1473	0.1485	0.1465	0.1478	138506400.0
2004-11-05 15:00:00	NVDA	Stock	0.1478	0.1491	0.1466	0.1466	366323520.0
2004-11-05 16:00:00	NVDA	Stock	0.1466	0.1483	0.1466	0.1469	31568880.0
2004-11-05 17:00:00	NVDA	Stock	0.147	0.1475	0.1467	0.1471	1892880.0
2004-11-05 08:00:00	AMZN	Stock	1.8475	1.8825	1.8475	1.88	520400.0
2004-11-05 09:00:00	AMZN	Stock	1.88	1.88	1.84	1.85	21713840.0
2004-11-05 10:00:00	AMZN	Stock	1.85	1.854	1.8155	1.82	40750660.0
2004-11-05 11:00:00	AMZN	Stock	1.82	1.827	1.802	1.8055	25463060.0
2004-11-05 12:00:00	AMZN	Stock	1.805	1.823	1.801	1.82	14831040.0
2004-11-05 13:00:00	AMZN	Stock	1.8205	1.833	1.8125	1.827	7723220.0
2004-11-05 14:00:00	AMZN	Stock	1.8265	1.833	1.8195	1.8275	11501360.0
2004-11-05 15:00:00	AMZN	Stock	1.828	1.8385	1.8235	1.826	21635880.0
2004-11-05 16:00:00	AMZN	Stock	1.828	1.8285	1.823	1.823	2589960.0
2004-11-05 17:00:00	AMZN	Stock	1.828	1.828	1.828	1.828	215440.0
2004-11-05 18:00:00	AMZN	Stock	1.846	1.846	1.821	1.825	74000.0
2004-11-05 08:00:00	CL	Stock	23.36	23.36	23.36	23.36	400.0
2004-11-05 09:00:00	CL	Stock	23.35	23.445	23.3	23.405	902800.0
2004-11-05 10:00:00	CL	Stock	23.405	23.53	23.4	23.52	1039600.0
2004-11-05 11:00:00	CL	Stock	23.515	23.515	23.375	23.439	687200.0
2004-11-05 12:00:00	CL	Stock	23.44	23.5	23.42	23.495	316800.0
2004-11-05 13:00:00	CL	Stock	23.495	23.525	23.46	23.505	439200.0
2004-11-05 14:00:00	CL	Stock	23.515	23.555	23.48	23.495	577400.0

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

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