PREVIEW / stock_daily / 2009-03-02

all stock daily files

  file:    by_date/stock_daily/2009/2009-03-02.parquet
  size:    174 KB
  rows:    5,779
  symbols: 3,458

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-03-02	AAPL	Stock	3.1471	3.2571	3.1311	3.1407	770929600.0
2009-03-02	MSFT	Stock	15.96	16.25	15.72	15.79	80602100.0
2009-03-02	NVDA	Stock	0.202	0.2062	0.1888	0.1895	700064000.0
2009-03-02	AMZN	Stock	3.197	3.276	3.0755	3.0995	210238000.0
2009-03-02	TLT	Stock	102.22	103.28	102.09	103.28	3301952.0
2009-03-02	CL	Stock	29.745	29.77	29.02	29.07	8626600.0
2009-03-02	A	Stock	9.7282	9.7997	9.02	9.0701	5994904.0
2009-03-02	AABA-DELISTED	Stock	12.85	12.97	12.47	12.59	20778936.0
2009-03-02	AACC-DELISTED	Stock	3.24	3.34	3.24	3.3	64862.0
2009-03-02	AACG	Stock	5.1	5.36	5.1	5.18	9900.0
2009-03-02	AAI-DELISTED	Stock	2.91	2.98	2.54	2.54	2843493.0
2009-03-02	AAIC-DELISTED	Stock	3.0	3.0	2.2	2.2	819175.0
2009-03-02	AAME	Stock	0.66	0.67	0.61	0.64	1500.0
2009-03-02	AAON	Stock	3.0202	3.1012	2.9077	2.9254	345769.0
2009-03-02	AAP	Stock	37.69	38.56	36.12	36.31	2624400.0
2009-03-02	AATI-DELISTED	Stock	2.95	3.18	2.94	2.94	122163.0
2009-03-02	AAU-DELISTED	Stock	0.73	0.76	0.73	0.75	36012.0
2009-03-02	AAUAF-DELISTED	Stock	0.73	0.76	0.73	0.75	36212.0
2009-03-02	AAV-DELISTED	Stock	2.27	2.27	1.93	1.95	1278768.0
2009-03-02	AAWW-DELISTED	Stock	13.75	13.75	12.25	12.37	217328.0
2009-03-02	AAXJ	Stock	28.83	28.83	26.69	26.7	96106.0
2009-03-02	AAXN-DELISTED	Stock	4.1	4.13	3.6	3.62	734804.0
2009-03-02	AB	Stock	11.71	11.88	11.06	11.24	560000.0
2009-03-02	ABAX-DELISTED	Stock	15.52	15.76	14.14	14.66	416378.0
2009-03-02	ABB-DELISTED	Stock	11.48	11.569	10.88	10.96	6050574.0
2009-03-02	ABBC-DELISTED	Stock	7.26	7.3	6.94	6.97	90898.0
2009-03-02	ABBNY-DELISTED	Stock	11.49	11.569	10.88	10.97	6144054.0
2009-03-02	ABC-DELISTED	Stock	15.64	15.86	15.22	15.28	4441588.0
2009-03-02	ABCB	Stock	4.6978	4.7367	4.5033	4.5033	23544.0
2009-03-02	ABCO-DELISTED	Stock	7.445	7.445	7.16	7.22	357344.0
2009-03-02	ABCW-DELISTED	Stock	0.7	0.78	0.62	0.63	283180.0
2009-03-02	ABD-DELISTED	Stock	1.0	1.64	0.99	1.52	539510.0
2009-03-02	ABE-DELISTED	Stock	10.5	10.52	10.13	10.33	82654.0
2009-03-02	ABEO	Stock	1437.5	1437.5	1262.5	1437.5	9.0
2009-03-02	ABFS-DELISTED	Stock	17.08	17.49	15.84	16.34	770387.0
2009-03-02	ABG	Stock	2.78	2.95	2.7	2.72	245000.0
2009-03-02	ABII-DELISTED	Stock	58.0	68.29	58.0	59.02	38592.0
2009-03-02	ABK-DELISTED	Stock	0.59	0.65	0.56	0.6	8563176.0
2009-03-02	ABM	Stock	11.9	12.15	11.78	11.79	473800.0
2009-03-02	ABMD-DELISTED	Stock	6.69	6.69	6.0	6.02	466226.0
2009-03-02	ABR	Stock	0.6	0.62	0.56	0.58	136400.0
2009-03-02	ABT	Stock	22.4019	22.7425	21.7781	22.5698	33721134.0
2009-03-02	ABTL-DELISTED	Stock	2.1067	2.1067	1.8057	1.8433	4060.0
2009-03-02	ABV-DELISTED	Stock	39.45	39.68	36.87	37.06	1242457.0
2009-03-02	ABVA-DELISTED	Stock	1.42	1.5	1.42	1.5	1200.0
2009-03-02	ABVT-DELISTED	Stock	38.0	38.0	38.0	38.0	100.0
2009-03-02	ABX-DELISTED	Stock	30.65	30.89	27.74	28.01	25398433.0
2009-03-02	ACAD	Stock	0.81	0.93	0.76	0.77	73700.0
2009-03-02	ACAP-DELISTED	Stock	41.98	43.11	40.87	41.27	55587.0
2009-03-02	ACAS-DELISTED	Stock	1.14	1.28	0.969	1.19	7313991.0

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

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