PREVIEW / stock_daily / 2009-02-19

all stock daily files

  file:    by_date/stock_daily/2009/2009-02-19.parquet
  size:    175 KB
  rows:    5,743
  symbols: 3,435

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-02-19	AAPL	Stock	3.3346	3.3661	3.2182	3.2371	922804400.0
2009-02-19	MSFT	Stock	18.3	18.38	17.81	17.91	49195600.0
2009-02-19	NVDA	Stock	0.205	0.2068	0.1855	0.1855	743988000.0
2009-02-19	AMZN	Stock	3.142	3.209	3.0835	3.0975	135378000.0
2009-02-19	TLT	Stock	102.69	104.06	102.23	102.92	3220161.0
2009-02-19	CL	Stock	30.64	30.87	30.23	30.36	4831800.0
2009-02-19	A	Stock	11.5165	11.5808	11.0873	11.1302	7898281.0
2009-02-19	AABA-DELISTED	Stock	12.43	12.59	11.93	11.98	12276633.0
2009-02-19	AACC-DELISTED	Stock	4.0	4.32	3.72	3.82	118406.0
2009-02-19	AACG	Stock	4.26	4.48	3.95	4.48	7000.0
2009-02-19	AAI-DELISTED	Stock	4.18	4.23	3.81	3.83	1947391.0
2009-02-19	AAIC-DELISTED	Stock	4.0	4.2	3.4	3.4	239530.0
2009-02-19	AAME	Stock	0.88	0.88	0.66	0.87	18000.0
2009-02-19	AAON	Stock	3.1605	3.2277	3.1032	3.2059	374119.0
2009-02-19	AAP	Stock	36.37	37.93	36.26	37.0	9416800.0
2009-02-19	AATI-DELISTED	Stock	3.19	3.2	2.82	2.89	152310.0
2009-02-19	AAU-DELISTED	Stock	0.9	0.91	0.86	0.89	93000.0
2009-02-19	AAUAF-DELISTED	Stock	0.9	0.91	0.86	0.89	93500.0
2009-02-19	AAV-DELISTED	Stock	2.64	2.68	2.53	2.59	1037655.0
2009-02-19	AAWW-DELISTED	Stock	14.17	14.86	13.97	14.27	175955.0
2009-02-19	AAXJ	Stock	30.3	30.3	29.36	29.41	436032.0
2009-02-19	AAXN-DELISTED	Stock	4.69	4.76	4.51	4.58	423291.0
2009-02-19	AB	Stock	14.17	14.3	12.89	13.0	623200.0
2009-02-19	ABAX-DELISTED	Stock	17.65	17.94	17.115	17.58	175636.0
2009-02-19	ABB-DELISTED	Stock	12.44	12.5	11.9	11.94	7486076.0
2009-02-19	ABBC-DELISTED	Stock	6.76	6.79	6.545	6.61	131751.0
2009-02-19	ABBNY-DELISTED	Stock	12.4	12.5	11.9	11.95	7490006.0
2009-02-19	ABC-DELISTED	Stock	18.1	18.16	17.68	17.75	4334598.0
2009-02-19	ABCB	Stock	5.369	6.5264	5.3203	5.5538	55108.0
2009-02-19	ABCO-DELISTED	Stock	8.005	8.295	8.005	8.24	371304.0
2009-02-19	ABCW-DELISTED	Stock	1.08	1.25	1.0	1.01	269050.0
2009-02-19	ABD-DELISTED	Stock	1.35	1.38	1.1491	1.17	112220.0
2009-02-19	ABE-DELISTED	Stock	11.75	11.95	11.55	11.75	29693.0
2009-02-19	ABEO	Stock	1250.0	1375.0	1087.5	1250.0	10.0
2009-02-19	ABFS-DELISTED	Stock	21.13	21.97	20.6	20.75	381021.0
2009-02-19	ABG	Stock	3.21	3.46	3.06	3.41	223600.0
2009-02-19	ABII-DELISTED	Stock	72.25	73.49	71.53	72.93	18285.0
2009-02-19	ABK-DELISTED	Stock	1.29	1.31	1.1	1.1	10759262.0
2009-02-19	ABM	Stock	12.71	12.86	12.48	12.48	377400.0
2009-02-19	ABMD-DELISTED	Stock	8.27	8.4	7.91	7.96	287922.0
2009-02-19	ABR	Stock	1.25	1.25	0.85	0.95	758100.0
2009-02-19	ABT	Stock	25.7365	26.293	25.7365	26.1299	14768862.0
2009-02-19	ABTL-DELISTED	Stock	1.75	2.2	1.705	2.1	8316.0
2009-02-19	ABV-DELISTED	Stock	43.06	43.21	41.56	41.91	546264.0
2009-02-19	ABVA-DELISTED	Stock	2.94	2.95	1.54	2.47	9657.0
2009-02-19	ABVT-DELISTED	Stock	47.0	47.0	47.0	47.0	100.0
2009-02-19	ABX-DELISTED	Stock	37.95	38.61	36.25	36.45	14417907.0
2009-02-19	ACAD	Stock	0.88	0.92	0.82	0.83	77000.0
2009-02-19	ACAP-DELISTED	Stock	47.06	47.2	45.63	46.13	26504.0
2009-02-19	ACAS-DELISTED	Stock	1.74	1.86	1.51	1.55	4496818.0

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

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