PREVIEW / stock_1hour / 2003-08-07

all stock 1-hour files

  file:    by_date/stock_1hour/2003/2003-08-07.parquet
  size:    455 KB
  rows:    22,174
  symbols: 1,599

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-07 08:00:00	AAPL	Stock	0.3509	0.3509	0.3509	0.3509	5600.0
2003-08-07 09:00:00	AAPL	Stock	0.3518	0.3541	0.3493	0.3514	14538048.0
2003-08-07 10:00:00	AAPL	Stock	0.3518	0.3521	0.3468	0.3504	22446368.0
2003-08-07 11:00:00	AAPL	Stock	0.3504	0.3571	0.3488	0.3559	19059656.0
2003-08-07 12:00:00	AAPL	Stock	0.3559	0.3582	0.3543	0.355	18321968.0
2003-08-07 13:00:00	AAPL	Stock	0.355	0.3584	0.3548	0.3571	16897608.0
2003-08-07 14:00:00	AAPL	Stock	0.3571	0.3588	0.3529	0.3543	36619352.0
2003-08-07 15:00:00	AAPL	Stock	0.3543	0.3575	0.3538	0.355	23506392.0
2003-08-07 16:00:00	AAPL	Stock	0.355	0.3582	0.3536	0.3579	2800000.0
2003-08-07 17:00:00	AAPL	Stock	0.355	0.355	0.3505	0.3505	761600.0
2003-08-07 08:00:00	MSFT	Stock	25.69	25.72	25.62	25.68	57156.0
2003-08-07 09:00:00	MSFT	Stock	25.65	25.81	25.54	25.66	5877385.0
2003-08-07 10:00:00	MSFT	Stock	25.66	25.68	25.45	25.532	6773962.0
2003-08-07 11:00:00	MSFT	Stock	25.54	25.73	25.47	25.67	5167459.0
2003-08-07 12:00:00	MSFT	Stock	25.67	25.738	25.555	25.58	2903595.0
2003-08-07 13:00:00	MSFT	Stock	25.58	25.74	25.54	25.72	5024472.0
2003-08-07 14:00:00	MSFT	Stock	25.73	25.73	25.58	25.63	4914472.0
2003-08-07 15:00:00	MSFT	Stock	25.64	25.79	25.63	25.7	6844396.0
2003-08-07 16:00:00	MSFT	Stock	25.7	25.76	25.68	25.74	339867.0
2003-08-07 17:00:00	MSFT	Stock	25.6283	25.72	25.6283	25.68	93900.0
2003-08-07 18:00:00	MSFT	Stock	25.68	25.72	25.6484	25.71	5800.0
2003-08-07 08:00:00	NVDA	Stock	0.1633	0.1642	0.1629	0.1629	540000.0
2003-08-07 09:00:00	NVDA	Stock	0.1626	0.165	0.1602	0.1621	103049400.0
2003-08-07 10:00:00	NVDA	Stock	0.1621	0.1625	0.16	0.1604	124725120.0
2003-08-07 11:00:00	NVDA	Stock	0.1604	0.1624	0.1597	0.1618	78003120.0
2003-08-07 12:00:00	NVDA	Stock	0.1619	0.1637	0.1612	0.1635	48657960.0
2003-08-07 13:00:00	NVDA	Stock	0.1635	0.165	0.1623	0.163	86374200.0
2003-08-07 14:00:00	NVDA	Stock	0.163	0.1633	0.1597	0.1599	104136240.0
2003-08-07 15:00:00	NVDA	Stock	0.1599	0.1614	0.1587	0.1608	179647440.0
2003-08-07 16:00:00	NVDA	Stock	0.1607	0.166	0.1565	0.1615	112858560.0
2003-08-07 17:00:00	NVDA	Stock	0.1612	0.1641	0.1405	0.1415	141173520.0
2003-08-07 18:00:00	NVDA	Stock	0.1413	0.1467	0.141	0.1434	39389400.0
2003-08-07 08:00:00	AMZN	Stock	1.944	1.9475	1.944	1.9475	33000.0
2003-08-07 09:00:00	AMZN	Stock	1.9485	1.967	1.945	1.9468	19359480.0
2003-08-07 10:00:00	AMZN	Stock	1.9475	1.9615	1.9375	1.942	20724860.0
2003-08-07 11:00:00	AMZN	Stock	1.9415	1.95	1.9295	1.94	16370760.0
2003-08-07 12:00:00	AMZN	Stock	1.94	1.9472	1.933	1.944	11973920.0
2003-08-07 13:00:00	AMZN	Stock	1.944	1.962	1.9435	1.9605	12589660.0
2003-08-07 14:00:00	AMZN	Stock	1.96	1.9605	1.941	1.9555	13912740.0
2003-08-07 15:00:00	AMZN	Stock	1.955	1.958	1.9475	1.953	18744520.0
2003-08-07 16:00:00	AMZN	Stock	1.9535	1.961	1.9505	1.9605	347000.0
2003-08-07 17:00:00	AMZN	Stock	1.96	1.9605	1.9455	1.9455	375840.0
2003-08-07 18:00:00	AMZN	Stock	1.9585	1.9585	1.9575	1.9575	14000.0
2003-08-07 09:00:00	CL	Stock	27.425	27.425	27.185	27.335	383000.0
2003-08-07 10:00:00	CL	Stock	27.3345	27.42	27.25	27.25	293200.0
2003-08-07 11:00:00	CL	Stock	27.245	27.33	27.205	27.235	330000.0
2003-08-07 12:00:00	CL	Stock	27.25	27.25	27.155	27.2	302800.0
2003-08-07 13:00:00	CL	Stock	27.2	27.32	27.185	27.29	267200.0
2003-08-07 14:00:00	CL	Stock	27.295	27.325	27.24	27.265	288600.0
2003-08-07 15:00:00	CL	Stock	27.265	27.395	27.255	27.36	619600.0

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

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