PREVIEW / stock_1hour / 2004-02-18

all stock 1-hour files

  file:    by_date/stock_1hour/2004/2004-02-18.parquet
  size:    502 KB
  rows:    22,876
  symbols: 1,720

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-02-18 08:00:00	AAPL	Stock	0.4143	0.4145	0.4138	0.4141	834680.0
2004-02-18 09:00:00	AAPL	Stock	0.4139	0.4139	0.4109	0.4139	36193192.0
2004-02-18 10:00:00	AAPL	Stock	0.4141	0.4186	0.4139	0.4152	28388752.0
2004-02-18 11:00:00	AAPL	Stock	0.4152	0.4155	0.4143	0.4152	9867256.0
2004-02-18 12:00:00	AAPL	Stock	0.4154	0.4179	0.4148	0.4157	8530816.0
2004-02-18 13:00:00	AAPL	Stock	0.4154	0.4157	0.4145	0.4146	5654768.0
2004-02-18 14:00:00	AAPL	Stock	0.4147	0.415	0.4118	0.4129	16496760.0
2004-02-18 15:00:00	AAPL	Stock	0.4129	0.4161	0.4123	0.415	24385200.0
2004-02-18 16:00:00	AAPL	Stock	0.4148	0.4186	0.4143	0.4177	2794568.0
2004-02-18 17:00:00	AAPL	Stock	0.4177	0.4177	0.4177	0.4177	16800.0
2004-02-18 08:00:00	MSFT	Stock	27.1	27.1	26.9	26.92	27050.0
2004-02-18 09:00:00	MSFT	Stock	26.91	26.99	26.87	26.88	5952097.0
2004-02-18 10:00:00	MSFT	Stock	26.88	26.95	26.85	26.94	5987299.0
2004-02-18 11:00:00	MSFT	Stock	26.95	27.07	26.94	27.04	6308646.0
2004-02-18 12:00:00	MSFT	Stock	27.04	27.11	27.01	27.01	4949379.0
2004-02-18 13:00:00	MSFT	Stock	27.02	27.02	26.9	26.94	4319565.0
2004-02-18 14:00:00	MSFT	Stock	26.94	26.95	26.799	26.859	8192252.0
2004-02-18 15:00:00	MSFT	Stock	26.86	26.86	26.76	26.77	11585309.0
2004-02-18 16:00:00	MSFT	Stock	26.77	26.8	26.7	26.8	1391238.0
2004-02-18 17:00:00	MSFT	Stock	26.78	26.9024	26.78	26.82	47100.0
2004-02-18 18:00:00	MSFT	Stock	26.82	26.82	26.81	26.82	6000.0
2004-02-18 08:00:00	NVDA	Stock	0.1966	0.1967	0.1957	0.1957	1584000.0
2004-02-18 09:00:00	NVDA	Stock	0.1957	0.1969	0.195	0.1963	66108120.0
2004-02-18 10:00:00	NVDA	Stock	0.1963	0.1975	0.1958	0.196	63748200.0
2004-02-18 11:00:00	NVDA	Stock	0.1959	0.197	0.1958	0.1962	31424160.0
2004-02-18 12:00:00	NVDA	Stock	0.1963	0.1974	0.1961	0.1972	26907240.0
2004-02-18 13:00:00	NVDA	Stock	0.1972	0.1979	0.1965	0.1967	28611480.0
2004-02-18 14:00:00	NVDA	Stock	0.1967	0.1967	0.1956	0.1959	41986800.0
2004-02-18 15:00:00	NVDA	Stock	0.1959	0.1969	0.1958	0.1963	42381120.0
2004-02-18 16:00:00	NVDA	Stock	0.1964	0.197	0.1962	0.197	5800080.0
2004-02-18 17:00:00	NVDA	Stock	0.197	0.197	0.197	0.197	60000.0
2004-02-18 18:00:00	NVDA	Stock	0.197	0.197	0.197	0.197	612000.0
2004-02-18 08:00:00	AMZN	Stock	2.2825	2.285	2.265	2.2745	102000.0
2004-02-18 09:00:00	AMZN	Stock	2.2745	2.2745	2.2365	2.242	30921600.0
2004-02-18 10:00:00	AMZN	Stock	2.2425	2.2475	2.232	2.242	37378040.0
2004-02-18 11:00:00	AMZN	Stock	2.242	2.257	2.2415	2.245	17247180.0
2004-02-18 12:00:00	AMZN	Stock	2.2455	2.253	2.2415	2.2485	9558840.0
2004-02-18 13:00:00	AMZN	Stock	2.249	2.2575	2.247	2.2485	15874600.0
2004-02-18 14:00:00	AMZN	Stock	2.2495	2.254	2.2425	2.252	18469700.0
2004-02-18 15:00:00	AMZN	Stock	2.2524	2.2535	2.243	2.244	21492120.0
2004-02-18 16:00:00	AMZN	Stock	2.244	2.2515	2.2435	2.2515	2705220.0
2004-02-18 17:00:00	AMZN	Stock	2.2515	2.2515	2.251	2.251	34000.0
2004-02-18 18:00:00	AMZN	Stock	2.251	2.2525	2.25	2.25	53000.0
2004-02-18 09:00:00	CL	Stock	27.8	27.8	27.69	27.74	272000.0
2004-02-18 10:00:00	CL	Stock	27.735	27.785	27.67	27.745	259000.0
2004-02-18 11:00:00	CL	Stock	27.74	27.75	27.675	27.725	273600.0
2004-02-18 12:00:00	CL	Stock	27.73	27.78	27.72	27.77	330200.0
2004-02-18 13:00:00	CL	Stock	27.77	27.79	27.75	27.77	242800.0
2004-02-18 14:00:00	CL	Stock	27.755	27.785	27.7	27.745	367600.0
2004-02-18 15:00:00	CL	Stock	27.735	27.775	27.735	27.75	670000.0

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

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