PREVIEW / stock_daily / 2009-03-10

all stock daily files

  file:    by_date/stock_daily/2009/2009-03-10.parquet
  size:    174 KB
  rows:    5,803
  symbols: 3,464

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-03-10	AAPL	Stock	3.0311	3.1846	3.0129	3.1654	844258800.0
2009-03-10	MSFT	Stock	15.37	16.62	15.25	16.48	95184200.0
2009-03-10	NVDA	Stock	0.215	0.2303	0.213	0.2263	1254800000.0
2009-03-10	AMZN	Stock	3.1245	3.295	3.089	3.2855	308714000.0
2009-03-10	TLT	Stock	102.43	102.75	101.51	101.66	2602554.0
2009-03-10	ES	Stock	19.88	19.97	19.55	19.97	1491400.0
2009-03-10	CL	Stock	27.895	27.95	27.455	27.92	9061200.0
2009-03-10	A	Stock	9.0916	9.6352	9.0343	9.6066	6584300.0
2009-03-10	AABA-DELISTED	Stock	12.84	13.4	12.75	13.16	22302138.0
2009-03-10	AACC-DELISTED	Stock	3.5	3.88	3.5	3.85	45122.0
2009-03-10	AACG	Stock	5.16	5.16	4.5	4.95	47600.0
2009-03-10	AAI-DELISTED	Stock	3.19	3.59	3.05	3.57	6305309.0
2009-03-10	AAIC-DELISTED	Stock	2.5	2.6	2.2	2.6	575492.0
2009-03-10	AAME	Stock	0.55	0.55	0.51	0.55	12900.0
2009-03-10	AAON	Stock	3.1111	3.3956	3.0479	3.3896	1062112.0
2009-03-10	AAP	Stock	36.65	38.39	36.52	38.28	2105400.0
2009-03-10	AATI-DELISTED	Stock	2.77	3.0	2.69	2.98	293658.0
2009-03-10	AAU-DELISTED	Stock	0.79	0.79	0.65	0.66	112111.0
2009-03-10	AAUAF-DELISTED	Stock	0.79	0.79	0.65	0.66	113111.0
2009-03-10	AAV-DELISTED	Stock	2.02	2.12	2.02	2.07	665516.0
2009-03-10	AAWW-DELISTED	Stock	10.47	11.38	10.32	11.28	276514.0
2009-03-10	AAXJ	Stock	28.81	29.66	28.39	29.59	92432.0
2009-03-10	AAXN-DELISTED	Stock	3.79	4.19	3.79	4.06	691984.0
2009-03-10	AB	Stock	10.88	11.65	10.35	11.49	716900.0
2009-03-10	ABAX-DELISTED	Stock	17.22	18.25	16.72	17.55	495004.0
2009-03-10	ABB-DELISTED	Stock	12.27	12.85	12.25	12.73	4832045.0
2009-03-10	ABBC-DELISTED	Stock	5.88	7.43	5.88	7.25	115633.0
2009-03-10	ABBNY-DELISTED	Stock	12.27	12.85	12.25	12.72	4837057.0
2009-03-10	ABC-DELISTED	Stock	15.38	15.61	15.06	15.6	5281812.0
2009-03-10	ABCB	Stock	3.8516	4.4644	3.7933	4.4547	30535.0
2009-03-10	ABCO-DELISTED	Stock	6.8674	7.263	6.8674	7.223	176367.0
2009-03-10	ABCW-DELISTED	Stock	0.4618	0.511	0.4515	0.49	132350.0
2009-03-10	ABD-DELISTED	Stock	1.25	1.63	1.25	1.39	281790.0
2009-03-10	ABE-DELISTED	Stock	10.28	11.14	10.28	10.97	77510.0
2009-03-10	ABEO	Stock	1625.0	1875.0	1625.0	1750.0	4.0
2009-03-10	ABFS-DELISTED	Stock	16.98	17.78	16.77	17.63	491864.0
2009-03-10	ABG	Stock	2.13	2.28	2.04	2.17	727900.0
2009-03-10	ABII-DELISTED	Stock	57.17	58.0	54.77	57.42	19093.0
2009-03-10	ABK-DELISTED	Stock	0.4601	0.48	0.43	0.4799	8973817.0
2009-03-10	ABM	Stock	13.89	14.99	13.81	14.86	766200.0
2009-03-10	ABMD-DELISTED	Stock	5.24	5.47	5.1798	5.43	307690.0
2009-03-10	ABR	Stock	0.61	0.75	0.61	0.68	81700.0
2009-03-10	ABT	Stock	22.6945	22.7569	22.2339	22.541	24025636.0
2009-03-10	ABTL-DELISTED	Stock	1.4131	1.4131	1.2117	1.3	20139.0
2009-03-10	ABV-DELISTED	Stock	40.89	42.44	40.89	42.06	568878.0
2009-03-10	ABVA-DELISTED	Stock	1.61	1.76	1.61	1.72	2100.0
2009-03-10	ABVT-DELISTED	Stock	37.05	40.0	37.05	40.0	40198.0
2009-03-10	ABX-DELISTED	Stock	27.97	28.13	25.77	26.01	19627552.0
2009-03-10	ACAD	Stock	0.86	1.0	0.86	0.98	206100.0
2009-03-10	ACAP-DELISTED	Stock	39.46	42.55	38.82	42.54	79401.0

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

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