PREVIEW / stock_daily / 2006-09-13

all stock daily files

  file:    by_date/stock_daily/2006/2006-09-13.parquet
  size:    150 KB
  rows:    4,503
  symbols: 2,843

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-09-13	AAPL	Stock	2.6018	2.6543	2.5821	2.65	1146138000.0
2006-09-13	MSFT	Stock	25.82	26.1	25.82	25.98	37706700.0
2006-09-13	NVDA	Stock	0.4823	0.4913	0.4808	0.485	476286000.0
2006-09-13	AMZN	Stock	1.5865	1.598	1.5685	1.5835	87408000.0
2006-09-13	CL	Stock	30.945	31.025	30.455	30.63	6060200.0
2006-09-13	A	Stock	22.6037	22.6609	22.3176	22.4249	2713658.0
2006-09-13	AABA-DELISTED	Stock	29.0599994659424	29.3700008392334	28.7999992370605	29.1700000762939	15248400.0
2006-09-13	AACC-DELISTED	Stock	14.38	14.79	14.3	14.78	114420.0
2006-09-13	AACQU-DELISTED	Stock	6.08	6.08	6.08	6.08	500.0
2006-09-13	AAI-DELISTED	Stock	10.0	10.24	9.71	9.74	3213800.0
2006-09-13	AAIC-DELISTED	Stock	169.6	178.0	167.8	176.2	2786400.0
2006-09-13	AAME	Stock	2.7	2.74	2.7	2.74	700.0
2006-09-13	AAON	Stock	3.1223	3.1605	3.1078	3.1605	79734.0
2006-09-13	AAP	Stock	32.93	33.24	32.65	32.87	1303000.0
2006-09-13	AATI-DELISTED	Stock	8.22	8.4	8.2	8.39	154943.0
2006-09-13	AAU-DELISTED	Stock	2.38	2.4	2.36	2.36	37900.0
2006-09-13	AAUAF-DELISTED	Stock	2.38	2.4	2.36	2.36	37900.0
2006-09-13	AAV-DELISTED	Stock	14.25	14.6	14.2	14.5847	426900.0
2006-09-13	AAWW-DELISTED	Stock	43.72	44.0	43.64	43.9	116306.0
2006-09-13	AAXN-DELISTED	Stock	7.57999992370605	7.65999984741211	7.55000019073486	7.6100001335144	461500.0
2006-09-13	AB	Stock	67.85	69.93	67.83	69.64	431300.0
2006-09-13	ABAX-DELISTED	Stock	23.08	23.23	22.87	22.96	81775.0
2006-09-13	ABB-DELISTED	Stock	13.37	13.49	13.34	13.44	2796600.0
2006-09-13	ABBC-DELISTED	Stock	15.23	15.45	15.22	15.33	11241.0
2006-09-13	ABC-DELISTED	Stock	22.82	23.1	22.8	23.08	1783800.0
2006-09-13	ABCB	Stock	26.0863	26.1154	25.7458	25.8723	31872.0
2006-09-13	ABCO-DELISTED	Stock	25.35	25.73	25.14	25.6	179170.0
2006-09-13	ABCW-DELISTED	Stock	29.44	29.46	28.61	28.73	54590.0
2006-09-13	ABD-DELISTED	Stock	20.65	20.99	20.53	20.95	242700.0
2006-09-13	ABE-DELISTED	Stock	13.31	13.84	13.31	13.83	5100.0
2006-09-13	ABFS-DELISTED	Stock	46.43	47.08	46.2	47.03	318512.0
2006-09-13	ABG	Stock	20.76	20.85	20.67	20.81	275900.0
2006-09-13	ABK-DELISTED	Stock	84.85	85.54	84.31	85.19	695500.0
2006-09-13	ABM	Stock	18.76	18.81	18.58	18.73	188700.0
2006-09-13	ABMD-DELISTED	Stock	14.7612	15.15	14.7612	14.8	135221.0
2006-09-13	ABP-DELISTED	Stock	3.79	3.86	3.71	3.81	195400.0
2006-09-13	ABR	Stock	25.61	25.75	25.36	25.67	66700.0
2006-09-13	ABT	Stock	23.4142	23.6637	23.2943	23.5966	8631722.0
2006-09-13	ABTL-DELISTED	Stock	16.349	16.549	15.951	16.001	60060.0
2006-09-13	ABV-DELISTED	Stock	44.27	45.0	43.81	44.99	380700.0
2006-09-13	ABVA-DELISTED	Stock	16.783	16.783	16.76	16.76	200.0
2006-09-13	ABX-DELISTED	Stock	29.5	30.17	29.5	29.67	3793300.0
2006-09-13	ACAD	Stock	8.3	8.4	8.16	8.38	171600.0
2006-09-13	ACAP-DELISTED	Stock	47.68	48.08	47.68	47.9	36518.0
2006-09-13	ACAS-DELISTED	Stock	37.97	38.175	37.855	38.16	574440.0
2006-09-13	ACAT-DELISTED	Stock	16.1	16.73	16.1	16.54	151322.0
2006-09-13	ACC-DELISTED	Stock	25.15	25.65	25.01	25.24	1583300.0
2006-09-13	ACCL-DELISTED	Stock	5.5	5.6	5.47	5.5	164141.0
2006-09-13	ACCO	Stock	20.65	20.99	20.53	20.95	250400.0
2006-09-13	ACCP-DELISTED	Stock	0.75	0.8	0.75	0.8	1387.0

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

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