PREVIEW / stock_daily / 2006-10-04

all stock daily files

  file:    by_date/stock_daily/2006/2006-10-04.parquet
  size:    151 KB
  rows:    4,531
  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-04	AAPL	Stock	2.6464	2.695	2.6129	2.6921	829082800.0
2006-10-04	MSFT	Stock	27.39	27.96	27.37	27.94	82191200.0
2006-10-04	NVDA	Stock	0.4723	0.5182	0.471	0.518	1460382000.0
2006-10-04	AMZN	Stock	1.5875	1.6415	1.565	1.638	141296000.0
2006-10-04	CL	Stock	30.95	31.255	30.9	31.2	6487400.0
2006-10-04	A	Stock	22.9971	23.691	22.99	23.6338	3541274.0
2006-10-04	AABA-DELISTED	Stock	24.8899993896484	25.2600002288818	24.7399997711182	25.2099990844727	21717900.0
2006-10-04	AACC-DELISTED	Stock	16.52	16.87	16.41	16.82	136824.0
2006-10-04	AACQ-DELISTED	Stock	5.37	5.37	5.37	5.37	1500.0
2006-10-04	AACQU-DELISTED	Stock	6.15	6.17	6.12	6.16	14600.0
2006-10-04	AACQW-DELISTED	Stock	0.42	0.43	0.41	0.41	152200.0
2006-10-04	AAI-DELISTED	Stock	10.37	10.44	10.18	10.29	2018400.0
2006-10-04	AAIC-DELISTED	Stock	160.0	167.0	158.4	166.2	1351700.0
2006-10-04	AAME	Stock	2.45	2.52	2.45	2.45	3300.0
2006-10-04	AAON	Stock	3.0235	3.2277	3.0235	3.225	180731.0
2006-10-04	AAP	Stock	34.3	35.21	34.24	35.15	1838700.0
2006-10-04	AATI-DELISTED	Stock	4.98	5.15	4.98	5.06	909066.0
2006-10-04	AAU-DELISTED	Stock	2.3	2.41	2.28	2.41	107100.0
2006-10-04	AAUAF-DELISTED	Stock	2.3	2.41	2.28	2.41	107100.0
2006-10-04	AAV-DELISTED	Stock	11.35	11.36	10.73	11.2595	1584600.0
2006-10-04	AAWW-DELISTED	Stock	43.98	45.03	43.81	44.74	110158.0
2006-10-04	AAXN-DELISTED	Stock	7.57000017166138	7.69000005722046	7.51999998092651	7.65000009536743	493500.0
2006-10-04	AB	Stock	68.3	69.67	68.3	69.0	178800.0
2006-10-04	ABAX-DELISTED	Stock	23.43	24.5	23.27	24.04	424421.0
2006-10-04	ABB-DELISTED	Stock	13.16	13.35	13.12	13.33	1586800.0
2006-10-04	ABBC-DELISTED	Stock	14.87	15.03	14.87	15.0	5911.0
2006-10-04	ABC-DELISTED	Stock	22.64	23.02	22.62	22.99	1693600.0
2006-10-04	ABCB	Stock	26.5921	27.5161	26.417	27.4285	45649.0
2006-10-04	ABCO-DELISTED	Stock	25.51	26.59	25.47	26.47	364962.0
2006-10-04	ABCW-DELISTED	Stock	28.45	28.99	28.45	28.8	48000.0
2006-10-04	ABD-DELISTED	Stock	22.27	22.54	22.12	22.52	229850.0
2006-10-04	ABE-DELISTED	Stock	14.26	14.5799	14.26	14.3499	17200.0
2006-10-04	ABFS-DELISTED	Stock	43.46	46.09	43.13	45.53	496808.0
2006-10-04	ABG	Stock	20.95	21.59	20.79	21.5	308600.0
2006-10-04	ABK-DELISTED	Stock	83.15	84.46	83.13	84.39	504200.0
2006-10-04	ABM	Stock	18.85	18.98	18.73	18.82	296300.0
2006-10-04	ABMD-DELISTED	Stock	14.45	15.2	14.17	14.99	134467.0
2006-10-04	ABP-DELISTED	Stock	2.95	3.3	2.9	3.3	440700.0
2006-10-04	ABR	Stock	25.3	25.94	25.3	25.92	103400.0
2006-10-04	ABT	Stock	22.7665	22.7665	22.4498	22.6178	15358274.0
2006-10-04	ABTL-DELISTED	Stock	14.875	14.875	14.375	14.425	8268.0
2006-10-04	ABV-DELISTED	Stock	46.21	46.37	45.63	46.3	484800.0
2006-10-04	ABVA-DELISTED	Stock	16.85	16.98	16.85	16.98	2275.0
2006-10-04	ABX-DELISTED	Stock	28.67	28.91	27.64	28.84	8612800.0
2006-10-04	ACAD	Stock	8.38	8.67	8.3	8.65	103700.0
2006-10-04	ACAP-DELISTED	Stock	49.67	50.8	48.67	50.65	31947.0
2006-10-04	ACAS-DELISTED	Stock	40.05	40.5	39.89	40.46	1430341.0
2006-10-04	ACAT-DELISTED	Stock	16.51	17.57	16.51	17.35	274752.0
2006-10-04	ACC-DELISTED	Stock	25.34	25.81	25.33	25.59	115300.0
2006-10-04	ACCL-DELISTED	Stock	6.04	6.38	6.04	6.16	70745.0

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

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