PREVIEW / stock_1hour / 2003-06-25

all stock 1-hour files

  file:    by_date/stock_1hour/2003/2003-06-25.parquet
  size:    453 KB
  rows:    21,498
  symbols: 1,583

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-06-25 08:00:00	AAPL	Stock	0.3368	0.3368	0.3368	0.3368	78400.0
2003-06-25 09:00:00	AAPL	Stock	0.3368	0.3432	0.3359	0.3432	23673384.0
2003-06-25 10:00:00	AAPL	Stock	0.3434	0.3439	0.3416	0.343	34639976.0
2003-06-25 11:00:00	AAPL	Stock	0.343	0.3439	0.3414	0.3418	17369128.0
2003-06-25 12:00:00	AAPL	Stock	0.3418	0.3439	0.3411	0.3438	11708480.0
2003-06-25 13:00:00	AAPL	Stock	0.3436	0.3464	0.3425	0.3427	23483936.0
2003-06-25 14:00:00	AAPL	Stock	0.3427	0.3446	0.338	0.34	52184552.0
2003-06-25 15:00:00	AAPL	Stock	0.3398	0.3418	0.3341	0.3389	100178456.0
2003-06-25 16:00:00	AAPL	Stock	0.3391	0.3427	0.3377	0.3417	7386176.0
2003-06-25 18:00:00	AAPL	Stock	0.3409	0.3409	0.3409	0.3409	476000.0
2003-06-25 08:00:00	MSFT	Stock	25.78	25.82	25.72	25.77	80830.0
2003-06-25 09:00:00	MSFT	Stock	25.75	25.92	25.6	25.89	7520924.0
2003-06-25 10:00:00	MSFT	Stock	25.89	25.96	25.8	25.89	6082120.0
2003-06-25 11:00:00	MSFT	Stock	25.89	25.987	25.82	25.89	4418139.0
2003-06-25 12:00:00	MSFT	Stock	25.89	25.935	25.81	25.87	2323167.0
2003-06-25 13:00:00	MSFT	Stock	25.88	25.89	25.69	25.699	3799721.0
2003-06-25 14:00:00	MSFT	Stock	25.69	25.87	25.53	25.61	12764584.0
2003-06-25 15:00:00	MSFT	Stock	25.609	25.66	25.139	25.25	15966060.0
2003-06-25 16:00:00	MSFT	Stock	25.26	25.82	25.17	25.23	1378005.0
2003-06-25 17:00:00	MSFT	Stock	25.23	25.6407	25.16	25.239	32905.0
2003-06-25 18:00:00	MSFT	Stock	25.22	25.25	25.19	25.25	68580.0
2003-06-25 08:00:00	NVDA	Stock	0.1937	0.194	0.1921	0.1923	2665200.0
2003-06-25 09:00:00	NVDA	Stock	0.1921	0.1946	0.1897	0.1945	104017080.0
2003-06-25 10:00:00	NVDA	Stock	0.1945	0.1982	0.1937	0.1979	219393600.0
2003-06-25 11:00:00	NVDA	Stock	0.1979	0.1982	0.1957	0.1962	101896560.0
2003-06-25 12:00:00	NVDA	Stock	0.1962	0.197	0.1957	0.1969	47580960.0
2003-06-25 13:00:00	NVDA	Stock	0.1969	0.1972	0.1954	0.1955	84332160.0
2003-06-25 14:00:00	NVDA	Stock	0.1956	0.1964	0.1927	0.1948	189983880.0
2003-06-25 15:00:00	NVDA	Stock	0.1948	0.1952	0.1909	0.1912	216734640.0
2003-06-25 16:00:00	NVDA	Stock	0.1912	0.197	0.19	0.1905	18523800.0
2003-06-25 17:00:00	NVDA	Stock	0.1908	0.1908	0.1902	0.1908	288000.0
2003-06-25 18:00:00	NVDA	Stock	0.1908	0.1912	0.1908	0.1912	1320000.0
2003-06-25 08:00:00	AMZN	Stock	1.77	1.77	1.77	1.77	20000.0
2003-06-25 09:00:00	AMZN	Stock	1.77	1.7965	1.7635	1.794	13889840.0
2003-06-25 10:00:00	AMZN	Stock	1.794	1.8065	1.79	1.802	32872000.0
2003-06-25 11:00:00	AMZN	Stock	1.8025	1.8042	1.7875	1.793	14841960.0
2003-06-25 12:00:00	AMZN	Stock	1.793	1.7995	1.787	1.7905	9325500.0
2003-06-25 13:00:00	AMZN	Stock	1.791	1.8005	1.7823	1.7823	10131120.0
2003-06-25 14:00:00	AMZN	Stock	1.7825	1.798	1.775	1.7875	17706160.0
2003-06-25 15:00:00	AMZN	Stock	1.7885	1.7925	1.7575	1.7665	22395160.0
2003-06-25 16:00:00	AMZN	Stock	1.766	1.7955	1.761	1.7674	616420.0
2003-06-25 17:00:00	AMZN	Stock	1.7675	1.7695	1.7675	1.7695	56000.0
2003-06-25 18:00:00	AMZN	Stock	1.7695	1.7695	1.7695	1.7695	86000.0
2003-06-25 09:00:00	CL	Stock	29.65	29.885	29.65	29.765	347600.0
2003-06-25 10:00:00	CL	Stock	29.76	29.85	29.675	29.75	571800.0
2003-06-25 11:00:00	CL	Stock	29.76	29.78	29.625	29.635	425000.0
2003-06-25 12:00:00	CL	Stock	29.63	29.685	29.625	29.685	205600.0
2003-06-25 13:00:00	CL	Stock	29.685	29.7	29.62	29.62	238600.0
2003-06-25 14:00:00	CL	Stock	29.615	29.69	29.575	29.585	424400.0
2003-06-25 15:00:00	CL	Stock	29.59	29.635	29.3	29.39	804400.0

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

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