PREVIEW / stock_daily / 2009-09-15

all stock daily files

  file:    by_date/stock_daily/2009/2009-09-15.parquet
  size:    186 KB
  rows:    5,813
  symbols: 3,458

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-09-15	AAPL	Stock	6.2157	6.2732	6.1996	6.2557	426470800.0
2009-09-15	MSFT	Stock	24.97	25.27	24.86	25.2	44716600.0
2009-09-15	NVDA	Stock	0.405	0.4145	0.4013	0.4095	546136000.0
2009-09-15	AMZN	Stock	4.2085	4.2205	4.1395	4.1775	88936000.0
2009-09-15	TLT	Stock	95.19	95.77	95.07	95.25	2187812.0
2009-09-15	ES	Stock	23.97	24.52	23.88	24.48	1662600.0
2009-09-15	CL	Stock	37.55	37.55	37.18	37.225	5164800.0
2009-09-15	A	Stock	19.7783	20.3004	19.7783	20.2575	4638704.0
2009-09-15	AABA-DELISTED	Stock	16.01	16.49	15.87	16.43	63506788.0
2009-09-15	AACC-DELISTED	Stock	7.61	7.7	7.54	7.7	19299.0
2009-09-15	AACG	Stock	6.46	6.81	6.46	6.66	39000.0
2009-09-15	AAI-DELISTED	Stock	6.55	6.87	6.5	6.83	2154934.0
2009-09-15	AAIC-DELISTED	Stock	9.6	10.792	9.6	10.4	1269406.0
2009-09-15	AAME	Stock	0.71	0.93	0.71	0.74	9500.0
2009-09-15	AAON	Stock	4.0277	4.0691	3.9921	4.0672	597881.0
2009-09-15	AAP	Stock	39.63	39.87	38.6	39.03	3105300.0
2009-09-15	AATI-DELISTED	Stock	4.49	4.67	4.48	4.51	237733.0
2009-09-15	AAU-DELISTED	Stock	0.68	0.7	0.6711	0.7	210730.0
2009-09-15	AAUAF-DELISTED	Stock	0.68	0.7	0.6711	0.7	211630.0
2009-09-15	AAV-DELISTED	Stock	6.35	6.57	6.35	6.53	1029920.0
2009-09-15	AAWW-DELISTED	Stock	29.52	29.99	29.34	29.48	261394.0
2009-09-15	AAXJ	Stock	51.8	52.19	51.45	52.19	2009103.0
2009-09-15	AAXN-DELISTED	Stock	4.86	4.93	4.69	4.81	567407.0
2009-09-15	AB	Stock	24.81	25.01	24.57	24.7	468600.0
2009-09-15	ABAX-DELISTED	Stock	27.79	28.199	27.25	28.1	128017.0
2009-09-15	ABB-DELISTED	Stock	20.44	20.68	20.29	20.62	2993842.0
2009-09-15	ABBC-DELISTED	Stock	7.79	7.79	7.51	7.74	70872.0
2009-09-15	ABBNY-DELISTED	Stock	20.44	20.68	20.29	20.61	2994092.0
2009-09-15	ABC-DELISTED	Stock	21.775	21.78	21.38	21.56	3627784.0
2009-09-15	ABCB	Stock	6.1666	6.2444	6.1082	6.186	10384.0
2009-09-15	ABCO-DELISTED	Stock	13.535	13.775	13.43	13.585	132608.0
2009-09-15	ABCW-DELISTED	Stock	1.22	1.29	1.2	1.25	49120.0
2009-09-15	ABD-DELISTED	Stock	6.22	6.91	6.2	6.44	767410.0
2009-09-15	ABE-DELISTED	Stock	16.71	17.149	16.71	16.96	12685.0
2009-09-15	ABEO	Stock	4500.0	4500.0	4125.0	4312.5	29.0
2009-09-15	ABFS-DELISTED	Stock	33.81	34.56	33.36	33.48	440143.0
2009-09-15	ABG	Stock	14.59	14.95	14.41	14.82	439300.0
2009-09-15	ABII-DELISTED	Stock	27.65	29.0	27.25	27.95	150869.0
2009-09-15	ABK-DELISTED	Stock	1.81	1.81	1.59	1.6	23229911.0
2009-09-15	ABM	Stock	20.64	20.71	20.31	20.53	167900.0
2009-09-15	ABMD-DELISTED	Stock	8.09	8.31	8.02	8.28	123560.0
2009-09-15	ABR	Stock	1.85	2.14	1.85	2.04	503100.0
2009-09-15	ABT	Stock	22.7137	22.7905	22.5266	22.5938	14999166.0
2009-09-15	ABTL-DELISTED	Stock	2.95	3.0	2.8565	3.0	4958.0
2009-09-15	ABV-DELISTED	Stock	77.44	79.29	77.37	79.15	714860.0
2009-09-15	ABVA-DELISTED	Stock	2.55	2.729	2.5057	2.5536	6629.0
2009-09-15	ABVT-DELISTED	Stock	44.72	45.0	43.89	44.18	41632.0
2009-09-15	ABX-DELISTED	Stock	37.41	38.1	37.03	37.95	17047322.0
2009-09-15	ACAD	Stock	1.89	1.89	1.84	1.86	1608800.0
2009-09-15	ACAP-DELISTED	Stock	30.93	31.22	30.54	30.74	32036.0

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

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