PREVIEW / stock_daily / 2009-09-09

all stock daily files

  file:    by_date/stock_daily/2009/2009-09-09.parquet
  size:    185 KB
  rows:    5,807
  symbols: 3,455

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-09	AAPL	Stock	6.1707	6.2311	6.0607	6.1121	811087200.0
2009-09-09	MSFT	Stock	24.74	24.95	24.67	24.78	49900300.0
2009-09-09	NVDA	Stock	0.3875	0.3998	0.382	0.399	571684000.0
2009-09-09	AMZN	Stock	4.03	4.1315	4.025	4.112	135524000.0
2009-09-09	TLT	Stock	93.89	94.43	93.52	94.43	3182346.0
2009-09-09	ES	Stock	23.77	23.83	23.61	23.69	591000.0
2009-09-09	CL	Stock	35.73	36.04	35.31	36.02	5466400.0
2009-09-09	A	Stock	18.8197	19.4492	18.7124	19.4206	5139747.0
2009-09-09	AABA-DELISTED	Stock	14.45	14.86	14.42	14.77	18039248.0
2009-09-09	AACC-DELISTED	Stock	7.52	7.69	7.42	7.49	20913.0
2009-09-09	AACG	Stock	6.84	6.84	6.63	6.73	8900.0
2009-09-09	AAI-DELISTED	Stock	6.48	6.72	6.48	6.6	1636005.0
2009-09-09	AAIC-DELISTED	Stock	10.2	10.2	9.398	9.4	302448.0
2009-09-09	AAON	Stock	3.9723	4.0138	3.9289	3.9407	372094.0
2009-09-09	AAP	Stock	41.61	41.88	41.19	41.55	1791700.0
2009-09-09	AATI-DELISTED	Stock	4.4	4.55	4.4	4.47	207730.0
2009-09-09	AAU-DELISTED	Stock	0.77	0.77	0.68	0.6991	242504.0
2009-09-09	AAUAF-DELISTED	Stock	0.77	0.77	0.68	0.6991	243704.0
2009-09-09	AAV-DELISTED	Stock	5.88	6.08	5.83	6.05	738469.0
2009-09-09	AAWW-DELISTED	Stock	24.6	25.43	24.56	25.27	391536.0
2009-09-09	AAXJ	Stock	51.45	51.58	50.96	51.47	124003.0
2009-09-09	AAXN-DELISTED	Stock	4.66	4.7	4.53	4.55	438478.0
2009-09-09	AB	Stock	23.52	24.93	23.19	24.81	1925700.0
2009-09-09	ABAX-DELISTED	Stock	26.74	27.57	26.43	27.2	88977.0
2009-09-09	ABB-DELISTED	Stock	20.21	20.4	19.99	20.1	7478860.0
2009-09-09	ABBC-DELISTED	Stock	7.74	7.88	7.64	7.78	1173428.0
2009-09-09	ABBNY-DELISTED	Stock	20.21	20.4	19.99	20.12	7483660.0
2009-09-09	ABC-DELISTED	Stock	21.4	21.66	21.04	21.44	2640133.0
2009-09-09	ABCB	Stock	5.7873	6.1957	5.651	6.1471	38246.0
2009-09-09	ABCO-DELISTED	Stock	13.648	13.803	13.532	13.597	83770.0
2009-09-09	ABCW-DELISTED	Stock	1.33	1.33	1.25	1.28	62910.0
2009-09-09	ABD-DELISTED	Stock	5.62	5.9501	5.62	5.75	406290.0
2009-09-09	ABE-DELISTED	Stock	17.08	17.2	16.8812	17.0278	10022.0
2009-09-09	ABEO	Stock	4550.0	4550.0	4125.0	4137.5	64.0
2009-09-09	ABFS-DELISTED	Stock	31.84	32.8	31.67	32.66	615230.0
2009-09-09	ABG	Stock	12.7	13.74	12.62	13.44	217300.0
2009-09-09	ABII-DELISTED	Stock	25.43	26.44	25.21	26.21	74992.0
2009-09-09	ABK-DELISTED	Stock	1.6	1.67	1.53	1.65	16333635.0
2009-09-09	ABM	Stock	20.36	20.48	20.07	20.29	200400.0
2009-09-09	ABMD-DELISTED	Stock	7.81	8.32	7.81	8.12	122805.0
2009-09-09	ABR	Stock	1.88	1.93	1.88	1.91	153900.0
2009-09-09	ABT	Stock	22.066	22.3683	22.0036	22.2435	17529804.0
2009-09-09	ABTL-DELISTED	Stock	2.9003	3.1997	2.9003	2.9997	5242.0
2009-09-09	ABV-DELISTED	Stock	76.03	76.24	75.11	75.3	504644.0
2009-09-09	ABVA-DELISTED	Stock	2.41	2.8	2.41	2.8	822.0
2009-09-09	ABVT-DELISTED	Stock	45.05	45.2399	44.77	44.93	79604.0
2009-09-09	ABX-DELISTED	Stock	38.03	38.1	36.59	36.93	52342253.0
2009-09-09	ACAD	Stock	1.98	1.99	1.91	1.94	2007100.0
2009-09-09	ACAP-DELISTED	Stock	31.66	31.92	31.0	31.6	19418.0
2009-09-09	ACAS-DELISTED	Stock	2.28	2.35	2.22	2.285	2882099.0

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

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