PREVIEW / stock_1hour / 2004-06-30

all stock 1-hour files

  file:    by_date/stock_1hour/2004/2004-06-30.parquet
  size:    526 KB
  rows:    25,061
  symbols: 1,796

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-30 08:00:00	AAPL	Stock	0.5813	0.583	0.5813	0.583	140280.0
2004-06-30 09:00:00	AAPL	Stock	0.5814	0.5888	0.575	0.5857	37585968.0
2004-06-30 10:00:00	AAPL	Stock	0.5857	0.5859	0.5766	0.5777	34833344.0
2004-06-30 11:00:00	AAPL	Stock	0.5779	0.5788	0.5718	0.5745	28089600.0
2004-06-30 12:00:00	AAPL	Stock	0.5743	0.5745	0.5704	0.5707	21591416.0
2004-06-30 13:00:00	AAPL	Stock	0.5705	0.573	0.5695	0.5727	26726336.0
2004-06-30 14:00:00	AAPL	Stock	0.5727	0.5754	0.5704	0.5725	57966832.0
2004-06-30 15:00:00	AAPL	Stock	0.5727	0.585	0.5721	0.5798	112013608.0
2004-06-30 16:00:00	AAPL	Stock	0.5804	0.5836	0.5795	0.5795	13928208.0
2004-06-30 17:00:00	AAPL	Stock	0.5811	0.5819	0.5795	0.5804	1135456.0
2004-06-30 08:00:00	MSFT	Stock	28.45	28.57	28.45	28.56	13450.0
2004-06-30 09:00:00	MSFT	Stock	28.57	28.68	28.5	28.58	5205180.0
2004-06-30 10:00:00	MSFT	Stock	28.58	28.59	28.43	28.47	6889686.0
2004-06-30 11:00:00	MSFT	Stock	28.46	28.511	28.42	28.47	7598153.0
2004-06-30 12:00:00	MSFT	Stock	28.46	28.47	28.39	28.42	3279688.0
2004-06-30 13:00:00	MSFT	Stock	28.41	28.46	28.41	28.46	4078221.0
2004-06-30 14:00:00	MSFT	Stock	28.45	28.56	28.41	28.54	16107001.0
2004-06-30 15:00:00	MSFT	Stock	28.53	28.8	28.46	28.57	32767125.0
2004-06-30 16:00:00	MSFT	Stock	28.58	28.67	28.08	28.61	4577095.0
2004-06-30 17:00:00	MSFT	Stock	28.56	28.68	28.511	28.66	293602.0
2004-06-30 18:00:00	MSFT	Stock	28.67	28.71	28.56	28.71	42865.0
2004-06-30 08:00:00	NVDA	Stock	0.1733	0.1733	0.1733	0.1733	96000.0
2004-06-30 09:00:00	NVDA	Stock	0.1733	0.1735	0.1685	0.1712	27702120.0
2004-06-30 10:00:00	NVDA	Stock	0.1712	0.1722	0.1695	0.1713	39797400.0
2004-06-30 11:00:00	NVDA	Stock	0.1713	0.172	0.1693	0.1702	48725040.0
2004-06-30 12:00:00	NVDA	Stock	0.17	0.1705	0.1696	0.1702	21407520.0
2004-06-30 13:00:00	NVDA	Stock	0.1702	0.1709	0.1692	0.1693	17832960.0
2004-06-30 14:00:00	NVDA	Stock	0.1692	0.1713	0.1691	0.1699	68393160.0
2004-06-30 15:00:00	NVDA	Stock	0.1701	0.1717	0.1694	0.1708	86345520.0
2004-06-30 16:00:00	NVDA	Stock	0.1708	0.1715	0.1702	0.1706	10464000.0
2004-06-30 17:00:00	NVDA	Stock	0.1705	0.1712	0.1705	0.1709	907680.0
2004-06-30 08:00:00	AMZN	Stock	2.686	2.686	2.686	2.686	86000.0
2004-06-30 09:00:00	AMZN	Stock	2.6875	2.7225	2.6755	2.7115	18734960.0
2004-06-30 10:00:00	AMZN	Stock	2.7115	2.719	2.6975	2.6975	17852300.0
2004-06-30 11:00:00	AMZN	Stock	2.698	2.699	2.671	2.694	13797880.0
2004-06-30 12:00:00	AMZN	Stock	2.6945	2.7125	2.6875	2.709	12455120.0
2004-06-30 13:00:00	AMZN	Stock	2.709	2.7125	2.705	2.709	7069060.0
2004-06-30 14:00:00	AMZN	Stock	2.709	2.723	2.6985	2.7215	24829320.0
2004-06-30 15:00:00	AMZN	Stock	2.722	2.735	2.715	2.7215	36805840.0
2004-06-30 16:00:00	AMZN	Stock	2.7205	2.7255	2.701	2.7205	1390100.0
2004-06-30 17:00:00	AMZN	Stock	2.72	2.7242	2.72	2.72	377880.0
2004-06-30 18:00:00	AMZN	Stock	2.72	2.72	2.72	2.72	58000.0
2004-06-30 09:00:00	CL	Stock	29.225	29.3	29.19	29.295	162600.0
2004-06-30 10:00:00	CL	Stock	29.295	29.325	29.195	29.195	329400.0
2004-06-30 11:00:00	CL	Stock	29.195	29.2	29.05	29.095	222200.0
2004-06-30 12:00:00	CL	Stock	29.09	29.155	29.06	29.105	152000.0
2004-06-30 13:00:00	CL	Stock	29.105	29.15	29.085	29.13	223000.0
2004-06-30 14:00:00	CL	Stock	29.125	29.255	29.08	29.13	464400.0
2004-06-30 15:00:00	CL	Stock	29.13	29.26	29.055	29.25	833800.0
2004-06-30 16:00:00	CL	Stock	29.226	29.227	29.226	29.227	22200.0

> showing 50 of 25,061 rows — these rows as CSV

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