PREVIEW / stock_daily / 2009-07-13

all stock daily files

  file:    by_date/stock_daily/2009/2009-07-13.parquet
  size:    180 KB
  rows:    5,757
  symbols: 3,433

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-07-13	AAPL	Stock	4.9836	5.0836	4.9118	5.0836	483501200.0
2009-07-13	MSFT	Stock	22.42	23.29	22.14	23.23	67584000.0
2009-07-13	NVDA	Stock	0.2645	0.2645	0.2488	0.2623	556012000.0
2009-07-13	AMZN	Stock	3.9035	4.0825	3.9005	4.0735	161004000.0
2009-07-13	TLT	Stock	96.32	96.6	95.56	95.69	2604382.0
2009-07-13	ES	Stock	21.52	21.6	21.11	21.55	1177800.0
2009-07-13	CL	Stock	35.675	36.62	35.635	36.42	5881000.0
2009-07-13	A	Stock	13.5765	13.877	13.412	13.8698	3290333.0
2009-07-13	AABA-DELISTED	Stock	14.91	15.06	14.64	15.01	12939982.0
2009-07-13	AACC-DELISTED	Stock	7.39	7.8	7.39	7.75	40464.0
2009-07-13	AACG	Stock	7.93	8.31	7.71	7.98	21400.0
2009-07-13	AAI-DELISTED	Stock	5.95	6.25	5.73	6.25	1779138.0
2009-07-13	AAIC-DELISTED	Stock	6.8	7.2	6.8	7.0	951933.0
2009-07-13	AAME	Stock	0.73	0.73	0.73	0.73	1000.0
2009-07-13	AAON	Stock	3.7195	3.9506	3.6681	3.9052	452081.0
2009-07-13	AAP	Stock	44.12	44.98	43.22	44.92	1427400.0
2009-07-13	AATI-DELISTED	Stock	4.24	4.32	4.12	4.31	82516.0
2009-07-13	AAU-DELISTED	Stock	0.58	0.62	0.58	0.62	22240.0
2009-07-13	AAUAF-DELISTED	Stock	0.58	0.62	0.58	0.62	22240.0
2009-07-13	AAV-DELISTED	Stock	4.25	4.52	4.18	4.32	1873478.0
2009-07-13	AAWW-DELISTED	Stock	21.43	21.43	20.15	20.8	335930.0
2009-07-13	AAXJ	Stock	43.38	43.48	42.29	43.48	507903.0
2009-07-13	AAXN-DELISTED	Stock	4.36	4.57	4.25	4.48	455173.0
2009-07-13	AB	Stock	18.35	18.75	17.96	18.5	1645300.0
2009-07-13	ABAX-DELISTED	Stock	18.69	19.1	18.54	18.97	239433.0
2009-07-13	ABB-DELISTED	Stock	15.24	15.51	15.045	15.4717	3214841.0
2009-07-13	ABBC-DELISTED	Stock	8.08	8.26	7.99	8.26	36517.0
2009-07-13	ABBNY-DELISTED	Stock	15.24	15.51	15.045	15.47	3218231.0
2009-07-13	ABC-DELISTED	Stock	17.79	18.22	17.69	18.1	2983280.0
2009-07-13	ABCB	Stock	6.1957	6.4681	6.0791	6.4681	26423.0
2009-07-13	ABCO-DELISTED	Stock	11.373	11.775	11.148	11.597	164308.0
2009-07-13	ABCW-DELISTED	Stock	1.0617	1.11	1.0424	1.11	28860.0
2009-07-13	ABD-DELISTED	Stock	2.43	2.43	2.24	2.38	186000.0
2009-07-13	ABE-DELISTED	Stock	14.24	14.9	14.18	14.9	13413.0
2009-07-13	ABEO	Stock	2312.5	2312.5	2125.0	2300.0	3.0
2009-07-13	ABFS-DELISTED	Stock	28.18	28.31	26.88	28.27	407278.0
2009-07-13	ABG	Stock	9.34	10.25	8.81	10.2	403300.0
2009-07-13	ABII-DELISTED	Stock	32.61	32.62	31.5	31.7	19796.0
2009-07-13	ABK-DELISTED	Stock	0.79	0.82	0.78	0.82	2315030.0
2009-07-13	ABM	Stock	17.16	17.33	16.66	17.24	286300.0
2009-07-13	ABMD-DELISTED	Stock	7.93	8.05	7.74	7.94	207615.0
2009-07-13	ABR	Stock	1.5	1.54	1.5	1.52	121600.0
2009-07-13	ABT	Stock	21.6774	22.1908	21.591	22.1428	15447270.0
2009-07-13	ABTL-DELISTED	Stock	2.124	2.4	2.124	2.15	24811.0
2009-07-13	ABV-DELISTED	Stock	63.06	64.1	61.95	64.03	400585.0
2009-07-13	ABVA-DELISTED	Stock	2.48	2.48	2.48	2.48	200.0
2009-07-13	ABVT-DELISTED	Stock	70.8	71.95	69.31	71.74	43882.0
2009-07-13	ABX-DELISTED	Stock	31.24	31.99	30.67	31.99	7311592.0
2009-07-13	ACAD	Stock	1.99	2.14	1.97	2.06	155500.0
2009-07-13	ACAP-DELISTED	Stock	37.92	38.69	37.49	38.69	25975.0

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

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