PREVIEW / stock_1hour / 2004-07-02

all stock 1-hour files

  file:    by_date/stock_1hour/2004/2004-07-02.parquet
  size:    491 KB
  rows:    22,981
  symbols: 1,782

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-07-02 08:00:00	AAPL	Stock	0.5445	0.5464	0.5375	0.5454	24554320.0
2004-07-02 09:00:00	AAPL	Stock	0.5454	0.5473	0.5309	0.5373	235346664.0
2004-07-02 10:00:00	AAPL	Stock	0.5375	0.5495	0.5341	0.5439	267366064.0
2004-07-02 11:00:00	AAPL	Stock	0.5438	0.5525	0.5411	0.5518	99385104.0
2004-07-02 12:00:00	AAPL	Stock	0.5516	0.5568	0.55	0.5532	95097800.0
2004-07-02 13:00:00	AAPL	Stock	0.5534	0.5552	0.5502	0.5539	31570728.0
2004-07-02 14:00:00	AAPL	Stock	0.5543	0.5554	0.5527	0.553	32037712.0
2004-07-02 15:00:00	AAPL	Stock	0.5529	0.5564	0.5493	0.5546	76975024.0
2004-07-02 16:00:00	AAPL	Stock	0.555	0.5571	0.5527	0.5536	5520760.0
2004-07-02 17:00:00	AAPL	Stock	0.5536	0.5579	0.5536	0.5579	218456.0
2004-07-02 18:00:00	AAPL	Stock	0.5577	0.5577	0.5577	0.5577	16800.0
2004-07-02 08:00:00	MSFT	Stock	28.48	28.65	28.31	28.55	31865.0
2004-07-02 09:00:00	MSFT	Stock	28.54	28.65	28.4	28.48	4478914.0
2004-07-02 10:00:00	MSFT	Stock	28.48	28.661	28.41	28.61	6392552.0
2004-07-02 11:00:00	MSFT	Stock	28.6	28.68	28.55	28.599	5128265.0
2004-07-02 12:00:00	MSFT	Stock	28.6	28.62	28.42	28.5	5336161.0
2004-07-02 13:00:00	MSFT	Stock	28.5	28.55	28.43	28.54	2796123.0
2004-07-02 14:00:00	MSFT	Stock	28.54	28.6	28.49	28.57	4043550.0
2004-07-02 15:00:00	MSFT	Stock	28.58	28.6	28.47	28.6	6226979.0
2004-07-02 16:00:00	MSFT	Stock	28.57	28.6	28.52	28.58	992558.0
2004-07-02 17:00:00	MSFT	Stock	28.58	28.58	28.57	28.57	5564.0
2004-07-02 18:00:00	MSFT	Stock	28.58	28.58	28.58	28.58	1000.0
2004-07-02 08:00:00	NVDA	Stock	0.1634	0.1634	0.1626	0.1626	180000.0
2004-07-02 09:00:00	NVDA	Stock	0.1634	0.1646	0.1592	0.1602	78499200.0
2004-07-02 10:00:00	NVDA	Stock	0.1602	0.1607	0.1593	0.16	66740400.0
2004-07-02 11:00:00	NVDA	Stock	0.1599	0.1614	0.1599	0.1612	37115040.0
2004-07-02 12:00:00	NVDA	Stock	0.1612	0.1617	0.1603	0.1608	21244920.0
2004-07-02 13:00:00	NVDA	Stock	0.1608	0.1615	0.1607	0.1614	14292600.0
2004-07-02 14:00:00	NVDA	Stock	0.1614	0.1614	0.1606	0.1612	34236000.0
2004-07-02 15:00:00	NVDA	Stock	0.1613	0.1614	0.1602	0.1607	37076880.0
2004-07-02 16:00:00	NVDA	Stock	0.1607	0.1612	0.1604	0.1612	1163520.0
2004-07-02 17:00:00	NVDA	Stock	0.1615	0.1615	0.1615	0.1615	144000.0
2004-07-02 18:00:00	NVDA	Stock	0.1615	0.1615	0.1615	0.1615	12000.0
2004-07-02 08:00:00	AMZN	Stock	2.6235	2.669	2.6145	2.6195	76000.0
2004-07-02 09:00:00	AMZN	Stock	2.6195	2.65	2.5955	2.604	16197220.0
2004-07-02 10:00:00	AMZN	Stock	2.601	2.628	2.5955	2.6265	17987620.0
2004-07-02 11:00:00	AMZN	Stock	2.6265	2.66	2.6235	2.657	13280220.0
2004-07-02 12:00:00	AMZN	Stock	2.6575	2.662	2.6405	2.643	10207020.0
2004-07-02 13:00:00	AMZN	Stock	2.643	2.6575	2.638	2.649	7263940.0
2004-07-02 14:00:00	AMZN	Stock	2.6485	2.649	2.632	2.6385	9565200.0
2004-07-02 15:00:00	AMZN	Stock	2.638	2.641	2.625	2.6275	16141380.0
2004-07-02 16:00:00	AMZN	Stock	2.6275	2.641	2.624	2.6295	727980.0
2004-07-02 17:00:00	AMZN	Stock	2.628	2.628	2.627	2.627	11000.0
2004-07-02 09:00:00	CL	Stock	29.3	29.375	29.215	29.23	217200.0
2004-07-02 10:00:00	CL	Stock	29.215	29.275	29.075	29.19	296600.0
2004-07-02 11:00:00	CL	Stock	29.2	29.32	29.18	29.315	153600.0
2004-07-02 12:00:00	CL	Stock	29.315	29.375	29.225	29.265	129600.0
2004-07-02 13:00:00	CL	Stock	29.255	29.26	29.21	29.22	85200.0
2004-07-02 14:00:00	CL	Stock	29.21	29.21	29.14	29.155	138200.0
2004-07-02 15:00:00	CL	Stock	29.15	29.225	29.125	29.15	258200.0

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

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