PREVIEW / stock_daily / 2011-08-12

all stock daily files

  file:    by_date/stock_daily/2011/2011-08-12.parquet
  size:    195 KB
  rows:    6,102
  symbols: 3,542

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
2011-08-12	AAPL	Stock	13.5025	13.5586	13.3654	13.4639	528976000.0
2011-08-12	MSFT	Stock	25.13	25.34	24.65	25.1	64787100.0
2011-08-12	NVDA	Stock	0.371	0.3715	0.3168	0.322	3195784000.0
2011-08-12	AMZN	Stock	10.014	10.228	9.8605	10.115	112408000.0
2011-08-12	TSLA	Stock	1.7067	1.8093	1.6907	1.754	15136500.0
2011-08-12	TLT	Stock	104.44	105.66	104.07	105.57	15590705.0
2011-08-12	ES	Stock	32.96	33.18	32.27	32.44	1981500.0
2011-08-12	CL	Stock	42.27	42.93	42.16	42.67	5925000.0
2011-08-12	A	Stock	25.0	26.4235	24.6137	25.9013	13183979.0
2011-08-12	AABA-DELISTED	Stock	12.8	13.62	12.76	13.58	47938935.0
2011-08-12	AACC-DELISTED	Stock	4.41	4.455	3.96	4.4	81471.0
2011-08-12	AACG	Stock	10.0	10.16	9.95	10.0	16600.0
2011-08-12	AAIC-DELISTED	Stock	25.13	25.26	24.0601	24.25	42996.0
2011-08-12	AAME	Stock	1.85	1.9	1.82	1.88	2400.0
2011-08-12	AAON	Stock	5.8874	5.9052	5.6356	5.6652	167063.0
2011-08-12	AAP	Stock	55.73	56.14	54.64	55.17	1339500.0
2011-08-12	AAT	Stock	18.49	19.1	17.83	18.19	227200.0
2011-08-12	AATI-DELISTED	Stock	5.91	5.96	5.89	5.92	490633.0
2011-08-12	AAU-DELISTED	Stock	3.31	3.37	3.21	3.27	183244.0
2011-08-12	AAUAF-DELISTED	Stock	3.31	3.37	3.21	3.27	183844.0
2011-08-12	AAV-DELISTED	Stock	5.89	6.14	5.78	5.81	533628.0
2011-08-12	AAWW-DELISTED	Stock	44.16	45.01	42.94	43.42	121539.0
2011-08-12	AAXJ	Stock	55.48	55.8	54.98	55.53	1016689.0
2011-08-12	AAXN-DELISTED	Stock	3.88	3.91	3.77	3.89	379873.0
2011-08-12	AB	Stock	15.1	15.27	14.25	14.37	302000.0
2011-08-12	ABAC-DELISTED	Stock	2.42	2.48	2.39	2.48	24115.0
2011-08-12	ABAX-DELISTED	Stock	22.69	23.41	22.14	23.19	137671.0
2011-08-12	ABB-DELISTED	Stock	21.86	22.22	21.58	21.87	3485678.0
2011-08-12	ABBC-DELISTED	Stock	8.47	8.48	8.12	8.18	31484.0
2011-08-12	ABBNY-DELISTED	Stock	21.86	22.22	21.58	21.86	3485878.0
2011-08-12	ABC-DELISTED	Stock	37.85	38.34	37.24	38.29	3833669.0
2011-08-12	ABCB	Stock	9.1	9.11	8.81	8.89	60300.0
2011-08-12	ABCD-DELISTED	Stock	2.89	3.08	2.749	2.78	51765.0
2011-08-12	ABCO-DELISTED	Stock	28.94	28.94	27.82	28.08	104737.0
2011-08-12	ABCW-DELISTED	Stock	0.65	0.6771	0.5987	0.61	77160.0
2011-08-12	ABD-DELISTED	Stock	7.04	7.28	6.7099	6.73	281490.0
2011-08-12	ABE-DELISTED	Stock	17.59	18.0	17.59	18.0	7483.0
2011-08-12	ABEO	Stock	2687.5	2812.5	2575.0	2812.5	6.0
2011-08-12	ABFS-DELISTED	Stock	19.88	20.75	19.37	20.56	472120.0
2011-08-12	ABG	Stock	18.42	18.67	17.13	17.9	610500.0
2011-08-12	ABH-DELISTED	Stock	16.42	16.5	15.93	16.49	402770.0
2011-08-12	ABM	Stock	19.29	19.31	18.73	19.21	272900.0
2011-08-12	ABMD-DELISTED	Stock	10.87	11.72	10.7343	11.69	272899.0
2011-08-12	ABR	Stock	3.88	4.0	3.75	3.9	29800.0
2011-08-12	ABT	Stock	24.0092	24.0092	23.4142	23.8125	20827220.0
2011-08-12	ABTL-DELISTED	Stock	4.3507	4.5008	4.2097	4.3993	13725.0
2011-08-12	ABUS	Stock	2.31	2.31	2.31	2.31	200.0
2011-08-12	ABV-DELISTED	Stock	30.35	31.51	30.34	31.32	4478557.0
2011-08-12	ABVA-DELISTED	Stock	4.64	4.65	4.51	4.6	10258.0
2011-08-12	ABVT-DELISTED	Stock	59.8	59.8	58.6	58.86	117677.0

> showing 50 of 6,102 rows — these rows as CSV

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