PREVIEW / stock_1hour / 2004-06-28

all stock 1-hour files

  file:    by_date/stock_1hour/2004/2004-06-28.parquet
  size:    526 KB
  rows:    24,619
  symbols: 1,783

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-28 08:00:00	AAPL	Stock	0.6071	0.6127	0.6071	0.608	2512720.0
2004-06-28 09:00:00	AAPL	Stock	0.608	0.6105	0.5902	0.5925	72398648.0
2004-06-28 10:00:00	AAPL	Stock	0.5923	0.5979	0.5871	0.5879	77677656.0
2004-06-28 11:00:00	AAPL	Stock	0.5879	0.5884	0.5836	0.5863	90977992.0
2004-06-28 12:00:00	AAPL	Stock	0.5863	0.5884	0.5839	0.585	39421088.0
2004-06-28 13:00:00	AAPL	Stock	0.5852	0.5893	0.5848	0.5865	43703352.0
2004-06-28 14:00:00	AAPL	Stock	0.5868	0.5875	0.5816	0.5829	62809264.0
2004-06-28 15:00:00	AAPL	Stock	0.5827	0.583	0.5752	0.5795	104314616.0
2004-06-28 16:00:00	AAPL	Stock	0.5795	0.5813	0.5784	0.5786	6140680.0
2004-06-28 17:00:00	AAPL	Stock	0.5872	0.5872	0.5872	0.5872	181664.0
2004-06-28 08:00:00	MSFT	Stock	28.74	28.84	28.57	28.58	107946.0
2004-06-28 09:00:00	MSFT	Stock	28.68	28.84	28.59	28.67	9834719.0
2004-06-28 10:00:00	MSFT	Stock	28.67	28.7	28.62	28.66	9880252.0
2004-06-28 11:00:00	MSFT	Stock	28.66	28.69	28.59	28.64	6718417.0
2004-06-28 12:00:00	MSFT	Stock	28.64	28.67	28.55	28.55	6926987.0
2004-06-28 13:00:00	MSFT	Stock	28.55	28.61	28.44	28.467	6835698.0
2004-06-28 14:00:00	MSFT	Stock	28.469	28.48	28.23	28.27	16242809.0
2004-06-28 15:00:00	MSFT	Stock	28.27	28.33	28.17	28.26	15454482.0
2004-06-28 16:00:00	MSFT	Stock	28.28	28.32	28.22	28.23	3391734.0
2004-06-28 17:00:00	MSFT	Stock	28.19	28.5593	28.19	28.28	91261.0
2004-06-28 18:00:00	MSFT	Stock	28.23	28.24	28.23	28.24	3880.0
2004-06-28 08:00:00	NVDA	Stock	0.17	0.1739	0.17	0.1739	120000.0
2004-06-28 09:00:00	NVDA	Stock	0.1709	0.1717	0.1697	0.1704	51265440.0
2004-06-28 10:00:00	NVDA	Stock	0.1704	0.1709	0.1694	0.1703	39164640.0
2004-06-28 11:00:00	NVDA	Stock	0.1704	0.1707	0.1688	0.1699	27607320.0
2004-06-28 12:00:00	NVDA	Stock	0.1699	0.1704	0.1696	0.1699	12602280.0
2004-06-28 13:00:00	NVDA	Stock	0.1698	0.1698	0.169	0.1692	17335200.0
2004-06-28 14:00:00	NVDA	Stock	0.1692	0.1695	0.167	0.1671	65328000.0
2004-06-28 15:00:00	NVDA	Stock	0.1672	0.1682	0.1667	0.1674	73431000.0
2004-06-28 16:00:00	NVDA	Stock	0.1676	0.1683	0.1662	0.1662	3784440.0
2004-06-28 17:00:00	NVDA	Stock	0.1675	0.1675	0.1675	0.1675	18000.0
2004-06-28 18:00:00	NVDA	Stock	0.1673	0.1673	0.1673	0.1673	54000000.0
2004-06-28 08:00:00	AMZN	Stock	2.6	2.617	2.6	2.61	70840.0
2004-06-28 09:00:00	AMZN	Stock	2.61	2.65	2.61	2.637	35544680.0
2004-06-28 10:00:00	AMZN	Stock	2.6325	2.6735	2.628	2.668	42690400.0
2004-06-28 11:00:00	AMZN	Stock	2.6675	2.67	2.651	2.6605	15317700.0
2004-06-28 12:00:00	AMZN	Stock	2.659	2.675	2.658	2.6745	14312820.0
2004-06-28 13:00:00	AMZN	Stock	2.6745	2.702	2.67	2.675	36369660.0
2004-06-28 14:00:00	AMZN	Stock	2.675	2.6755	2.647	2.662	38107840.0
2004-06-28 15:00:00	AMZN	Stock	2.662	2.6825	2.6515	2.673	38032780.0
2004-06-28 16:00:00	AMZN	Stock	2.6725	2.674	2.6665	2.67	2847240.0
2004-06-28 17:00:00	AMZN	Stock	2.6675	2.6695	2.6625	2.6675	247200.0
2004-06-28 18:00:00	AMZN	Stock	2.6695	2.6695	2.665	2.665	24960.0
2004-06-28 09:00:00	CL	Stock	28.85	28.97	28.85	28.865	252600.0
2004-06-28 10:00:00	CL	Stock	28.855	28.905	28.8	28.83	254000.0
2004-06-28 11:00:00	CL	Stock	28.83	28.925	28.81	28.92	205000.0
2004-06-28 12:00:00	CL	Stock	28.92	28.95	28.875	28.895	162400.0
2004-06-28 13:00:00	CL	Stock	28.9	28.915	28.87	28.905	158400.0
2004-06-28 14:00:00	CL	Stock	28.905	28.935	28.88	28.9	562000.0
2004-06-28 15:00:00	CL	Stock	28.9	28.925	28.855	28.89	678000.0

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

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