PREVIEW / stock_daily / 2006-10-02

all stock daily files

  file:    by_date/stock_daily/2006/2006-10-02.parquet
  size:    151 KB
  rows:    4,516
  symbols: 2,853

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-10-02	AAPL	Stock	2.6821	2.7096	2.6536	2.6736	712639200.0
2006-10-02	MSFT	Stock	27.32	27.49	27.15	27.36	52908100.0
2006-10-02	NVDA	Stock	0.4908	0.494	0.4767	0.4807	647442000.0
2006-10-02	AMZN	Stock	1.599	1.6015	1.5415	1.5435	136300000.0
2006-10-02	CL	Stock	31.15	31.245	30.875	31.205	2727600.0
2006-10-02	A	Stock	23.2475	23.4478	22.9757	23.1187	3959136.0
2006-10-02	AABA-DELISTED	Stock	25.4500007629395	25.4599990844727	24.75	24.8799991607666	19641300.0
2006-10-02	AACC-DELISTED	Stock	16.2	16.37	16.05	16.26	184916.0
2006-10-02	AACQ-DELISTED	Stock	5.34	5.4	5.34	5.4	39000.0
2006-10-02	AACQU-DELISTED	Stock	6.2	6.2	6.2	6.2	1500.0
2006-10-02	AACQW-DELISTED	Stock	0.44	0.44	0.44	0.44	18800.0
2006-10-02	AAI-DELISTED	Stock	9.98	10.13	9.85	10.0	1761800.0
2006-10-02	AAIC-DELISTED	Stock	160.6	160.6	156.0	158.0	1102800.0
2006-10-02	AAME	Stock	2.53	2.53	2.51	2.51	200.0
2006-10-02	AAON	Stock	3.038	3.0683	2.9946	3.017	175416.0
2006-10-02	AAP	Stock	33.0	33.75	32.95	33.39	637200.0
2006-10-02	AATI-DELISTED	Stock	5.5	5.5	5.2	5.21	293251.0
2006-10-02	AAU-DELISTED	Stock	2.31	2.32	2.2401	2.25	32500.0
2006-10-02	AAUAF-DELISTED	Stock	2.31	2.32	2.2401	2.25	32500.0
2006-10-02	AAV-DELISTED	Stock	12.4	12.4	11.96	11.96	721600.0
2006-10-02	AAWW-DELISTED	Stock	43.6	43.98	43.07	43.53	55119.0
2006-10-02	AAXN-DELISTED	Stock	7.59999990463257	7.80000019073486	7.46000003814697	7.53999996185303	867500.0
2006-10-02	AB	Stock	69.19	69.19	68.33	68.99	159800.0
2006-10-02	ABAX-DELISTED	Stock	23.43	23.48	22.8384	23.07	171047.0
2006-10-02	ABB-DELISTED	Stock	13.07	13.24	13.021	13.18	1817800.0
2006-10-02	ABBC-DELISTED	Stock	15.03	15.05	14.89	14.9	3549.0
2006-10-02	ABC-DELISTED	Stock	22.69	22.82	22.54	22.62	1655400.0
2006-10-02	ABCB	Stock	26.3197	26.3197	24.9482	25.1914	23338.0
2006-10-02	ABCO-DELISTED	Stock	25.2	25.32	24.73	25.23	216734.0
2006-10-02	ABCW-DELISTED	Stock	28.57	28.6	28.44	28.48	53480.0
2006-10-02	ABD-DELISTED	Stock	22.26	22.45	21.96	22.21	308210.0
2006-10-02	ABE-DELISTED	Stock	14.39	14.66	14.34	14.49	26500.0
2006-10-02	ABFS-DELISTED	Stock	43.06	43.06	42.3	42.39	447179.0
2006-10-02	ABG	Stock	20.65	20.84	20.65	20.74	374000.0
2006-10-02	ABK-DELISTED	Stock	83.3	83.3	82.2	82.83	1047500.0
2006-10-02	ABM	Stock	18.73	18.92	18.69	18.71	174700.0
2006-10-02	ABMD-DELISTED	Stock	14.77	14.85	14.6	14.75	72229.0
2006-10-02	ABP-DELISTED	Stock	3.07	3.17	3.07	3.08	200200.0
2006-10-02	ABR	Stock	25.56	25.6	25.07	25.12	131400.0
2006-10-02	ABT	Stock	22.9104	23.3663	22.9104	23.1456	7398916.0
2006-10-02	ABTL-DELISTED	Stock	14.304	14.549	14.255	14.5	4373.0
2006-10-02	ABV-DELISTED	Stock	45.66	46.0	45.15	45.73	281200.0
2006-10-02	ABVA-DELISTED	Stock	17.03	17.04	16.7623	16.9	3200.0
2006-10-02	ABVT-DELISTED	Stock	53.75	53.75	53.75	53.75	103.0
2006-10-02	ABX-DELISTED	Stock	30.9	31.35	30.74	30.86	2598134.0
2006-10-02	ACAD	Stock	8.6	8.66	8.12	8.34	122000.0
2006-10-02	ACAP-DELISTED	Stock	48.25	49.33	47.53	49.3	27016.0
2006-10-02	ACAS-DELISTED	Stock	39.5	39.65	39.17	39.48	599504.0
2006-10-02	ACAT-DELISTED	Stock	16.6	16.69	16.18	16.45	121485.0
2006-10-02	ACC-DELISTED	Stock	25.5	25.5	25.15	25.16	120800.0

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

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