PREVIEW / stock_1hour / 2003-07-29

all stock 1-hour files

  file:    by_date/stock_1hour/2003/2003-07-29.parquet
  size:    467 KB
  rows:    22,223
  symbols: 1,600

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-07-29 08:00:00	AAPL	Stock	0.3752	0.3752	0.3752	0.3752	11200.0
2003-07-29 09:00:00	AAPL	Stock	0.3757	0.3802	0.3718	0.3754	12706456.0
2003-07-29 10:00:00	AAPL	Stock	0.375	0.375	0.3664	0.3704	36273048.0
2003-07-29 11:00:00	AAPL	Stock	0.3702	0.3748	0.368	0.3732	17176712.0
2003-07-29 12:00:00	AAPL	Stock	0.3732	0.3732	0.3693	0.3709	24033520.0
2003-07-29 13:00:00	AAPL	Stock	0.3709	0.3752	0.3709	0.3721	17577392.0
2003-07-29 14:00:00	AAPL	Stock	0.372	0.3736	0.3696	0.3702	18181912.0
2003-07-29 15:00:00	AAPL	Stock	0.3702	0.3716	0.3671	0.3716	48303920.0
2003-07-29 16:00:00	AAPL	Stock	0.3716	0.3716	0.37	0.3707	2139200.0
2003-07-29 17:00:00	AAPL	Stock	0.3713	0.3714	0.3713	0.3714	3046400.0
2003-07-29 08:00:00	MSFT	Stock	26.8	28.5	26.731	26.85	82903.0
2003-07-29 09:00:00	MSFT	Stock	26.85	26.9	26.6	26.65	6424109.0
2003-07-29 10:00:00	MSFT	Stock	26.65	26.66	26.24	26.34	12099327.0
2003-07-29 11:00:00	MSFT	Stock	26.334	26.73	26.3	26.63	8020825.0
2003-07-29 12:00:00	MSFT	Stock	26.636	26.64	26.51	26.52	4184791.0
2003-07-29 13:00:00	MSFT	Stock	26.53	26.687	26.45	26.5	5568407.0
2003-07-29 14:00:00	MSFT	Stock	26.5	26.6	26.39	26.43	6075958.0
2003-07-29 15:00:00	MSFT	Stock	26.42	26.528	26.24	26.49	8998238.0
2003-07-29 16:00:00	MSFT	Stock	26.48	26.55	26.35	26.47	4157592.0
2003-07-29 17:00:00	MSFT	Stock	26.47	26.48	26.43	26.45	408100.0
2003-07-29 18:00:00	MSFT	Stock	26.45	26.49	26.44	26.49	3850.0
2003-07-29 08:00:00	NVDA	Stock	0.1585	0.17	0.1562	0.1582	43620600.0
2003-07-29 09:00:00	NVDA	Stock	0.1579	0.1611	0.153	0.1602	544120440.0
2003-07-29 10:00:00	NVDA	Stock	0.1601	0.168	0.1572	0.1622	513023880.0
2003-07-29 11:00:00	NVDA	Stock	0.1623	0.1645	0.1607	0.1632	279267000.0
2003-07-29 12:00:00	NVDA	Stock	0.1635	0.1641	0.1587	0.1595	198031200.0
2003-07-29 13:00:00	NVDA	Stock	0.1596	0.1615	0.1579	0.158	193593360.0
2003-07-29 14:00:00	NVDA	Stock	0.158	0.1587	0.1558	0.1559	248734680.0
2003-07-29 15:00:00	NVDA	Stock	0.1562	0.1591	0.1548	0.1589	425316000.0
2003-07-29 16:00:00	NVDA	Stock	0.159	0.159	0.1577	0.1586	29945280.0
2003-07-29 17:00:00	NVDA	Stock	0.1588	0.1592	0.1586	0.1586	3356280.0
2003-07-29 18:00:00	NVDA	Stock	0.1592	0.1592	0.1587	0.1592	960000.0
2003-07-29 08:00:00	AMZN	Stock	2.108	2.11	2.1026	2.105	44000.0
2003-07-29 09:00:00	AMZN	Stock	2.105	2.125	2.07	2.0814	26760720.0
2003-07-29 10:00:00	AMZN	Stock	2.0815	2.0815	2.053	2.0635	32502440.0
2003-07-29 11:00:00	AMZN	Stock	2.0635	2.0965	2.0625	2.09	21768340.0
2003-07-29 12:00:00	AMZN	Stock	2.0905	2.0905	2.073	2.0775	10865580.0
2003-07-29 13:00:00	AMZN	Stock	2.078	2.087	2.073	2.075	11103220.0
2003-07-29 14:00:00	AMZN	Stock	2.075	2.083	2.0625	2.0725	11972340.0
2003-07-29 15:00:00	AMZN	Stock	2.073	2.0825	2.063	2.071	20996360.0
2003-07-29 16:00:00	AMZN	Stock	2.0695	2.075	2.0625	2.0685	4029000.0
2003-07-29 17:00:00	AMZN	Stock	2.0656	2.071	2.064	2.071	911780.0
2003-07-29 18:00:00	AMZN	Stock	2.065	2.065	2.062	2.062	25260.0
2003-07-29 09:00:00	CL	Stock	27.75	27.75	27.645	27.67	226600.0
2003-07-29 10:00:00	CL	Stock	27.67	27.67	27.515	27.62	751600.0
2003-07-29 11:00:00	CL	Stock	27.615	27.875	27.56	27.845	481000.0
2003-07-29 12:00:00	CL	Stock	27.845	27.915	27.775	27.82	286400.0
2003-07-29 13:00:00	CL	Stock	27.82	27.885	27.775	27.79	173200.0
2003-07-29 14:00:00	CL	Stock	27.795	27.85	27.63	27.64	198800.0
2003-07-29 15:00:00	CL	Stock	27.64	27.645	27.55	27.62	481200.0

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

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