PREVIEW / stock_1hour / 2004-05-25

all stock 1-hour files

  file:    by_date/stock_1hour/2004/2004-05-25.parquet
  size:    511 KB
  rows:    24,106
  symbols: 1,779

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-05-25 08:00:00	AAPL	Stock	0.4909	0.4909	0.4893	0.4893	28000.0
2004-05-25 09:00:00	AAPL	Stock	0.4893	0.4911	0.4873	0.4884	13307112.0
2004-05-25 10:00:00	AAPL	Stock	0.4884	0.4938	0.4884	0.4929	43051904.0
2004-05-25 11:00:00	AAPL	Stock	0.4932	0.4934	0.4907	0.4918	21984648.0
2004-05-25 12:00:00	AAPL	Stock	0.4916	0.4955	0.4911	0.495	22564920.0
2004-05-25 13:00:00	AAPL	Stock	0.4952	0.5	0.495	0.4993	64737792.0
2004-05-25 14:00:00	AAPL	Stock	0.4991	0.5016	0.4989	0.5009	51777768.0
2004-05-25 15:00:00	AAPL	Stock	0.5009	0.5091	0.4993	0.5068	75461176.0
2004-05-25 16:00:00	AAPL	Stock	0.5068	0.5081	0.5039	0.5039	3976224.0
2004-05-25 17:00:00	AAPL	Stock	0.5084	0.5084	0.5045	0.505	1280104.0
2004-05-25 08:00:00	MSFT	Stock	25.775	25.775	25.74	25.76	82055.0
2004-05-25 09:00:00	MSFT	Stock	25.75	25.78	25.66	25.69	3545703.0
2004-05-25 10:00:00	MSFT	Stock	25.7	25.74	25.6	25.65	10899462.0
2004-05-25 11:00:00	MSFT	Stock	25.65	25.7	25.61	25.69	6252409.0
2004-05-25 12:00:00	MSFT	Stock	25.68	25.91	25.68	25.89	9540294.0
2004-05-25 13:00:00	MSFT	Stock	25.89	26.05	25.88	25.9	11351887.0
2004-05-25 14:00:00	MSFT	Stock	25.9	25.96	25.8299	25.92	7024020.0
2004-05-25 15:00:00	MSFT	Stock	25.92	26.19	25.9	26.13	13402338.0
2004-05-25 16:00:00	MSFT	Stock	26.12	26.17	25.8423	26.1	571820.0
2004-05-25 17:00:00	MSFT	Stock	26.1	26.13	26.1	26.13	215998.0
2004-05-25 18:00:00	MSFT	Stock	26.1	26.12	26.09	26.1	2616.0
2004-05-25 09:00:00	NVDA	Stock	0.1757	0.1772	0.1732	0.175	43383600.0
2004-05-25 10:00:00	NVDA	Stock	0.1747	0.1767	0.1737	0.1747	85521480.0
2004-05-25 11:00:00	NVDA	Stock	0.1748	0.1754	0.1741	0.1753	30749400.0
2004-05-25 12:00:00	NVDA	Stock	0.1752	0.1762	0.1749	0.1757	62821560.0
2004-05-25 13:00:00	NVDA	Stock	0.1757	0.1774	0.1757	0.1768	155645640.0
2004-05-25 14:00:00	NVDA	Stock	0.1768	0.1802	0.1767	0.1794	105506040.0
2004-05-25 15:00:00	NVDA	Stock	0.1794	0.1846	0.1794	0.1838	151440240.0
2004-05-25 16:00:00	NVDA	Stock	0.1838	0.1842	0.1832	0.1842	1519920.0
2004-05-25 17:00:00	NVDA	Stock	0.1838	0.1838	0.1832	0.1837	532800.0
2004-05-25 18:00:00	NVDA	Stock	0.1831	0.1831	0.183	0.183	96000.0
2004-05-25 08:00:00	AMZN	Stock	2.065	2.074	2.06	2.074	86000.0
2004-05-25 09:00:00	AMZN	Stock	2.074	2.088	2.0675	2.0725	6277940.0
2004-05-25 10:00:00	AMZN	Stock	2.0735	2.1	2.0695	2.0805	18366060.0
2004-05-25 11:00:00	AMZN	Stock	2.082	2.099	2.0775	2.0915	7954940.0
2004-05-25 12:00:00	AMZN	Stock	2.0915	2.1105	2.091	2.1095	14487500.0
2004-05-25 13:00:00	AMZN	Stock	2.1095	2.136	2.104	2.1345	19419500.0
2004-05-25 14:00:00	AMZN	Stock	2.1345	2.1535	2.133	2.1503	19930620.0
2004-05-25 15:00:00	AMZN	Stock	2.1515	2.193	2.1515	2.181	41061580.0
2004-05-25 16:00:00	AMZN	Stock	2.1815	2.186	2.1545	2.1845	3326600.0
2004-05-25 17:00:00	AMZN	Stock	2.183	2.186	2.183	2.1846	156860.0
2004-05-25 18:00:00	AMZN	Stock	2.181	2.181	2.181	2.181	397440.0
2004-05-25 09:00:00	CL	Stock	28.41	28.415	28.265	28.275	298800.0
2004-05-25 10:00:00	CL	Stock	28.275	28.33	28.185	28.315	467800.0
2004-05-25 11:00:00	CL	Stock	28.32	28.375	28.3	28.3	453600.0
2004-05-25 12:00:00	CL	Stock	28.325	28.465	28.285	28.46	527600.0
2004-05-25 13:00:00	CL	Stock	28.46	28.605	28.415	28.56	279000.0
2004-05-25 14:00:00	CL	Stock	28.56	28.625	28.49	28.5	418000.0
2004-05-25 15:00:00	CL	Stock	28.5	28.65	28.47	28.585	871600.0
2004-05-25 16:00:00	CL	Stock	28.58	28.6	28.505	28.6	3400.0

> showing 50 of 24,106 rows — these rows as CSV

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