PREVIEW / stock_1hour / 2003-06-27

all stock 1-hour files

  file:    by_date/stock_1hour/2003/2003-06-27.parquet
  size:    455 KB
  rows:    21,544
  symbols: 1,580

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-27 08:00:00	AAPL	Stock	0.3446	0.3447	0.3446	0.3446	1108800.0
2003-06-27 09:00:00	AAPL	Stock	0.3446	0.3455	0.3395	0.3409	32130336.0
2003-06-27 10:00:00	AAPL	Stock	0.3405	0.3434	0.3402	0.3418	57334536.0
2003-06-27 11:00:00	AAPL	Stock	0.3416	0.3425	0.3371	0.3379	26108264.0
2003-06-27 12:00:00	AAPL	Stock	0.3377	0.3393	0.337	0.337	28211456.0
2003-06-27 13:00:00	AAPL	Stock	0.3371	0.3382	0.33	0.3354	50746080.0
2003-06-27 14:00:00	AAPL	Stock	0.3348	0.3366	0.3336	0.3364	23177896.0
2003-06-27 15:00:00	AAPL	Stock	0.3364	0.3371	0.333	0.3345	29809808.0
2003-06-27 16:00:00	AAPL	Stock	0.3346	0.3361	0.333	0.333	4928000.0
2003-06-27 08:00:00	MSFT	Stock	26.0	26.15	25.94	26.0	399822.0
2003-06-27 09:00:00	MSFT	Stock	25.99	26.065	25.87	25.92	10819881.0
2003-06-27 10:00:00	MSFT	Stock	25.92	26.25	25.9	26.242	13453383.0
2003-06-27 11:00:00	MSFT	Stock	26.24	26.34	26.02	26.07	11807758.0
2003-06-27 12:00:00	MSFT	Stock	26.07	26.11	25.91	25.96	6438091.0
2003-06-27 13:00:00	MSFT	Stock	25.96	26.01	25.54	25.73	11045571.0
2003-06-27 14:00:00	MSFT	Stock	25.738	25.784	25.66	25.7	5350864.0
2003-06-27 15:00:00	MSFT	Stock	25.7	25.85	25.54	25.64	8364110.0
2003-06-27 16:00:00	MSFT	Stock	25.64	25.75	25.6	25.62	848751.0
2003-06-27 17:00:00	MSFT	Stock	25.64	25.65	25.6	25.62	22707.0
2003-06-27 18:00:00	MSFT	Stock	25.64	25.67	25.64	25.65	13703.0
2003-06-27 08:00:00	NVDA	Stock	0.1917	0.1917	0.1917	0.1917	200760.0
2003-06-27 09:00:00	NVDA	Stock	0.1917	0.1937	0.1893	0.1915	89272560.0
2003-06-27 10:00:00	NVDA	Stock	0.1914	0.1954	0.1899	0.1938	135753120.0
2003-06-27 11:00:00	NVDA	Stock	0.1939	0.1942	0.1906	0.191	73057800.0
2003-06-27 12:00:00	NVDA	Stock	0.1909	0.1935	0.1907	0.1917	62470920.0
2003-06-27 13:00:00	NVDA	Stock	0.1918	0.1922	0.1871	0.1888	107953200.0
2003-06-27 14:00:00	NVDA	Stock	0.1888	0.1894	0.1881	0.1887	55028160.0
2003-06-27 15:00:00	NVDA	Stock	0.1887	0.189	0.1875	0.1877	100893240.0
2003-06-27 16:00:00	NVDA	Stock	0.1878	0.1882	0.1873	0.1882	10466520.0
2003-06-27 17:00:00	NVDA	Stock	0.1882	0.1882	0.1882	0.1882	116760.0
2003-06-27 08:00:00	AMZN	Stock	1.836	1.8475	1.8325	1.8335	82000.0
2003-06-27 09:00:00	AMZN	Stock	1.8335	1.8545	1.8225	1.825	22080400.0
2003-06-27 10:00:00	AMZN	Stock	1.8235	1.8435	1.82	1.842	26044620.0
2003-06-27 11:00:00	AMZN	Stock	1.842	1.846	1.829	1.84	18776020.0
2003-06-27 12:00:00	AMZN	Stock	1.841	1.8486	1.8375	1.8405	8269940.0
2003-06-27 13:00:00	AMZN	Stock	1.84	1.841	1.8134	1.823	17571520.0
2003-06-27 14:00:00	AMZN	Stock	1.8234	1.824	1.8115	1.8139	11096220.0
2003-06-27 15:00:00	AMZN	Stock	1.813	1.819	1.809	1.815	16099240.0
2003-06-27 16:00:00	AMZN	Stock	1.8155	1.819	1.81	1.8146	744700.0
2003-06-27 17:00:00	AMZN	Stock	1.814	1.815	1.814	1.815	44000.0
2003-06-27 18:00:00	AMZN	Stock	1.814	1.8165	1.814	1.8165	32000.0
2003-06-27 09:00:00	CL	Stock	29.0	29.01	28.75	28.805	568400.0
2003-06-27 10:00:00	CL	Stock	28.805	29.03	28.775	28.945	687000.0
2003-06-27 11:00:00	CL	Stock	28.955	28.995	28.91	28.995	264200.0
2003-06-27 12:00:00	CL	Stock	28.975	29.025	28.97	28.985	232200.0
2003-06-27 13:00:00	CL	Stock	28.985	28.985	28.815	28.86	441400.0
2003-06-27 14:00:00	CL	Stock	28.865	28.895	28.825	28.885	385400.0
2003-06-27 15:00:00	CL	Stock	28.885	28.9	28.75	28.835	460200.0
2003-06-27 16:00:00	CL	Stock	28.84	28.84	28.84	28.84	53800.0

> showing 49 of 21,544 rows — these rows as CSV

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