PREVIEW / stock_daily / 2009-04-22

all stock daily files

  file:    by_date/stock_daily/2009/2009-04-22.parquet
  size:    177 KB
  rows:    5,722
  symbols: 3,408

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
2009-04-22	AAPL	Stock	4.3796	4.4768	4.3286	4.3396	938767200.0
2009-04-22	MSFT	Stock	18.76	19.19	18.7	18.78	59401000.0
2009-04-22	NVDA	Stock	0.273	0.2952	0.2685	0.2838	916404000.0
2009-04-22	AMZN	Stock	3.9085	4.109	3.8905	3.96	175510000.0
2009-04-22	TLT	Stock	102.45	102.56	101.11	101.6	2278060.0
2009-04-22	ES	Stock	20.77	20.88	20.29	20.33	2647900.0
2009-04-22	CL	Stock	30.03	30.105	29.565	29.615	7943800.0
2009-04-22	A	Stock	11.7525	12.3247	11.6953	11.9886	3967524.0
2009-04-22	AABA-DELISTED	Stock	14.62	15.39	14.41	14.48	64497628.0
2009-04-22	AACC-DELISTED	Stock	6.33	6.65	6.3286	6.42	58620.0
2009-04-22	AACG	Stock	4.24	4.34	4.15	4.15	2300.0
2009-04-22	AAI-DELISTED	Stock	6.15	7.12	6.11	6.91	13132103.0
2009-04-22	AAIC-DELISTED	Stock	6.0	6.0	5.4	5.6	573242.0
2009-04-22	AAME	Stock	0.6	0.6	0.6	0.6	1400.0
2009-04-22	AAON	Stock	3.3995	3.6385	3.3995	3.5911	611550.0
2009-04-22	AAP	Stock	42.24	44.18	42.24	43.62	2167600.0
2009-04-22	AATI-DELISTED	Stock	4.71	4.94	4.71	4.91	633709.0
2009-04-22	AAU-DELISTED	Stock	0.59	0.63	0.58	0.63	45146.0
2009-04-22	AAUAF-DELISTED	Stock	0.59	0.63	0.58	0.63	45646.0
2009-04-22	AAV-DELISTED	Stock	2.8	2.92	2.77	2.85	642331.0
2009-04-22	AAWW-DELISTED	Stock	23.7	24.67	23.4	23.94	271433.0
2009-04-22	AAXJ	Stock	36.46	37.32	36.26	36.51	102150.0
2009-04-22	AAXN-DELISTED	Stock	4.87	5.25	4.87	5.1	907677.0
2009-04-22	AB	Stock	19.12	19.58	18.53	18.88	749700.0
2009-04-22	ABAX-DELISTED	Stock	15.06	15.53	14.81	15.07	266316.0
2009-04-22	ABB-DELISTED	Stock	15.03	15.61	14.925	15.11	5666413.0
2009-04-22	ABBC-DELISTED	Stock	8.86	9.31	8.81	8.96	49729.0
2009-04-22	ABBNY-DELISTED	Stock	15.03	15.61	14.925	15.12	5667013.0
2009-04-22	ABC-DELISTED	Stock	17.14	17.72	17.02	17.38	5078606.0
2009-04-22	ABCB	Stock	7.1684	7.8784	6.6918	6.7502	23030.0
2009-04-22	ABCO-DELISTED	Stock	8.487	8.678	8.457	8.503	306062.0
2009-04-22	ABCW-DELISTED	Stock	1.7	1.9	1.7	1.81	187620.0
2009-04-22	ABD-DELISTED	Stock	1.4	2.2	1.33	2.05	819600.0
2009-04-22	ABE-DELISTED	Stock	12.75	12.91	12.75	12.85	41065.0
2009-04-22	ABEO	Stock	1875.0	1875.0	1637.5	1800.0	1.0
2009-04-22	ABFS-DELISTED	Stock	20.32	22.7	20.08	21.89	1239956.0
2009-04-22	ABG	Stock	6.58	7.51	6.54	7.3	569800.0
2009-04-22	ABII-DELISTED	Stock	54.72	57.6	50.15	50.17	18082.0
2009-04-22	ABK-DELISTED	Stock	1.0	1.05	0.97	0.99	8625199.0
2009-04-22	ABM	Stock	16.98	17.64	16.77	17.3	356000.0
2009-04-22	ABMD-DELISTED	Stock	5.47	5.75	5.443	5.55	361793.0
2009-04-22	ABR	Stock	1.25	1.36	1.25	1.34	94600.0
2009-04-22	ABT	Stock	21.1736	21.1784	20.3195	20.3915	28798875.0
2009-04-22	ABTL-DELISTED	Stock	2.05	2.1	1.6	1.95	43544.0
2009-04-22	ABV-DELISTED	Stock	51.8	53.32	51.76	52.65	609561.0
2009-04-22	ABVA-DELISTED	Stock	1.9	1.9	1.9	1.9	4330.0
2009-04-22	ABX-DELISTED	Stock	28.62	28.98	28.25	28.41	9580547.0
2009-04-22	ACAD	Stock	1.05	1.07	1.0	1.01	88700.0
2009-04-22	ACAP-DELISTED	Stock	40.89	41.51	40.01	40.15	27780.0
2009-04-22	ACAS-DELISTED	Stock	2.54	2.806	2.47	2.74	4419149.0

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

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