PREVIEW / stock_daily / 2010-02-05

all stock daily files

  file:    by_date/stock_daily/2010/2010-02-05.parquet
  size:    188 KB
  rows:    5,897
  symbols: 3,486

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-05	AAPL	Stock	6.8796	7.0	6.8161	6.9807	850306800.0
2010-02-05	MSFT	Stock	28.0	28.28	27.57	28.02	80960100.0
2010-02-05	NVDA	Stock	0.397	0.4065	0.39	0.4055	604856000.0
2010-02-05	AMZN	Stock	5.794	5.8825	5.705	5.8695	220496000.0
2010-02-05	TLT	Stock	91.37	92.42	91.2095	91.98	6876508.0
2010-02-05	ES	Stock	25.25	25.29	24.75	25.14	1390500.0
2010-02-05	CL	Stock	39.82	40.025	39.035	39.63	6091800.0
2010-02-05	A	Stock	20.6795	20.9299	20.1574	20.8655	9546662.0
2010-02-05	AABA-DELISTED	Stock	15.08	15.25	14.92	15.19	20547787.0
2010-02-05	AACC-DELISTED	Stock	5.25	5.54	5.14	5.51	20189.0
2010-02-05	AACG	Stock	3.36	3.58	3.36	3.49	10700.0
2010-02-05	AAI-DELISTED	Stock	4.67	4.67	4.42	4.65	3746493.0
2010-02-05	AAIC-DELISTED	Stock	15.43	15.58	14.91	14.9542	12102.0
2010-02-05	AAME	Stock	1.35	1.39	1.3	1.39	19600.0
2010-02-05	AAON	Stock	4.079	4.16	3.9901	4.1323	409050.0
2010-02-05	AAP	Stock	41.01	41.13	40.02	40.72	1313200.0
2010-02-05	AATI-DELISTED	Stock	3.37	3.51	3.15	3.47	666109.0
2010-02-05	AAU-DELISTED	Stock	0.87	0.94	0.85	0.94	253083.0
2010-02-05	AAUAF-DELISTED	Stock	0.87	0.94	0.85	0.94	254183.0
2010-02-05	AAV-DELISTED	Stock	6.32	6.42	6.07	6.38	901430.0
2010-02-05	AAWW-DELISTED	Stock	38.37	39.02	37.53	38.08	432107.0
2010-02-05	AAXJ	Stock	50.91	50.91	49.25	50.29	552425.0
2010-02-05	AAXN-DELISTED	Stock	5.62	5.65	5.33	5.47	928180.0
2010-02-05	AB	Stock	25.81	25.81	25.0	25.73	659500.0
2010-02-05	ABAX-DELISTED	Stock	23.25	23.27	22.59	23.02	122565.0
2010-02-05	ABB-DELISTED	Stock	17.77	17.83	17.08	17.57	5854286.0
2010-02-05	ABBC-DELISTED	Stock	7.09	7.45	7.09	7.35	127358.0
2010-02-05	ABBNY-DELISTED	Stock	17.77	17.83	17.08	17.57	5869776.0
2010-02-05	ABC-DELISTED	Stock	27.37	27.4	26.65	27.0	5469883.0
2010-02-05	ABCB	Stock	9.2742	9.3137	9.0865	9.2446	44752.0
2010-02-05	ABCD-DELISTED	Stock	3.55	3.63	3.507	3.62	11157.0
2010-02-05	ABCO-DELISTED	Stock	15.89	16.56	15.63	16.45	365858.0
2010-02-05	ABCW-DELISTED	Stock	1.04	1.11	1.01	1.06	226560.0
2010-02-05	ABD-DELISTED	Stock	7.25	7.26	6.89	7.19	419690.0
2010-02-05	ABE-DELISTED	Stock	15.65	15.65	15.21	15.52	31353.0
2010-02-05	ABEO	Stock	3375.0	3437.5	3312.5	3437.5	16.0
2010-02-05	ABFS-DELISTED	Stock	21.73	22.65	21.5	22.29	821900.0
2010-02-05	ABG	Stock	11.4	11.42	10.93	11.34	420400.0
2010-02-05	ABII-DELISTED	Stock	40.06	40.06	38.1	39.18	76723.0
2010-02-05	ABK-DELISTED	Stock	0.66	0.68	0.6386	0.65	5539696.0
2010-02-05	ABM	Stock	19.36	19.67	19.25	19.65	167300.0
2010-02-05	ABMD-DELISTED	Stock	8.31	8.45	8.2	8.43	205982.0
2010-02-05	ABR	Stock	2.11	2.22	2.08	2.17	95300.0
2010-02-05	ABT	Stock	25.7317	25.9716	25.5733	25.8948	22546061.0
2010-02-05	ABTL-DELISTED	Stock	5.25	5.8	5.15	5.5	9162.0
2010-02-05	ABV-DELISTED	Stock	92.31	92.39	87.63	90.5	1110356.0
2010-02-05	ABVA-DELISTED	Stock	2.6	3.17	2.6	3.17	6340.0
2010-02-05	ABVT-DELISTED	Stock	56.73	56.89	54.66	56.74	121648.0
2010-02-05	ABX-DELISTED	Stock	33.88	35.93	33.63	35.87	19926235.0
2010-02-05	ACAD	Stock	1.33	1.38	1.3	1.38	352100.0

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

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