PREVIEW / stock_daily / 2008-04-07

all stock daily files

  file:    by_date/stock_daily/2008/2008-04-07.parquet
  size:    181 KB
  rows:    5,699
  symbols: 3,441

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-07	AAPL	Stock	5.5761	5.7032	5.5396	5.5675	1158326400.0
2008-04-07	MSFT	Stock	29.55	29.59	29.03	29.16	44428600.0
2008-04-07	NVDA	Stock	0.481	0.488	0.477	0.4808	729496000.0
2008-04-07	AMZN	Stock	3.868	3.9215	3.8	3.845	133448000.0
2008-04-07	TLT	Stock	94.62	94.78	93.9	94.7	2231757.0
2008-04-07	CL	Stock	39.655	39.655	38.89	39.175	5169000.0
2008-04-07	A	Stock	22.6896	22.8827	22.5465	22.5823	1860039.0
2008-04-07	AABA-DELISTED	Stock	27.81	28.15	27.57	27.68	27930238.0
2008-04-07	AACC-DELISTED	Stock	10.96	11.0	10.69	10.98	116118.0
2008-04-07	AACG	Stock	10.5	10.5	9.57	9.57	38300.0
2008-04-07	AAI-DELISTED	Stock	6.53	6.58	6.42	6.47	691554.0
2008-04-07	AAIC-DELISTED	Stock	36.2	36.2	33.6	35.0	1199721.0
2008-04-07	AAME	Stock	1.55	1.55	1.5	1.5	800.0
2008-04-07	AAON	Stock	3.7432	3.8242	3.6227	3.6958	243000.0
2008-04-07	AAP	Stock	36.11	36.11	35.48	35.57	487800.0
2008-04-07	AATI-DELISTED	Stock	5.9	6.26	5.85	6.13	1267650.0
2008-04-07	AAU-DELISTED	Stock	2.36	2.53	2.36	2.43	49084.0
2008-04-07	AAUAF-DELISTED	Stock	2.36	2.53	2.36	2.43	50184.0
2008-04-07	AAV-DELISTED	Stock	11.35	11.45	11.22	11.31	476618.0
2008-04-07	AAWW-DELISTED	Stock	60.73	60.73	59.0	59.13	153381.0
2008-04-07	AAXN-DELISTED	Stock	10.28	10.39	10.05	10.11	920739.0
2008-04-07	AB	Stock	63.92	64.4	63.63	63.76	536700.0
2008-04-07	ABAX-DELISTED	Stock	24.82	25.01	24.42	24.67	154231.0
2008-04-07	ABB-DELISTED	Stock	27.79	27.82	27.22	27.36	3300092.0
2008-04-07	ABBC-DELISTED	Stock	10.38	10.4	10.3	10.38	34802.0
2008-04-07	ABBNY-DELISTED	Stock	27.8	27.82	27.22	27.39	3304592.0
2008-04-07	ABC-DELISTED	Stock	20.64	20.7	20.16	20.24	1951624.0
2008-04-07	ABCB	Stock	15.2413	15.6206	14.9787	15.4164	28993.0
2008-04-07	ABCO-DELISTED	Stock	27.23	27.23	26.51	26.58	219482.0
2008-04-07	ABCW-DELISTED	Stock	18.66	19.43	17.64	17.85	127240.0
2008-04-07	ABD-DELISTED	Stock	13.71	14.04	13.58	13.79	238750.0
2008-04-07	ABE-DELISTED	Stock	23.67	23.98	23.05	23.84	16000.0
2008-04-07	ABEO	Stock	2075.0	2125.0	2062.5	2125.0	6.0
2008-04-07	ABFS-DELISTED	Stock	33.49	34.41	33.3	34.07	338272.0
2008-04-07	ABG	Stock	14.69	15.15	14.65	14.77	224400.0
2008-04-07	ABII-DELISTED	Stock	59.42	60.37	59.28	60.0	22731.0
2008-04-07	ABK-DELISTED	Stock	6.28	6.4	6.12	6.19	6572823.0
2008-04-07	ABM	Stock	22.47	22.68	22.07	22.27	285200.0
2008-04-07	ABMD-DELISTED	Stock	13.5	13.63	13.36	13.63	137595.0
2008-04-07	ABP-DELISTED	Stock	3.46	3.48	3.38	3.38	157981.0
2008-04-07	ABR	Stock	16.75	18.18	16.5	17.55	512300.0
2008-04-07	ABT	Stock	26.4514	26.5329	26.1635	26.3266	5576907.0
2008-04-07	ABTL-DELISTED	Stock	9.925	10.076	9.524	9.725	11306.0
2008-04-07	ABV-DELISTED	Stock	80.01	81.17	78.34	78.99	405396.0
2008-04-07	ABVA-DELISTED	Stock	5.11	5.2	5.1	5.15	6665.0
2008-04-07	ABVT-DELISTED	Stock	60.5	62.0	60.5	62.0	1821.0
2008-04-07	ABX-DELISTED	Stock	44.2	45.33	43.78	44.05	7263456.0
2008-04-07	ACAD	Stock	9.18	9.86	9.11	9.17	300900.0
2008-04-07	ACAP-DELISTED	Stock	47.3	47.38	46.24	46.66	48158.0
2008-04-07	ACAS-DELISTED	Stock	34.51	34.98	34.31	34.49	1426470.0

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

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