PREVIEW / stock_1hour / 2003-07-01

all stock 1-hour files

  file:    by_date/stock_1hour/2003/2003-07-01.parquet
  size:    465 KB
  rows:    21,997
  symbols: 1,582

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-01 08:00:00	AAPL	Stock	0.3409	0.3409	0.3405	0.3405	1965600.0
2003-07-01 09:00:00	AAPL	Stock	0.3395	0.3402	0.3353	0.337	18523680.0
2003-07-01 10:00:00	AAPL	Stock	0.3373	0.3375	0.3305	0.3318	38112200.0
2003-07-01 11:00:00	AAPL	Stock	0.3316	0.3341	0.3316	0.3341	9889096.0
2003-07-01 12:00:00	AAPL	Stock	0.3341	0.3352	0.3321	0.3348	10354624.0
2003-07-01 13:00:00	AAPL	Stock	0.3346	0.338	0.3346	0.3366	9893128.0
2003-07-01 14:00:00	AAPL	Stock	0.3366	0.3425	0.3352	0.342	31919160.0
2003-07-01 15:00:00	AAPL	Stock	0.3418	0.3423	0.3396	0.3421	28092064.0
2003-07-01 16:00:00	AAPL	Stock	0.3423	0.3423	0.3402	0.3409	6601112.0
2003-07-01 17:00:00	AAPL	Stock	0.342	0.342	0.3409	0.3409	582400.0
2003-07-01 08:00:00	MSFT	Stock	25.61	25.71	24.25	25.6	177172.0
2003-07-01 09:00:00	MSFT	Stock	25.6	25.78	25.5	25.74	5853955.0
2003-07-01 10:00:00	MSFT	Stock	25.749	25.761	25.39	25.49	10631525.0
2003-07-01 11:00:00	MSFT	Stock	25.49	25.76	25.49	25.73	5494360.0
2003-07-01 12:00:00	MSFT	Stock	25.73	25.75	25.53	25.64	3922190.0
2003-07-01 13:00:00	MSFT	Stock	25.64	25.88	25.64	25.74	4965237.0
2003-07-01 14:00:00	MSFT	Stock	25.739	26.12	25.65	26.0	11499483.0
2003-07-01 15:00:00	MSFT	Stock	26.0	26.201	25.98	26.13	9759326.0
2003-07-01 16:00:00	MSFT	Stock	26.13	26.194	25.7867	26.151	2138454.0
2003-07-01 17:00:00	MSFT	Stock	26.151	26.1938	26.13	26.15	123200.0
2003-07-01 18:00:00	MSFT	Stock	26.15	26.15	26.0	26.13	2864.0
2003-07-01 08:00:00	NVDA	Stock	0.1913	0.1971	0.1908	0.1908	720000.0
2003-07-01 09:00:00	NVDA	Stock	0.1909	0.1917	0.1883	0.1905	64167480.0
2003-07-01 10:00:00	NVDA	Stock	0.1907	0.1912	0.1881	0.1881	109206600.0
2003-07-01 11:00:00	NVDA	Stock	0.1881	0.1892	0.1878	0.1887	51596640.0
2003-07-01 12:00:00	NVDA	Stock	0.1887	0.1887	0.1867	0.1878	42402120.0
2003-07-01 13:00:00	NVDA	Stock	0.1879	0.1902	0.1879	0.1895	82526880.0
2003-07-01 14:00:00	NVDA	Stock	0.1895	0.1987	0.1892	0.1971	308983440.0
2003-07-01 15:00:00	NVDA	Stock	0.1971	0.199	0.1957	0.1983	190835520.0
2003-07-01 16:00:00	NVDA	Stock	0.1984	0.1995	0.1981	0.1987	19760040.0
2003-07-01 17:00:00	NVDA	Stock	0.1987	0.1995	0.198	0.1987	768000.0
2003-07-01 08:00:00	AMZN	Stock	1.816	1.821	1.8155	1.8195	876000.0
2003-07-01 09:00:00	AMZN	Stock	1.8195	1.8245	1.8055	1.8136	13403760.0
2003-07-01 10:00:00	AMZN	Stock	1.814	1.815	1.785	1.786	25440700.0
2003-07-01 11:00:00	AMZN	Stock	1.7855	1.7975	1.785	1.795	11513860.0
2003-07-01 12:00:00	AMZN	Stock	1.795	1.7975	1.79	1.7975	7889520.0
2003-07-01 13:00:00	AMZN	Stock	1.797	1.8075	1.7965	1.8	9127060.0
2003-07-01 14:00:00	AMZN	Stock	1.8005	1.8545	1.7995	1.845	30385120.0
2003-07-01 15:00:00	AMZN	Stock	1.845	1.8645	1.8365	1.86	29636140.0
2003-07-01 16:00:00	AMZN	Stock	1.8605	1.87	1.859	1.866	1991000.0
2003-07-01 17:00:00	AMZN	Stock	1.865	1.869	1.8599	1.8665	432000.0
2003-07-01 18:00:00	AMZN	Stock	1.8695	1.87	1.865	1.865	27560.0
2003-07-01 09:00:00	CL	Stock	28.975	29.0	28.845	28.85	492800.0
2003-07-01 10:00:00	CL	Stock	28.85	28.965	28.725	28.965	546200.0
2003-07-01 11:00:00	CL	Stock	28.965	29.13	28.96	29.055	651600.0
2003-07-01 12:00:00	CL	Stock	29.065	29.13	28.975	29.125	363200.0
2003-07-01 13:00:00	CL	Stock	29.13	29.25	29.13	29.15	374000.0
2003-07-01 14:00:00	CL	Stock	29.155	29.3	29.115	29.24	570400.0
2003-07-01 15:00:00	CL	Stock	29.235	29.28	29.155	29.17	487800.0
2003-07-01 16:00:00	CL	Stock	29.17	29.17	29.125	29.125	287800.0

> showing 50 of 21,997 rows — these rows as CSV

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