PREVIEW / stock_daily / 2006-01-18

all stock daily files

  file:    by_date/stock_daily/2006/2006-01-18.parquet
  size:    144 KB
  rows:    4,325
  symbols: 2,739

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-01-18	AAPL	Stock	2.9671	3.0018	2.9232	2.9461	1200637200.0
2006-01-18	MSFT	Stock	26.74	26.98	26.7	26.83	52376200.0
2006-01-18	NVDA	Stock	0.3432	0.357	0.34	0.3558	459948000.0
2006-01-18	AMZN	Stock	2.1595	2.2295	2.155	2.216	174866000.0
2006-01-18	CL	Stock	27.185	27.305	27.06	27.26	2934000.0
2006-01-18	A	Stock	24.1345	24.7353	23.8984	24.6495	3948791.0
2006-01-18	AABA-DELISTED	Stock	35.0099983215332	36.1599998474121	34.7400016784668	35.1800003051758	118556100.0
2006-01-18	AACC-DELISTED	Stock	22.5	23.53	22.5	23.51	71445.0
2006-01-18	AACQ-DELISTED	Stock	5.22	5.22	5.22	5.22	2000.0
2006-01-18	AACQU-DELISTED	Stock	6.3	6.3	6.3	6.3	3500.0
2006-01-18	AAI-DELISTED	Stock	13.56	14.37	13.51	14.24	2530500.0
2006-01-18	AAIC-DELISTED	Stock	212.6	216.0	211.4	213.3	953100.0
2006-01-18	AAME	Stock	2.66	2.68	2.66	2.66	1400.0
2006-01-18	AAON	Stock	2.3717	2.4362	2.3717	2.4283	91884.0
2006-01-18	AAP	Stock	43.2	43.56	42.9	43.15	1337500.0
2006-01-18	AATI-DELISTED	Stock	13.935	14.19	13.935	14.19	57601.0
2006-01-18	AAU-DELISTED	Stock	2.61	2.61	2.41	2.41	107500.0
2006-01-18	AAUAF-DELISTED	Stock	2.61	2.61	2.41	2.41	107500.0
2006-01-18	AAV-DELISTED	Stock	19.0	19.04	18.63	18.78	227600.0
2006-01-18	AAWW-DELISTED	Stock	44.0	45.0	44.0	44.7	14500.0
2006-01-18	AAXN-DELISTED	Stock	8.05000019073486	8.35999965667725	7.75	8.31999969482422	2188700.0
2006-01-18	ABAX-DELISTED	Stock	17.7	18.06	17.7	17.85	66751.0
2006-01-18	ABB-DELISTED	Stock	10.58	10.68	10.57	10.66	1678000.0
2006-01-18	ABBC-DELISTED	Stock	13.26	13.28	13.18	13.18	1400.0
2006-01-18	ABC-DELISTED	Stock	20.5	20.72	20.48	20.52	3205200.0
2006-01-18	ABCB	Stock	19.696	19.8905	19.4626	19.5793	9356.0
2006-01-18	ABCO-DELISTED	Stock	23.14	23.19	22.99	23.04	234992.0
2006-01-18	ABCW-DELISTED	Stock	31.28	31.85	31.28	31.46	64720.0
2006-01-18	ABD-DELISTED	Stock	24.72	24.73	24.28	24.3	173700.0
2006-01-18	ABE-DELISTED	Stock	12.4	12.43	12.21	12.33	42000.0
2006-01-18	ABFS-DELISTED	Stock	44.33	44.47	43.6	44.09	491893.0
2006-01-18	ABG	Stock	16.26	16.54	16.23	16.42	25600.0
2006-01-18	ABK-DELISTED	Stock	77.1	77.94	76.44	76.54	378300.0
2006-01-18	ABM	Stock	19.5	19.64	19.45	19.54	149100.0
2006-01-18	ABMD-DELISTED	Stock	9.88	10.4	9.88	10.36	41360.0
2006-01-18	ABP-DELISTED	Stock	6.3	6.48	6.05	6.3	1081500.0
2006-01-18	ABR	Stock	26.59	27.19	26.59	26.84	133100.0
2006-01-18	ABT	Stock	19.7054	19.9117	19.6046	19.7774	7513130.0
2006-01-18	ABTL-DELISTED	Stock	24.95	25.65	24.9	25.25	17259.0
2006-01-18	ABV-DELISTED	Stock	39.98	39.98	39.6	39.78	395000.0
2006-01-18	ABVA-DELISTED	Stock	16.35	16.92	16.25	16.767	12704.0
2006-01-18	ABX-DELISTED	Stock	29.1	29.53	28.99	29.14	5414696.0
2006-01-18	ACAD	Stock	10.83	10.9	10.6	10.77	102300.0
2006-01-18	ACAP-DELISTED	Stock	47.05	48.7	47.05	48.22	60700.0
2006-01-18	ACAS-DELISTED	Stock	35.37	35.65	34.99	34.99	1209394.0
2006-01-18	ACAT-DELISTED	Stock	22.0	22.99	21.86	22.88	93006.0
2006-01-18	ACC-DELISTED	Stock	24.6	24.87	24.58	24.58	63700.0
2006-01-18	ACCL-DELISTED	Stock	6.91	7.02	6.77	7.0	94075.0
2006-01-18	ACCO	Stock	24.72	24.73	24.28	24.3	173900.0
2006-01-18	ACE-DELISTED	Stock	54.83	55.1	54.45	54.83	660543.0

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

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