PREVIEW / stock_daily / 2006-10-17

all stock daily files

  file:    by_date/stock_daily/2006/2006-10-17.parquet
  size:    152 KB
  rows:    4,536
  symbols: 2,866

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-10-17	AAPL	Stock	2.68	2.6882	2.6443	2.6532	480925200.0
2006-10-17	MSFT	Stock	28.24	28.51	28.17	28.44	40122600.0
2006-10-17	NVDA	Stock	0.5527	0.5565	0.535	0.5403	526506000.0
2006-10-17	AMZN	Stock	1.61	1.6305	1.5875	1.6235	132714000.0
2006-10-17	CL	Stock	29.895	30.015	29.675	29.895	6189800.0
2006-10-17	A	Stock	24.2489	24.7496	24.2489	24.6066	7013486.0
2006-10-17	AABA-DELISTED	Stock	23.7399997711182	24.3500003814697	23.6800003051758	24.1499996185303	67417200.0
2006-10-17	AACC-DELISTED	Stock	17.34	17.97	17.3	17.65	173410.0
2006-10-17	AACQ-DELISTED	Stock	5.35	5.35	5.33	5.33	3500.0
2006-10-17	AACQU-DELISTED	Stock	6.03	6.08	6.03	6.08	28000.0
2006-10-17	AACQW-DELISTED	Stock	0.365	0.4	0.365	0.39	968400.0
2006-10-17	AAI-DELISTED	Stock	10.55	10.75	10.45	10.69	1669400.0
2006-10-17	AAIC-DELISTED	Stock	163.8	165.2	161.4	161.4	913300.0
2006-10-17	AAME	Stock	2.51	2.51	2.48	2.5	2100.0
2006-10-17	AAON	Stock	3.1276	3.1802	3.0565	3.1565	388800.0
2006-10-17	AAP	Stock	35.2	35.2	34.42	34.92	951300.0
2006-10-17	AATI-DELISTED	Stock	5.6	5.6	5.35	5.53	357003.0
2006-10-17	AAU-DELISTED	Stock	2.42	2.4649	2.4152	2.46	28256.0
2006-10-17	AAUAF-DELISTED	Stock	2.42	2.47	2.42	2.47	28200.0
2006-10-17	AAV-DELISTED	Stock	13.55	13.6	13.2	13.3688	1092900.0
2006-10-17	AAWW-DELISTED	Stock	47.16	47.55	46.53	47.04	212391.0
2006-10-17	AAXN-DELISTED	Stock	9.67000007629395	9.75	9.39000034332275	9.63000011444092	1144600.0
2006-10-17	AB	Stock	75.4	76.43	75.22	76.04	327800.0
2006-10-17	ABAX-DELISTED	Stock	22.32	22.35	21.8	22.15	209807.0
2006-10-17	ABB-DELISTED	Stock	13.92	13.96	13.76	13.88	2386200.0
2006-10-17	ABBC-DELISTED	Stock	15.66	15.88	15.56	15.87	6541.0
2006-10-17	ABC-DELISTED	Stock	23.0	23.23	23.0	23.1	1333400.0
2006-10-17	ABCB	Stock	27.3896	27.4285	26.8936	27.234	39789.0
2006-10-17	ABCO-DELISTED	Stock	27.59	27.82	27.31	27.71	50231.0
2006-10-17	ABCW-DELISTED	Stock	29.25	29.47	28.82	29.47	38740.0
2006-10-17	ABD-DELISTED	Stock	22.7	22.98	22.53	22.81	151800.0
2006-10-17	ABE-DELISTED	Stock	14.58	14.75	14.47	14.7	52200.0
2006-10-17	ABFS-DELISTED	Stock	48.64	48.64	47.03	47.4	515150.0
2006-10-17	ABG	Stock	22.8	22.9	22.61	22.78	834700.0
2006-10-17	ABK-DELISTED	Stock	84.94	85.51	84.55	85.38	548700.0
2006-10-17	ABM	Stock	19.5	19.73	19.37	19.72	123400.0
2006-10-17	ABMD-DELISTED	Stock	13.93	14.08	13.67	13.89	85930.0
2006-10-17	ABP-DELISTED	Stock	3.6	3.7	3.6	3.64	162700.0
2006-10-17	ABR	Stock	27.0	27.01	26.47	26.96	82400.0
2006-10-17	ABT	Stock	22.6322	22.8049	22.4306	22.6418	8803251.0
2006-10-17	ABTL-DELISTED	Stock	16.175	16.375	16.175	16.375	9430.0
2006-10-17	ABV-DELISTED	Stock	45.24	46.26	45.2	46.04	281300.0
2006-10-17	ABVA-DELISTED	Stock	16.32	16.82	16.32	16.82	300.0
2006-10-17	ABVT-DELISTED	Stock	60.0	60.0	60.0	60.0	2.0
2006-10-17	ABX-DELISTED	Stock	30.2	30.21	29.4	30.09	4543200.0
2006-10-17	ACAD	Stock	10.0	10.29	9.98	10.2	191100.0
2006-10-17	ACAP-DELISTED	Stock	51.54	51.58	50.03	51.3	34030.0
2006-10-17	ACAS-DELISTED	Stock	41.74	41.96	41.6	41.81	840924.0
2006-10-17	ACAT-DELISTED	Stock	17.01	17.01	16.72	16.85	49340.0
2006-10-17	ACC-DELISTED	Stock	26.45	26.69	26.32	26.63	56700.0

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

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