PREVIEW / stock_daily / 2006-04-28

all stock daily files

  file:    by_date/stock_daily/2006/2006-04-28.parquet
  size:    148 KB
  rows:    4,417
  symbols: 2,788

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-04-28	AAPL	Stock	2.4779	2.5464	2.4714	2.5139	760037600.0
2006-04-28	MSFT	Stock	24.23	24.5	24.0	24.15	591052200.0
2006-04-28	NVDA	Stock	0.4865	0.4932	0.4823	0.487	284736000.0
2006-04-28	AMZN	Stock	1.7885	1.7945	1.757	1.7605	69850000.0
2006-04-28	CL	Stock	29.525	29.64	29.3	29.56	6421000.0
2006-04-28	A	Stock	27.8255	27.8684	27.4535	27.4821	2775030.0
2006-04-28	AABA-DELISTED	Stock	32.8800010681152	33.4500007629395	32.7799987792969	32.7799987792969	13283500.0
2006-04-28	AACC-DELISTED	Stock	20.51	20.84	20.4	20.78	72443.0
2006-04-28	AACQ-DELISTED	Stock	5.39	5.39	5.39	5.39	2500.0
2006-04-28	AACQW-DELISTED	Stock	0.69	0.69	0.65	0.65	140500.0
2006-04-28	AAI-DELISTED	Stock	13.86	14.47	13.71	13.96	4510100.0
2006-04-28	AAIC-DELISTED	Stock	214.0	226.8	211.0	216.2	4188800.0
2006-04-28	AAME	Stock	2.94	2.97	2.94	2.97	200.0
2006-04-28	AAON	Stock	3.4897	3.6214	3.4239	3.6109	158709.0
2006-04-28	AAP	Stock	39.67	40.4	39.6	40.22	1368400.0
2006-04-28	AATI-DELISTED	Stock	11.19	11.35	11.09	11.25	220166.0
2006-04-28	AAU-DELISTED	Stock	2.72	2.8316	2.713	2.82	99400.0
2006-04-28	AAUAF-DELISTED	Stock	2.72	2.8316	2.713	2.82	99400.0
2006-04-28	AAV-DELISTED	Stock	19.1	19.4	19.1	19.33	139100.0
2006-04-28	AAWW-DELISTED	Stock	46.0	48.0	45.0	48.0	78600.0
2006-04-28	AAXN-DELISTED	Stock	10.5799999237061	11.0799999237061	10.3000001907349	10.6999998092651	3864000.0
2006-04-28	AB	Stock	68.05	68.06	64.31	64.45	533000.0
2006-04-28	ABAX-DELISTED	Stock	24.605	26.85	24.5	26.14	1042588.0
2006-04-28	ABB-DELISTED	Stock	14.0	14.3	14.0	14.22	1519200.0
2006-04-28	ABBC-DELISTED	Stock	13.5	13.55	13.5	13.54	2503.0
2006-04-28	ABC-DELISTED	Stock	21.74	21.94	21.5	21.58	5113800.0
2006-04-28	ABCB	Stock	21.9428	22.1665	21.4468	21.6802	14497.0
2006-04-28	ABCO-DELISTED	Stock	27.64	28.11	27.38	28.06	147654.0
2006-04-28	ABCW-DELISTED	Stock	28.61	29.36	28.61	29.07	33130.0
2006-04-28	ABD-DELISTED	Stock	21.7	21.77	21.41	21.48	179900.0
2006-04-28	ABE-DELISTED	Stock	13.67	13.7799	13.6	13.72	16900.0
2006-04-28	ABFS-DELISTED	Stock	43.0	43.4	42.56	42.93	238106.0
2006-04-28	ABG	Stock	18.97	19.44	18.75	19.27	109300.0
2006-04-28	ABK-DELISTED	Stock	81.97	82.46	81.84	82.44	729400.0
2006-04-28	ABM	Stock	17.53	17.59	17.2	17.2	227900.0
2006-04-28	ABMD-DELISTED	Stock	12.84	13.23	12.707	12.95	70270.0
2006-04-28	ABP-DELISTED	Stock	5.95	6.31	5.95	6.12	357000.0
2006-04-28	ABR	Stock	25.35	26.04	25.35	25.9	140300.0
2006-04-28	ABT	Stock	20.0796	20.5114	20.0796	20.5067	11984368.0
2006-04-28	ABTL-DELISTED	Stock	22.2	22.95	22.1	22.75	40826.0
2006-04-28	ABV-DELISTED	Stock	46.65	46.78	46.05	46.3	431600.0
2006-04-28	ABVA-DELISTED	Stock	18.71	18.8	18.7	18.8	8000.0
2006-04-28	ABX-DELISTED	Stock	30.06	30.72	29.89	30.45	4223300.0
2006-04-28	ACAD	Stock	12.0	12.02	11.33	11.57	2481900.0
2006-04-28	ACAP-DELISTED	Stock	47.96	48.38	47.87	48.13	22235.0
2006-04-28	ACAS-DELISTED	Stock	34.55	34.92	34.369	34.85	1187559.0
2006-04-28	ACAT-DELISTED	Stock	21.5	22.0	21.42	21.67	38365.0
2006-04-28	ACC-DELISTED	Stock	23.95	24.38	23.7	24.12	72200.0
2006-04-28	ACCL-DELISTED	Stock	6.97	7.08	6.9	7.03	33963.0
2006-04-28	ACCO	Stock	21.7	21.77	21.41	21.48	181900.0

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

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