PREVIEW / stock_1hour / 2004-05-24

all stock 1-hour files

  file:    by_date/stock_1hour/2004/2004-05-24.parquet
  size:    507 KB
  rows:    24,222
  symbols: 1,775

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-24 09:00:00	AAPL	Stock	0.4857	0.497	0.4841	0.495	44694048.0
2004-05-24 10:00:00	AAPL	Stock	0.495	0.4979	0.4886	0.4973	47265400.0
2004-05-24 11:00:00	AAPL	Stock	0.4971	0.4982	0.488	0.4916	48217792.0
2004-05-24 12:00:00	AAPL	Stock	0.4914	0.4925	0.4863	0.4871	18157216.0
2004-05-24 13:00:00	AAPL	Stock	0.4871	0.4918	0.4871	0.49	14860552.0
2004-05-24 14:00:00	AAPL	Stock	0.49	0.4905	0.487	0.4884	15657040.0
2004-05-24 15:00:00	AAPL	Stock	0.4886	0.4911	0.4873	0.4888	28269360.0
2004-05-24 16:00:00	AAPL	Stock	0.4888	0.4952	0.4882	0.4952	3641120.0
2004-05-24 18:00:00	AAPL	Stock	0.4895	0.4895	0.4895	0.4895	84000.0
2004-05-24 08:00:00	MSFT	Stock	26.06	26.16	26.01	26.09	41316.0
2004-05-24 09:00:00	MSFT	Stock	26.07	26.17	25.87	26.05	6606635.0
2004-05-24 10:00:00	MSFT	Stock	26.06	26.09	25.93	25.93	8090887.0
2004-05-24 11:00:00	MSFT	Stock	25.94	25.97	25.74	25.81	9171824.0
2004-05-24 12:00:00	MSFT	Stock	25.8	25.86	25.76	25.79	5073639.0
2004-05-24 13:00:00	MSFT	Stock	25.8	25.91	25.79	25.83	6605657.0
2004-05-24 14:00:00	MSFT	Stock	25.83	25.85	25.76	25.8	7288673.0
2004-05-24 15:00:00	MSFT	Stock	25.8	25.89	25.75	25.77	11427112.0
2004-05-24 16:00:00	MSFT	Stock	25.77	25.877	25.72	25.8	625940.0
2004-05-24 17:00:00	MSFT	Stock	25.87	25.87	25.8	25.81	70300.0
2004-05-24 18:00:00	MSFT	Stock	25.83	25.83	25.81	25.81	5700.0
2004-05-24 09:00:00	NVDA	Stock	0.1777	0.179	0.1758	0.1768	42129360.0
2004-05-24 10:00:00	NVDA	Stock	0.177	0.1775	0.1752	0.177	57552960.0
2004-05-24 11:00:00	NVDA	Stock	0.1771	0.1771	0.174	0.1745	49761960.0
2004-05-24 12:00:00	NVDA	Stock	0.1744	0.1757	0.1743	0.1749	17935560.0
2004-05-24 13:00:00	NVDA	Stock	0.1749	0.1764	0.1748	0.1757	29764920.0
2004-05-24 14:00:00	NVDA	Stock	0.1757	0.1765	0.1751	0.1757	33276840.0
2004-05-24 15:00:00	NVDA	Stock	0.1757	0.1766	0.1755	0.1764	61750680.0
2004-05-24 16:00:00	NVDA	Stock	0.1762	0.1765	0.1758	0.1761	2126040.0
2004-05-24 17:00:00	NVDA	Stock	0.1763	0.1763	0.1761	0.1761	59880.0
2004-05-24 08:00:00	AMZN	Stock	2.0625	2.0655	2.0625	2.0655	62000.0
2004-05-24 09:00:00	AMZN	Stock	2.0755	2.115	2.062	2.1115	16940460.0
2004-05-24 10:00:00	AMZN	Stock	2.1114	2.1115	2.081	2.0855	20015820.0
2004-05-24 11:00:00	AMZN	Stock	2.0875	2.091	2.0585	2.0635	13034440.0
2004-05-24 12:00:00	AMZN	Stock	2.0635	2.0775	2.0625	2.0725	12320880.0
2004-05-24 13:00:00	AMZN	Stock	2.0725	2.094	2.0715	2.0875	11434760.0
2004-05-24 14:00:00	AMZN	Stock	2.088	2.0915	2.0765	2.088	11996800.0
2004-05-24 15:00:00	AMZN	Stock	2.088	2.0915	2.08	2.088	12445900.0
2004-05-24 16:00:00	AMZN	Stock	2.088	2.089	2.0815	2.0815	645200.0
2004-05-24 17:00:00	AMZN	Stock	2.0865	2.09	2.0815	2.0815	39280.0
2004-05-24 09:00:00	CL	Stock	28.74	28.885	28.7	28.775	367400.0
2004-05-24 10:00:00	CL	Stock	28.775	28.8	28.625	28.705	446400.0
2004-05-24 11:00:00	CL	Stock	28.705	28.72	28.595	28.625	427200.0
2004-05-24 12:00:00	CL	Stock	28.62	28.645	28.555	28.56	209400.0
2004-05-24 13:00:00	CL	Stock	28.56	28.625	28.5	28.5	207800.0
2004-05-24 14:00:00	CL	Stock	28.49	28.505	28.38	28.405	428400.0
2004-05-24 15:00:00	CL	Stock	28.41	28.47	28.385	28.405	681000.0
2004-05-24 16:00:00	CL	Stock	28.4	28.4	28.4	28.4	1200.0
2004-05-24 17:00:00	CL	Stock	28.615	28.615	28.615	28.615	6200.0

> showing 48 of 24,222 rows — these rows as CSV

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