PREVIEW / stock_1hour / 2004-09-02

all stock 1-hour files

  file:    by_date/stock_1hour/2004/2004-09-02.parquet
  size:    484 KB
  rows:    23,288
  symbols: 1,829

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-09-02 08:00:00	AAPL	Stock	0.6384	0.6429	0.6339	0.6393	358960.0
2004-09-02 09:00:00	AAPL	Stock	0.6375	0.6388	0.6302	0.6309	58391872.0
2004-09-02 10:00:00	AAPL	Stock	0.6309	0.6348	0.6302	0.632	62669264.0
2004-09-02 11:00:00	AAPL	Stock	0.632	0.6327	0.6232	0.6254	58742992.0
2004-09-02 12:00:00	AAPL	Stock	0.6252	0.6262	0.622	0.6241	25298784.0
2004-09-02 13:00:00	AAPL	Stock	0.6245	0.6277	0.6232	0.6275	21148064.0
2004-09-02 14:00:00	AAPL	Stock	0.6275	0.632	0.6263	0.6302	49745472.0
2004-09-02 15:00:00	AAPL	Stock	0.63	0.6395	0.6291	0.637	105833504.0
2004-09-02 16:00:00	AAPL	Stock	0.6371	0.638	0.6205	0.6346	6542536.0
2004-09-02 17:00:00	AAPL	Stock	0.628	0.628	0.6279	0.6279	72800.0
2004-09-02 18:00:00	AAPL	Stock	0.6279	0.6279	0.6279	0.6279	28000.0
2004-09-02 08:00:00	MSFT	Stock	27.41	27.41	27.27	27.3	12200.0
2004-09-02 09:00:00	MSFT	Stock	27.35	27.49	27.28	27.45	4170311.0
2004-09-02 10:00:00	MSFT	Stock	27.45	27.55	27.44	27.55	7109753.0
2004-09-02 11:00:00	MSFT	Stock	27.55	27.57	27.44	27.45	4220132.0
2004-09-02 12:00:00	MSFT	Stock	27.46	27.48	27.43	27.45	1583860.0
2004-09-02 13:00:00	MSFT	Stock	27.45	27.46	27.4	27.41	2287201.0
2004-09-02 14:00:00	MSFT	Stock	27.42	27.57	27.39	27.56	8018638.0
2004-09-02 15:00:00	MSFT	Stock	27.56	27.68	27.51	27.63	12540104.0
2004-09-02 16:00:00	MSFT	Stock	27.63	27.65	27.25	27.3	1087321.0
2004-09-02 17:00:00	MSFT	Stock	27.33	27.35	27.3	27.3	32299.0
2004-09-02 18:00:00	MSFT	Stock	27.3	27.34	27.3	27.34	42400.0
2004-09-02 08:00:00	NVDA	Stock	0.1058	0.1058	0.1058	0.1058	30240.0
2004-09-02 09:00:00	NVDA	Stock	0.1056	0.1078	0.1053	0.1062	112347600.0
2004-09-02 10:00:00	NVDA	Stock	0.1062	0.1068	0.1061	0.1067	92333640.0
2004-09-02 11:00:00	NVDA	Stock	0.1067	0.107	0.1061	0.1069	60580200.0
2004-09-02 12:00:00	NVDA	Stock	0.1069	0.1072	0.1067	0.1071	31923840.0
2004-09-02 13:00:00	NVDA	Stock	0.1071	0.1074	0.107	0.1074	32249760.0
2004-09-02 14:00:00	NVDA	Stock	0.1074	0.1092	0.1073	0.1087	173137440.0
2004-09-02 15:00:00	NVDA	Stock	0.1087	0.111	0.1087	0.1102	234541080.0
2004-09-02 16:00:00	NVDA	Stock	0.1102	0.1104	0.105	0.1067	13682880.0
2004-09-02 17:00:00	NVDA	Stock	0.107	0.1083	0.107	0.1071	1571880.0
2004-09-02 18:00:00	NVDA	Stock	0.1067	0.1067	0.1058	0.1058	396000.0
2004-09-02 08:00:00	AMZN	Stock	1.914	1.914	1.914	1.914	54000.0
2004-09-02 09:00:00	AMZN	Stock	1.912	1.9185	1.8975	1.9135	14732380.0
2004-09-02 10:00:00	AMZN	Stock	1.9135	1.9335	1.913	1.9275	17793900.0
2004-09-02 11:00:00	AMZN	Stock	1.9275	1.9305	1.918	1.923	6818340.0
2004-09-02 12:00:00	AMZN	Stock	1.9225	1.9325	1.9225	1.9265	6352560.0
2004-09-02 13:00:00	AMZN	Stock	1.9265	1.927	1.92	1.925	6195680.0
2004-09-02 14:00:00	AMZN	Stock	1.925	1.9585	1.9245	1.956	22813460.0
2004-09-02 15:00:00	AMZN	Stock	1.9555	1.982	1.954	1.9585	30964660.0
2004-09-02 16:00:00	AMZN	Stock	1.9585	1.963	1.937	1.939	2196420.0
2004-09-02 17:00:00	AMZN	Stock	1.9405	1.9455	1.939	1.9445	36000.0
2004-09-02 18:00:00	AMZN	Stock	1.9445	1.9495	1.9445	1.9495	82400.0
2004-09-02 09:00:00	CL	Stock	27.25	27.35	27.21	27.33	248600.0
2004-09-02 10:00:00	CL	Stock	27.34	27.355	27.16	27.215	366800.0
2004-09-02 11:00:00	CL	Stock	27.225	27.225	27.14	27.195	287800.0
2004-09-02 12:00:00	CL	Stock	27.19	27.265	27.185	27.2	158200.0
2004-09-02 13:00:00	CL	Stock	27.2	27.32	27.195	27.31	318200.0
2004-09-02 14:00:00	CL	Stock	27.3	27.425	27.29	27.405	298800.0

> showing 50 of 23,288 rows — these rows as CSV

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