PREVIEW / stock_daily / 2006-07-26

all stock daily files

  file:    by_date/stock_daily/2006/2006-07-26.parquet
  size:    147 KB
  rows:    4,457
  symbols: 2,808

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-07-26	AAPL	Stock	2.2143	2.3086	2.2029	2.2811	898427600.0
2006-07-26	MSFT	Stock	24.12	24.53	24.1	24.37	54942100.0
2006-07-26	NVDA	Stock	0.3375	0.3415	0.3275	0.3375	495318000.0
2006-07-26	AMZN	Stock	1.438	1.45	1.298	1.313	1539704000.0
2006-07-26	CL	Stock	29.9	30.065	29.6	29.725	6218400.0
2006-07-26	A	Stock	20.8011	20.8226	19.8856	19.8927	7971536.0
2006-07-26	AABA-DELISTED	Stock	26.7800006866455	27.5100002288818	26.5699996948242	27.0799999237061	20073800.0
2006-07-26	AACC-DELISTED	Stock	18.48	18.66	18.0	18.34	113764.0
2006-07-26	AACQW-DELISTED	Stock	0.35	0.36	0.35	0.36	30000.0
2006-07-26	AAI-DELISTED	Stock	12.78	12.82	12.4	12.6	1365500.0
2006-07-26	AAIC-DELISTED	Stock	197.2	197.4	187.0	193.0	2275700.0
2006-07-26	AAME	Stock	2.84	2.9	2.8	2.8	8000.0
2006-07-26	AAON	Stock	3.1473	3.1631	3.0907	3.1039	291600.0
2006-07-26	AAP	Stock	31.29	31.95	31.07	31.51	1731500.0
2006-07-26	AATI-DELISTED	Stock	9.66	9.66	9.18	9.25	130954.0
2006-07-26	AAU-DELISTED	Stock	2.36	2.36	2.23	2.35	27359.0
2006-07-26	AAUAF-DELISTED	Stock	2.4	2.4	2.27	2.39	26900.0
2006-07-26	AAV-DELISTED	Stock	16.32	16.58	16.05	16.58	483100.0
2006-07-26	AAWW-DELISTED	Stock	42.5	42.7	41.41	41.53	55119.0
2006-07-26	AAXN-DELISTED	Stock	8.11999988555908	8.11999988555908	7.21999979019165	7.30000019073486	5185900.0
2006-07-26	AB	Stock	60.35	60.55	59.4	60.4	229200.0
2006-07-26	ABAX-DELISTED	Stock	20.68	20.79	20.14	20.51	189211.0
2006-07-26	ABB-DELISTED	Stock	12.21	12.48	12.19	12.43	1633300.0
2006-07-26	ABBC-DELISTED	Stock	14.28	14.42	14.24	14.3	9658.0
2006-07-26	ABC-DELISTED	Stock	21.75	21.87	21.54	21.56	2306600.0
2006-07-26	ABCB	Stock	22.5069	22.9252	22.0401	22.8279	36807.0
2006-07-26	ABCO-DELISTED	Stock	24.09	24.37	23.38	23.62	131434.0
2006-07-26	ABCW-DELISTED	Stock	29.81	30.14	28.97	29.94	34080.0
2006-07-26	ABD-DELISTED	Stock	19.7	19.77	19.21	19.5	115900.0
2006-07-26	ABE-DELISTED	Stock	12.38	12.65	12.2644	12.5	15300.0
2006-07-26	ABFS-DELISTED	Stock	47.16	47.16	44.07	45.08	867998.0
2006-07-26	ABG	Stock	20.68	21.0	20.61	20.64	179400.0
2006-07-26	ABK-DELISTED	Stock	85.2	86.5	83.7	84.75	2362000.0
2006-07-26	ABM	Stock	16.87	17.06	16.46	16.8	171200.0
2006-07-26	ABMD-DELISTED	Stock	13.52	13.75	13.24	13.64	90160.0
2006-07-26	ABP-DELISTED	Stock	4.15	4.45	4.15	4.4	343800.0
2006-07-26	ABR	Stock	24.75	25.18	23.89	25.06	211900.0
2006-07-26	ABT	Stock	22.7905	23.0256	22.5362	22.5986	20448312.0
2006-07-26	ABTL-DELISTED	Stock	16.1	16.301	15.799	16.0	23653.0
2006-07-26	ABV-DELISTED	Stock	40.61	40.64	39.92	40.35	695400.0
2006-07-26	ABVA-DELISTED	Stock	16.0	16.0	15.79	15.94	615.0
2006-07-26	ABX-DELISTED	Stock	29.25	30.02	29.04	29.97	3292600.0
2006-07-26	ACAD	Stock	6.77	6.9	6.59	6.63	121800.0
2006-07-26	ACAP-DELISTED	Stock	46.13	48.36	46.13	47.34	69313.0
2006-07-26	ACAS-DELISTED	Stock	34.8	34.98	34.6	34.82	717355.0
2006-07-26	ACAT-DELISTED	Stock	17.62	19.94	17.62	18.31	214700.0
2006-07-26	ACC-DELISTED	Stock	25.16	26.0	25.16	25.67	61600.0
2006-07-26	ACCL-DELISTED	Stock	6.21	6.34	6.05	6.3	23805.0
2006-07-26	ACCO	Stock	19.7	19.77	19.21	19.5	126300.0
2006-07-26	ACCP-DELISTED	Stock	0.85	1.05	0.85	1.05	2000.0

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

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