PREVIEW / stock_1hour / 2003-08-15

all stock 1-hour files

  file:    by_date/stock_1hour/2003/2003-08-15.parquet
  size:    394 KB
  rows:    19,147
  symbols: 1,568

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-08-15 08:00:00	AAPL	Stock	0.3509	0.3541	0.3459	0.3513	296800.0
2003-08-15 09:00:00	AAPL	Stock	0.3545	0.358	0.3521	0.3555	15632792.0
2003-08-15 10:00:00	AAPL	Stock	0.3555	0.3584	0.3532	0.3582	19929896.0
2003-08-15 11:00:00	AAPL	Stock	0.3582	0.3584	0.3566	0.3568	18261600.0
2003-08-15 12:00:00	AAPL	Stock	0.3566	0.3568	0.3516	0.352	16317616.0
2003-08-15 13:00:00	AAPL	Stock	0.352	0.3536	0.3518	0.3527	12750864.0
2003-08-15 14:00:00	AAPL	Stock	0.3527	0.3533	0.352	0.3527	9649360.0
2003-08-15 15:00:00	AAPL	Stock	0.3527	0.3534	0.3513	0.3523	19265176.0
2003-08-15 16:00:00	AAPL	Stock	0.3521	0.3539	0.352	0.3523	1114400.0
2003-08-15 08:00:00	MSFT	Stock	25.55	25.63	25.51	25.54	26450.0
2003-08-15 09:00:00	MSFT	Stock	25.53	25.65	25.47	25.54	4153290.0
2003-08-15 10:00:00	MSFT	Stock	25.54	25.57	25.48	25.53	6023967.0
2003-08-15 11:00:00	MSFT	Stock	25.53	25.55	25.46	25.49	4473999.0
2003-08-15 12:00:00	MSFT	Stock	25.49	25.52	25.44	25.49	3114279.0
2003-08-15 13:00:00	MSFT	Stock	25.49	25.54	25.468	25.5	1684453.0
2003-08-15 14:00:00	MSFT	Stock	25.5	25.52	25.47	25.48	1616586.0
2003-08-15 15:00:00	MSFT	Stock	25.49	25.55	25.43	25.45	3143314.0
2003-08-15 16:00:00	MSFT	Stock	25.54	25.57	25.45	25.55	897248.0
2003-08-15 17:00:00	MSFT	Stock	25.55	25.55	25.52	25.53	4470.0
2003-08-15 18:00:00	MSFT	Stock	25.53	25.54	25.53	25.54	900.0
2003-08-15 08:00:00	NVDA	Stock	0.1339	0.1342	0.1339	0.1342	30000.0
2003-08-15 09:00:00	NVDA	Stock	0.1346	0.1354	0.1337	0.1348	26056080.0
2003-08-15 10:00:00	NVDA	Stock	0.1347	0.1351	0.1344	0.1348	40144200.0
2003-08-15 11:00:00	NVDA	Stock	0.1349	0.135	0.1345	0.135	32832360.0
2003-08-15 12:00:00	NVDA	Stock	0.1349	0.1349	0.1337	0.1339	21159480.0
2003-08-15 13:00:00	NVDA	Stock	0.1338	0.1344	0.1333	0.1343	22519560.0
2003-08-15 14:00:00	NVDA	Stock	0.1344	0.1348	0.134	0.1341	18181800.0
2003-08-15 15:00:00	NVDA	Stock	0.1342	0.1352	0.1339	0.1349	34096920.0
2003-08-15 16:00:00	NVDA	Stock	0.1349	0.135	0.1329	0.1333	8415120.0
2003-08-15 17:00:00	NVDA	Stock	0.1333	0.1333	0.1333	0.1333	12000.0
2003-08-15 18:00:00	NVDA	Stock	0.1337	0.1337	0.1337	0.1337	60000.0
2003-08-15 08:00:00	AMZN	Stock	2.015	2.015	1.998	2.01	295000.0
2003-08-15 09:00:00	AMZN	Stock	2.001	2.0168	1.9985	2.002	7064580.0
2003-08-15 10:00:00	AMZN	Stock	2.003	2.019	2.0	2.014	6884260.0
2003-08-15 11:00:00	AMZN	Stock	2.0135	2.017	2.007	2.0105	5735720.0
2003-08-15 12:00:00	AMZN	Stock	2.0095	2.015	2.0035	2.004	7314660.0
2003-08-15 13:00:00	AMZN	Stock	2.004	2.009	2.004	2.0075	4206220.0
2003-08-15 14:00:00	AMZN	Stock	2.007	2.0075	2.004	2.0069	3143140.0
2003-08-15 15:00:00	AMZN	Stock	2.007	2.009	2.001	2.0052	9612620.0
2003-08-15 16:00:00	AMZN	Stock	2.009	2.0105	2.005	2.009	1026000.0
2003-08-15 17:00:00	AMZN	Stock	2.009	2.009	2.0085	2.0085	64000.0
2003-08-15 09:00:00	CL	Stock	27.825	27.83	27.69	27.8	216400.0
2003-08-15 10:00:00	CL	Stock	27.835	27.855	27.656	27.67	330000.0
2003-08-15 11:00:00	CL	Stock	27.67	27.715	27.595	27.625	229800.0
2003-08-15 12:00:00	CL	Stock	27.6	27.65	27.525	27.555	191400.0
2003-08-15 13:00:00	CL	Stock	27.56	27.59	27.525	27.575	156000.0
2003-08-15 14:00:00	CL	Stock	27.57	27.575	27.52	27.535	198200.0
2003-08-15 15:00:00	CL	Stock	27.535	27.545	27.45	27.48	924200.0
2003-08-15 16:00:00	CL	Stock	27.48	27.495	27.48	27.495	150400.0

> showing 49 of 19,147 rows — these rows as CSV

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