PREVIEW / stock_daily / 2006-06-26

all stock daily files

  file:    by_date/stock_daily/2006/2006-06-26.parquet
  size:    148 KB
  rows:    4,446
  symbols: 2,800

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-26	AAPL	Stock	2.1132	2.1143	2.0846	2.1068	466536000.0
2006-06-26	MSFT	Stock	22.65	22.89	22.63	22.82	53644100.0
2006-06-26	NVDA	Stock	0.338	0.3417	0.3337	0.3353	281736000.0
2006-06-26	AMZN	Stock	1.8275	1.8585	1.8215	1.8385	72116000.0
2006-06-26	CL	Stock	30.03	30.22	29.965	30.105	4068000.0
2006-06-26	A	Stock	22.3891	22.5608	22.2175	22.4893	3932434.0
2006-06-26	AABA-DELISTED	Stock	31.4500007629395	31.7000007629395	31.1599998474121	31.5499992370605	11457000.0
2006-06-26	AACC-DELISTED	Stock	19.36	19.75	19.34	19.5	240241.0
2006-06-26	AACQU-DELISTED	Stock	6.2	6.2	6.2	6.2	5000.0
2006-06-26	AAI-DELISTED	Stock	14.62	14.69	14.21	14.4	764900.0
2006-06-26	AAIC-DELISTED	Stock	220.6	231.4	219.0	230.4	2170900.0
2006-06-26	AAME	Stock	2.89	3.3	2.89	3.05	47200.0
2006-06-26	AAON	Stock	2.7984	2.8998	2.7984	2.8945	234647.0
2006-06-26	AAP	Stock	37.62	38.12	37.11	37.29	661000.0
2006-06-26	AATI-DELISTED	Stock	9.95	10.05	9.9	9.95	132436.0
2006-06-26	AAU-DELISTED	Stock	2.25	2.26	2.2	2.24	29200.0
2006-06-26	AAUAF-DELISTED	Stock	2.25	2.26	2.2	2.24	29200.0
2006-06-26	AAV-DELISTED	Stock	17.89	17.92	17.66	17.7	327100.0
2006-06-26	AAWW-DELISTED	Stock	50.23	50.23	49.85	50.0	102794.0
2006-06-26	AAXN-DELISTED	Stock	8.15999984741211	8.15999984741211	8.0	8.07999992370605	302400.0
2006-06-26	AB	Stock	58.05	58.26	56.99	58.09	296800.0
2006-06-26	ABAX-DELISTED	Stock	20.64	21.0	20.64	21.0	155041.0
2006-06-26	ABB-DELISTED	Stock	12.21	12.37	12.18	12.35	1266700.0
2006-06-26	ABBC-DELISTED	Stock	15.58	15.68	15.57	15.68	17395.0
2006-06-26	ABC-DELISTED	Stock	20.54	20.76	20.54	20.66	1796800.0
2006-06-26	ABCB	Stock	20.2796	21.2036	19.9586	21.0966	29404.0
2006-06-26	ABCO-DELISTED	Stock	23.75	24.03	23.64	24.0	168158.0
2006-06-26	ABCW-DELISTED	Stock	28.6	29.37	28.47	29.36	65410.0
2006-06-26	ABD-DELISTED	Stock	21.81	21.85	21.45	21.49	338400.0
2006-06-26	ABE-DELISTED	Stock	11.52	11.85	11.52	11.76	5200.0
2006-06-26	ABFS-DELISTED	Stock	47.22	47.22	45.75	46.73	497996.0
2006-06-26	ABG	Stock	20.51	20.89	20.43	20.53	70700.0
2006-06-26	ABK-DELISTED	Stock	79.47	80.82	79.42	80.7	753300.0
2006-06-26	ABM	Stock	17.5	17.59	17.3	17.56	143800.0
2006-06-26	ABMD-DELISTED	Stock	12.14	12.25	11.87	12.24	27947.0
2006-06-26	ABP-DELISTED	Stock	4.29	4.35	4.2	4.24	218000.0
2006-06-26	ABR	Stock	24.4	24.6	24.23	24.58	72800.0
2006-06-26	ABT	Stock	20.1036	20.2428	19.9453	20.166	6393706.0
2006-06-26	ABTL-DELISTED	Stock	14.975	15.624	14.925	15.275	50309.0
2006-06-26	ABV-DELISTED	Stock	38.08	38.21	37.49	37.89	200300.0
2006-06-26	ABVA-DELISTED	Stock	16.76	16.9	16.76	16.81	850.0
2006-06-26	ABVT-DELISTED	Stock	45.0	45.0	45.0	45.0	1300.0
2006-06-26	ABX-DELISTED	Stock	28.3	28.42	27.95	28.36	2061700.0
2006-06-26	ACAD	Stock	7.97	8.27	7.96	8.17	176700.0
2006-06-26	ACAP-DELISTED	Stock	47.86	48.41	47.45	48.3	41176.0
2006-06-26	ACAS-DELISTED	Stock	32.9	33.11	32.85	33.09	523998.0
2006-06-26	ACAT-DELISTED	Stock	17.61	18.56	17.58	18.52	63847.0
2006-06-26	ACC-DELISTED	Stock	24.3	24.7	24.25	24.5	23200.0
2006-06-26	ACCL-DELISTED	Stock	7.21	7.21	7.12	7.17	48752.0
2006-06-26	ACCO	Stock	21.81	21.85	21.45	21.49	350700.0

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

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