PREVIEW / stock_1hour / 2003-08-05

all stock 1-hour files

  file:    by_date/stock_1hour/2003/2003-08-05.parquet
  size:    468 KB
  rows:    22,273
  symbols: 1,599

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
2003-08-05 08:00:00	AAPL	Stock	0.379	0.379	0.3786	0.3786	1736000.0
2003-08-05 09:00:00	AAPL	Stock	0.3804	0.3821	0.373	0.375	17019688.0
2003-08-05 10:00:00	AAPL	Stock	0.3748	0.38	0.3729	0.3747	43624840.0
2003-08-05 11:00:00	AAPL	Stock	0.3746	0.3748	0.3705	0.373	14940464.0
2003-08-05 12:00:00	AAPL	Stock	0.373	0.3748	0.3714	0.3729	9973264.0
2003-08-05 13:00:00	AAPL	Stock	0.3729	0.3736	0.3689	0.3693	14332808.0
2003-08-05 14:00:00	AAPL	Stock	0.3695	0.3702	0.3661	0.3661	31437056.0
2003-08-05 15:00:00	AAPL	Stock	0.3661	0.3663	0.3589	0.3643	63701008.0
2003-08-05 16:00:00	AAPL	Stock	0.3643	0.3646	0.3618	0.362	3074400.0
2003-08-05 17:00:00	AAPL	Stock	0.3638	0.3638	0.3638	0.3638	1573600.0
2003-08-05 08:00:00	MSFT	Stock	26.13	26.35	26.13	26.32	124388.0
2003-08-05 09:00:00	MSFT	Stock	26.31	26.5	26.21	26.42	7559287.0
2003-08-05 10:00:00	MSFT	Stock	26.43	26.54	26.176	26.28	10348995.0
2003-08-05 11:00:00	MSFT	Stock	26.27	26.28	26.09	26.19	6097306.0
2003-08-05 12:00:00	MSFT	Stock	26.19	26.29	26.11	26.12	2718487.0
2003-08-05 13:00:00	MSFT	Stock	26.13	26.13	26.0	26.07	6628985.0
2003-08-05 14:00:00	MSFT	Stock	26.07	26.11	25.97	26.02	5757862.0
2003-08-05 15:00:00	MSFT	Stock	26.02	26.04	25.6	25.64	11694486.0
2003-08-05 16:00:00	MSFT	Stock	25.64	26.25	25.09	25.33	1048208.0
2003-08-05 17:00:00	MSFT	Stock	25.35	25.9191	25.32	25.43	902690.0
2003-08-05 18:00:00	MSFT	Stock	25.43	25.9557	25.4	25.9557	65020.0
2003-08-05 08:00:00	NVDA	Stock	0.1708	0.1761	0.1708	0.1752	4075800.0
2003-08-05 09:00:00	NVDA	Stock	0.1758	0.1789	0.173	0.1778	296657760.0
2003-08-05 10:00:00	NVDA	Stock	0.1779	0.1787	0.1766	0.1776	234507840.0
2003-08-05 11:00:00	NVDA	Stock	0.1776	0.1781	0.1762	0.177	99383760.0
2003-08-05 12:00:00	NVDA	Stock	0.1769	0.1775	0.175	0.1752	53757600.0
2003-08-05 13:00:00	NVDA	Stock	0.1752	0.1761	0.174	0.1744	45626040.0
2003-08-05 14:00:00	NVDA	Stock	0.1743	0.1744	0.1717	0.1732	72808200.0
2003-08-05 15:00:00	NVDA	Stock	0.1731	0.1737	0.1686	0.1697	164342520.0
2003-08-05 16:00:00	NVDA	Stock	0.1698	0.1714	0.1658	0.1702	6678000.0
2003-08-05 17:00:00	NVDA	Stock	0.1666	0.1722	0.1658	0.166	3238800.0
2003-08-05 18:00:00	NVDA	Stock	0.1662	0.1662	0.1658	0.1658	144000.0
2003-08-05 08:00:00	AMZN	Stock	1.98	1.9825	1.975	1.975	75000.0
2003-08-05 09:00:00	AMZN	Stock	1.9725	1.9825	1.9545	1.9655	15572080.0
2003-08-05 10:00:00	AMZN	Stock	1.966	1.98	1.957	1.9685	17052920.0
2003-08-05 11:00:00	AMZN	Stock	1.9685	1.99	1.9665	1.989	14370140.0
2003-08-05 12:00:00	AMZN	Stock	1.989	1.9925	1.9715	1.9815	18342280.0
2003-08-05 13:00:00	AMZN	Stock	1.982	1.984	1.963	1.971	8297660.0
2003-08-05 14:00:00	AMZN	Stock	1.9695	1.97	1.946	1.9462	16127040.0
2003-08-05 15:00:00	AMZN	Stock	1.946	1.951	1.9315	1.9365	30989660.0
2003-08-05 16:00:00	AMZN	Stock	1.9365	1.9405	1.915	1.918	1412160.0
2003-08-05 17:00:00	AMZN	Stock	1.918	1.9395	1.918	1.925	489700.0
2003-08-05 18:00:00	AMZN	Stock	1.9245	1.927	1.9245	1.927	45000.0
2003-08-05 09:00:00	CL	Stock	27.24	27.255	27.1	27.13	312600.0
2003-08-05 10:00:00	CL	Stock	27.14	27.26	27.11	27.19	456600.0
2003-08-05 11:00:00	CL	Stock	27.19	27.385	27.17	27.355	338400.0
2003-08-05 12:00:00	CL	Stock	27.36	27.36	27.28	27.29	295200.0
2003-08-05 13:00:00	CL	Stock	27.285	27.38	27.28	27.325	415800.0
2003-08-05 14:00:00	CL	Stock	27.325	27.405	27.28	27.325	347600.0
2003-08-05 15:00:00	CL	Stock	27.33	27.33	27.13	27.16	576400.0

> showing 50 of 22,273 rows — these rows as CSV

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