PREVIEW / stock_daily / 2006-03-23

all stock daily files

  file:    by_date/stock_daily/2006/2006-03-23.parquet
  size:    146 KB
  rows:    4,352
  symbols: 2,745

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-03-23	AAPL	Stock	2.2079	2.2107	2.1289	2.1486	1427826400.0
2006-03-23	MSFT	Stock	27.08	27.1	26.66	26.85	73682900.0
2006-03-23	NVDA	Stock	0.4125	0.4204	0.4078	0.4187	661992000.0
2006-03-23	AMZN	Stock	1.798	1.817	1.774	1.784	80718000.0
2006-03-23	CL	Stock	28.9	28.925	28.45	28.67	3403400.0
2006-03-23	A	Stock	26.5737	26.7167	26.2303	26.6094	2907001.0
2006-03-23	AABA-DELISTED	Stock	31.5200004577637	31.9500007629395	31.4799995422363	31.8299999237061	33834000.0
2006-03-23	AACC-DELISTED	Stock	19.43	19.57	19.0	19.14	117751.0
2006-03-23	AACQW-DELISTED	Stock	0.78	0.78	0.75	0.75	70330.0
2006-03-23	AAI-DELISTED	Stock	18.44	18.85	17.7	17.78	1541000.0
2006-03-23	AAIC-DELISTED	Stock	185.4	188.0	184.162	186.8	833400.0
2006-03-23	AAME	Stock	2.9	2.9	2.9	2.9	200.0
2006-03-23	AAON	Stock	2.9616	2.9867	2.9261	2.9761	21262.0
2006-03-23	AAP	Stock	41.54	41.98	41.53	41.84	503700.0
2006-03-23	AATI-DELISTED	Stock	11.0	11.05	10.6704	10.75	339283.0
2006-03-23	AAU-DELISTED	Stock	2.58	2.59	2.54	2.55	40600.0
2006-03-23	AAUAF-DELISTED	Stock	2.58	2.59	2.54	2.55	40600.0
2006-03-23	AAV-DELISTED	Stock	19.05	19.4	18.97	19.35	228800.0
2006-03-23	AAWW-DELISTED	Stock	47.25	47.75	47.25	47.25	27800.0
2006-03-23	AAXN-DELISTED	Stock	11.0	11.2399997711182	10.710000038147	10.8800001144409	3423200.0
2006-03-23	AB	Stock	64.83	64.9	64.53	64.7	177000.0
2006-03-23	ABAX-DELISTED	Stock	24.25	24.46	22.77	23.47	444191.0
2006-03-23	ABB-DELISTED	Stock	11.98	11.989	11.82	11.8599	1398000.0
2006-03-23	ABBC-DELISTED	Stock	13.4	13.45	13.4	13.4	2010.0
2006-03-23	ABC-DELISTED	Stock	23.78	23.82	23.48	23.55	1501000.0
2006-03-23	ABCB	Stock	22.0206	22.1276	21.6413	21.9428	24572.0
2006-03-23	ABCO-DELISTED	Stock	28.51	28.63	27.79	28.13	136723.0
2006-03-23	ABCW-DELISTED	Stock	29.52	29.58	29.23	29.34	38880.0
2006-03-23	ABD-DELISTED	Stock	22.15	22.15	21.91	21.99	139300.0
2006-03-23	ABE-DELISTED	Stock	12.75	12.79	12.668	12.7	13300.0
2006-03-23	ABFS-DELISTED	Stock	40.51	40.79	39.7	40.42	1177178.0
2006-03-23	ABG	Stock	20.35	20.49	19.8	20.22	65900.0
2006-03-23	ABK-DELISTED	Stock	80.0	80.0	79.25	79.5	351500.0
2006-03-23	ABM	Stock	17.5	17.58	17.31	17.54	146100.0
2006-03-23	ABMD-DELISTED	Stock	12.0	12.97	11.94	12.79	233617.0
2006-03-23	ABP-DELISTED	Stock	5.8	5.88	5.69	5.84	341200.0
2006-03-23	ABR	Stock	27.0	27.23	26.75	27.2	115400.0
2006-03-23	ABT	Stock	21.0152	21.1688	20.7082	21.0536	8978324.0
2006-03-23	ABTL-DELISTED	Stock	22.65	23.15	22.65	23.0	34411.0
2006-03-23	ABV-DELISTED	Stock	42.8	43.18	41.76	41.85	700700.0
2006-03-23	ABX-DELISTED	Stock	25.63	25.91	25.46	25.75	5300900.0
2006-03-23	ACAD	Stock	15.51	15.74	15.25	15.58	326400.0
2006-03-23	ACAP-DELISTED	Stock	49.18	49.27	48.46	48.9	15173.0
2006-03-23	ACAS-DELISTED	Stock	35.58	35.58	34.79	34.93	881429.0
2006-03-23	ACAT-DELISTED	Stock	23.27	23.93	23.27	23.77	27153.0
2006-03-23	ACC-DELISTED	Stock	26.27	26.87	26.02	26.83	77644.0
2006-03-23	ACCL-DELISTED	Stock	7.29	7.65	7.21	7.42	77658.0
2006-03-23	ACCO	Stock	22.15	22.15	21.91	21.99	140800.0
2006-03-23	ACCP-DELISTED	Stock	1.75	1.75	1.5	1.5	7625.0
2006-03-23	ACE-DELISTED	Stock	55.25	55.25	54.44	54.48	967800.0

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

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