PREVIEW / stock_daily / 2005-09-02

all stock daily files

  file:    by_date/stock_daily/2005/2005-09-02.parquet
  size:    139 KB
  rows:    4,165
  symbols: 2,611

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
2005-09-02	AAPL	Stock	1.6536	1.6714	1.6471	1.6507	222378800.0
2005-09-02	MSFT	Stock	27.21	27.27	26.97	27.02	52047500.0
2005-09-02	NVDA	Stock	0.2562	0.2562	0.2507	0.2516	469800000.0
2005-09-02	AMZN	Stock	2.1	2.1025	2.052	2.0755	80542000.0
2005-09-02	CL	Stock	26.35	26.35	26.125	26.245	2467600.0
2005-09-02	A	Stock	23.0973	23.176	22.9256	22.99	2614679.0
2005-09-02	AABA-DELISTED	Stock	33.2000007629395	33.3699989318848	33.0999984741211	33.1699981689453	6849000.0
2005-09-02	AACC-DELISTED	Stock	28.47	28.47	27.94	28.15	102171.0
2005-09-02	AAI-DELISTED	Stock	9.77	10.04	9.77	9.95	1321500.0
2005-09-02	AAIC-DELISTED	Stock	239.6	240.98	233.2	237.2	979300.0
2005-09-02	AAME	Stock	2.8	2.89	2.8	2.89	1300.0
2005-09-02	AAON	Stock	2.3506	2.4033	2.3374	2.3651	167062.0
2005-09-02	AAP	Stock	39.8	39.8733	38.6533	38.7867	1433700.0
2005-09-02	AATI-DELISTED	Stock	13.16	13.3	12.75	12.87	46348.0
2005-09-02	AAV-DELISTED	Stock	16.86	17.07	16.68	16.86	53200.0
2005-09-02	AAXN-DELISTED	Stock	8.5	8.53999996185303	8.34000015258789	8.38000011444092	1565000.0
2005-09-02	ABAX-DELISTED	Stock	11.75	12.0	11.73	11.73	67911.0
2005-09-02	ABB-DELISTED	Stock	7.62	7.68	7.61	7.63	1675400.0
2005-09-02	ABBC-DELISTED	Stock	12.66	12.66	12.65	12.65	496.0
2005-09-02	ABC-DELISTED	Stock	18.66	18.72	18.44	18.47	1370400.0
2005-09-02	ABCB	Stock	18.0717	18.1885	18.0231	18.1885	4524.0
2005-09-02	ABCO-DELISTED	Stock	26.35	26.45	25.76	25.89	66150.0
2005-09-02	ABCW-DELISTED	Stock	30.45	30.56	30.39	30.48	20540.0
2005-09-02	ABD-DELISTED	Stock	26.01	26.83	26.01	26.74	610160.0
2005-09-02	ABE-DELISTED	Stock	10.55	10.77	10.55	10.72	17800.0
2005-09-02	ABFS-DELISTED	Stock	34.9	35.09	34.23	34.45	135063.0
2005-09-02	ABG	Stock	16.91	16.92	16.57	16.75	79800.0
2005-09-02	ABK-DELISTED	Stock	67.88	67.88	65.98	67.03	958500.0
2005-09-02	ABM	Stock	19.67	19.8	19.5	19.66	51200.0
2005-09-02	ABMD-DELISTED	Stock	9.73	10.0	9.72	9.92	34608.0
2005-09-02	ABP-DELISTED	Stock	4.61	4.63	4.43	4.59	277600.0
2005-09-02	ABR	Stock	28.2	28.25	28.02	28.25	82700.0
2005-09-02	ABT	Stock	21.687	21.7253	21.4902	21.5334	5307420.0
2005-09-02	ABTL-DELISTED	Stock	25.35	25.5	24.7	24.75	31262.0
2005-09-02	ABV-DELISTED	Stock	32.7	33.24	32.7	32.99	551900.0
2005-09-02	ABVA-DELISTED	Stock	16.22	16.22	16.2	16.2	250.0
2005-09-02	ABX-DELISTED	Stock	27.24	27.58	26.91	27.38	2838300.0
2005-09-02	ACAD	Stock	9.91	10.35	9.8	10.07	226700.0
2005-09-02	ACAP-DELISTED	Stock	44.65	44.65	44.16	44.41	16616.0
2005-09-02	ACAS-DELISTED	Stock	38.2	38.2	37.56	37.78	381720.0
2005-09-02	ACAT-DELISTED	Stock	21.6	21.88	21.31	21.88	169536.0
2005-09-02	ACC-DELISTED	Stock	23.9	23.95	23.4	23.48	35000.0
2005-09-02	ACCL-DELISTED	Stock	5.45	5.62	5.45	5.59	59171.0
2005-09-02	ACCO	Stock	26.0	26.81	26.0	26.75	610200.0
2005-09-02	ACE-DELISTED	Stock	44.75	44.76	44.25	44.67	987000.0
2005-09-02	ACF-DELISTED	Stock	24.93	25.09	24.76	24.99	1082600.0
2005-09-02	ACFC-DELISTED	Stock	72.7	72.96	72.6	72.96	3324.0
2005-09-02	ACG-DELISTED	Stock	8.36	8.37	8.33	8.35	356600.0
2005-09-02	ACGL	Stock	4.9389	4.9456	4.8889	4.9144	761400.0
2005-09-02	ACGN-DELISTED	Stock	521.3288	544.0	510.0	544.0	76400.0

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

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