PREVIEW / stock_daily / 2006-06-27

all stock daily files

  file:    by_date/stock_daily/2006/2006-06-27.parquet
  size:    148 KB
  rows:    4,435
  symbols: 2,798

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-06-27	AAPL	Stock	2.1104	2.115	2.05	2.0511	550611600.0
2006-06-27	MSFT	Stock	22.89	23.16	22.84	22.86	84759100.0
2006-06-27	NVDA	Stock	0.3373	0.3377	0.3202	0.3247	608514000.0
2006-06-27	AMZN	Stock	1.836	1.875	1.8085	1.824	112820000.0
2006-06-27	CL	Stock	30.05	30.105	29.85	30.065	5811600.0
2006-06-27	A	Stock	21.8884	22.4607	21.731	21.774	5071525.0
2006-06-27	AABA-DELISTED	Stock	31.8500003814697	32.2200012207031	31.3199996948242	31.5100002288818	16589400.0
2006-06-27	AACC-DELISTED	Stock	19.46	19.62	19.12	19.5	185282.0
2006-06-27	AACQ-DELISTED	Stock	5.32	5.32	5.32	5.32	500.0
2006-06-27	AACQU-DELISTED	Stock	6.3	6.3	6.3	6.3	900.0
2006-06-27	AACQW-DELISTED	Stock	0.47	0.48	0.47	0.47	125000.0
2006-06-27	AAI-DELISTED	Stock	14.36	14.62	13.89	13.95	1022800.0
2006-06-27	AAIC-DELISTED	Stock	228.4	241.398	226.0	233.8	3021900.0
2006-06-27	AAME	Stock	2.9	3.1	2.9	2.94	4100.0
2006-06-27	AAON	Stock	2.909	3.0578	2.909	2.963	467016.0
2006-06-27	AAP	Stock	37.34	37.35	36.59	36.66	418800.0
2006-06-27	AATI-DELISTED	Stock	9.99	10.0	9.88	9.97	36599.0
2006-06-27	AAU-DELISTED	Stock	2.21	2.331	2.2	2.24	37100.0
2006-06-27	AAUAF-DELISTED	Stock	2.21	2.331	2.2	2.24	37100.0
2006-06-27	AAV-DELISTED	Stock	17.8	17.87	17.61	17.62	395600.0
2006-06-27	AAWW-DELISTED	Stock	50.0	50.0	49.78	49.94	75853.0
2006-06-27	AAXN-DELISTED	Stock	8.10000038146973	8.19999980926514	7.82999992370605	7.84999990463257	513400.0
2006-06-27	AB	Stock	57.89	58.23	56.3	56.84	305300.0
2006-06-27	ABAX-DELISTED	Stock	21.06	21.06	20.21	20.33	192691.0
2006-06-27	ABB-DELISTED	Stock	12.29	12.3	11.97	11.98	1263700.0
2006-06-27	ABBC-DELISTED	Stock	15.7	15.7	15.51	15.61	21063.0
2006-06-27	ABC-DELISTED	Stock	20.59	20.67	20.4	20.43	2174800.0
2006-06-27	ABCB	Stock	21.2036	21.3981	20.4838	20.4936	21385.0
2006-06-27	ABCO-DELISTED	Stock	23.93	24.22	23.42	23.51	126677.0
2006-06-27	ABCW-DELISTED	Stock	29.45	29.45	28.88	28.91	65240.0
2006-06-27	ABD-DELISTED	Stock	21.75	21.94	21.46	21.5	228810.0
2006-06-27	ABE-DELISTED	Stock	11.56	11.78	11.52	11.55	35900.0
2006-06-27	ABFS-DELISTED	Stock	46.51	47.85	46.2	46.43	454722.0
2006-06-27	ABG	Stock	20.53	20.86	20.29	20.43	89900.0
2006-06-27	ABK-DELISTED	Stock	80.57	80.86	79.84	79.93	390500.0
2006-06-27	ABM	Stock	17.55	17.69	17.15	17.18	149400.0
2006-06-27	ABMD-DELISTED	Stock	12.39	12.55	11.91	12.01	46735.0
2006-06-27	ABP-DELISTED	Stock	4.26	4.32	4.21	4.29	190000.0
2006-06-27	ABR	Stock	24.7	24.7	23.99	24.04	77600.0
2006-06-27	ABT	Stock	20.1996	20.262	19.8829	19.9789	8073572.0
2006-06-27	ABTL-DELISTED	Stock	15.375	15.776	15.275	15.275	68152.0
2006-06-27	ABV-DELISTED	Stock	38.07	38.5	37.53	37.55	430400.0
2006-06-27	ABVA-DELISTED	Stock	17.47	17.47	16.75	16.79	3500.0
2006-06-27	ABX-DELISTED	Stock	28.6	28.63	27.8	27.81	2929000.0
2006-06-27	ACAD	Stock	8.15	8.2	7.6	7.62	271500.0
2006-06-27	ACAP-DELISTED	Stock	48.3	48.51	47.36	47.37	27528.0
2006-06-27	ACAS-DELISTED	Stock	33.16	33.17	32.84	32.87	528742.0
2006-06-27	ACAT-DELISTED	Stock	18.48	18.67	17.44	17.59	66903.0
2006-06-27	ACC-DELISTED	Stock	24.4	24.5	23.99	24.02	70200.0
2006-06-27	ACCL-DELISTED	Stock	7.11	7.19	6.97	7.06	59961.0

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

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