PREVIEW / stock_daily / 2009-12-02

all stock daily files

  file:    by_date/stock_daily/2009/2009-12-02.parquet
  size:    186 KB
  rows:    5,886
  symbols: 3,487

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-12-02	AAPL	Stock	7.1057	7.1936	6.9911	7.0082	715260000.0
2009-12-02	MSFT	Stock	29.9	29.99	29.65	29.78	36308600.0
2009-12-02	NVDA	Stock	0.3338	0.3438	0.3318	0.343	602292000.0
2009-12-02	AMZN	Stock	6.9575	7.1335	6.948	7.1125	235960000.0
2009-12-02	TLT	Stock	95.29	95.96	94.99	95.33	2193898.0
2009-12-02	ES	Stock	24.25	24.6	24.16	24.57	1514000.0
2009-12-02	CL	Stock	42.935	43.295	42.675	43.16	6133000.0
2009-12-02	A	Stock	21.1016	21.2375	20.9943	21.0944	3675901.0
2009-12-02	AABA-DELISTED	Stock	15.17	15.5	15.16	15.31	17513375.0
2009-12-02	AACC-DELISTED	Stock	5.7	5.95	5.6819	5.94	22893.0
2009-12-02	AACG	Stock	5.24	5.24	5.05	5.05	6000.0
2009-12-02	AAI-DELISTED	Stock	4.54	4.99	4.53	4.96	9567539.0
2009-12-02	AAIC-DELISTED	Stock	13.34	13.77	13.31	13.52	107222.0
2009-12-02	AAON	Stock	3.7728	3.9249	3.7728	3.8775	664200.0
2009-12-02	AAP	Stock	40.32	40.79	40.15	40.61	1105100.0
2009-12-02	AATI-DELISTED	Stock	3.29	3.4	3.26	3.39	144391.0
2009-12-02	AAU-DELISTED	Stock	0.9	0.99	0.85	0.97	1017799.0
2009-12-02	AAUAF-DELISTED	Stock	0.9	0.99	0.85	0.96	1029499.0
2009-12-02	AAV-DELISTED	Stock	5.97	6.06	5.86	5.86	646341.0
2009-12-02	AAWW-DELISTED	Stock	30.82	31.78	30.82	31.57	430612.0
2009-12-02	AAXJ	Stock	56.06	56.45	55.97	56.32	133451.0
2009-12-02	AAXN-DELISTED	Stock	4.27	4.3	4.0	4.25	190108.0
2009-12-02	AB	Stock	25.83	26.44	25.59	26.32	317000.0
2009-12-02	ABAX-DELISTED	Stock	22.82	23.87	22.82	23.33	91658.0
2009-12-02	ABB-DELISTED	Stock	18.8	18.945	18.7	18.86	3275776.0
2009-12-02	ABBC-DELISTED	Stock	7.01	7.01	6.83	6.88	36590.0
2009-12-02	ABBNY-DELISTED	Stock	18.8	18.945	18.7	18.83	3278726.0
2009-12-02	ABC-DELISTED	Stock	24.51	24.93	24.51	24.74	3207102.0
2009-12-02	ABCB	Stock	6.6158	6.8217	6.557	6.8119	22242.0
2009-12-02	ABCO-DELISTED	Stock	13.228	13.603	13.127	13.197	134506.0
2009-12-02	ABCW-DELISTED	Stock	0.65	0.74	0.61	0.71	1543030.0
2009-12-02	ABD-DELISTED	Stock	6.76	7.2	6.66	6.78	290910.0
2009-12-02	ABE-DELISTED	Stock	16.9	16.99	16.89	16.92	4178.0
2009-12-02	ABEO	Stock	3587.5	3812.5	3587.5	3712.5	9.0
2009-12-02	ABFS-DELISTED	Stock	25.54	26.7	25.54	26.58	518848.0
2009-12-02	ABG	Stock	11.05	11.44	10.89	11.05	239700.0
2009-12-02	ABII-DELISTED	Stock	34.82	36.9	34.82	36.45	47399.0
2009-12-02	ABK-DELISTED	Stock	0.8101	0.82	0.78	0.8	5191356.0
2009-12-02	ABM	Stock	18.61	19.23	18.58	19.21	155000.0
2009-12-02	ABMD-DELISTED	Stock	8.77	9.0	8.77	8.96	79391.0
2009-12-02	ABR	Stock	1.75	1.79	1.69	1.77	198600.0
2009-12-02	ABT	Stock	26.1443	26.3746	26.0244	26.1203	11586078.0
2009-12-02	ABTL-DELISTED	Stock	4.75	4.8	4.5	4.7	9751.0
2009-12-02	ABV-DELISTED	Stock	99.45	101.12	99.34	99.6	468499.0
2009-12-02	ABVA-DELISTED	Stock	2.57	2.6799	2.2	2.2	2910.0
2009-12-02	ABVT-DELISTED	Stock	54.0	54.7	53.77	53.95	99423.0
2009-12-02	ABX-DELISTED	Stock	46.58	47.995	46.46	47.9746	21850093.0
2009-12-02	ACAD	Stock	1.19	1.23	1.18	1.21	282700.0
2009-12-02	ACAP-DELISTED	Stock	27.49	28.89	27.49	28.11	67579.0
2009-12-02	ACAS-DELISTED	Stock	2.88	2.94	2.85	2.91	4105466.0

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

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