PREVIEW / stock_1hour / 2005-09-29

all stock 1-hour files

  file:    by_date/stock_1hour/2005/2005-09-29.parquet
  size:    570 KB
  rows:    26,683
  symbols: 2,079

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-09-29 07:00:00	AAPL	Stock	1.8243	1.8243	1.8243	1.8243	8400.0
2005-09-29 08:00:00	AAPL	Stock	1.8268	1.8314	1.8214	1.8293	1621592.0
2005-09-29 09:00:00	AAPL	Stock	1.8289	1.8414	1.8146	1.8364	108959760.0
2005-09-29 10:00:00	AAPL	Stock	1.8365	1.8657	1.8361	1.8464	155727992.0
2005-09-29 11:00:00	AAPL	Stock	1.8464	1.8646	1.8461	1.8575	79537612.0
2005-09-29 12:00:00	AAPL	Stock	1.8575	1.8618	1.8532	1.8557	35991340.0
2005-09-29 13:00:00	AAPL	Stock	1.8557	1.8643	1.8518	1.8586	60156152.0
2005-09-29 14:00:00	AAPL	Stock	1.8586	1.8643	1.8546	1.8582	52275020.0
2005-09-29 15:00:00	AAPL	Stock	1.8582	1.8782	1.8575	1.8682	130636408.0
2005-09-29 16:00:00	AAPL	Stock	1.8693	1.8707	1.8625	1.8679	1917356.0
2005-09-29 17:00:00	AAPL	Stock	1.8664	1.8693	1.8607	1.8693	965916.0
2005-09-29 18:00:00	AAPL	Stock	1.8643	1.8689	1.8636	1.8636	37100.0
2005-09-29 07:00:00	MSFT	Stock	25.75	25.75	25.75	25.75	235.0
2005-09-29 08:00:00	MSFT	Stock	25.67	25.7	25.67	25.67	19855.0
2005-09-29 09:00:00	MSFT	Stock	25.65	25.78	25.54	25.54	6248898.0
2005-09-29 10:00:00	MSFT	Stock	25.53	25.71	25.515	25.54	8908997.0
2005-09-29 11:00:00	MSFT	Stock	25.54	25.74	25.5	25.7	9135986.0
2005-09-29 12:00:00	MSFT	Stock	25.7	25.74	25.55	25.58	5145658.0
2005-09-29 13:00:00	MSFT	Stock	25.58	25.82	25.57	25.71	7746378.0
2005-09-29 14:00:00	MSFT	Stock	25.71	25.93	25.7	25.87	9013403.0
2005-09-29 15:00:00	MSFT	Stock	25.87	26.0	25.667	25.95	17478852.0
2005-09-29 16:00:00	MSFT	Stock	25.94	26.0	25.91	25.91	520488.0
2005-09-29 17:00:00	MSFT	Stock	25.94	25.94	25.92	25.94	215300.0
2005-09-29 18:00:00	MSFT	Stock	25.92	25.95	25.92	25.92	1800.0
2005-09-29 09:00:00	NVDA	Stock	0.2777	0.2783	0.2752	0.2768	66200640.0
2005-09-29 10:00:00	NVDA	Stock	0.2768	0.2812	0.2762	0.2767	126599280.0
2005-09-29 11:00:00	NVDA	Stock	0.2767	0.281	0.2762	0.28	62179560.0
2005-09-29 12:00:00	NVDA	Stock	0.28	0.2802	0.2795	0.2798	30153600.0
2005-09-29 13:00:00	NVDA	Stock	0.2797	0.2824	0.2797	0.2809	61881600.0
2005-09-29 14:00:00	NVDA	Stock	0.281	0.283	0.2808	0.2814	55435320.0
2005-09-29 15:00:00	NVDA	Stock	0.2814	0.2833	0.2811	0.2833	92602560.0
2005-09-29 16:00:00	NVDA	Stock	0.2832	0.2852	0.2817	0.2832	13131120.0
2005-09-29 17:00:00	NVDA	Stock	0.285	0.2852	0.2832	0.2832	900000.0
2005-09-29 18:00:00	NVDA	Stock	0.2852	0.2852	0.2852	0.2852	120000.0
2005-09-29 09:00:00	AMZN	Stock	2.165	2.175	2.1565	2.1685	8754900.0
2005-09-29 10:00:00	AMZN	Stock	2.168	2.1855	2.1645	2.168	16209120.0
2005-09-29 11:00:00	AMZN	Stock	2.168	2.2105	2.1605	2.1955	23216080.0
2005-09-29 12:00:00	AMZN	Stock	2.1955	2.206	2.1935	2.1995	8586500.0
2005-09-29 13:00:00	AMZN	Stock	2.1995	2.2235	2.1985	2.212	14213340.0
2005-09-29 14:00:00	AMZN	Stock	2.2125	2.228	2.2115	2.2245	17877160.0
2005-09-29 15:00:00	AMZN	Stock	2.225	2.24	2.2215	2.2355	35224120.0
2005-09-29 16:00:00	AMZN	Stock	2.239	2.24	2.2255	2.2375	1363820.0
2005-09-29 17:00:00	AMZN	Stock	2.2385	2.241	2.2385	2.241	33500.0
2005-09-29 09:00:00	CL	Stock	26.095	26.105	25.895	25.95	283400.0
2005-09-29 10:00:00	CL	Stock	25.965	26.255	25.93	26.115	705400.0
2005-09-29 11:00:00	CL	Stock	26.12	26.355	26.08	26.325	535400.0
2005-09-29 12:00:00	CL	Stock	26.325	26.36	26.185	26.26	532200.0
2005-09-29 13:00:00	CL	Stock	26.26	26.36	26.25	26.255	356200.0
2005-09-29 14:00:00	CL	Stock	26.25	26.405	26.25	26.34	349800.0
2005-09-29 15:00:00	CL	Stock	26.34	26.36	26.275	26.305	769400.0

> showing 50 of 26,683 rows — these rows as CSV

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