PREVIEW / stock_1hour / 2002-07-02

all stock 1-hour files

  file:    by_date/stock_1hour/2002/2002-07-02.parquet
  size:    421 KB
  rows:    19,669
  symbols: 1,447

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
2002-07-02 09:00:00	AAPL	Stock	0.3025	0.3065	0.3025	0.3046	27283200.0
2002-07-02 10:00:00	AAPL	Stock	0.3039	0.3046	0.3027	0.3032	46810400.0
2002-07-02 11:00:00	AAPL	Stock	0.3029	0.3036	0.3018	0.303	29131200.0
2002-07-02 12:00:00	AAPL	Stock	0.303	0.3039	0.3023	0.303	32552800.0
2002-07-02 13:00:00	AAPL	Stock	0.303	0.3052	0.3027	0.3034	32037600.0
2002-07-02 14:00:00	AAPL	Stock	0.3036	0.3048	0.3014	0.3018	42156800.0
2002-07-02 15:00:00	AAPL	Stock	0.3018	0.305	0.3005	0.3025	66292800.0
2002-07-02 16:00:00	AAPL	Stock	0.3025	0.3042	0.3005	0.3025	15853600.0
2002-07-02 18:00:00	AAPL	Stock	0.3027	0.3027	0.3027	0.3027	5600.0
2002-07-02 08:00:00	MSFT	Stock	26.02	26.251	25.535	26.21	80400.0
2002-07-02 09:00:00	MSFT	Stock	26.205	26.46	25.955	26.3305	9470800.0
2002-07-02 10:00:00	MSFT	Stock	26.33	26.3505	25.915	26.01	12431200.0
2002-07-02 11:00:00	MSFT	Stock	26.0065	26.165	25.68	25.745	10169400.0
2002-07-02 12:00:00	MSFT	Stock	25.746	26.175	25.705	26.015	9894600.0
2002-07-02 13:00:00	MSFT	Stock	26.015	26.29	25.775	26.085	10753600.0
2002-07-02 14:00:00	MSFT	Stock	26.085	26.295	25.75	25.89	10818600.0
2002-07-02 15:00:00	MSFT	Stock	25.89	26.015	25.665	25.725	13517400.0
2002-07-02 16:00:00	MSFT	Stock	25.725	26.095	25.575	25.775	3508000.0
2002-07-02 17:00:00	MSFT	Stock	25.795	26.3495	25.775	25.825	61200.0
2002-07-02 18:00:00	MSFT	Stock	25.825	25.85	25.805	25.85	8600.0
2002-07-02 08:00:00	NVDA	Stock	0.1421	0.1428	0.14	0.1416	1452000.0
2002-07-02 09:00:00	NVDA	Stock	0.1416	0.1421	0.1377	0.1397	175452000.0
2002-07-02 10:00:00	NVDA	Stock	0.1397	0.1408	0.1348	0.1368	270684000.0
2002-07-02 11:00:00	NVDA	Stock	0.1367	0.1377	0.1341	0.1348	174108000.0
2002-07-02 12:00:00	NVDA	Stock	0.1347	0.1393	0.1343	0.137	131280000.0
2002-07-02 13:00:00	NVDA	Stock	0.1367	0.1387	0.1346	0.1368	157908000.0
2002-07-02 14:00:00	NVDA	Stock	0.1368	0.1382	0.1327	0.1341	162240000.0
2002-07-02 15:00:00	NVDA	Stock	0.1338	0.1345	0.1302	0.1338	223572000.0
2002-07-02 16:00:00	NVDA	Stock	0.1338	0.1401	0.1323	0.1333	47496000.0
2002-07-02 17:00:00	NVDA	Stock	0.1333	0.1338	0.1333	0.1338	96000.0
2002-07-02 18:00:00	NVDA	Stock	0.134	0.134	0.1337	0.134	324000.0
2002-07-02 08:00:00	AMZN	Stock	0.679	0.6895	0.675	0.6825	180000.0
2002-07-02 09:00:00	AMZN	Stock	0.683	0.708	0.675	0.7011	21924000.0
2002-07-02 10:00:00	AMZN	Stock	0.701	0.7045	0.6792	0.681	19122000.0
2002-07-02 11:00:00	AMZN	Stock	0.6845	0.6845	0.65	0.662	34414000.0
2002-07-02 12:00:00	AMZN	Stock	0.6615	0.6665	0.652	0.6615	20372000.0
2002-07-02 13:00:00	AMZN	Stock	0.66	0.6735	0.65	0.6675	27062000.0
2002-07-02 14:00:00	AMZN	Stock	0.667	0.678	0.655	0.661	22738000.0
2002-07-02 15:00:00	AMZN	Stock	0.661	0.6745	0.66	0.6655	19634000.0
2002-07-02 16:00:00	AMZN	Stock	0.6655	0.6711	0.66	0.6675	2098000.0
2002-07-02 17:00:00	AMZN	Stock	0.666	0.669	0.666	0.669	74000.0
2002-07-02 09:00:00	CL	Stock	25.6	25.65	25.355	25.625	625200.0
2002-07-02 10:00:00	CL	Stock	25.65	25.65	25.425	25.485	1099000.0
2002-07-02 11:00:00	CL	Stock	25.48	25.625	25.435	25.445	634800.0
2002-07-02 12:00:00	CL	Stock	25.44	25.51	25.375	25.425	712200.0
2002-07-02 13:00:00	CL	Stock	25.425	25.45	25.25	25.285	590800.0
2002-07-02 14:00:00	CL	Stock	25.29	25.5	25.26	25.41	988600.0
2002-07-02 15:00:00	CL	Stock	25.415	25.475	25.2	25.2	841600.0
2002-07-02 16:00:00	CL	Stock	25.205	25.5	25.205	25.415	206800.0
2002-07-02 17:00:00	CL	Stock	25.275	25.275	25.275	25.275	2600.0

> showing 50 of 19,669 rows — these rows as CSV

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