PREVIEW / stock_daily / 2009-11-16

all stock daily files

  file:    by_date/stock_daily/2009/2009-11-16.parquet
  size:    188 KB
  rows:    5,904
  symbols: 3,504

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-11-16	AAPL	Stock	7.3386	7.4286	7.3218	7.3796	485206400.0
2009-11-16	MSFT	Stock	29.61	29.8	29.37	29.54	54129500.0
2009-11-16	NVDA	Stock	0.342	0.3478	0.3402	0.3438	402820000.0
2009-11-16	AMZN	Stock	6.606	6.728	6.549	6.5795	180366000.0
2009-11-16	TLT	Stock	94.65	95.45	94.52	95.02	5175649.0
2009-11-16	ES	Stock	23.74	23.91	23.64	23.91	2102100.0
2009-11-16	CL	Stock	40.925	41.26	40.83	41.2	3756200.0
2009-11-16	A	Stock	20.2074	21.1016	20.1001	21.0086	6200969.0
2009-11-16	AABA-DELISTED	Stock	16.1	16.19	15.92	16.08	25790793.0
2009-11-16	AACC-DELISTED	Stock	5.25	5.41	5.14	5.28	60314.0
2009-11-16	AACG	Stock	4.31	4.48	4.3	4.47	11100.0
2009-11-16	AAI-DELISTED	Stock	4.51	4.58	4.49	4.5	2706637.0
2009-11-16	AAIC-DELISTED	Stock	12.81	13.1499	12.81	12.99	39853.0
2009-11-16	AAME	Stock	1.2	1.34	1.2	1.34	10600.0
2009-11-16	AAON	Stock	3.9605	4.0691	3.9526	4.0533	476887.0
2009-11-16	AAP	Stock	39.39	39.85	38.97	39.6	1976000.0
2009-11-16	AATI-DELISTED	Stock	3.21	3.24	3.06	3.1	774729.0
2009-11-16	AAU-DELISTED	Stock	0.72	0.76	0.72	0.73	221100.0
2009-11-16	AAUAF-DELISTED	Stock	0.72	0.76	0.72	0.73	230164.0
2009-11-16	AAV-DELISTED	Stock	6.26	6.38	6.16	6.31	906612.0
2009-11-16	AAWW-DELISTED	Stock	28.77	29.94	28.62	29.84	513703.0
2009-11-16	AAXJ	Stock	56.33	56.89	56.0	56.81	347854.0
2009-11-16	AAXN-DELISTED	Stock	4.19	4.35	4.1	4.35	491412.0
2009-11-16	AB	Stock	27.42	27.48	27.14	27.4	453800.0
2009-11-16	ABAX-DELISTED	Stock	22.89	23.98	22.851	23.81	101572.0
2009-11-16	ABB-DELISTED	Stock	19.44	19.85	19.43	19.65	5055902.0
2009-11-16	ABBC-DELISTED	Stock	6.89	7.11	6.82	7.11	51227.0
2009-11-16	ABBNY-DELISTED	Stock	19.44	19.85	19.43	19.64	5056837.0
2009-11-16	ABC-DELISTED	Stock	24.7	24.85	24.48	24.52	2742502.0
2009-11-16	ABCB	Stock	5.8318	5.9787	5.8318	5.9787	51116.0
2009-11-16	ABCO-DELISTED	Stock	13.135	13.37	13.0	13.315	97514.0
2009-11-16	ABCW-DELISTED	Stock	0.52	0.63	0.51	0.61	470400.0
2009-11-16	ABD-DELISTED	Stock	6.55	6.71	6.47	6.7	146920.0
2009-11-16	ABE-DELISTED	Stock	16.86	17.04	16.86	16.9901	7748.0
2009-11-16	ABEO	Stock	3937.5	3937.5	3775.0	3775.0	8.0
2009-11-16	ABFS-DELISTED	Stock	25.32	26.38	25.16	25.94	304559.0
2009-11-16	ABG	Stock	10.35	10.96	10.35	10.74	345500.0
2009-11-16	ABII-DELISTED	Stock	35.18	35.32	33.86	34.12	29383.0
2009-11-16	ABK-DELISTED	Stock	0.8	0.82	0.73	0.7446	14035796.0
2009-11-16	ABM	Stock	19.5	19.79	19.46	19.62	179000.0
2009-11-16	ABMD-DELISTED	Stock	9.0	9.12	8.94	9.0	152980.0
2009-11-16	ABR	Stock	1.95	2.05	1.87	1.89	111800.0
2009-11-16	ABT	Stock	25.6837	25.8564	25.4966	25.7317	14141100.0
2009-11-16	ABTL-DELISTED	Stock	4.05	4.15	4.0	4.0	5017.0
2009-11-16	ABV-DELISTED	Stock	98.92	101.24	98.42	101.02	1066728.0
2009-11-16	ABVT-DELISTED	Stock	54.78	56.93	54.455	56.9	123177.0
2009-11-16	ABX-DELISTED	Stock	43.83	44.46	43.28	44.03	12122880.0
2009-11-16	ACAD	Stock	1.43	1.47	1.4	1.45	253000.0
2009-11-16	ACAP-DELISTED	Stock	28.42	28.67	28.0	28.57	46955.0
2009-11-16	ACAS-DELISTED	Stock	2.87	2.93	2.85	2.89	3683099.0

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

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