PREVIEW / stock_daily / 2009-09-04

all stock daily files

  file:    by_date/stock_daily/2009/2009-09-04.parquet
  size:    183 KB
  rows:    5,765
  symbols: 3,418

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-09-04	AAPL	Stock	5.9743	6.0964	5.9675	6.0825	374628800.0
2009-09-04	MSFT	Stock	24.09	24.8	24.08	24.62	44999700.0
2009-09-04	NVDA	Stock	0.3628	0.3803	0.3628	0.3778	513048000.0
2009-09-04	AMZN	Stock	3.9135	3.989	3.8815	3.9435	93430000.0
2009-09-04	TLT	Stock	96.44	96.5992	95.06	95.21	3642929.0
2009-09-04	ES	Stock	23.64	23.83	23.56	23.72	483500.0
2009-09-04	CL	Stock	35.54	35.575	35.35	35.54	3965000.0
2009-09-04	A	Stock	18.1474	18.5408	17.99	18.4979	4551469.0
2009-09-04	AABA-DELISTED	Stock	14.26	14.64	14.2307	14.5	16460700.0
2009-09-04	AACC-DELISTED	Stock	7.05	7.44	6.96	7.185	48170.0
2009-09-04	AACG	Stock	7.17	7.29	6.6	6.7	22800.0
2009-09-04	AAI-DELISTED	Stock	6.42	6.58	6.4	6.55	849142.0
2009-09-04	AAIC-DELISTED	Stock	9.004	9.6	8.82	9.4	313784.0
2009-09-04	AAME	Stock	0.78	0.81	0.78	0.81	2500.0
2009-09-04	AAON	Stock	4.0435	4.0672	3.9704	4.0138	330581.0
2009-09-04	AAP	Stock	41.55	41.6	41.05	41.2	1606700.0
2009-09-04	AATI-DELISTED	Stock	4.39	4.45	4.36	4.41	87922.0
2009-09-04	AAU-DELISTED	Stock	0.76	0.77	0.72	0.7499	182559.0
2009-09-04	AAUAF-DELISTED	Stock	0.76	0.77	0.72	0.7499	182759.0
2009-09-04	AAV-DELISTED	Stock	5.57	5.86	5.4	5.84	1062857.0
2009-09-04	AAWW-DELISTED	Stock	23.5	24.48	23.32	24.46	218155.0
2009-09-04	AAXJ	Stock	49.79	50.11	49.41	50.11	44395.0
2009-09-04	AAXN-DELISTED	Stock	4.5	4.6	4.45	4.6	321518.0
2009-09-04	AB	Stock	22.18	22.65	21.96	22.58	461500.0
2009-09-04	ABAX-DELISTED	Stock	26.1	26.76	25.8	26.62	112291.0
2009-09-04	ABB-DELISTED	Stock	18.67	19.02	18.55	18.96	2127504.0
2009-09-04	ABBC-DELISTED	Stock	7.61	7.86	7.5	7.62	59170.0
2009-09-04	ABBNY-DELISTED	Stock	18.67	19.02	18.55	18.98	2129554.0
2009-09-04	ABC-DELISTED	Stock	21.09	21.29	21.08	21.28	1134783.0
2009-09-04	ABCB	Stock	6.186	6.2735	6.0401	6.2444	15422.0
2009-09-04	ABCO-DELISTED	Stock	13.44	13.6	13.081	13.54	106005.0
2009-09-04	ABCW-DELISTED	Stock	1.181	1.2395	1.181	1.22	25050.0
2009-09-04	ABD-DELISTED	Stock	5.58	5.83	5.37	5.69	212240.0
2009-09-04	ABE-DELISTED	Stock	16.49	16.73	16.3178	16.621	18424.0
2009-09-04	ABEO	Stock	4187.5	4562.5	4187.5	4500.0	6.0
2009-09-04	ABFS-DELISTED	Stock	32.05	32.74	31.98	32.57	302108.0
2009-09-04	ABG	Stock	12.48	12.7	12.15	12.55	143700.0
2009-09-04	ABII-DELISTED	Stock	25.5	26.26	24.904	25.95	86791.0
2009-09-04	ABK-DELISTED	Stock	1.61	1.74	1.59	1.67	25617788.0
2009-09-04	ABM	Stock	21.06	21.06	19.87	20.11	459100.0
2009-09-04	ABMD-DELISTED	Stock	7.79	7.87	7.6	7.84	119674.0
2009-09-04	ABR	Stock	1.95	1.97	1.84	1.88	70800.0
2009-09-04	ABT	Stock	21.663	21.9125	21.5382	21.8933	10668404.0
2009-09-04	ABTL-DELISTED	Stock	2.9475	3.0973	2.8525	2.8525	7737.0
2009-09-04	ABV-DELISTED	Stock	73.76	74.8687	73.67	74.42	332415.0
2009-09-04	ABVT-DELISTED	Stock	45.44	45.45	44.15	44.66	105042.0
2009-09-04	ABX-DELISTED	Stock	39.13	40.51	38.44	40.04	12684218.0
2009-09-04	ACAD	Stock	2.05	2.05	1.92	2.03	4069400.0
2009-09-04	ACAP-DELISTED	Stock	31.83	31.83	30.97	31.58	61687.0
2009-09-04	ACAS-DELISTED	Stock	2.19	2.21	2.08	2.2	5032405.0

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

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