PREVIEW / stock_daily / 2006-07-24

all stock daily files

  file:    by_date/stock_daily/2006/2006-07-24.parquet
  size:    148 KB
  rows:    4,462
  symbols: 2,815

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-24	AAPL	Stock	2.1879	2.2179	2.1582	2.1936	722856400.0
2006-07-24	MSFT	Stock	24.01	24.11	23.79	24.0	59586700.0
2006-07-24	NVDA	Stock	0.3072	0.3335	0.3055	0.326	983178000.0
2006-07-24	AMZN	Stock	1.6675	1.734	1.667	1.7155	147708000.0
2006-07-24	CL	Stock	30.995	31.2	30.995	31.045	3559000.0
2006-07-24	A	Stock	19.9499	20.9299	19.9499	20.7725	4984150.0
2006-07-24	AABA-DELISTED	Stock	26.2399997711182	27.2299995422363	25.8899993896484	26.9400005340576	42631300.0
2006-07-24	AACC-DELISTED	Stock	17.9	18.45	17.9	18.4	158338.0
2006-07-24	AACQU-DELISTED	Stock	6.03	6.03	6.03	6.03	3700.0
2006-07-24	AACQW-DELISTED	Stock	0.37	0.37	0.37	0.37	20500.0
2006-07-24	AAI-DELISTED	Stock	12.8	13.1	12.79	12.95	977600.0
2006-07-24	AAIC-DELISTED	Stock	193.8	197.8	191.8	197.8	1042900.0
2006-07-24	AAON	Stock	3.1302	3.2263	3.042	3.1394	229331.0
2006-07-24	AAP	Stock	29.27	29.84	29.2	29.71	1277100.0
2006-07-24	AATI-DELISTED	Stock	9.09	9.27	9.0	9.22	112800.0
2006-07-24	AAU-DELISTED	Stock	2.35	2.37	2.27	2.32	83000.0
2006-07-24	AAUAF-DELISTED	Stock	2.35	2.37	2.27	2.32	83000.0
2006-07-24	AAV-DELISTED	Stock	15.63	16.05	15.59	16.05	446500.0
2006-07-24	AAWW-DELISTED	Stock	41.68	44.01	41.68	42.85	60333.0
2006-07-24	AAXN-DELISTED	Stock	7.69999980926514	8.03999996185303	7.61999988555908	8.01000022888184	1509000.0
2006-07-24	AB	Stock	59.22	61.39	59.15	61.23	175700.0
2006-07-24	ABAX-DELISTED	Stock	19.58	20.58	19.45	20.58	153778.0
2006-07-24	ABB-DELISTED	Stock	11.78	11.93	11.77	11.91	1283200.0
2006-07-24	ABBC-DELISTED	Stock	14.38	14.39	14.15	14.33	11300.0
2006-07-24	ABC-DELISTED	Stock	21.25	21.76	21.22	21.74	3117600.0
2006-07-24	ABCB	Stock	21.9526	22.3708	21.9526	22.3708	19946.0
2006-07-24	ABCO-DELISTED	Stock	23.45	23.89	23.45	23.88	147558.0
2006-07-24	ABCW-DELISTED	Stock	29.19	30.06	29.19	30.04	23360.0
2006-07-24	ABD-DELISTED	Stock	19.625	20.07	19.424	20.05	157860.0
2006-07-24	ABE-DELISTED	Stock	12.0	12.38	11.97	12.35	26600.0
2006-07-24	ABFS-DELISTED	Stock	45.31	48.39	45.31	48.11	1085566.0
2006-07-24	ABG	Stock	20.34	21.2	20.34	20.84	106400.0
2006-07-24	ABK-DELISTED	Stock	81.16	83.26	81.11	83.12	678100.0
2006-07-24	ABM	Stock	16.51	16.89	16.51	16.75	63300.0
2006-07-24	ABMD-DELISTED	Stock	12.81	13.5	12.81	13.47	61396.0
2006-07-24	ABP-DELISTED	Stock	4.02	4.14	4.01	4.11	135400.0
2006-07-24	ABR	Stock	25.51	25.62	25.21	25.62	61600.0
2006-07-24	ABT	Stock	22.0228	22.8337	21.994	22.8193	18151105.0
2006-07-24	ABTL-DELISTED	Stock	16.4	16.5	16.25	16.25	18192.0
2006-07-24	ABV-DELISTED	Stock	40.2	41.0	39.82	40.71	550400.0
2006-07-24	ABVA-DELISTED	Stock	15.96	16.01	15.93	16.0	12090.0
2006-07-24	ABX-DELISTED	Stock	27.91	28.73	27.61	28.55	3833200.0
2006-07-24	ACAD	Stock	6.52	6.85	6.52	6.84	195000.0
2006-07-24	ACAP-DELISTED	Stock	46.71	47.35	46.54	46.77	40484.0
2006-07-24	ACAS-DELISTED	Stock	34.65	34.79	34.4	34.54	755269.0
2006-07-24	ACAT-DELISTED	Stock	17.0	17.49	16.73	17.25	63602.0
2006-07-24	ACC-DELISTED	Stock	24.6	25.47	24.6	25.47	51500.0
2006-07-24	ACCL-DELISTED	Stock	6.01	6.2	6.01	6.15	43817.0
2006-07-24	ACCO	Stock	19.6	20.07	19.4	20.07	168400.0
2006-07-24	ACCP-DELISTED	Stock	1.05	1.05	0.85	1.05	4425.0

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

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