PREVIEW / stock_daily / 2006-11-16

all stock daily files

  file:    by_date/stock_daily/2006/2006-11-16.parquet
  size:    154 KB
  rows:    4,597
  symbols: 2,912

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-11-16	AAPL	Stock	3.0311	3.0821	3.0221	3.0575	693940800.0
2006-11-16	MSFT	Stock	29.14	29.64	29.13	29.47	64328500.0
2006-11-16	NVDA	Stock	0.5985	0.6058	0.5933	0.6037	457182000.0
2006-11-16	AMZN	Stock	2.1225	2.1475	2.12	2.142	220016000.0
2006-11-16	CL	Stock	32.275	32.9	32.225	32.825	3948800.0
2006-11-16	A	Stock	23.7411	24.2847	23.6052	24.0701	4576493.0
2006-11-16	AABA-DELISTED	Stock	27.3099994659424	27.3299999237061	26.2000007629395	26.6399993896484	38508500.0
2006-11-16	AACC-DELISTED	Stock	16.84	16.9	16.63	16.71	163494.0
2006-11-16	AACQ-DELISTED	Stock	5.49	5.5	5.485	5.5	324629.0
2006-11-16	AACQW-DELISTED	Stock	0.67	0.7	0.67	0.68	86500.0
2006-11-16	AAI-DELISTED	Stock	12.93	13.77	12.78	12.92	4793900.0
2006-11-16	AAIC-DELISTED	Stock	146.0	147.2	144.0	146.0	1229100.0
2006-11-16	AAME	Stock	2.8	2.87	2.79	2.82	25400.0
2006-11-16	AAON	Stock	3.7939	3.811	3.6714	3.736	326531.0
2006-11-16	AAP	Stock	38.15	38.24	37.78	37.98	781700.0
2006-11-16	AATI-DELISTED	Stock	6.09	6.1	5.9	5.91	160322.0
2006-11-16	AAU-DELISTED	Stock	2.515	2.57	2.48	2.51	69038.0
2006-11-16	AAUAF-DELISTED	Stock	2.5201	2.58	2.48	2.52	68900.0
2006-11-16	AAV-DELISTED	Stock	11.5	11.65	11.15	11.35	1602500.0
2006-11-16	AAWW-DELISTED	Stock	37.86	38.03	37.57	38.0	232724.0
2006-11-16	AAXN-DELISTED	Stock	9.25	9.27999973297119	9.05000019073486	9.06999969482422	646900.0
2006-11-16	AB	Stock	76.95	78.1	76.44	77.78	195400.0
2006-11-16	ABAX-DELISTED	Stock	20.58	20.72	20.33	20.43	87610.0
2006-11-16	ABB-DELISTED	Stock	15.88	15.95	15.83	15.9001	1653000.0
2006-11-16	ABBC-DELISTED	Stock	16.2	16.3	16.17	16.24	10112.0
2006-11-16	ABC-DELISTED	Stock	23.56	23.74	23.54	23.68	2256200.0
2006-11-16	ABCB	Stock	27.234	27.6425	27.234	27.4868	29919.0
2006-11-16	ABCO-DELISTED	Stock	28.9	28.9	28.49	28.75	110703.0
2006-11-16	ABCW-DELISTED	Stock	29.99	29.99	29.33	29.5	50900.0
2006-11-16	ABD-DELISTED	Stock	25.1	25.1	24.91	25.0	188900.0
2006-11-16	ABE-DELISTED	Stock	17.35	17.37	16.3	16.6	43500.0
2006-11-16	ABFS-DELISTED	Stock	40.33	41.01	40.18	40.96	242987.0
2006-11-16	ABG	Stock	24.22	24.26	23.96	24.08	506400.0
2006-11-16	ABK-DELISTED	Stock	83.65	85.75	83.45	85.5	767600.0
2006-11-16	ABM	Stock	20.68	20.8	20.6	20.74	110800.0
2006-11-16	ABMD-DELISTED	Stock	13.02	13.07	12.75	12.93	84607.0
2006-11-16	ABP-DELISTED	Stock	3.83	3.83	3.58	3.59	157700.0
2006-11-16	ABR	Stock	28.62	28.83	28.2	28.46	90100.0
2006-11-16	ABT	Stock	22.7425	22.8529	22.637	22.7857	8438724.0
2006-11-16	ABTL-DELISTED	Stock	16.15	16.5	14.75	15.35	85100.0
2006-11-16	ABV-DELISTED	Stock	47.0	47.68	46.89	47.35	440900.0
2006-11-16	ABVA-DELISTED	Stock	15.7599	15.85	15.61	15.818	12908.0
2006-11-16	ABX-DELISTED	Stock	29.41	29.41	28.43	28.45	5455826.0
2006-11-16	ACAD	Stock	9.82	9.95	9.74	9.84	77100.0
2006-11-16	ACAP-DELISTED	Stock	39.88	39.88	38.83	38.87	46815.0
2006-11-16	ACAS-DELISTED	Stock	44.0	44.18	43.88	44.08	669588.0
2006-11-16	ACAT-DELISTED	Stock	17.59	17.69	17.24	17.48	111245.0
2006-11-16	ACC-DELISTED	Stock	28.05	28.44	28.0	28.23	129600.0
2006-11-16	ACCL-DELISTED	Stock	6.33	6.45	6.25	6.31	18758.0
2006-11-16	ACCO	Stock	25.1	25.1	24.91	25.0	209800.0

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

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