PREVIEW / stock_daily / 2006-03-02

all stock daily files

  file:    by_date/stock_daily/2006/2006-03-02.parquet
  size:    146 KB
  rows:    4,361
  symbols: 2,755

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-03-02	AAPL	Stock	2.4639	2.4996	2.4525	2.4861	625273600.0
2006-03-02	MSFT	Stock	27.02	27.1	26.9	26.97	41850300.0
2006-03-02	NVDA	Stock	0.4072	0.414	0.403	0.4082	545460000.0
2006-03-02	AMZN	Stock	1.782	1.85	1.7685	1.844	231674000.0
2006-03-02	CL	Stock	27.275	27.37	27.05	27.255	1961600.0
2006-03-02	A	Stock	26.1445	26.1803	25.8941	25.98	2916787.0
2006-03-02	AABA-DELISTED	Stock	32.0099983215332	32.1100006103516	31.5799999237061	31.7000007629395	23487300.0
2006-03-02	AACC-DELISTED	Stock	19.68	20.0	19.68	19.9	171126.0
2006-03-02	AACQ-DELISTED	Stock	5.37	5.37	5.37	5.37	1500.0
2006-03-02	AACQU-DELISTED	Stock	6.75	6.75	6.7	6.7	900.0
2006-03-02	AAI-DELISTED	Stock	17.66	18.27	17.66	17.82	993000.0
2006-03-02	AAIC-DELISTED	Stock	196.6	196.6	187.0	195.0	2088800.0
2006-03-02	AAME	Stock	2.59	2.65	2.59	2.65	3800.0
2006-03-02	AAON	Stock	2.8365	2.8734	2.8326	2.8471	167822.0
2006-03-02	AAP	Stock	43.52	44.06	42.6	42.62	1711700.0
2006-03-02	AATI-DELISTED	Stock	12.03	12.03	11.4	11.73	198840.0
2006-03-02	AAU-DELISTED	Stock	2.8	2.9	2.8	2.85	21700.0
2006-03-02	AAUAF-DELISTED	Stock	2.8	2.9	2.8	2.85	21700.0
2006-03-02	AAV-DELISTED	Stock	19.7	19.83	19.6	19.7	267000.0
2006-03-02	AAWW-DELISTED	Stock	48.0	48.0	48.0	48.0	24400.0
2006-03-02	AAXN-DELISTED	Stock	10.0	10.25	9.81999969482422	9.9399995803833	2183300.0
2006-03-02	AB	Stock	64.8	65.1	63.6	63.91	140100.0
2006-03-02	ABAX-DELISTED	Stock	22.76	23.29	22.42	23.24	250255.0
2006-03-02	ABB-DELISTED	Stock	12.17	12.32	12.14	12.28	2448800.0
2006-03-02	ABBC-DELISTED	Stock	13.37	13.37	13.37	13.37	100.0
2006-03-02	ABC-DELISTED	Stock	23.0	23.02	22.84	22.96	2876000.0
2006-03-02	ABCB	Stock	22.3805	22.5166	22.0401	22.293	19534.0
2006-03-02	ABCO-DELISTED	Stock	27.6	27.6	27.04	27.27	128776.0
2006-03-02	ABCW-DELISTED	Stock	30.48	30.56	30.23	30.29	55120.0
2006-03-02	ABD-DELISTED	Stock	22.96	23.16	22.96	23.16	173700.0
2006-03-02	ABE-DELISTED	Stock	13.1	13.15	13.02	13.15	18600.0
2006-03-02	ABFS-DELISTED	Stock	42.49	42.63	41.75	41.98	233048.0
2006-03-02	ABG	Stock	19.47	19.77	19.32	19.77	78600.0
2006-03-02	ABK-DELISTED	Stock	75.34	75.55	74.73	75.51	299500.0
2006-03-02	ABM	Stock	18.68	18.75	18.51	18.65	163600.0
2006-03-02	ABMD-DELISTED	Stock	10.84	10.86	10.54	10.75	50400.0
2006-03-02	ABP-DELISTED	Stock	6.01	6.19	6.0	6.14	413000.0
2006-03-02	ABR	Stock	27.3	27.32	26.56	26.77	64800.0
2006-03-02	ABT	Stock	21.0152	21.044	20.6458	20.8425	11865986.0
2006-03-02	ABTL-DELISTED	Stock	21.73	22.47	20.88	22.17	188907.0
2006-03-02	ABV-DELISTED	Stock	42.89	43.14	42.72	42.99	569600.0
2006-03-02	ABVA-DELISTED	Stock	18.671	18.782	18.661	18.68	2188.0
2006-03-02	ABX-DELISTED	Stock	27.55	28.45	27.05	28.16	5368300.0
2006-03-02	ACAD	Stock	14.64	14.88	13.75	14.81	616400.0
2006-03-02	ACAP-DELISTED	Stock	50.05	50.09	48.51	48.98	16570.0
2006-03-02	ACAS-DELISTED	Stock	35.69	35.89	35.45	35.67	759761.0
2006-03-02	ACAT-DELISTED	Stock	24.69	24.79	24.33	24.65	40445.0
2006-03-02	ACC-DELISTED	Stock	25.6	25.65	24.35	24.62	130200.0
2006-03-02	ACCL-DELISTED	Stock	6.4	6.432	6.33	6.33	58581.0
2006-03-02	ACCO	Stock	22.96	23.16	22.96	23.16	175900.0

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

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