PREVIEW / stock_daily / 2008-01-09

all stock daily files

  file:    by_date/stock_daily/2008/2008-01-09.parquet
  size:    183 KB
  rows:    5,701
  symbols: 3,451

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-01-09	AAPL	Stock	6.1179	6.4107	6.0107	6.4071	1813882000.0
2008-01-09	MSFT	Stock	33.36	34.54	33.35	34.44	74305500.0
2008-01-09	NVDA	Stock	0.696	0.7225	0.6858	0.7223	741036000.0
2008-01-09	AMZN	Stock	4.378	4.39	4.012	4.261	328218000.0
2008-01-09	TLT	Stock	94.79	95.3	94.62	94.62	2203500.0
2008-01-09	CL	Stock	39.925	40.99	39.925	40.49	7698600.0
2008-01-09	A	Stock	24.9571	25.5436	24.8355	25.3076	5362728.0
2008-01-09	AABA-DELISTED	Stock	22.57	22.8	21.37	22.54	46671231.0
2008-01-09	AACC-DELISTED	Stock	9.25	9.73	9.11	9.26	258805.0
2008-01-09	AAI-DELISTED	Stock	6.28	6.47	6.01	6.44	5913983.0
2008-01-09	AAIC-DELISTED	Stock	61.8	63.4	58.0	62.4	2669695.0
2008-01-09	AAME	Stock	1.55	1.72	1.55	1.64	1400.0
2008-01-09	AAON	Stock	3.4489	3.6148	3.4114	3.5793	368044.0
2008-01-09	AAP	Stock	35.37	35.97	33.46	34.83	2981000.0
2008-01-09	AATI-DELISTED	Stock	8.79	8.88	8.27	8.81	519680.0
2008-01-09	AAU-DELISTED	Stock	2.89	2.94	2.81	2.86	86000.0
2008-01-09	AAUAF-DELISTED	Stock	2.89	2.94	2.81	2.86	86500.0
2008-01-09	AAV-DELISTED	Stock	9.36	9.36	8.93	9.22	622921.0
2008-01-09	AAWW-DELISTED	Stock	49.78	49.89	46.52	48.12	315326.0
2008-01-09	AAXN-DELISTED	Stock	13.21	13.4572	10.11	12.57	5336403.0
2008-01-09	AB	Stock	73.91	74.49	72.21	74.29	584100.0
2008-01-09	ABAX-DELISTED	Stock	31.94	32.79	31.5	32.6	285507.0
2008-01-09	ABB-DELISTED	Stock	25.89	26.18	25.34	26.04	6256968.0
2008-01-09	ABBC-DELISTED	Stock	8.98	9.02	8.75	8.89	94330.0
2008-01-09	ABBNY-DELISTED	Stock	25.89	26.18	25.34	26.08	6256968.0
2008-01-09	ABC-DELISTED	Stock	22.8	23.08	22.52	23.02	4349244.0
2008-01-09	ABCB	Stock	14.1909	14.5507	14.0158	14.3853	59734.0
2008-01-09	ABCO-DELISTED	Stock	30.98	32.08	30.96	31.72	221162.0
2008-01-09	ABCW-DELISTED	Stock	21.1	21.74	20.66	21.71	147150.0
2008-01-09	ABD-DELISTED	Stock	14.24	14.61	14.0	14.59	513800.0
2008-01-09	ABE-DELISTED	Stock	25.32	25.9	24.35	25.9	30400.0
2008-01-09	ABEO	Stock	3875.0	3875.0	3562.5	3750.0	6.0
2008-01-09	ABFS-DELISTED	Stock	18.2	18.92	17.94	18.92	720053.0
2008-01-09	ABG	Stock	13.79	13.98	13.45	13.93	420200.0
2008-01-09	ABII-DELISTED	Stock	61.95	63.9	59.62	63.5	29693.0
2008-01-09	ABK-DELISTED	Stock	19.79	20.07	15.5	18.61	15325181.0
2008-01-09	ABM	Stock	19.02	19.47	18.92	19.47	421700.0
2008-01-09	ABMD-DELISTED	Stock	14.6	15.0	14.44	14.99	188318.0
2008-01-09	ABP-DELISTED	Stock	4.25	4.3	4.15	4.19	117070.0
2008-01-09	ABR	Stock	14.76	15.21	13.46	14.59	608700.0
2008-01-09	ABT	Stock	28.2602	28.9271	28.2362	28.8072	20584410.0
2008-01-09	ABTL-DELISTED	Stock	14.454	14.605	13.898	14.1	16648.0
2008-01-09	ABV-DELISTED	Stock	72.03	72.3	70.13	72.28	606700.0
2008-01-09	ABVA-DELISTED	Stock	6.93	6.93	6.75	6.75	400.0
2008-01-09	ABX-DELISTED	Stock	48.68	50.45	48.05	50.05	14013423.0
2008-01-09	ACAD	Stock	11.52	11.79	11.2	11.61	330400.0
2008-01-09	ACAP-DELISTED	Stock	38.54	40.22	38.54	39.73	95423.0
2008-01-09	ACAS-DELISTED	Stock	31.33	31.76	30.62	31.22	4867294.0
2008-01-09	ACAT-DELISTED	Stock	8.09	8.17	7.5	7.7	584371.0
2008-01-09	ACC-DELISTED	Stock	25.7	26.67	25.05	26.66	311057.0

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

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