PREVIEW / stock_daily / 2009-12-01

all stock daily files

  file:    by_date/stock_daily/2009/2009-12-01.parquet
  size:    188 KB
  rows:    5,901
  symbols: 3,500

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-01	AAPL	Stock	7.2229	7.2418	7.0296	7.0346	465763200.0
2009-12-01	MSFT	Stock	29.52	30.05	29.41	30.01	49904200.0
2009-12-01	NVDA	Stock	0.3283	0.3368	0.3265	0.333	461936000.0
2009-12-01	AMZN	Stock	6.847	6.9675	6.7875	6.925	193152000.0
2009-12-01	TLT	Stock	95.76	95.93	95.19	95.25	3979501.0
2009-12-01	ES	Stock	24.27	24.41	24.21	24.35	1353800.0
2009-12-01	CL	Stock	42.095	42.995	42.075	42.875	6139800.0
2009-12-01	A	Stock	20.8155	21.0944	20.8011	21.0587	3171503.0
2009-12-01	AABA-DELISTED	Stock	15.02	15.19	14.85	15.14	16891810.0
2009-12-01	AACC-DELISTED	Stock	5.89	5.89	5.62	5.72	78348.0
2009-12-01	AACG	Stock	5.17	5.26	5.0	5.24	640600.0
2009-12-01	AAI-DELISTED	Stock	4.23	4.49	4.2	4.46	10949082.0
2009-12-01	AAIC-DELISTED	Stock	13.5	13.5	13.07	13.43	30665.0
2009-12-01	AAME	Stock	1.25	1.25	1.25	1.25	3900.0
2009-12-01	AAON	Stock	3.7748	3.8341	3.6721	3.763	956812.0
2009-12-01	AAP	Stock	39.42	40.73	39.38	40.38	2087300.0
2009-12-01	AATI-DELISTED	Stock	3.24	3.3	3.18	3.28	207445.0
2009-12-01	AAU-DELISTED	Stock	0.76	0.85	0.7564	0.82	516170.0
2009-12-01	AAUAF-DELISTED	Stock	0.76	0.85	0.7564	0.82	516820.0
2009-12-01	AAV-DELISTED	Stock	5.85	6.05	5.85	5.96	851078.0
2009-12-01	AAWW-DELISTED	Stock	29.82	30.77	29.82	30.73	495030.0
2009-12-01	AAXJ	Stock	55.72	56.02	55.4123	55.83	1318424.0
2009-12-01	AAXN-DELISTED	Stock	4.29	4.32	4.23	4.27	374209.0
2009-12-01	AB	Stock	25.72	25.97	25.38	25.7	366500.0
2009-12-01	ABAX-DELISTED	Stock	22.53	23.17	22.4	22.74	78066.0
2009-12-01	ABB-DELISTED	Stock	18.75	18.86	18.58	18.69	4812444.0
2009-12-01	ABBC-DELISTED	Stock	6.86	7.24	6.76	6.93	50646.0
2009-12-01	ABBNY-DELISTED	Stock	18.75	18.86	18.58	18.72	4834294.0
2009-12-01	ABC-DELISTED	Stock	24.75	24.95	24.7	24.86	2611866.0
2009-12-01	ABCB	Stock	6.606	6.7825	6.5472	6.6942	26323.0
2009-12-01	ABCO-DELISTED	Stock	13.15	13.4	13.115	13.255	167108.0
2009-12-01	ABCW-DELISTED	Stock	0.5187	0.538	0.4502	0.46	411470.0
2009-12-01	ABD-DELISTED	Stock	6.6	6.86	6.5337	6.78	471450.0
2009-12-01	ABE-DELISTED	Stock	16.65	16.98	16.51	16.89	26981.0
2009-12-01	ABEO	Stock	3712.5	3875.0	3587.5	3775.0	24.0
2009-12-01	ABFS-DELISTED	Stock	24.69	26.26	24.63	25.56	460463.0
2009-12-01	ABG	Stock	10.78	11.02	10.56	10.94	549500.0
2009-12-01	ABII-DELISTED	Stock	34.7	35.0	33.47	35.0	27217.0
2009-12-01	ABK-DELISTED	Stock	0.799	0.83	0.78	0.81	8706073.0
2009-12-01	ABM	Stock	18.65	18.77	18.36	18.63	110000.0
2009-12-01	ABMD-DELISTED	Stock	8.55	8.85	8.4	8.8	100988.0
2009-12-01	ABR	Stock	1.78	1.82	1.72	1.74	140700.0
2009-12-01	ABT	Stock	26.317	26.3266	26.0148	26.1395	21289912.0
2009-12-01	ABTL-DELISTED	Stock	4.85	4.95	4.5	4.75	8248.0
2009-12-01	ABV-DELISTED	Stock	99.86	100.4	99.0	99.7	422885.0
2009-12-01	ABVA-DELISTED	Stock	2.66	2.68	2.05	2.07	2936.0
2009-12-01	ABVT-DELISTED	Stock	51.94	54.25	51.52	53.99	161211.0
2009-12-01	ABX-DELISTED	Stock	44.1	46.61	44.02	46.04	22739309.0
2009-12-01	ACAD	Stock	1.21	1.29	1.18	1.23	479000.0
2009-12-01	ACAP-DELISTED	Stock	27.44	28.25	27.3	27.39	146347.0

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

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