PREVIEW / stock_daily / 2006-09-28

all stock daily files

  file:    by_date/stock_daily/2006/2006-09-28.parquet
  size:    151 KB
  rows:    4,518
  symbols: 2,853

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-09-28	AAPL	Stock	2.7507	2.7671	2.7125	2.7504	723609600.0
2006-09-28	MSFT	Stock	27.47	27.52	27.26	27.4	44179700.0
2006-09-28	NVDA	Stock	0.4827	0.4948	0.4805	0.4928	647346000.0
2006-09-28	AMZN	Stock	1.6135	1.6165	1.561	1.592	149988000.0
2006-09-28	CL	Stock	31.05	31.3	30.935	31.285	2640200.0
2006-09-28	A	Stock	23.0186	23.6123	22.9328	23.5908	5407045.0
2006-09-28	AABA-DELISTED	Stock	24.8700008392334	25.5	24.8400001525879	25.3299999237061	35331200.0
2006-09-28	AACC-DELISTED	Stock	16.0	16.23	15.95	16.09	169255.0
2006-09-28	AACQ-DELISTED	Stock	5.36	5.36	5.34	5.34	8600.0
2006-09-28	AACQU-DELISTED	Stock	6.12	6.12	6.1	6.1	2500.0
2006-09-28	AACQW-DELISTED	Stock	0.4	0.4	0.4	0.4	30000.0
2006-09-28	AAI-DELISTED	Stock	10.0	10.05	9.71	9.95	1503300.0
2006-09-28	AAIC-DELISTED	Stock	164.4	164.8	161.6	163.0	857200.0
2006-09-28	AAME	Stock	2.45	2.59	2.45	2.59	2300.0
2006-09-28	AAON	Stock	3.146	3.15	3.0499	3.0841	112387.0
2006-09-28	AAP	Stock	33.48	33.97	33.12	33.65	630400.0
2006-09-28	AATI-DELISTED	Stock	5.24	5.43	5.05	5.42	1977051.0
2006-09-28	AAU-DELISTED	Stock	2.23	2.27	2.2	2.22	71000.0
2006-09-28	AAUAF-DELISTED	Stock	2.23	2.27	2.2	2.22	71000.0
2006-09-28	AAV-DELISTED	Stock	12.1	12.3	11.88	12.23	1123300.0
2006-09-28	AAWW-DELISTED	Stock	43.99	44.0	43.73	43.88	33570.0
2006-09-28	AAXN-DELISTED	Stock	7.28999996185303	7.36999988555908	7.19000005722046	7.23999977111816	571700.0
2006-09-28	AB	Stock	69.73	69.8	68.9	69.07	183500.0
2006-09-28	ABAX-DELISTED	Stock	23.85	23.85	23.16	23.23	140939.0
2006-09-28	ABB-DELISTED	Stock	13.26	13.33	13.24	13.32	1063600.0
2006-09-28	ABBC-DELISTED	Stock	15.25	15.25	15.11	15.23	1461.0
2006-09-28	ABC-DELISTED	Stock	22.26	22.54	22.2	22.5	1700200.0
2006-09-28	ABCB	Stock	27.0686	27.2146	26.8936	27.0881	21179.0
2006-09-28	ABCO-DELISTED	Stock	25.45	25.65	25.36	25.49	73374.0
2006-09-28	ABCW-DELISTED	Stock	29.08	29.11	28.68	28.99	12820.0
2006-09-28	ABD-DELISTED	Stock	22.43	22.58	22.2	22.45	231380.0
2006-09-28	ABE-DELISTED	Stock	14.07	14.1	13.95	14.1	4800.0
2006-09-28	ABFS-DELISTED	Stock	43.83	44.17	43.05	44.0	345933.0
2006-09-28	ABG	Stock	20.5	20.5	20.26	20.31	192600.0
2006-09-28	ABK-DELISTED	Stock	82.69	83.16	82.66	82.89	470100.0
2006-09-28	ABM	Stock	19.07	19.08	18.78	18.94	207600.0
2006-09-28	ABMD-DELISTED	Stock	15.1	15.3	14.81	15.12	63659.0
2006-09-28	ABP-DELISTED	Stock	3.11	3.12	3.07	3.09	152100.0
2006-09-28	ABR	Stock	25.94	25.94	25.49	25.65	91000.0
2006-09-28	ABT	Stock	23.2463	23.2559	23.0112	23.1887	9546478.0
2006-09-28	ABTL-DELISTED	Stock	14.825	14.975	14.476	14.825	20709.0
2006-09-28	ABV-DELISTED	Stock	45.09	45.74	44.8	45.66	256500.0
2006-09-28	ABVA-DELISTED	Stock	16.45	16.86	16.45	16.61	4100.0
2006-09-28	ABX-DELISTED	Stock	31.4	31.54	30.81	30.82	3170900.0
2006-09-28	ACAD	Stock	8.63	8.75	8.6	8.63	144900.0
2006-09-28	ACAP-DELISTED	Stock	49.43	49.43	48.48	49.06	50273.0
2006-09-28	ACAS-DELISTED	Stock	39.15	39.4	39.12	39.33	989610.0
2006-09-28	ACAT-DELISTED	Stock	17.57	17.62	16.92	17.26	138669.0
2006-09-28	ACC-DELISTED	Stock	25.6	25.89	25.53	25.7	109900.0
2006-09-28	ACCL-DELISTED	Stock	6.43	6.64	6.25	6.45	211954.0

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

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