PREVIEW / stock_1hour / 2006-11-13

all stock 1-hour files

  file:    by_date/stock_1hour/2006/2006-11-13.parquet
  size:    629 KB
  rows:    30,153
  symbols: 2,448

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
2006-11-13 08:00:00	AAPL	Stock	2.9704	2.9764	2.9686	2.9696	622972.0
2006-11-13 09:00:00	AAPL	Stock	2.9696	2.9911	2.9514	2.9893	58003484.0
2006-11-13 10:00:00	AAPL	Stock	2.9886	3.0107	2.9864	2.9964	81267732.0
2006-11-13 11:00:00	AAPL	Stock	2.9964	3.0161	2.9964	3.007	67320988.0
2006-11-13 12:00:00	AAPL	Stock	3.0071	3.015	2.9954	2.9979	53771592.0
2006-11-13 13:00:00	AAPL	Stock	2.9982	2.9996	2.9736	2.9887	65403156.0
2006-11-13 14:00:00	AAPL	Stock	2.9886	3.0107	2.9854	3.0089	50236536.0
2006-11-13 15:00:00	AAPL	Stock	3.0089	3.0125	3.0004	3.0121	66710840.0
2006-11-13 16:00:00	AAPL	Stock	3.0121	3.0164	3.0054	3.0114	1522388.0
2006-11-13 17:00:00	AAPL	Stock	3.0121	3.0129	3.0107	3.0107	142492.0
2006-11-13 18:00:00	AAPL	Stock	3.0107	3.0107	3.0082	3.0107	141960.0
2006-11-13 19:00:00	AAPL	Stock	3.0107	3.0107	3.0082	3.0107	87724.0
2006-11-13 07:00:00	MSFT	Stock	29.24	29.24	29.24	29.24	5100.0
2006-11-13 08:00:00	MSFT	Stock	29.23	29.27	29.23	29.25	1337425.0
2006-11-13 09:00:00	MSFT	Stock	29.29	29.42	29.16	29.39	6113633.0
2006-11-13 10:00:00	MSFT	Stock	29.4	29.45	29.31	29.323	7483028.0
2006-11-13 11:00:00	MSFT	Stock	29.33	29.4	29.32	29.36	4337602.0
2006-11-13 12:00:00	MSFT	Stock	29.36	29.42	29.34	29.34	3663981.0
2006-11-13 13:00:00	MSFT	Stock	29.34	29.42	29.34	29.398	4246262.0
2006-11-13 14:00:00	MSFT	Stock	29.39	29.46	29.36	29.409	3918976.0
2006-11-13 15:00:00	MSFT	Stock	29.41	29.42	29.32	29.36	8633542.0
2006-11-13 16:00:00	MSFT	Stock	29.36	29.39	29.32	29.35	1855716.0
2006-11-13 17:00:00	MSFT	Stock	29.36	29.38	29.35	29.36	8246.0
2006-11-13 18:00:00	MSFT	Stock	29.38	29.38	29.36	29.36	1200.0
2006-11-13 19:00:00	MSFT	Stock	29.36	29.36	29.35	29.36	2100.0
2006-11-13 08:00:00	NVDA	Stock	0.5675	0.5752	0.5667	0.5745	464100.0
2006-11-13 09:00:00	NVDA	Stock	0.5747	0.5982	0.574	0.598	120030840.0
2006-11-13 10:00:00	NVDA	Stock	0.5978	0.5992	0.5913	0.5943	170595960.0
2006-11-13 11:00:00	NVDA	Stock	0.5943	0.5973	0.5905	0.5912	114090660.0
2006-11-13 12:00:00	NVDA	Stock	0.5912	0.5975	0.591	0.5945	78757380.0
2006-11-13 13:00:00	NVDA	Stock	0.5947	0.5972	0.5942	0.5952	74695740.0
2006-11-13 14:00:00	NVDA	Stock	0.5953	0.6017	0.595	0.601	122967480.0
2006-11-13 15:00:00	NVDA	Stock	0.601	0.6012	0.5972	0.6	139377900.0
2006-11-13 16:00:00	NVDA	Stock	0.6	0.6	0.5987	0.5998	1384440.0
2006-11-13 17:00:00	NVDA	Stock	0.6	0.6003	0.5988	0.5995	363600.0
2006-11-13 18:00:00	NVDA	Stock	0.5998	0.6005	0.5998	0.6005	168000.0
2006-11-13 19:00:00	NVDA	Stock	0.6017	0.6025	0.6017	0.6025	66600.0
2006-11-13 08:00:00	AMZN	Stock	1.963	1.963	1.9575	1.9575	14680.0
2006-11-13 09:00:00	AMZN	Stock	1.955	1.995	1.955	1.9925	12275840.0
2006-11-13 10:00:00	AMZN	Stock	1.9925	2.0	1.987	1.9935	18429800.0
2006-11-13 11:00:00	AMZN	Stock	1.9938	1.998	1.9885	1.989	40054520.0
2006-11-13 12:00:00	AMZN	Stock	1.989	1.9965	1.9875	1.988	14163640.0
2006-11-13 13:00:00	AMZN	Stock	1.9875	1.997	1.9844	1.9955	13581640.0
2006-11-13 14:00:00	AMZN	Stock	1.996	1.9995	1.9928	1.9985	14531820.0
2006-11-13 15:00:00	AMZN	Stock	1.9985	2.0	1.9925	2.0	21334380.0
2006-11-13 16:00:00	AMZN	Stock	1.9995	2.002	1.9995	2.0	451800.0
2006-11-13 17:00:00	AMZN	Stock	1.996	1.999	1.996	1.999	16000.0
2006-11-13 18:00:00	AMZN	Stock	1.9975	2.001	1.9975	2.001	15000.0
2006-11-13 19:00:00	AMZN	Stock	2.0015	2.0015	2.0	2.0	12000.0
2006-11-13 08:00:00	CL	Stock	32.62	32.62	32.62	32.62	9400.0

> showing 50 of 30,153 rows — these rows as CSV

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