PREVIEW / stock_daily / 2009-02-20

all stock daily files

  file:    by_date/stock_daily/2009/2009-02-20.parquet
  size:    177 KB
  rows:    5,804
  symbols: 3,477

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-02-20	AAPL	Stock	3.1929	3.3	3.1786	3.2571	750316000.0
2009-02-20	MSFT	Stock	17.77	18.19	17.66	18.0	69413800.0
2009-02-20	NVDA	Stock	0.183	0.1933	0.1813	0.1903	770056000.0
2009-02-20	AMZN	Stock	3.0535	3.2075	3.042	3.193	187090000.0
2009-02-20	TLT	Stock	104.27	105.16	103.3	103.92	4272002.0
2009-02-20	CL	Stock	30.055	30.37	29.62	29.74	9235600.0
2009-02-20	A	Stock	10.9585	11.0515	10.7082	10.8584	7148953.0
2009-02-20	AABA-DELISTED	Stock	11.88	12.27	11.75	12.12	16278952.0
2009-02-20	AACC-DELISTED	Stock	3.75	4.21	3.73	3.81	46073.0
2009-02-20	AACG	Stock	4.2	5.0	4.2	4.68	37600.0
2009-02-20	AAI-DELISTED	Stock	3.75	3.79	3.14	3.44	3344496.0
2009-02-20	AAIC-DELISTED	Stock	3.4	3.6	2.6	3.0	1119381.0
2009-02-20	AAME	Stock	0.7	0.7	0.7	0.7	6900.0
2009-02-20	AAON	Stock	3.1368	3.2435	3.1012	3.1111	336150.0
2009-02-20	AAP	Stock	36.31	37.9	36.3	36.91	4039300.0
2009-02-20	AATI-DELISTED	Stock	2.83	3.05	2.75	2.91	130960.0
2009-02-20	AAU-DELISTED	Stock	0.89	0.91	0.87	0.87	118713.0
2009-02-20	AAUAF-DELISTED	Stock	0.89	0.91	0.87	0.87	119713.0
2009-02-20	AAV-DELISTED	Stock	2.52	2.59	2.21	2.36	1536654.0
2009-02-20	AAWW-DELISTED	Stock	13.89	13.89	12.77	13.79	242141.0
2009-02-20	AAXJ	Stock	29.13	29.22	28.54	29.01	316200.0
2009-02-20	AAXN-DELISTED	Stock	4.5	4.56	4.2002	4.3	588348.0
2009-02-20	AB	Stock	12.71	12.91	11.71	12.59	1719300.0
2009-02-20	ABAX-DELISTED	Stock	17.19	17.61	16.75	17.04	275919.0
2009-02-20	ABB-DELISTED	Stock	11.45	11.86	11.37	11.67	5942993.0
2009-02-20	ABBC-DELISTED	Stock	6.51	6.81	6.43	6.78	424688.0
2009-02-20	ABBNY-DELISTED	Stock	11.45	11.86	11.37	11.66	5962493.0
2009-02-20	ABC-DELISTED	Stock	17.57	17.98	17.51	17.84	4584922.0
2009-02-20	ABCB	Stock	5.5538	6.0596	5.0966	5.6899	70324.0
2009-02-20	ABCO-DELISTED	Stock	8.107	8.127	7.938	7.998	404605.0
2009-02-20	ABCW-DELISTED	Stock	1.0	1.11	0.77	0.84	203300.0
2009-02-20	ABD-DELISTED	Stock	1.1389	1.1786	1.0102	1.03	131580.0
2009-02-20	ABE-DELISTED	Stock	11.41	11.9	11.26	11.5	11860.0
2009-02-20	ABEO	Stock	1337.5	1475.0	1087.5	1475.0	14.0
2009-02-20	ABFS-DELISTED	Stock	20.32	20.96	20.12	20.31	553469.0
2009-02-20	ABG	Stock	3.33	3.87	3.25	3.55	171900.0
2009-02-20	ABII-DELISTED	Stock	71.0	72.97	71.0	72.86	7195.0
2009-02-20	ABK-DELISTED	Stock	1.1	1.12	1.01	1.05	11620677.0
2009-02-20	ABM	Stock	12.3	12.33	11.64	12.3	786700.0
2009-02-20	ABMD-DELISTED	Stock	7.87	7.98	7.54	7.62	394449.0
2009-02-20	ABR	Stock	0.95	0.98	0.85	0.89	257300.0
2009-02-20	ABT	Stock	25.9092	26.2259	25.7173	25.9236	18687995.0
2009-02-20	ABTL-DELISTED	Stock	2.0534	2.1242	1.8966	1.8966	1351.0
2009-02-20	ABV-DELISTED	Stock	40.52	42.08	40.43	41.59	781316.0
2009-02-20	ABVA-DELISTED	Stock	2.06	2.4001	2.05	2.0501	3279.0
2009-02-20	ABVT-DELISTED	Stock	38.0	46.0	38.0	45.0	400.0
2009-02-20	ABX-DELISTED	Stock	37.42	37.86	35.62	37.02	20571910.0
2009-02-20	ACAD	Stock	0.82	0.92	0.82	0.83	87400.0
2009-02-20	ACAP-DELISTED	Stock	45.6	46.22	44.75	45.71	27649.0
2009-02-20	ACAS-DELISTED	Stock	1.39	1.49	1.29	1.41	5512638.0

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

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