PREVIEW / stock_daily / 2006-02-27

all stock daily files

  file:    by_date/stock_daily/2006/2006-02-27.parquet
  size:    146 KB
  rows:    4,369
  symbols: 2,770

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-27	AAPL	Stock	2.5711	2.5757	2.5232	2.5354	791240800.0
2006-02-27	MSFT	Stock	26.75	27.26	26.67	27.05	51301500.0
2006-02-27	NVDA	Stock	0.3834	0.3983	0.3794	0.3959	666468000.0
2006-02-27	AMZN	Stock	1.92	1.939	1.8965	1.9005	88982000.0
2006-02-27	CL	Stock	27.185	27.765	27.15	27.715	3451800.0
2006-02-27	A	Stock	25.6438	26.2804	25.6438	26.1731	4910335.0
2006-02-27	AABA-DELISTED	Stock	33.1100006103516	33.2099990844727	32.5699996948242	32.7400016784668	11821900.0
2006-02-27	AACC-DELISTED	Stock	19.21	19.88	19.1	19.74	234867.0
2006-02-27	AACQ-DELISTED	Stock	5.35	5.4	5.35	5.4	7000.0
2006-02-27	AAI-DELISTED	Stock	17.94	18.29	17.8	18.16	1005600.0
2006-02-27	AAIC-DELISTED	Stock	207.8	210.0	204.2	207.4	1020300.0
2006-02-27	AAME	Stock	2.7	2.7	2.7	2.7	1100.0
2006-02-27	AAON	Stock	2.8971	2.9182	2.8668	2.8971	300712.0
2006-02-27	AAP	Stock	41.5	41.94	41.41	41.64	830900.0
2006-02-27	AATI-DELISTED	Stock	12.36	12.47	12.1	12.24	341953.0
2006-02-27	AAU-DELISTED	Stock	3.0	3.03	2.93	2.96	42200.0
2006-02-27	AAUAF-DELISTED	Stock	3.0	3.03	2.93	2.96	42200.0
2006-02-27	AAV-DELISTED	Stock	19.9	19.96	19.5	19.75	365900.0
2006-02-27	AAWW-DELISTED	Stock	47.5	47.5	47.48	47.48	13200.0
2006-02-27	AAXN-DELISTED	Stock	10.0	10.0900001525879	9.86999988555908	9.93000030517578	1663800.0
2006-02-27	ABAX-DELISTED	Stock	21.66	22.73	20.95	22.66	414345.0
2006-02-27	ABB-DELISTED	Stock	12.42	12.58	12.34	12.51	4096700.0
2006-02-27	ABBC-DELISTED	Stock	13.34	13.34	13.31	13.31	3975.0
2006-02-27	ABC-DELISTED	Stock	22.98	23.4	22.98	23.35	2353600.0
2006-02-27	ABCB	Stock	22.3708	22.8571	21.9817	22.6528	34956.0
2006-02-27	ABCO-DELISTED	Stock	27.03	27.66	26.83	27.54	141551.0
2006-02-27	ABCW-DELISTED	Stock	31.37	31.47	31.1	31.16	25800.0
2006-02-27	ABD-DELISTED	Stock	23.84	24.25	23.74	24.23	157290.0
2006-02-27	ABE-DELISTED	Stock	13.2	13.26	13.2	13.25	26800.0
2006-02-27	ABFS-DELISTED	Stock	42.41	43.05	42.35	42.57	429919.0
2006-02-27	ABG	Stock	19.85	19.88	19.39	19.55	141600.0
2006-02-27	ABK-DELISTED	Stock	75.7	76.31	75.68	75.8	345200.0
2006-02-27	ABM	Stock	18.65	18.91	18.65	18.81	145100.0
2006-02-27	ABMD-DELISTED	Stock	10.73	10.83	10.56	10.82	64657.0
2006-02-27	ABP-DELISTED	Stock	6.07	6.19	5.9	5.91	367100.0
2006-02-27	ABR	Stock	26.5	26.75	26.32	26.5	75900.0
2006-02-27	ABT	Stock	21.0344	21.4998	21.0296	21.3271	8704252.0
2006-02-27	ABTL-DELISTED	Stock	23.35	23.85	23.35	23.65	65942.0
2006-02-27	ABV-DELISTED	Stock	42.38	43.11	42.38	42.78	210000.0
2006-02-27	ABVA-DELISTED	Stock	18.489	18.802	18.425	18.761	2453.0
2006-02-27	ABVT-DELISTED	Stock	38.0	38.0	38.0	38.0	1200.0
2006-02-27	ABX-DELISTED	Stock	27.83	27.83	27.31	27.37	3782900.0
2006-02-27	ACAD	Stock	14.7	14.75	14.5	14.73	266700.0
2006-02-27	ACAP-DELISTED	Stock	48.8	49.46	48.57	49.07	34913.0
2006-02-27	ACAS-DELISTED	Stock	36.39	36.8	36.04	36.2	897938.0
2006-02-27	ACAT-DELISTED	Stock	24.75	25.75	24.54	24.58	110431.0
2006-02-27	ACC-DELISTED	Stock	25.58	25.67	25.38	25.63	36700.0
2006-02-27	ACCL-DELISTED	Stock	6.34	6.48	6.17	6.22	87176.0
2006-02-27	ACCO	Stock	23.83	24.24	23.73	24.24	157400.0
2006-02-27	ACCP-DELISTED	Stock	1.2	1.2	1.05	1.2	157965.0

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

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