PREVIEW / stock_daily / 2006-12-18

all stock daily files

  file:    by_date/stock_daily/2006/2006-12-18.parquet
  size:    156 KB
  rows:    4,674
  symbols: 2,966

schema

  date         DATE
  symbol       VARCHAR
  asset_type   VARCHAR
  open         DOUBLE
  high         DOUBLE
  low          DOUBLE
  close        DOUBLE
  volume       DOUBLE

sample rows

date	symbol	asset_type	open	high	low	close	volume
2006-12-18	AAPL	Stock	3.1296	3.1429	3.0211	3.0525	721576800.0
2006-12-18	MSFT	Stock	30.19	30.26	29.78	29.89	56986800.0
2006-12-18	NVDA	Stock	0.6257	0.6433	0.6253	0.6358	688356000.0
2006-12-18	AMZN	Stock	2.01	2.032	1.943	1.963	129734000.0
2006-12-18	CL	Stock	32.545	32.7	32.505	32.595	2514200.0
2006-12-18	A	Stock	24.3777	24.5351	24.2632	24.3777	1588547.0
2006-12-18	AABA-DELISTED	Stock	26.8899993896484	26.9699993133545	26.0699996948242	26.2999992370605	19431200.0
2006-12-18	AACC-DELISTED	Stock	16.01	16.48	15.99	16.09	79182.0
2006-12-18	AACQ-DELISTED	Stock	5.44	5.44	5.43	5.43	5500.0
2006-12-18	AACQU-DELISTED	Stock	6.55	6.65	6.52	6.52	11000.0
2006-12-18	AACQW-DELISTED	Stock	0.56	0.56	0.56	0.56	39000.0
2006-12-18	AAI-DELISTED	Stock	12.56	12.84	12.53	12.66	2122900.0
2006-12-18	AAIC-DELISTED	Stock	151.0	152.4	147.6	148.0	6333000.0
2006-12-18	AAME	Stock	3.0	3.0	2.96	2.96	500.0
2006-12-18	AAON	Stock	3.4621	3.4739	3.229	3.2435	226294.0
2006-12-18	AAP	Stock	35.3	35.74	35.1	35.53	787700.0
2006-12-18	AATI-DELISTED	Stock	5.17	5.37	5.13	5.21	235984.0
2006-12-18	AAU-DELISTED	Stock	2.39	2.39	2.22	2.32	40100.0
2006-12-18	AAUAF-DELISTED	Stock	2.39	2.39	2.22	2.32	40100.0
2006-12-18	AAV-DELISTED	Stock	11.57	11.74	11.41	11.49	898800.0
2006-12-18	AAWW-DELISTED	Stock	46.68	47.38	45.53	45.86	146121.0
2006-12-18	AAXN-DELISTED	Stock	7.94000005722046	7.94999980926514	7.73999977111816	7.78000020980835	880100.0
2006-12-18	AB	Stock	79.06	80.1	78.79	79.27	153000.0
2006-12-18	ABAX-DELISTED	Stock	19.2	19.22	18.74	18.86	126547.0
2006-12-18	ABB-DELISTED	Stock	17.52	17.66	17.45	17.5	3579400.0
2006-12-18	ABBC-DELISTED	Stock	19.1123	19.23	18.95	18.95	8292.0
2006-12-18	ABC-DELISTED	Stock	23.2	23.22	22.82	22.86	3621000.0
2006-12-18	ABCB	Stock	27.6425	27.6717	26.7088	26.8546	20048.0
2006-12-18	ABCO-DELISTED	Stock	26.7	27.04	26.11	26.38	164962.0
2006-12-18	ABCW-DELISTED	Stock	28.51	28.71	28.4	28.45	61650.0
2006-12-18	ABD-DELISTED	Stock	26.76	26.86	26.15	26.35	173500.0
2006-12-18	ABE-DELISTED	Stock	18.75	19.5	18.75	19.5	126000.0
2006-12-18	ABFS-DELISTED	Stock	37.23	37.36	36.2	36.33	370482.0
2006-12-18	ABG	Stock	23.99	23.99	23.65	23.73	151000.0
2006-12-18	ABK-DELISTED	Stock	88.3	90.75	88.3	88.77	928200.0
2006-12-18	ABM	Stock	23.22	24.0	23.22	23.7	351900.0
2006-12-18	ABMD-DELISTED	Stock	13.1	13.63	13.08	13.52	200225.0
2006-12-18	ABP-DELISTED	Stock	3.52	3.59	3.35	3.35	351000.0
2006-12-18	ABR	Stock	27.92	28.74	27.91	28.72	123800.0
2006-12-18	ABT	Stock	23.1743	23.1935	22.9584	23.0928	6944560.0
2006-12-18	ABTL-DELISTED	Stock	17.825	17.925	17.174	17.475	32537.0
2006-12-18	ABV-DELISTED	Stock	49.18	49.25	48.49	48.62	360200.0
2006-12-18	ABVA-DELISTED	Stock	15.88	16.05	15.84	15.999	3149.0
2006-12-18	ABX-DELISTED	Stock	30.34	30.44	29.86	30.22	5085900.0
2006-12-18	ACAD	Stock	9.25	9.5	9.17	9.26	220400.0
2006-12-18	ACAP-DELISTED	Stock	39.23	39.99	38.83	38.88	96832.0
2006-12-18	ACAS-DELISTED	Stock	45.09	45.28	44.95	45.16	452890.0
2006-12-18	ACAT-DELISTED	Stock	18.271	18.401	17.269	17.269	65116.0
2006-12-18	ACC-DELISTED	Stock	29.42	29.42	28.97	29.03	134035.0
2006-12-18	ACCL-DELISTED	Stock	5.72	5.83	5.71	5.76	69644.0

> showing 50 of 4,674 rows — these rows as CSV

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