PREVIEW / stock_daily / 2008-04-02

all stock daily files

  file:    by_date/stock_daily/2008/2008-04-02.parquet
  size:    181 KB
  rows:    5,664
  symbols: 3,430

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
2008-04-02	AAPL	Stock	5.3136	5.4	5.2089	5.2675	1044968400.0
2008-04-02	MSFT	Stock	29.57	29.58	29.0	29.16	49499400.0
2008-04-02	NVDA	Stock	0.5265	0.5265	0.505	0.509	616536000.0
2008-04-02	AMZN	Stock	3.854	3.95	3.806	3.8685	171848000.0
2008-04-02	TLT	Stock	93.99	94.86	93.99	94.13	3794152.0
2008-04-02	CL	Stock	39.165	39.375	38.85	38.88	6451400.0
2008-04-02	A	Stock	22.1602	22.6395	22.0887	22.3391	3447887.0
2008-04-02	AABA-DELISTED	Stock	28.55	28.6	27.49	27.82	29181495.0
2008-04-02	AACC-DELISTED	Stock	10.23	10.49	10.0	10.44	150395.0
2008-04-02	AACG	Stock	9.55	9.7	8.96	9.48	3400.0
2008-04-02	AAI-DELISTED	Stock	6.82	6.89	6.49	6.5	1999342.0
2008-04-02	AAIC-DELISTED	Stock	33.8	37.4	33.0	36.6	1232010.0
2008-04-02	AAME	Stock	1.56	1.59	1.56	1.59	12800.0
2008-04-02	AAON	Stock	4.0395	4.0395	3.842	3.9309	542700.0
2008-04-02	AAP	Stock	35.47	36.86	35.43	35.81	1280900.0
2008-04-02	AATI-DELISTED	Stock	6.0	6.15	5.92	5.94	1091317.0
2008-04-02	AAU-DELISTED	Stock	2.3	2.45	2.26	2.41	78400.0
2008-04-02	AAUAF-DELISTED	Stock	2.3	2.45	2.26	2.41	78500.0
2008-04-02	AAV-DELISTED	Stock	11.2	11.36	11.16	11.33	409035.0
2008-04-02	AAWW-DELISTED	Stock	57.17	57.8	56.3	57.27	203749.0
2008-04-02	AAXN-DELISTED	Stock	9.92	9.98	9.7	9.76	993011.0
2008-04-02	AB	Stock	67.75	67.75	64.96	65.7	557100.0
2008-04-02	ABAX-DELISTED	Stock	23.98	24.72	23.78	24.43	270578.0
2008-04-02	ABB-DELISTED	Stock	26.89	27.19	26.68	27.08	4923414.0
2008-04-02	ABBC-DELISTED	Stock	10.33	10.4	10.33	10.4	29315.0
2008-04-02	ABBNY-DELISTED	Stock	26.89	27.19	26.68	27.12	4932914.0
2008-04-02	ABC-DELISTED	Stock	20.86	20.92	20.09	20.18	3556098.0
2008-04-02	ABCB	Stock	15.9902	16.0486	15.6303	15.961	23955.0
2008-04-02	ABCO-DELISTED	Stock	27.45	27.45	26.76	27.07	240070.0
2008-04-02	ABCW-DELISTED	Stock	19.86	19.87	19.049	19.15	161910.0
2008-04-02	ABD-DELISTED	Stock	14.14	14.36	13.72	13.93	255900.0
2008-04-02	ABE-DELISTED	Stock	23.14	23.36	22.76	23.096	42770.0
2008-04-02	ABEO	Stock	1687.5	1812.5	1562.5	1812.5	3.0
2008-04-02	ABFS-DELISTED	Stock	33.01	34.22	33.0	33.84	468517.0
2008-04-02	ABG	Stock	14.11	14.52	13.92	14.19	260200.0
2008-04-02	ABII-DELISTED	Stock	59.26	60.46	59.26	60.44	51326.0
2008-04-02	ABK-DELISTED	Stock	6.09	6.42	6.0	6.22	6675013.0
2008-04-02	ABM	Stock	22.87	22.98	22.6	22.75	230100.0
2008-04-02	ABMD-DELISTED	Stock	13.09	13.3	12.9	13.02	133541.0
2008-04-02	ABP-DELISTED	Stock	3.3	3.34	3.24	3.29	308798.0
2008-04-02	ABR	Stock	15.68	16.5	15.46	16.44	137000.0
2008-04-02	ABT	Stock	26.5329	26.5665	25.9716	26.0531	10671321.0
2008-04-02	ABTL-DELISTED	Stock	9.738	9.811	8.951	9.0	37323.0
2008-04-02	ABV-DELISTED	Stock	79.08	80.07	78.44	79.37	420507.0
2008-04-02	ABVA-DELISTED	Stock	5.16	5.35	5.16	5.24	2104.0
2008-04-02	ABVT-DELISTED	Stock	66.75	66.75	66.0	66.0	2700.0
2008-04-02	ABX-DELISTED	Stock	42.21	43.94	42.21	43.82	9821633.0
2008-04-02	ACAD	Stock	9.38	9.38	8.85	8.99	248700.0
2008-04-02	ACAP-DELISTED	Stock	48.82	48.82	46.73	48.44	67752.0
2008-04-02	ACAS-DELISTED	Stock	34.84	35.86	34.53	35.02	2598039.0

> showing 50 of 5,664 rows — these rows as CSV

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