PREVIEW / stock_daily / 2009-09-21

all stock daily files

  file:    by_date/stock_daily/2009/2009-09-21.parquet
  size:    185 KB
  rows:    5,841
  symbols: 3,479

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-21	AAPL	Stock	6.5818	6.6129	6.4864	6.5721	437715600.0
2009-09-21	MSFT	Stock	25.11	25.37	25.1	25.3	28878700.0
2009-09-21	NVDA	Stock	0.376	0.3853	0.3728	0.3788	588776000.0
2009-09-21	AMZN	Stock	4.4845	4.538	4.424	4.528	84186000.0
2009-09-21	TLT	Stock	96.1	96.49	95.36	95.98	3050152.0
2009-09-21	ES	Stock	24.42	24.47	24.17	24.29	862300.0
2009-09-21	CL	Stock	38.005	38.11	37.74	37.85	2862600.0
2009-09-21	A	Stock	20.5508	21.0157	20.4721	20.608	7854943.0
2009-09-21	AABA-DELISTED	Stock	17.23	17.23	16.96	17.05	26680271.0
2009-09-21	AACC-DELISTED	Stock	7.67	7.81	7.6	7.66	17544.0
2009-09-21	AACG	Stock	6.56	6.84	6.56	6.57	2600.0
2009-09-21	AAI-DELISTED	Stock	6.55	7.045	6.5	6.95	1960229.0
2009-09-21	AAIC-DELISTED	Stock	9.6	10.4	9.6	9.6	773304.0
2009-09-21	AAME	Stock	0.85	0.92	0.85	0.87	25400.0
2009-09-21	AAON	Stock	4.1185	4.1383	3.9486	4.1205	236925.0
2009-09-21	AAP	Stock	39.09	40.35	38.77	40.11	2804700.0
2009-09-21	AATI-DELISTED	Stock	4.22	4.42	4.22	4.28	132235.0
2009-09-21	AAU-DELISTED	Stock	0.67	0.69	0.64	0.69	499313.0
2009-09-21	AAUAF-DELISTED	Stock	0.67	0.69	0.64	0.69	501113.0
2009-09-21	AAV-DELISTED	Stock	6.61	6.93	6.52	6.92	1471288.0
2009-09-21	AAWW-DELISTED	Stock	31.75	32.03	31.11	31.82	179713.0
2009-09-21	AAXJ	Stock	52.36	52.47	51.87	52.4	167998.0
2009-09-21	AAXN-DELISTED	Stock	4.7	4.71	4.55	4.66	234318.0
2009-09-21	AB	Stock	25.77	25.77	24.7	25.56	332800.0
2009-09-21	ABAX-DELISTED	Stock	28.7	28.93	28.53	28.76	71281.0
2009-09-21	ABB-DELISTED	Stock	20.17	20.4	20.09	20.39	2484549.0
2009-09-21	ABBC-DELISTED	Stock	7.84	8.0	7.81	8.0	58654.0
2009-09-21	ABBNY-DELISTED	Stock	20.18	20.4	20.09	20.38	2487481.0
2009-09-21	ABC-DELISTED	Stock	21.73	22.1	21.58	21.95	1824910.0
2009-09-21	ABCB	Stock	6.5264	7.042	6.5264	6.8766	44415.0
2009-09-21	ABCO-DELISTED	Stock	13.342	13.528	13.322	13.388	87024.0
2009-09-21	ABCW-DELISTED	Stock	1.38	1.451	1.3191	1.38	37820.0
2009-09-21	ABD-DELISTED	Stock	7.12	7.12	6.84	6.99	419660.0
2009-09-21	ABE-DELISTED	Stock	17.31	17.35	17.15	17.35	9415.0
2009-09-21	ABEO	Stock	4062.5	4125.0	3812.5	4125.0	28.0
2009-09-21	ABFS-DELISTED	Stock	32.56	33.1	31.74	32.23	391089.0
2009-09-21	ABG	Stock	13.09	13.67	12.94	13.45	290400.0
2009-09-21	ABII-DELISTED	Stock	29.5	30.0	29.0	29.97	39425.0
2009-09-21	ABK-DELISTED	Stock	1.6	1.7	1.56	1.6499	15408551.0
2009-09-21	ABM	Stock	21.13	21.23	20.79	20.88	241300.0
2009-09-21	ABMD-DELISTED	Stock	8.8	9.3	8.8	9.28	265357.0
2009-09-21	ABR	Stock	2.73	2.73	2.48	2.54	320500.0
2009-09-21	ABT	Stock	21.9796	22.3827	21.9748	22.3203	14861609.0
2009-09-21	ABTL-DELISTED	Stock	3.2	3.25	3.15	3.2	4340.0
2009-09-21	ABV-DELISTED	Stock	79.58	80.0	78.78	79.93	386119.0
2009-09-21	ABVA-DELISTED	Stock	2.68	2.68	2.5	2.6	4945.0
2009-09-21	ABVT-DELISTED	Stock	46.46	46.6699	45.55	46.0	90328.0
2009-09-21	ABX-DELISTED	Stock	36.13	36.71	35.62	36.5	16204423.0
2009-09-21	ACAD	Stock	1.94	1.95	1.88	1.9	1658600.0
2009-09-21	ACAP-DELISTED	Stock	29.45	29.925	29.45	29.66	25862.0

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

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