PREVIEW / stock_daily / 2009-07-16

all stock daily files

  file:    by_date/stock_daily/2009/2009-07-16.parquet
  size:    181 KB
  rows:    5,739
  symbols: 3,426

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-07-16	AAPL	Stock	5.2057	5.2864	5.1989	5.2686	393570800.0
2009-07-16	MSFT	Stock	23.93	24.44	23.86	24.44	64555100.0
2009-07-16	NVDA	Stock	0.2818	0.2942	0.2803	0.2932	952076000.0
2009-07-16	AMZN	Stock	4.221	4.312	4.186	4.3055	107238000.0
2009-07-16	TLT	Stock	92.81	93.18	92.5	92.67	4225157.0
2009-07-16	ES	Stock	22.05	22.28	21.88	22.21	1518700.0
2009-07-16	CL	Stock	36.385	37.07	36.385	36.77	4793800.0
2009-07-16	A	Stock	14.6495	14.9571	14.628	14.8999	4075869.0
2009-07-16	AABA-DELISTED	Stock	15.86	16.25	15.78	16.19	21780822.0
2009-07-16	AACC-DELISTED	Stock	7.92	8.32	7.795	8.26	21031.0
2009-07-16	AACG	Stock	8.0	8.65	8.0	8.33	5600.0
2009-07-16	AAI-DELISTED	Stock	6.6	6.66	6.27	6.41	1534340.0
2009-07-16	AAIC-DELISTED	Stock	8.4	8.4	7.6	7.62	732178.0
2009-07-16	AAME	Stock	0.73	0.75	0.73	0.73	1400.0
2009-07-16	AAON	Stock	3.9802	4.0237	3.8459	3.9684	478912.0
2009-07-16	AAP	Stock	44.93	45.59	44.63	45.41	1273700.0
2009-07-16	AATI-DELISTED	Stock	4.46	4.54	4.43	4.49	243995.0
2009-07-16	AAU-DELISTED	Stock	0.67	0.67	0.64	0.64	78020.0
2009-07-16	AAUAF-DELISTED	Stock	0.67	0.67	0.64	0.64	78120.0
2009-07-16	AAV-DELISTED	Stock	4.67	5.17	4.67	5.08	1332338.0
2009-07-16	AAWW-DELISTED	Stock	22.27	23.31	22.2	23.09	282696.0
2009-07-16	AAXJ	Stock	45.58	46.1593	45.308	46.12	141384.0
2009-07-16	AAXN-DELISTED	Stock	5.0	5.21	4.975	5.18	485325.0
2009-07-16	AB	Stock	20.43	21.14	20.11	20.98	352600.0
2009-07-16	ABAX-DELISTED	Stock	19.73	20.84	19.73	20.84	188743.0
2009-07-16	ABB-DELISTED	Stock	16.21	16.49	16.12	16.38	3251267.0
2009-07-16	ABBC-DELISTED	Stock	8.24	8.59	8.09	8.57	41337.0
2009-07-16	ABBNY-DELISTED	Stock	16.21	16.49	16.12	16.4	3254007.0
2009-07-16	ABC-DELISTED	Stock	18.23	18.58	18.12	18.52	2922707.0
2009-07-16	ABCB	Stock	6.507	6.9544	6.4681	6.9057	23441.0
2009-07-16	ABCO-DELISTED	Stock	12.31	12.725	12.31	12.515	132358.0
2009-07-16	ABCW-DELISTED	Stock	1.2195	1.2707	1.0402	1.24	151890.0
2009-07-16	ABD-DELISTED	Stock	2.7548	2.9752	2.6547	2.9452	221680.0
2009-07-16	ABE-DELISTED	Stock	15.15	15.38	15.03	15.34	8750.0
2009-07-16	ABEO	Stock	2500.0	2500.0	2450.0	2500.0	9.0
2009-07-16	ABFS-DELISTED	Stock	26.47	26.87	26.09	26.58	552421.0
2009-07-16	ABG	Stock	11.13	11.83	10.98	11.76	479500.0
2009-07-16	ABII-DELISTED	Stock	31.64	34.34	30.98	31.33	27746.0
2009-07-16	ABK-DELISTED	Stock	1.0	1.01	0.91	0.92	3963747.0
2009-07-16	ABM	Stock	18.29	18.77	18.22	18.74	159700.0
2009-07-16	ABMD-DELISTED	Stock	8.14	8.19	7.95	8.15	193428.0
2009-07-16	ABR	Stock	1.57	1.72	1.56	1.72	152200.0
2009-07-16	ABT	Stock	21.6534	21.6918	21.3895	21.5622	26617341.0
2009-07-16	ABTL-DELISTED	Stock	2.225	2.3	2.15	2.3	54445.0
2009-07-16	ABV-DELISTED	Stock	67.39	69.36	67.01	68.9	484165.0
2009-07-16	ABVA-DELISTED	Stock	2.4	2.738	2.0	2.2	7454.0
2009-07-16	ABVT-DELISTED	Stock	74.35	76.86	74.35	75.73	28667.0
2009-07-16	ABX-DELISTED	Stock	33.66	34.19	33.41	33.99	3847206.0
2009-07-16	ACAD	Stock	2.12	2.28	2.06	2.21	244000.0
2009-07-16	ACAP-DELISTED	Stock	39.6	40.0	38.92	39.75	23832.0

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

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