PREVIEW / stock_1hour / 2005-06-22

all stock 1-hour files

  file:    by_date/stock_1hour/2005/2005-06-22.parquet
  size:    545 KB
  rows:    25,983
  symbols: 1,993

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
2005-06-22 08:00:00	AAPL	Stock	1.3661	1.375	1.3625	1.3743	2349256.0
2005-06-22 09:00:00	AAPL	Stock	1.375	1.3764	1.352	1.3689	76539204.0
2005-06-22 10:00:00	AAPL	Stock	1.3682	1.3786	1.3661	1.3696	102164664.0
2005-06-22 11:00:00	AAPL	Stock	1.3696	1.3704	1.3621	1.3643	56933772.0
2005-06-22 12:00:00	AAPL	Stock	1.3646	1.3714	1.3632	1.3711	36402856.0
2005-06-22 13:00:00	AAPL	Stock	1.3714	1.3739	1.3679	1.3689	23058476.0
2005-06-22 14:00:00	AAPL	Stock	1.3689	1.3707	1.3646	1.3696	27119848.0
2005-06-22 15:00:00	AAPL	Stock	1.3696	1.3786	1.3679	1.3768	94877412.0
2005-06-22 16:00:00	AAPL	Stock	1.3768	1.3818	1.3761	1.3811	2114420.0
2005-06-22 17:00:00	AAPL	Stock	1.3793	1.3796	1.3768	1.3796	4429040.0
2005-06-22 18:00:00	AAPL	Stock	1.3804	1.385	1.3804	1.3839	361060.0
2005-06-22 07:00:00	MSFT	Stock	25.19	25.19	25.19	25.19	15900.0
2005-06-22 08:00:00	MSFT	Stock	25.19	25.19	25.13	25.15	194700.0
2005-06-22 09:00:00	MSFT	Stock	25.15	25.26	25.09	25.2	7457915.0
2005-06-22 10:00:00	MSFT	Stock	25.21	25.23	25.07	25.1	9043954.0
2005-06-22 11:00:00	MSFT	Stock	25.1	25.12	25.05	25.05	8795481.0
2005-06-22 12:00:00	MSFT	Stock	25.05	25.15	25.03	25.071	5009289.0
2005-06-22 13:00:00	MSFT	Stock	25.08	25.12	25.05	25.08	6393100.0
2005-06-22 14:00:00	MSFT	Stock	25.08	25.15	25.04	25.1	6760066.0
2005-06-22 15:00:00	MSFT	Stock	25.1	25.15	25.03	25.05	13740959.0
2005-06-22 16:00:00	MSFT	Stock	25.07	25.13	25.05	25.1	406095.0
2005-06-22 17:00:00	MSFT	Stock	25.11	25.26	25.017	25.26	433636.0
2005-06-22 18:00:00	MSFT	Stock	25.27	25.34	25.2	25.28	767932.0
2005-06-22 08:00:00	NVDA	Stock	0.2302	0.2302	0.2302	0.2302	36000.0
2005-06-22 09:00:00	NVDA	Stock	0.2304	0.2338	0.2278	0.2285	159728040.0
2005-06-22 10:00:00	NVDA	Stock	0.2285	0.2298	0.2267	0.2282	125166240.0
2005-06-22 11:00:00	NVDA	Stock	0.2282	0.2283	0.2272	0.2282	59280840.0
2005-06-22 12:00:00	NVDA	Stock	0.2282	0.2287	0.2279	0.2287	61765200.0
2005-06-22 13:00:00	NVDA	Stock	0.2287	0.2297	0.228	0.2288	52018080.0
2005-06-22 14:00:00	NVDA	Stock	0.2289	0.2289	0.2274	0.228	78375960.0
2005-06-22 15:00:00	NVDA	Stock	0.2281	0.2296	0.2277	0.2292	143566920.0
2005-06-22 16:00:00	NVDA	Stock	0.2293	0.2296	0.2288	0.2292	12601680.0
2005-06-22 17:00:00	NVDA	Stock	0.2293	0.2293	0.2293	0.2293	109800.0
2005-06-22 18:00:00	NVDA	Stock	0.2293	0.2293	0.2293	0.2293	24000.0
2005-06-22 08:00:00	AMZN	Stock	1.7805	1.7805	1.7805	1.7805	2000.0
2005-06-22 09:00:00	AMZN	Stock	1.775	1.7925	1.775	1.777	8566920.0
2005-06-22 10:00:00	AMZN	Stock	1.7765	1.7825	1.764	1.767	10107320.0
2005-06-22 11:00:00	AMZN	Stock	1.767	1.767	1.7575	1.758	5697260.0
2005-06-22 12:00:00	AMZN	Stock	1.7575	1.7695	1.7575	1.7665	7222000.0
2005-06-22 13:00:00	AMZN	Stock	1.767	1.7685	1.757	1.763	4754060.0
2005-06-22 14:00:00	AMZN	Stock	1.763	1.7645	1.7585	1.7635	3447700.0
2005-06-22 15:00:00	AMZN	Stock	1.764	1.7665	1.7575	1.7605	9547300.0
2005-06-22 16:00:00	AMZN	Stock	1.7625	1.7625	1.757	1.7575	307400.0
2005-06-22 17:00:00	AMZN	Stock	1.7573	1.7575	1.7573	1.7575	48720.0
2005-06-22 18:00:00	AMZN	Stock	1.76	1.76	1.76	1.76	2000.0
2005-06-22 09:00:00	CL	Stock	25.625	25.68	25.47	25.585	894000.0
2005-06-22 10:00:00	CL	Stock	25.585	25.625	25.525	25.545	696200.0
2005-06-22 11:00:00	CL	Stock	25.545	25.56	25.415	25.53	438000.0
2005-06-22 12:00:00	CL	Stock	25.53	25.58	25.44	25.5	399800.0
2005-06-22 13:00:00	CL	Stock	25.5	25.525	25.46	25.485	277000.0

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

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