PREVIEW / stock_daily / 2010-02-09

all stock daily files

  file:    by_date/stock_daily/2010/2010-02-09.parquet
  size:    188 KB
  rows:    5,896
  symbols: 3,483

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
2010-02-09	AAPL	Stock	7.015	7.0536	6.9554	7.0068	632886800.0
2010-02-09	MSFT	Stock	27.97	28.34	27.75	28.01	59195800.0
2010-02-09	NVDA	Stock	0.4112	0.4133	0.3975	0.4015	930144000.0
2010-02-09	AMZN	Stock	5.91	5.9545	5.85	5.9015	184460000.0
2010-02-09	TLT	Stock	91.74	92.22	91.14	91.18	4789948.0
2010-02-09	ES	Stock	24.97	25.24	24.86	25.04	926500.0
2010-02-09	CL	Stock	39.755	40.3	39.55	40.085	4059600.0
2010-02-09	A	Stock	21.123	21.2589	20.8727	21.0372	5150651.0
2010-02-09	AABA-DELISTED	Stock	15.2	15.24	14.94	15.08	16579882.0
2010-02-09	AACC-DELISTED	Stock	5.56	5.68	5.42	5.55	24718.0
2010-02-09	AACG	Stock	3.7	3.91	3.55	3.65	25900.0
2010-02-09	AAI-DELISTED	Stock	4.6	4.94	4.59	4.88	5025728.0
2010-02-09	AAIC-DELISTED	Stock	15.58	15.58	14.7544	14.8548	21789.0
2010-02-09	AAME	Stock	1.36	1.4	1.35	1.4	6800.0
2010-02-09	AAON	Stock	4.1442	4.1481	4.0533	4.1383	313875.0
2010-02-09	AAP	Stock	41.15	41.72	40.77	41.57	1030000.0
2010-02-09	AATI-DELISTED	Stock	3.42	3.47	3.25	3.33	583500.0
2010-02-09	AAU-DELISTED	Stock	0.9	0.9523	0.89	0.95	64664.0
2010-02-09	AAUAF-DELISTED	Stock	0.9	0.9522	0.89	0.9499	65080.0
2010-02-09	AAV-DELISTED	Stock	6.54	6.75	6.4801	6.75	751584.0
2010-02-09	AAWW-DELISTED	Stock	39.16	39.96	37.92	38.75	309567.0
2010-02-09	AAXJ	Stock	51.07	51.698	50.79	51.31	657601.0
2010-02-09	AAXN-DELISTED	Stock	5.57	5.71	5.549	5.66	411912.0
2010-02-09	AB	Stock	25.45	25.63	24.94	25.07	613300.0
2010-02-09	ABAX-DELISTED	Stock	23.13	23.28	22.91	23.21	122729.0
2010-02-09	ABB-DELISTED	Stock	17.89	18.23	17.59	17.98	4881600.0
2010-02-09	ABBC-DELISTED	Stock	7.32	7.32	7.2	7.21	22923.0
2010-02-09	ABBNY-DELISTED	Stock	17.89	18.23	17.59	17.97	4882725.0
2010-02-09	ABC-DELISTED	Stock	27.18	27.4	27.0	27.15	2161872.0
2010-02-09	ABCB	Stock	9.3137	9.3137	9.1359	9.1852	22579.0
2010-02-09	ABCD-DELISTED	Stock	3.65	3.65	3.55	3.57	30790.0
2010-02-09	ABCO-DELISTED	Stock	16.023	16.078	15.912	15.942	255169.0
2010-02-09	ABCW-DELISTED	Stock	1.149	1.149	1.1103	1.12	87810.0
2010-02-09	ABD-DELISTED	Stock	7.105	7.165	6.9449	7.135	387480.0
2010-02-09	ABE-DELISTED	Stock	15.6	15.91	15.6	15.81	25153.0
2010-02-09	ABEO	Stock	3437.5	3437.5	3375.0	3437.5	11.0
2010-02-09	ABFS-DELISTED	Stock	21.96	22.49	21.6	21.98	359371.0
2010-02-09	ABG	Stock	11.2	11.29	10.8	11.0	476100.0
2010-02-09	ABII-DELISTED	Stock	38.41	38.63	34.8	35.22	165154.0
2010-02-09	ABK-DELISTED	Stock	0.6588	0.66	0.6182	0.62	6591837.0
2010-02-09	ABM	Stock	19.44	19.6	19.25	19.36	956900.0
2010-02-09	ABMD-DELISTED	Stock	8.97	9.35	8.91	9.34	478829.0
2010-02-09	ABR	Stock	2.17	2.27	2.12	2.25	45700.0
2010-02-09	ABT	Stock	25.7365	25.8996	25.5925	25.5973	23229471.0
2010-02-09	ABTL-DELISTED	Stock	5.7	5.7	5.45	5.5	47780.0
2010-02-09	ABV-DELISTED	Stock	91.41	92.98	90.76	91.09	579674.0
2010-02-09	ABVA-DELISTED	Stock	2.62	2.899	2.61	2.61	2500.0
2010-02-09	ABVT-DELISTED	Stock	56.39	57.42	56.23	57.03	91802.0
2010-02-09	ABX-DELISTED	Stock	35.25	36.15	34.93	35.73	13775007.0
2010-02-09	ACAD	Stock	1.28	1.32	1.25	1.3	383100.0

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

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