PREVIEW / stock_1hour / 2004-05-28

all stock 1-hour files

  file:    by_date/stock_1hour/2004/2004-05-28.parquet
  size:    500 KB
  rows:    24,028
  symbols: 1,772

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-05-28 08:00:00	AAPL	Stock	0.5043	0.5043	0.4961	0.5039	28000.0
2004-05-28 09:00:00	AAPL	Stock	0.5021	0.5048	0.497	0.4971	17654672.0
2004-05-28 10:00:00	AAPL	Stock	0.4973	0.5002	0.4964	0.4995	22859984.0
2004-05-28 11:00:00	AAPL	Stock	0.4996	0.5023	0.4995	0.5005	11154416.0
2004-05-28 12:00:00	AAPL	Stock	0.5007	0.5039	0.4984	0.4989	19984552.0
2004-05-28 13:00:00	AAPL	Stock	0.4991	0.5	0.498	0.4996	12899712.0
2004-05-28 14:00:00	AAPL	Stock	0.4996	0.5005	0.4989	0.4996	9731568.0
2004-05-28 15:00:00	AAPL	Stock	0.4996	0.5016	0.4982	0.5013	30138136.0
2004-05-28 16:00:00	AAPL	Stock	0.5009	0.5016	0.5009	0.5013	2971640.0
2004-05-28 17:00:00	AAPL	Stock	0.5	0.5	0.5	0.5	231728.0
2004-05-28 08:00:00	MSFT	Stock	26.19	26.19	26.12	26.12	758300.0
2004-05-28 09:00:00	MSFT	Stock	26.15	26.2	26.02	26.05	4821817.0
2004-05-28 10:00:00	MSFT	Stock	26.05	26.13	26.02	26.08	4249157.0
2004-05-28 11:00:00	MSFT	Stock	26.08	26.16	26.06	26.12	3662282.0
2004-05-28 12:00:00	MSFT	Stock	26.13	26.18	26.1	26.11	2748542.0
2004-05-28 13:00:00	MSFT	Stock	26.12	26.12	26.039	26.08	2557234.0
2004-05-28 14:00:00	MSFT	Stock	26.09	26.17	26.08	26.11	4676313.0
2004-05-28 15:00:00	MSFT	Stock	26.11	26.25	26.07	26.24	6813505.0
2004-05-28 16:00:00	MSFT	Stock	26.24	26.354	26.11	26.35	4209032.0
2004-05-28 17:00:00	MSFT	Stock	26.29	26.3	26.29	26.3	2100.0
2004-05-28 18:00:00	MSFT	Stock	26.27	26.3	26.27	26.3	2750.0
2004-05-28 09:00:00	NVDA	Stock	0.1906	0.1907	0.1889	0.1902	50561400.0
2004-05-28 10:00:00	NVDA	Stock	0.1902	0.1912	0.1897	0.1912	48890040.0
2004-05-28 11:00:00	NVDA	Stock	0.1912	0.1941	0.1912	0.1935	103017000.0
2004-05-28 12:00:00	NVDA	Stock	0.1934	0.1946	0.1927	0.1939	59065560.0
2004-05-28 13:00:00	NVDA	Stock	0.194	0.1942	0.193	0.1937	26784000.0
2004-05-28 14:00:00	NVDA	Stock	0.1936	0.1948	0.1935	0.1947	45723360.0
2004-05-28 15:00:00	NVDA	Stock	0.1947	0.1962	0.1947	0.1961	128657400.0
2004-05-28 16:00:00	NVDA	Stock	0.1952	0.1965	0.1952	0.1964	109777800.0
2004-05-28 17:00:00	NVDA	Stock	0.1967	0.1967	0.1935	0.1962	9787800.0
2004-05-28 18:00:00	NVDA	Stock	0.1958	0.1958	0.1947	0.1947	132000.0
2004-05-28 08:00:00	AMZN	Stock	2.375	2.375	2.3675	2.3695	443600.0
2004-05-28 09:00:00	AMZN	Stock	2.37	2.372	2.344	2.3665	33706420.0
2004-05-28 10:00:00	AMZN	Stock	2.3665	2.3855	2.354	2.3665	37298580.0
2004-05-28 11:00:00	AMZN	Stock	2.367	2.3925	2.367	2.3855	17535900.0
2004-05-28 12:00:00	AMZN	Stock	2.385	2.411	2.385	2.4065	22548900.0
2004-05-28 13:00:00	AMZN	Stock	2.4055	2.4245	2.404	2.4235	20702340.0
2004-05-28 14:00:00	AMZN	Stock	2.423	2.425	2.4115	2.423	18380280.0
2004-05-28 15:00:00	AMZN	Stock	2.423	2.434	2.4035	2.4285	38200140.0
2004-05-28 16:00:00	AMZN	Stock	2.4265	2.429	2.392	2.4145	15533600.0
2004-05-28 17:00:00	AMZN	Stock	2.4215	2.4215	2.4145	2.4145	189760.0
2004-05-28 18:00:00	AMZN	Stock	2.4185	2.4185	2.4185	2.4185	4000.0
2004-05-28 09:00:00	CL	Stock	28.79	28.79	28.655	28.675	225800.0
2004-05-28 10:00:00	CL	Stock	28.675	28.695	28.62	28.64	464000.0
2004-05-28 11:00:00	CL	Stock	28.64	28.67	28.505	28.53	321400.0
2004-05-28 12:00:00	CL	Stock	28.53	28.645	28.525	28.63	444800.0
2004-05-28 13:00:00	CL	Stock	28.625	28.67	28.625	28.63	265600.0
2004-05-28 14:00:00	CL	Stock	28.63	28.645	28.575	28.635	271400.0
2004-05-28 15:00:00	CL	Stock	28.64	28.665	28.6	28.635	492000.0
2004-05-28 16:00:00	CL	Stock	28.602	28.602	28.6	28.6	33200.0

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

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