PREVIEW / stock_daily / 2010-02-02

all stock daily files

  file:    by_date/stock_daily/2010/2010-02-02.parquet
  size:    188 KB
  rows:    5,899
  symbols: 3,489

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-02	AAPL	Stock	6.9968	7.0114	6.9064	6.995	698342400.0
2010-02-02	MSFT	Stock	28.37	28.5	28.14	28.46	54413700.0
2010-02-02	NVDA	Stock	0.4128	0.4238	0.4115	0.4185	849812000.0
2010-02-02	AMZN	Stock	5.9395	5.949	5.72	5.906	461594000.0
2010-02-02	TLT	Stock	91.18	91.45	91.04	91.41	3047441.0
2010-02-02	ES	Stock	25.57	26.0	25.35	25.99	1349600.0
2010-02-02	CL	Stock	39.92	40.535	39.74	40.525	5937400.0
2010-02-02	A	Stock	20.9013	21.166	20.8083	21.1016	5884741.0
2010-02-02	AABA-DELISTED	Stock	15.1	15.32	15.03	15.15	26830953.0
2010-02-02	AACC-DELISTED	Stock	6.18	6.18	5.78	5.78	32608.0
2010-02-02	AACG	Stock	3.41	3.65	3.4	3.6	17100.0
2010-02-02	AAI-DELISTED	Stock	4.94	4.96	4.85	4.94	3370178.0
2010-02-02	AAIC-DELISTED	Stock	15.15	15.24	15.09	15.24	6850.0
2010-02-02	AAME	Stock	1.38	1.39	1.38	1.39	3000.0
2010-02-02	AAON	Stock	4.0751	4.16	4.0751	4.1343	350325.0
2010-02-02	AAP	Stock	40.46	41.35	40.46	41.19	1296200.0
2010-02-02	AATI-DELISTED	Stock	3.48	3.57	3.36	3.36	133637.0
2010-02-02	AAU-DELISTED	Stock	0.99	1.02	0.99	1.01	192182.0
2010-02-02	AAUAF-DELISTED	Stock	0.99	1.02	0.99	1.01	192782.0
2010-02-02	AAV-DELISTED	Stock	6.49	6.7	6.49	6.61	624451.0
2010-02-02	AAWW-DELISTED	Stock	37.53	38.56	37.53	38.34	223726.0
2010-02-02	AAXJ	Stock	53.03	53.7	52.5981	53.42	714441.0
2010-02-02	AAXN-DELISTED	Stock	5.91	5.98	5.8333	5.97	502768.0
2010-02-02	AB	Stock	26.44	27.18	26.44	27.15	327700.0
2010-02-02	ABAX-DELISTED	Stock	23.71	24.14	23.6	23.99	154298.0
2010-02-02	ABB-DELISTED	Stock	18.74	19.01	18.66	18.91	2634384.0
2010-02-02	ABBC-DELISTED	Stock	7.14	7.18	7.1	7.1	41928.0
2010-02-02	ABBNY-DELISTED	Stock	18.74	19.01	18.66	18.95	2635134.0
2010-02-02	ABC-DELISTED	Stock	27.8	28.61	27.66	28.55	6005861.0
2010-02-02	ABCB	Stock	9.2742	9.2742	9.0964	9.1359	110868.0
2010-02-02	ABCD-DELISTED	Stock	3.77	3.8299	3.75	3.77	17815.0
2010-02-02	ABCO-DELISTED	Stock	16.11	16.5	16.065	16.225	120046.0
2010-02-02	ABCW-DELISTED	Stock	1.29	1.29	1.14	1.15	271570.0
2010-02-02	ABD-DELISTED	Stock	7.84	7.89	7.63	7.73	433790.0
2010-02-02	ABE-DELISTED	Stock	16.05	16.35	16.05	16.35	12549.0
2010-02-02	ABEO	Stock	3437.5	3512.5	3250.0	3437.5	19.0
2010-02-02	ABFS-DELISTED	Stock	22.45	23.07	22.29	22.5	792440.0
2010-02-02	ABG	Stock	11.79	12.18	11.57	12.1	292600.0
2010-02-02	ABII-DELISTED	Stock	41.0	41.61	40.75	41.19	107672.0
2010-02-02	ABK-DELISTED	Stock	0.73	0.74	0.69	0.73	5526449.0
2010-02-02	ABM	Stock	19.55	19.7	19.44	19.51	132200.0
2010-02-02	ABMD-DELISTED	Stock	7.92	8.09	7.9	8.03	250614.0
2010-02-02	ABR	Stock	2.01	2.17	1.98	2.14	152100.0
2010-02-02	ABT	Stock	25.5685	26.1971	25.5254	26.1203	17214256.0
2010-02-02	ABTL-DELISTED	Stock	5.45	5.45	5.204	5.4	11480.0
2010-02-02	ABV-DELISTED	Stock	96.8	98.01	95.5	97.68	366213.0
2010-02-02	ABVA-DELISTED	Stock	2.99	2.99	2.99	2.99	200.0
2010-02-02	ABVT-DELISTED	Stock	60.4	60.61	58.98	59.3	118196.0
2010-02-02	ABX-DELISTED	Stock	37.01	37.03	36.09	36.17	11247743.0
2010-02-02	ACAD	Stock	1.32	1.41	1.29	1.4	596800.0

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

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