PREVIEW / stock_daily / 2006-06-23

all stock daily files

  file:    by_date/stock_daily/2006/2006-06-23.parquet
  size:    147 KB
  rows:    4,440
  symbols: 2,794

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-23	AAPL	Stock	2.1329	2.1489	2.0975	2.1011	660203600.0
2006-06-23	MSFT	Stock	22.85	22.87	22.5	22.5	60532600.0
2006-06-23	NVDA	Stock	0.3377	0.3455	0.3345	0.3385	335202000.0
2006-06-23	AMZN	Stock	1.823	1.8325	1.801	1.8275	78468000.0
2006-06-23	CL	Stock	30.0	30.24	29.97	30.035	2308200.0
2006-06-23	A	Stock	22.8898	22.8898	21.3448	22.3104	8503894.0
2006-06-23	AABA-DELISTED	Stock	31.0799999237061	31.7600002288818	30.8199996948242	31.3700008392334	17378500.0
2006-06-23	AACC-DELISTED	Stock	19.39	19.54	19.15	19.47	155310.0
2006-06-23	AACQW-DELISTED	Stock	0.49	0.49	0.47	0.49	70000.0
2006-06-23	AAI-DELISTED	Stock	14.42	14.67	14.12	14.6	579800.0
2006-06-23	AAIC-DELISTED	Stock	212.0	234.0	212.0	220.4	6398400.0
2006-06-23	AAME	Stock	3.05	3.13	2.8	2.93	134900.0
2006-06-23	AAON	Stock	2.8273	2.8523	2.7905	2.8036	109350.0
2006-06-23	AAP	Stock	36.92	37.87	36.89	37.64	441000.0
2006-06-23	AATI-DELISTED	Stock	10.0	10.0	9.8	9.95	65109.0
2006-06-23	AAU-DELISTED	Stock	2.3	2.32	2.22	2.28	21800.0
2006-06-23	AAUAF-DELISTED	Stock	2.3	2.32	2.22	2.28	21800.0
2006-06-23	AAV-DELISTED	Stock	17.86	18.0	17.77	17.82	437500.0
2006-06-23	AAWW-DELISTED	Stock	50.0	50.0	49.98	50.0	49892.0
2006-06-23	AAXN-DELISTED	Stock	8.01000022888184	8.11999988555908	8.0	8.07999992370605	395600.0
2006-06-23	AB	Stock	58.67	59.17	58.39	58.45	182700.0
2006-06-23	ABAX-DELISTED	Stock	20.35	20.58	20.0965	20.42	128371.0
2006-06-23	ABB-DELISTED	Stock	12.11	12.32	12.1	12.25	560000.0
2006-06-23	ABBC-DELISTED	Stock	15.43	15.63	15.35	15.53	21668.0
2006-06-23	ABC-DELISTED	Stock	20.28	20.64	20.08	20.48	3004800.0
2006-06-23	ABCB	Stock	20.1143	20.4255	19.9878	20.0754	10178.0
2006-06-23	ABCO-DELISTED	Stock	23.64	24.35	23.57	23.69	194778.0
2006-06-23	ABCW-DELISTED	Stock	28.58	28.76	28.33	28.47	134650.0
2006-06-23	ABD-DELISTED	Stock	21.91	22.02	21.64	21.82	237190.0
2006-06-23	ABE-DELISTED	Stock	11.9	11.9	11.74	11.85	34800.0
2006-06-23	ABFS-DELISTED	Stock	45.97	47.21	45.89	46.97	677842.0
2006-06-23	ABG	Stock	20.59	20.85	20.24	20.5	74400.0
2006-06-23	ABK-DELISTED	Stock	79.5	79.79	79.08	79.31	554100.0
2006-06-23	ABM	Stock	17.54	17.54	17.21	17.43	226800.0
2006-06-23	ABMD-DELISTED	Stock	12.0	12.12	11.78	12.03	24052.0
2006-06-23	ABP-DELISTED	Stock	4.55	4.7	4.25	4.27	656000.0
2006-06-23	ABR	Stock	24.01	24.33	23.95	24.29	90400.0
2006-06-23	ABT	Stock	20.0316	20.2476	19.9405	20.1276	8215298.0
2006-06-23	ABTL-DELISTED	Stock	14.925	15.324	14.875	15.025	76367.0
2006-06-23	ABV-DELISTED	Stock	38.15	38.75	37.83	38.07	312500.0
2006-06-23	ABVA-DELISTED	Stock	16.9	16.9	16.9	16.9	100.0
2006-06-23	ABX-DELISTED	Stock	27.6	28.33	27.36	28.2	3057800.0
2006-06-23	ACAD	Stock	8.12	8.22	7.96	7.97	198800.0
2006-06-23	ACAP-DELISTED	Stock	47.55	47.9	46.75	47.8	59810.0
2006-06-23	ACAS-DELISTED	Stock	32.94	33.0	32.7	32.89	552815.0
2006-06-23	ACAT-DELISTED	Stock	17.63	17.63	17.25	17.48	36333.0
2006-06-23	ACC-DELISTED	Stock	24.35	24.93	24.11	24.17	90800.0
2006-06-23	ACCL-DELISTED	Stock	7.06	7.21	7.06	7.21	66860.0
2006-06-23	ACCO	Stock	21.91	22.02	21.64	21.82	242900.0
2006-06-23	ACCP-DELISTED	Stock	1.45	1.46	1.3	1.35	14175.0

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

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