PREVIEW / stock_daily / 2006-02-09

all stock daily files

  file:    by_date/stock_daily/2006/2006-02-09.parquet
  size:    146 KB
  rows:    4,359
  symbols: 2,765

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-09	AAPL	Stock	2.4679	2.4725	2.3046	2.3196	1149764000.0
2006-02-09	MSFT	Stock	26.96	27.03	26.65	26.66	52861700.0
2006-02-09	NVDA	Stock	0.3754	0.3812	0.3656	0.3679	437100000.0
2006-02-09	AMZN	Stock	1.9305	1.95	1.8965	1.8995	138656000.0
2006-02-09	CL	Stock	26.84	27.135	26.82	26.88	3074400.0
2006-02-09	A	Stock	25.0	25.3219	25.0	25.1288	6363137.0
2006-02-09	AABA-DELISTED	Stock	33.0099983215332	33.3600006103516	32.4000015258789	32.5	25335200.0
2006-02-09	AACC-DELISTED	Stock	18.0	18.78	17.9572	18.35	441418.0
2006-02-09	AACQW-DELISTED	Stock	0.67	0.68	0.67	0.68	34000.0
2006-02-09	AAI-DELISTED	Stock	16.97	17.2	16.75	17.06	1007100.0
2006-02-09	AAIC-DELISTED	Stock	219.0	221.6	217.0	220.0	763000.0
2006-02-09	AAME	Stock	2.82	2.85	2.82	2.85	1800.0
2006-02-09	AAON	Stock	2.6574	2.6574	2.6008	2.6456	231609.0
2006-02-09	AAP	Stock	43.18	43.85	43.07	43.51	656900.0
2006-02-09	AATI-DELISTED	Stock	14.6	14.6	14.3	14.36	357159.0
2006-02-09	AAU-DELISTED	Stock	2.8	3.0	2.8	2.88	64700.0
2006-02-09	AAUAF-DELISTED	Stock	2.8	3.0	2.8	2.88	64700.0
2006-02-09	AAV-DELISTED	Stock	20.52	20.69	20.01	20.09	385900.0
2006-02-09	AAWW-DELISTED	Stock	47.5	48.25	47.5	48.25	300.0
2006-02-09	AAXN-DELISTED	Stock	9.14999961853027	9.64999961853027	9.14999961853027	9.48999977111816	2039400.0
2006-02-09	ABAX-DELISTED	Stock	20.77	21.21	20.68	20.93	274637.0
2006-02-09	ABB-DELISTED	Stock	10.73	10.83	10.7	10.7	1699600.0
2006-02-09	ABBC-DELISTED	Stock	13.25	13.35	13.25	13.3	156350.0
2006-02-09	ABC-DELISTED	Stock	21.75	21.82	21.54	21.64	3295400.0
2006-02-09	ABCB	Stock	19.5987	19.8419	19.4723	19.5015	16553.0
2006-02-09	ABCO-DELISTED	Stock	27.06	27.37	26.7	26.87	406496.0
2006-02-09	ABCW-DELISTED	Stock	30.87	31.18	30.6	30.6	20180.0
2006-02-09	ABD-DELISTED	Stock	23.55	23.66	23.5	23.52	300700.0
2006-02-09	ABE-DELISTED	Stock	12.63	12.74	12.6	12.668	16100.0
2006-02-09	ABFS-DELISTED	Stock	42.75	43.09	42.05	42.09	253442.0
2006-02-09	ABG	Stock	18.12	18.61	18.12	18.44	55100.0
2006-02-09	ABK-DELISTED	Stock	75.85	75.97	74.91	74.94	738000.0
2006-02-09	ABM	Stock	19.11	19.14	18.91	18.96	140600.0
2006-02-09	ABMD-DELISTED	Stock	10.33	10.4	10.1	10.13	33033.0
2006-02-09	ABP-DELISTED	Stock	6.7	6.75	6.45	6.59	556400.0
2006-02-09	ABR	Stock	25.25	25.57	24.97	25.01	77300.0
2006-02-09	ABT	Stock	20.2476	20.5546	20.0556	20.2236	10149437.0
2006-02-09	ABTL-DELISTED	Stock	24.75	24.95	24.45	24.8	45741.0
2006-02-09	ABV-DELISTED	Stock	40.3	40.98	40.21	40.74	538400.0
2006-02-09	ABVA-DELISTED	Stock	17.3495	17.35	17.3	17.35	108000.0
2006-02-09	ABX-DELISTED	Stock	29.4	29.56	28.74	28.82	4810300.0
2006-02-09	ACAD	Stock	13.98	14.38	13.87	14.01	421300.0
2006-02-09	ACAP-DELISTED	Stock	47.73	48.33	47.64	47.67	43427.0
2006-02-09	ACAS-DELISTED	Stock	36.19	36.49	36.05	36.24	968296.0
2006-02-09	ACAT-DELISTED	Stock	23.52	24.85	23.5	24.22	168645.0
2006-02-09	ACC-DELISTED	Stock	24.72	24.87	24.42	24.46	20400.0
2006-02-09	ACCL-DELISTED	Stock	6.35	6.41	6.29	6.3	53725.0
2006-02-09	ACCO	Stock	23.55	23.66	23.5	23.52	318900.0
2006-02-09	ACCP-DELISTED	Stock	1.2	1.2	1.0	1.0	35100.0
2006-02-09	ACE-DELISTED	Stock	53.1	53.25	52.48	52.49	1697500.0

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

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