PREVIEW / stock_daily / 2006-03-15

all stock daily files

  file:    by_date/stock_daily/2006/2006-03-15.parquet
  size:    146 KB
  rows:    4,344
  symbols: 2,735

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-15	AAPL	Stock	2.4182	2.43	2.34	2.3654	891996000.0
2006-03-15	MSFT	Stock	27.2	27.45	27.01	27.36	57152000.0
2006-03-15	NVDA	Stock	0.4116	0.4179	0.41	0.4173	510600000.0
2006-03-15	AMZN	Stock	1.8475	1.85	1.8215	1.8445	56030000.0
2006-03-15	CL	Stock	28.325	28.585	28.29	28.335	4101400.0
2006-03-15	A	Stock	26.2232	26.8884	26.0515	26.8455	5612411.0
2006-03-15	AABA-DELISTED	Stock	31.25	31.2800006866455	30.4699993133545	30.5300006866455	20758000.0
2006-03-15	AACC-DELISTED	Stock	19.91	19.99	19.58	19.78	117970.0
2006-03-15	AACQ-DELISTED	Stock	5.39	5.39	5.39	5.39	7000.0
2006-03-15	AACQU-DELISTED	Stock	6.8	6.8	6.8	6.8	10000.0
2006-03-15	AACQW-DELISTED	Stock	0.74	0.75	0.71	0.75	233200.0
2006-03-15	AAI-DELISTED	Stock	17.31	17.71	17.27	17.63	1134700.0
2006-03-15	AAIC-DELISTED	Stock	188.4	189.2	186.8	187.4	1000400.0
2006-03-15	AAON	Stock	3.0235	3.0235	2.9498	2.9511	100237.0
2006-03-15	AAP	Stock	41.36	41.99	41.22	41.9	1016400.0
2006-03-15	AATI-DELISTED	Stock	12.07	12.24	11.76	11.9	233984.0
2006-03-15	AAU-DELISTED	Stock	2.6	2.6	2.55	2.57	74300.0
2006-03-15	AAUAF-DELISTED	Stock	2.6	2.6	2.55	2.57	74300.0
2006-03-15	AAV-DELISTED	Stock	19.49	19.75	19.35	19.6	220200.0
2006-03-15	AAWW-DELISTED	Stock	46.75	48.0	46.75	48.0	24600.0
2006-03-15	AAXN-DELISTED	Stock	9.72000026702881	10.4200000762939	9.67000007629395	10.3599996566772	3322700.0
2006-03-15	AB	Stock	64.95	65.77	64.67	65.41	226700.0
2006-03-15	ABAX-DELISTED	Stock	20.4	21.13	20.3316	20.9	293388.0
2006-03-15	ABB-DELISTED	Stock	12.37	12.38	12.23	12.38	1057500.0
2006-03-15	ABBC-DELISTED	Stock	13.3	13.3	13.3	13.3	15437.0
2006-03-15	ABC-DELISTED	Stock	23.16	23.5	23.13	23.48	2913800.0
2006-03-15	ABCB	Stock	21.9526	22.2346	21.9137	22.0692	16553.0
2006-03-15	ABCO-DELISTED	Stock	26.43	27.04	26.43	26.94	132168.0
2006-03-15	ABCW-DELISTED	Stock	30.42	30.42	30.0	30.2	33100.0
2006-03-15	ABD-DELISTED	Stock	21.98	22.06	21.91	21.93	77200.0
2006-03-15	ABE-DELISTED	Stock	12.54	12.67	12.48	12.65	45100.0
2006-03-15	ABFS-DELISTED	Stock	42.3	42.73	41.86	42.57	437719.0
2006-03-15	ABG	Stock	19.74	20.39	19.54	20.16	208500.0
2006-03-15	ABK-DELISTED	Stock	79.87	80.36	78.86	80.33	568100.0
2006-03-15	ABM	Stock	17.06	17.47	16.87	17.42	289400.0
2006-03-15	ABMD-DELISTED	Stock	10.7	10.95	10.57	10.94	57267.0
2006-03-15	ABP-DELISTED	Stock	5.88	5.98	5.7	5.85	358600.0
2006-03-15	ABR	Stock	26.55	26.95	26.5	26.77	95800.0
2006-03-15	ABT	Stock	21.591	21.7781	21.3511	21.711	8165486.0
2006-03-15	ABTL-DELISTED	Stock	20.45	20.55	20.05	20.25	15733.0
2006-03-15	ABV-DELISTED	Stock	42.82	44.37	42.78	44.36	597600.0
2006-03-15	ABVA-DELISTED	Stock	18.662	18.738	18.64	18.738	1719.0
2006-03-15	ABX-DELISTED	Stock	26.66	26.86	26.24	26.64	4362287.0
2006-03-15	ACAD	Stock	16.35	17.1	16.31	16.86	754200.0
2006-03-15	ACAP-DELISTED	Stock	49.7	51.06	49.65	50.64	34200.0
2006-03-15	ACAS-DELISTED	Stock	35.94	36.22	35.82	36.16	889564.0
2006-03-15	ACAT-DELISTED	Stock	22.98	23.27	22.858	23.26	79098.0
2006-03-15	ACC-DELISTED	Stock	26.46	27.15	26.21	27.15	49046.0
2006-03-15	ACCL-DELISTED	Stock	7.15	7.17	7.1	7.15	55497.0
2006-03-15	ACCO	Stock	21.99	22.07	21.91	21.92	78300.0

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

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