PREVIEW / stock_daily / 2009-02-12

all stock daily files

  file:    by_date/stock_daily/2009/2009-02-12.parquet
  size:    175 KB
  rows:    5,675
  symbols: 3,378

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-12	AAPL	Stock	3.4225	3.5625	3.4225	3.5454	817188400.0
2009-02-12	MSFT	Stock	18.97	19.32	18.54	19.26	75323200.0
2009-02-12	NVDA	Stock	0.1992	0.2092	0.1965	0.208	1024020000.0
2009-02-12	AMZN	Stock	3.1625	3.2125	3.0855	3.198	161910000.0
2009-02-12	TLT	Stock	105.98	106.18	104.74	105.21	1818492.0
2009-02-12	CL	Stock	31.345	31.655	30.845	31.655	4379200.0
2009-02-12	A	Stock	12.9399	13.3262	12.8469	13.3262	6192161.0
2009-02-12	AABA-DELISTED	Stock	12.49	12.66	12.14	12.66	15326580.0
2009-02-12	AACC-DELISTED	Stock	4.43	4.67	4.37	4.52	20597.0
2009-02-12	AACG	Stock	3.95	3.99	3.89	3.99	1100.0
2009-02-12	AAI-DELISTED	Stock	4.07	4.32	4.01	4.31	2901438.0
2009-02-12	AAIC-DELISTED	Stock	4.6	5.0	4.4	4.8	291460.0
2009-02-12	AAON	Stock	3.443	3.5753	3.358	3.5733	209081.0
2009-02-12	AAP	Stock	32.45	33.1	31.64	33.0	2015900.0
2009-02-12	AATI-DELISTED	Stock	3.03	3.26	3.03	3.23	116728.0
2009-02-12	AAU-DELISTED	Stock	0.8564	0.88	0.82	0.88	105783.0
2009-02-12	AAUAF-DELISTED	Stock	0.8564	0.88	0.83	0.88	107283.0
2009-02-12	AAV-DELISTED	Stock	3.47	3.47	3.13	3.29	1655552.0
2009-02-12	AAWW-DELISTED	Stock	16.03	16.31	15.56	16.28	142993.0
2009-02-12	AAXJ	Stock	31.19	31.25	30.47	31.22	129799.0
2009-02-12	AAXN-DELISTED	Stock	5.14	5.28	5.02	5.19	486992.0
2009-02-12	AB	Stock	15.7	15.7	15.0	15.6	557400.0
2009-02-12	ABAX-DELISTED	Stock	17.24	17.58	16.96	17.46	142569.0
2009-02-12	ABB-DELISTED	Stock	12.95	13.45	12.63	13.44	8663510.0
2009-02-12	ABBC-DELISTED	Stock	6.74	6.79	6.58	6.75	116199.0
2009-02-12	ABBNY-DELISTED	Stock	12.95	13.45	12.63	13.43	8668510.0
2009-02-12	ABC-DELISTED	Stock	18.36	18.94	18.22	18.9	3571000.0
2009-02-12	ABCB	Stock	6.3903	6.4389	5.865	6.1374	34134.0
2009-02-12	ABCO-DELISTED	Stock	7.975	8.19	7.955	8.065	420870.0
2009-02-12	ABCW-DELISTED	Stock	1.7	1.8399	1.63	1.7	59150.0
2009-02-12	ABD-DELISTED	Stock	1.77	1.77	1.6068	1.69	77710.0
2009-02-12	ABE-DELISTED	Stock	12.25	12.25	11.65	11.94	23655.0
2009-02-12	ABEO	Stock	1062.5	1125.0	1037.5	1100.0	21.0
2009-02-12	ABFS-DELISTED	Stock	22.97	23.46	22.5	23.34	717132.0
2009-02-12	ABG	Stock	3.88	3.88	3.49	3.8	153800.0
2009-02-12	ABII-DELISTED	Stock	67.1	70.86	67.1	70.44	5203.0
2009-02-12	ABK-DELISTED	Stock	1.16	1.24	1.15	1.24	7992899.0
2009-02-12	ABM	Stock	13.43	13.43	12.91	13.24	430200.0
2009-02-12	ABMD-DELISTED	Stock	8.72	9.07	8.59	8.99	430452.0
2009-02-12	ABR	Stock	1.49	1.55	1.49	1.54	58700.0
2009-02-12	ABT	Stock	26.5233	26.9312	26.1779	26.9312	14070654.0
2009-02-12	ABTL-DELISTED	Stock	1.95	2.05	1.55	1.6	17291.0
2009-02-12	ABV-DELISTED	Stock	43.81	45.35	43.59	45.21	525864.0
2009-02-12	ABVA-DELISTED	Stock	1.75	2.08	1.7499	2.0	10147.0
2009-02-12	ABX-DELISTED	Stock	38.49	39.241	38.23	38.98	14078512.0
2009-02-12	ACAD	Stock	0.94	1.0	0.94	0.98	28800.0
2009-02-12	ACAP-DELISTED	Stock	44.21	45.01	44.21	45.0	31384.0
2009-02-12	ACAS-DELISTED	Stock	2.65	2.79	2.51	2.72	3587441.0
2009-02-12	ACAT-DELISTED	Stock	4.2	4.26	3.95	4.0	65537.0
2009-02-12	ACC-DELISTED	Stock	20.32	20.32	18.82	20.0	841770.0

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

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