PREVIEW / stock_daily / 2006-10-18

all stock daily files

  file:    by_date/stock_daily/2006/2006-10-18.parquet
  size:    152 KB
  rows:    4,556
  symbols: 2,882

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-18	AAPL	Stock	2.6696	2.6918	2.6396	2.6618	1133907600.0
2006-10-18	MSFT	Stock	28.5	28.7	28.26	28.52	40630800.0
2006-10-18	NVDA	Stock	0.5483	0.5542	0.5222	0.526	822750000.0
2006-10-18	AMZN	Stock	1.6285	1.639	1.6	1.6155	106986000.0
2006-10-18	CL	Stock	30.0	30.355	29.97	30.21	5037400.0
2006-10-18	A	Stock	24.7854	25.1216	24.7067	25.0429	5366642.0
2006-10-18	AABA-DELISTED	Stock	24.5699996948242	24.75	22.8799991607666	22.9899997711182	111660900.0
2006-10-18	AACC-DELISTED	Stock	17.83	17.97	17.4	17.77	277137.0
2006-10-18	AACQ-DELISTED	Stock	5.33	5.35	5.32	5.32	35500.0
2006-10-18	AACQU-DELISTED	Stock	6.1	6.12	6.1	6.12	7500.0
2006-10-18	AACQW-DELISTED	Stock	0.4	0.41	0.4	0.41	55000.0
2006-10-18	AAI-DELISTED	Stock	10.8	10.85	10.45	10.58	1792400.0
2006-10-18	AAIC-DELISTED	Stock	161.4	164.6	161.4	164.2	826700.0
2006-10-18	AAME	Stock	2.54	2.82	2.54	2.6	13300.0
2006-10-18	AAON	Stock	3.1671	3.2711	3.1249	3.1434	61509.0
2006-10-18	AAP	Stock	35.1	35.34	34.66	35.06	646800.0
2006-10-18	AATI-DELISTED	Stock	5.51	5.6	5.38	5.38	486351.0
2006-10-18	AAU-DELISTED	Stock	2.43	2.45	2.4	2.44	24900.0
2006-10-18	AAUAF-DELISTED	Stock	2.43	2.45	2.4	2.44	24900.0
2006-10-18	AAV-DELISTED	Stock	13.47	13.63	13.25	13.33	985300.0
2006-10-18	AAWW-DELISTED	Stock	47.4	48.05	47.3	48.0	110099.0
2006-10-18	AAXN-DELISTED	Stock	9.68000030517578	9.71000003814697	9.36999988555908	9.39000034332275	643600.0
2006-10-18	AB	Stock	76.2	77.48	76.16	76.65	446800.0
2006-10-18	ABAX-DELISTED	Stock	22.2	22.62	22.04	22.3	171678.0
2006-10-18	ABB-DELISTED	Stock	13.94	13.96	13.79	13.84	1303100.0
2006-10-18	ABBC-DELISTED	Stock	16.01	16.28	15.78	15.84	9156.0
2006-10-18	ABC-DELISTED	Stock	23.23	23.43	23.12	23.16	1304000.0
2006-10-18	ABCB	Stock	27.234	27.234	26.8254	26.9422	10076.0
2006-10-18	ABCO-DELISTED	Stock	27.93	28.0	27.32	27.61	77909.0
2006-10-18	ABCW-DELISTED	Stock	29.47	29.47	28.93	29.02	31210.0
2006-10-18	ABD-DELISTED	Stock	22.9	23.25	22.75	23.23	211500.0
2006-10-18	ABE-DELISTED	Stock	14.76	15.12	14.76	15.12	38300.0
2006-10-18	ABFS-DELISTED	Stock	46.75	46.75	44.37	44.58	1027048.0
2006-10-18	ABG	Stock	22.76	23.29	22.7	23.25	418300.0
2006-10-18	ABK-DELISTED	Stock	85.46	85.83	84.75	85.26	284100.0
2006-10-18	ABM	Stock	19.75	19.8	19.5	19.59	167700.0
2006-10-18	ABMD-DELISTED	Stock	13.9	14.11	13.6	13.93	60740.0
2006-10-18	ABP-DELISTED	Stock	3.64	3.72	3.55	3.71	98900.0
2006-10-18	ABR	Stock	27.05	27.3	27.02	27.18	42300.0
2006-10-18	ABT	Stock	22.8625	23.1504	22.6801	22.9584	14436432.0
2006-10-18	ABTL-DELISTED	Stock	16.425	16.525	15.729	16.225	13021.0
2006-10-18	ABV-DELISTED	Stock	46.5	46.82	45.54	45.93	726200.0
2006-10-18	ABVA-DELISTED	Stock	16.65	17.39	16.65	17.34	2881.0
2006-10-18	ABX-DELISTED	Stock	30.2	30.26	29.56	29.82	3655600.0
2006-10-18	ACAD	Stock	10.3	10.52	10.12	10.41	169100.0
2006-10-18	ACAP-DELISTED	Stock	51.36	51.99	51.17	51.86	21090.0
2006-10-18	ACAS-DELISTED	Stock	41.81	42.04	41.68	42.04	794805.0
2006-10-18	ACAT-DELISTED	Stock	16.96	17.27	16.96	17.02	33769.0
2006-10-18	ACC-DELISTED	Stock	26.6	26.94	26.41	26.4652	99430.0
2006-10-18	ACCL-DELISTED	Stock	6.04	6.28	6.04	6.27	69561.0

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

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