PREVIEW / stock_daily / 2009-10-12

all stock daily files

  file:    by_date/stock_daily/2009/2009-10-12.parquet
  size:    184 KB
  rows:    5,778
  symbols: 3,431

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-10-12	AAPL	Stock	6.8221	6.8396	6.7729	6.8146	288024800.0
2009-10-12	MSFT	Stock	25.66	25.89	25.55	25.72	29145800.0
2009-10-12	NVDA	Stock	0.3482	0.357	0.348	0.3502	499008000.0
2009-10-12	AMZN	Stock	4.8085	4.8125	4.6535	4.68	111828000.0
2009-10-12	TLT	Stock	96.03	96.33	95.6	96.05	1939612.0
2009-10-12	ES	Stock	23.51	23.66	23.39	23.52	1522100.0
2009-10-12	CL	Stock	39.51	40.01	39.26	39.81	4450200.0
2009-10-12	A	Stock	19.7353	19.8212	19.5494	19.6423	2649350.0
2009-10-12	AABA-DELISTED	Stock	16.97	17.11	16.66	16.74	16549564.0
2009-10-12	AACC-DELISTED	Stock	7.2	7.38	7.2	7.26	12104.0
2009-10-12	AACG	Stock	5.91	5.96	5.91	5.96	1200.0
2009-10-12	AAI-DELISTED	Stock	5.22	5.25	4.97	5.06	8392000.0
2009-10-12	AAIC-DELISTED	Stock	10.89	11.85	10.89	11.85	56368.0
2009-10-12	AAME	Stock	1.37	1.37	1.25	1.36	8400.0
2009-10-12	AAON	Stock	3.7274	3.763	3.6938	3.6958	313875.0
2009-10-12	AAP	Stock	38.47	38.87	38.21	38.26	1135100.0
2009-10-12	AATI-DELISTED	Stock	3.19	3.2	3.08	3.09	467561.0
2009-10-12	AAU-DELISTED	Stock	0.84	0.87	0.805	0.83	363537.0
2009-10-12	AAUAF-DELISTED	Stock	0.84	0.87	0.805	0.83	364116.0
2009-10-12	AAV-DELISTED	Stock	7.25	7.36	7.02	7.18	698952.0
2009-10-12	AAWW-DELISTED	Stock	34.35	35.33	33.93	34.3	167292.0
2009-10-12	AAXJ	Stock	53.57	53.61	53.0	53.26	177417.0
2009-10-12	AAXN-DELISTED	Stock	4.55	4.62	4.55	4.57	300952.0
2009-10-12	AB	Stock	28.33	28.6	27.9	28.4	527200.0
2009-10-12	ABAX-DELISTED	Stock	26.43	26.46	25.36	25.6	234074.0
2009-10-12	ABB-DELISTED	Stock	21.23	21.4	20.99	21.06	2455108.0
2009-10-12	ABBC-DELISTED	Stock	7.93	7.93	7.76	7.81	24333.0
2009-10-12	ABBNY-DELISTED	Stock	21.23	21.4	20.99	21.06	2488684.0
2009-10-12	ABC-DELISTED	Stock	22.67	22.85	22.61	22.73	1653556.0
2009-10-12	ABCB	Stock	6.8707	6.9295	6.6648	6.8119	8162.0
2009-10-12	ABCO-DELISTED	Stock	13.095	13.365	13.015	13.085	39942.0
2009-10-12	ABCW-DELISTED	Stock	1.29	1.3	1.2	1.25	87360.0
2009-10-12	ABD-DELISTED	Stock	7.42	7.67	7.34	7.58	151740.0
2009-10-12	ABE-DELISTED	Stock	17.49	17.97	17.21	17.6866	22208.0
2009-10-12	ABEO	Stock	4437.5	4437.5	4250.0	4250.0	40.0
2009-10-12	ABFS-DELISTED	Stock	29.0	30.32	29.0	29.89	617278.0
2009-10-12	ABG	Stock	13.03	13.39	12.95	13.17	220800.0
2009-10-12	ABII-DELISTED	Stock	38.52	38.52	37.1905	37.875	35750.0
2009-10-12	ABK-DELISTED	Stock	1.49	1.53	1.44	1.45	7725209.0
2009-10-12	ABM	Stock	20.62	20.81	20.52	20.67	61900.0
2009-10-12	ABMD-DELISTED	Stock	10.61	10.66	10.39	10.61	211267.0
2009-10-12	ABR	Stock	2.84	2.85	2.65	2.7	124900.0
2009-10-12	ABT	Stock	24.1963	24.1963	23.9036	23.99	15206336.0
2009-10-12	ABTL-DELISTED	Stock	3.3	3.3	3.15	3.15	5615.0
2009-10-12	ABV-DELISTED	Stock	90.95	93.31	90.95	92.07	374367.0
2009-10-12	ABVA-DELISTED	Stock	2.24	2.49	2.2301	2.456	1600.0
2009-10-12	ABVT-DELISTED	Stock	49.63	50.37	49.5316	49.85	266030.0
2009-10-12	ABX-DELISTED	Stock	39.85	40.19	39.1	39.36	9944622.0
2009-10-12	ACAD	Stock	1.74	1.79	1.72	1.72	534800.0
2009-10-12	ACAP-DELISTED	Stock	29.57	30.21	29.57	29.91	44865.0

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

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