PREVIEW / stock_1hour / 2004-06-17

all stock 1-hour files

  file:    by_date/stock_1hour/2004/2004-06-17.parquet
  size:    489 KB
  rows:    23,322
  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-06-17 08:00:00	AAPL	Stock	0.583	0.583	0.583	0.583	56000.0
2004-06-17 09:00:00	AAPL	Stock	0.583	0.5916	0.5804	0.5848	121012360.0
2004-06-17 10:00:00	AAPL	Stock	0.5848	0.5852	0.5752	0.5807	100419928.0
2004-06-17 11:00:00	AAPL	Stock	0.5807	0.5813	0.577	0.5796	55635272.0
2004-06-17 12:00:00	AAPL	Stock	0.5795	0.5804	0.5779	0.5789	22535856.0
2004-06-17 13:00:00	AAPL	Stock	0.5789	0.5845	0.5788	0.5836	35356048.0
2004-06-17 14:00:00	AAPL	Stock	0.5836	0.5839	0.5816	0.5832	47617248.0
2004-06-17 15:00:00	AAPL	Stock	0.5832	0.5902	0.5823	0.5861	103414136.0
2004-06-17 16:00:00	AAPL	Stock	0.5859	0.5871	0.5788	0.5859	7825272.0
2004-06-17 17:00:00	AAPL	Stock	0.5834	0.5859	0.5834	0.5859	6648432.0
2004-06-17 08:00:00	MSFT	Stock	27.35	27.4	27.31	27.34	37401.0
2004-06-17 09:00:00	MSFT	Stock	27.34	27.6	27.28	27.48	12325313.0
2004-06-17 10:00:00	MSFT	Stock	27.48	27.67	27.47	27.591	15688882.0
2004-06-17 11:00:00	MSFT	Stock	27.59	27.8	27.56	27.75	15350583.0
2004-06-17 12:00:00	MSFT	Stock	27.75	27.8	27.72	27.76	8457657.0
2004-06-17 13:00:00	MSFT	Stock	27.76	27.81	27.74	27.81	9616293.0
2004-06-17 14:00:00	MSFT	Stock	27.8	27.86	27.75	27.76	9548184.0
2004-06-17 15:00:00	MSFT	Stock	27.76	27.92	27.76	27.76	19832371.0
2004-06-17 16:00:00	MSFT	Stock	27.76	27.89	27.73	27.75	10804979.0
2004-06-17 17:00:00	MSFT	Stock	27.75	27.88	27.74	27.8	669551.0
2004-06-17 18:00:00	MSFT	Stock	27.8	27.85	27.78	27.83	7240.0
2004-06-17 09:00:00	NVDA	Stock	0.1675	0.1707	0.1665	0.1682	57885360.0
2004-06-17 10:00:00	NVDA	Stock	0.1682	0.1682	0.1662	0.1674	119774760.0
2004-06-17 11:00:00	NVDA	Stock	0.1673	0.1674	0.1662	0.1667	54294480.0
2004-06-17 12:00:00	NVDA	Stock	0.1667	0.1667	0.165	0.1653	50344560.0
2004-06-17 13:00:00	NVDA	Stock	0.1653	0.1666	0.165	0.166	25655520.0
2004-06-17 14:00:00	NVDA	Stock	0.1659	0.1661	0.1643	0.1643	39176640.0
2004-06-17 15:00:00	NVDA	Stock	0.1643	0.1647	0.1636	0.1643	86859120.0
2004-06-17 16:00:00	NVDA	Stock	0.1643	0.165	0.1643	0.1644	5902440.0
2004-06-17 17:00:00	NVDA	Stock	0.1646	0.1646	0.1644	0.1646	497040.0
2004-06-17 18:00:00	NVDA	Stock	0.1646	0.1646	0.1646	0.1646	34800.0
2004-06-17 08:00:00	AMZN	Stock	2.525	2.5325	2.525	2.529	132000.0
2004-06-17 09:00:00	AMZN	Stock	2.525	2.55	2.5045	2.512	13856540.0
2004-06-17 10:00:00	AMZN	Stock	2.512	2.5135	2.4975	2.5	18353540.0
2004-06-17 11:00:00	AMZN	Stock	2.4995	2.5035	2.493	2.494	18994520.0
2004-06-17 12:00:00	AMZN	Stock	2.494	2.4955	2.4875	2.489	16001540.0
2004-06-17 13:00:00	AMZN	Stock	2.4894	2.493	2.487	2.4915	8146940.0
2004-06-17 14:00:00	AMZN	Stock	2.4925	2.496	2.475	2.479	14899100.0
2004-06-17 15:00:00	AMZN	Stock	2.4785	2.495	2.4705	2.489	21205860.0
2004-06-17 16:00:00	AMZN	Stock	2.4885	2.4905	2.4815	2.4885	1608320.0
2004-06-17 17:00:00	AMZN	Stock	2.4885	2.4885	2.4825	2.4825	256200.0
2004-06-17 18:00:00	AMZN	Stock	2.481	2.4825	2.4725	2.4725	80000.0
2004-06-17 09:00:00	CL	Stock	29.17	29.285	29.135	29.28	301800.0
2004-06-17 10:00:00	CL	Stock	29.28	29.45	29.275	29.345	752200.0
2004-06-17 11:00:00	CL	Stock	29.34	29.35	29.32	29.34	306600.0
2004-06-17 12:00:00	CL	Stock	29.33	29.335	29.25	29.28	244200.0
2004-06-17 13:00:00	CL	Stock	29.27	29.315	29.19	29.215	317400.0
2004-06-17 14:00:00	CL	Stock	29.21	29.245	29.135	29.16	285200.0
2004-06-17 15:00:00	CL	Stock	29.16	29.21	29.13	29.185	479000.0
2004-06-17 16:00:00	CL	Stock	29.16	29.175	29.16	29.175	1400.0

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

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