PREVIEW / stock_daily / 2006-02-23

all stock daily files

  file:    by_date/stock_daily/2006/2006-02-23.parquet
  size:    146 KB
  rows:    4,365
  symbols: 2,762

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-02-23	AAPL	Stock	2.5639	2.6071	2.5511	2.5625	856917600.0
2006-02-23	MSFT	Stock	26.73	26.89	26.54	26.66	47359100.0
2006-02-23	NVDA	Stock	0.3853	0.3879	0.3795	0.3806	385128000.0
2006-02-23	AMZN	Stock	1.931	1.9375	1.8935	1.895	185750000.0
2006-02-23	CL	Stock	27.175	27.495	27.125	27.325	2954600.0
2006-02-23	A	Stock	25.3934	25.9657	25.372	25.7511	7033618.0
2006-02-23	AABA-DELISTED	Stock	33.0099983215332	33.6599998474121	32.8800010681152	33.1500015258789	14947600.0
2006-02-23	AACC-DELISTED	Stock	17.25	18.84	17.23	18.66	461412.0
2006-02-23	AACQ-DELISTED	Stock	5.35	5.35	5.35	5.35	72000.0
2006-02-23	AACQU-DELISTED	Stock	6.6	6.6	6.6	6.6	1000.0
2006-02-23	AAI-DELISTED	Stock	17.97	18.31	17.73	17.8	1064000.0
2006-02-23	AAIC-DELISTED	Stock	212.4	213.4	202.0	210.0	2644100.0
2006-02-23	AAON	Stock	2.8958	2.9156	2.8405	2.8471	779119.0
2006-02-23	AAP	Stock	41.1	41.96	40.81	41.33	1182900.0
2006-02-23	AATI-DELISTED	Stock	12.67	12.7	12.18	12.56	344769.0
2006-02-23	AAU-DELISTED	Stock	2.86	2.95	2.82	2.86	42100.0
2006-02-23	AAUAF-DELISTED	Stock	2.86	2.95	2.82	2.86	42100.0
2006-02-23	AAV-DELISTED	Stock	19.91	20.4	19.75	20.25	455700.0
2006-02-23	AAWW-DELISTED	Stock	46.0	49.0	46.0	47.5	35300.0
2006-02-23	AAXN-DELISTED	Stock	10.1499996185303	10.4200000762939	9.89999961853027	10.1099996566772	1931200.0
2006-02-23	ABAX-DELISTED	Stock	20.8	21.53	20.57	21.3	152979.0
2006-02-23	ABB-DELISTED	Stock	11.91	11.95	11.84	11.87	1470800.0
2006-02-23	ABBC-DELISTED	Stock	13.3	13.34	13.3	13.32	5756.0
2006-02-23	ABC-DELISTED	Stock	22.55	23.15	22.52	23.01	3136000.0
2006-02-23	ABCB	Stock	21.3592	22.1276	21.3592	21.8844	26320.0
2006-02-23	ABCO-DELISTED	Stock	27.0	27.0	26.73	26.95	157686.0
2006-02-23	ABCW-DELISTED	Stock	31.55	31.55	31.12	31.12	33730.0
2006-02-23	ABD-DELISTED	Stock	23.54	23.88	23.37	23.59	316700.0
2006-02-23	ABE-DELISTED	Stock	13.14	13.18	13.1	13.14	21800.0
2006-02-23	ABFS-DELISTED	Stock	42.7	43.0	42.3	42.89	267749.0
2006-02-23	ABG	Stock	19.6	20.0	19.5	19.94	96700.0
2006-02-23	ABK-DELISTED	Stock	75.85	75.97	75.29	75.74	341800.0
2006-02-23	ABM	Stock	18.71	18.84	18.56	18.57	162800.0
2006-02-23	ABMD-DELISTED	Stock	10.66	10.9	10.54	10.69	71226.0
2006-02-23	ABP-DELISTED	Stock	6.11	6.11	5.9	5.93	311800.0
2006-02-23	ABR	Stock	26.93	26.95	26.7	26.84	66000.0
2006-02-23	ABT	Stock	20.9912	21.0392	20.7753	20.8377	9850354.0
2006-02-23	ABTL-DELISTED	Stock	23.15	23.75	23.0	23.75	28251.0
2006-02-23	ABV-DELISTED	Stock	43.41	43.54	42.48	42.51	757800.0
2006-02-23	ABVT-DELISTED	Stock	33.0	33.0	33.0	33.0	1900.0
2006-02-23	ABX-DELISTED	Stock	28.94	28.95	27.23	27.41	7083200.0
2006-02-23	ACAD	Stock	14.7	14.81	14.11	14.74	205000.0
2006-02-23	ACAP-DELISTED	Stock	48.9	49.79	48.79	48.92	31139.0
2006-02-23	ACAS-DELISTED	Stock	37.75	37.8	37.05	37.2	1270529.0
2006-02-23	ACAT-DELISTED	Stock	24.06	24.27	23.87	24.23	33825.0
2006-02-23	ACC-DELISTED	Stock	24.82	25.26	24.61	25.15	65925.0
2006-02-23	ACCL-DELISTED	Stock	6.18	6.18	6.0	6.1	81213.0
2006-02-23	ACCO	Stock	23.54	23.88	23.37	23.59	316700.0
2006-02-23	ACCP-DELISTED	Stock	1.0	1.15	1.0	1.15	40600.0
2006-02-23	ACE-DELISTED	Stock	56.15	56.27	55.22	55.88	1274500.0

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

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