PREVIEW / stock_daily / 2010-02-08

all stock daily files

  file:    by_date/stock_daily/2010/2010-02-08.parquet
  size:    186 KB
  rows:    5,857
  symbols: 3,456

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-08	AAPL	Stock	6.9889	7.0671	6.9286	6.9329	478270800.0
2010-02-08	MSFT	Stock	28.01	28.08	27.57	27.72	52820600.0
2010-02-08	NVDA	Stock	0.4043	0.4145	0.3968	0.4048	445160000.0
2010-02-08	AMZN	Stock	5.969	6.05	5.828	5.8415	197804000.0
2010-02-08	TLT	Stock	91.87	92.15	91.65	92.1	3385933.0
2010-02-08	ES	Stock	25.1	25.12	24.76	24.78	975600.0
2010-02-08	CL	Stock	39.765	39.895	39.475	39.545	3262400.0
2010-02-08	A	Stock	20.8941	21.2303	20.8369	20.887	6924154.0
2010-02-08	AABA-DELISTED	Stock	15.21	15.47	14.95	14.99	19752232.0
2010-02-08	AACC-DELISTED	Stock	5.52	5.53	5.39	5.45	22145.0
2010-02-08	AACG	Stock	3.51	3.85	3.51	3.67	10100.0
2010-02-08	AAI-DELISTED	Stock	4.63	4.67	4.52	4.52	2216798.0
2010-02-08	AAIC-DELISTED	Stock	14.92	15.43	14.68	15.43	7098.0
2010-02-08	AAME	Stock	1.38	1.44	1.36	1.44	12100.0
2010-02-08	AAON	Stock	4.1323	4.1323	4.0711	4.0849	254137.0
2010-02-08	AAP	Stock	41.01	41.74	40.62	40.81	1721900.0
2010-02-08	AATI-DELISTED	Stock	3.47	3.47	3.31	3.37	246289.0
2010-02-08	AAU-DELISTED	Stock	0.97	0.97	0.91	0.91	89548.0
2010-02-08	AAUAF-DELISTED	Stock	0.97	0.97	0.91	0.91	98548.0
2010-02-08	AAV-DELISTED	Stock	6.42	6.57	6.3	6.4999	532941.0
2010-02-08	AAWW-DELISTED	Stock	37.92	39.0	37.57	38.57	203540.0
2010-02-08	AAXJ	Stock	50.5	50.65	49.82	49.82	174048.0
2010-02-08	AAXN-DELISTED	Stock	5.49	5.67	5.47	5.51	387635.0
2010-02-08	AB	Stock	25.7	25.7	25.05	25.12	277300.0
2010-02-08	ABAX-DELISTED	Stock	22.96	23.15	22.71	23.0	61773.0
2010-02-08	ABB-DELISTED	Stock	17.62	17.66	17.31	17.32	2016607.0
2010-02-08	ABBC-DELISTED	Stock	7.32	7.4799	7.2	7.22	53746.0
2010-02-08	ABBNY-DELISTED	Stock	17.62	17.66	17.3	17.3	2017988.0
2010-02-08	ABC-DELISTED	Stock	27.03	27.19	26.82	26.94	2778772.0
2010-02-08	ABCB	Stock	9.2544	9.2544	9.1359	9.1359	32805.0
2010-02-08	ABCD-DELISTED	Stock	3.66	3.71	3.62	3.66	10455.0
2010-02-08	ABCO-DELISTED	Stock	16.503	16.528	16.007	16.007	88375.0
2010-02-08	ABCW-DELISTED	Stock	1.1093	1.2001	1.069	1.19	152850.0
2010-02-08	ABD-DELISTED	Stock	7.155	7.305	6.9701	6.9851	392190.0
2010-02-08	ABE-DELISTED	Stock	15.48	15.795	15.411	15.48	18491.0
2010-02-08	ABEO	Stock	3462.5	3562.5	3437.5	3437.5	15.0
2010-02-08	ABFS-DELISTED	Stock	22.47	22.76	21.5	21.62	452699.0
2010-02-08	ABG	Stock	11.31	11.44	10.95	10.96	246000.0
2010-02-08	ABII-DELISTED	Stock	38.95	38.9985	38.11	38.4	56932.0
2010-02-08	ABK-DELISTED	Stock	0.6601	0.67	0.6351	0.64	3362603.0
2010-02-08	ABM	Stock	19.69	19.69	19.23	19.25	94700.0
2010-02-08	ABMD-DELISTED	Stock	8.4	8.92	8.2915	8.87	512453.0
2010-02-08	ABR	Stock	2.18	2.22	2.09	2.17	35300.0
2010-02-08	ABT	Stock	25.8372	25.8852	25.5781	25.5973	14861192.0
2010-02-08	ABTL-DELISTED	Stock	5.6	5.7455	5.4005	5.5	13014.0
2010-02-08	ABV-DELISTED	Stock	91.25	91.25	88.89	89.02	329033.0
2010-02-08	ABVA-DELISTED	Stock	2.62	2.8499	2.62	2.84	1079.0
2010-02-08	ABVT-DELISTED	Stock	56.8	57.0	55.88	55.88	60965.0
2010-02-08	ABX-DELISTED	Stock	35.73	35.94	34.544	34.584	10307813.0
2010-02-08	ACAD	Stock	1.38	1.42	1.24	1.27	981200.0

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

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