PREVIEW / stock_daily / 2011-08-25

all stock daily files

  file:    by_date/stock_daily/2011/2011-08-25.parquet
  size:    193 KB
  rows:    6,068
  symbols: 3,509

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-25	AAPL	Stock	13.0386	13.4089	13.0357	13.3471	871346000.0
2011-08-25	MSFT	Stock	25.08	25.16	24.5	24.57	48192000.0
2011-08-25	NVDA	Stock	0.3195	0.3253	0.3115	0.312	690968000.0
2011-08-25	AMZN	Stock	9.7205	9.8495	9.5535	9.6015	75216000.0
2011-08-25	TSLA	Stock	1.5913	1.5913	1.5267	1.5407	10197000.0
2011-08-25	TLT	Stock	106.69	107.9	106.36	107.43	10566794.0
2011-08-25	ES	Stock	34.4	34.42	33.71	33.9	2302900.0
2011-08-25	CL	Stock	43.855	44.05	43.28	43.425	5548800.0
2011-08-25	A	Stock	23.9127	24.2346	23.2904	23.6266	9486269.0
2011-08-25	AABA-DELISTED	Stock	13.17	13.21	12.81	12.87	21792022.0
2011-08-25	AACC-DELISTED	Stock	4.13	4.15	4.02	4.05	9012.0
2011-08-25	AAIC-DELISTED	Stock	25.87	26.18	24.79	25.02	55193.0
2011-08-25	AAME	Stock	1.81	1.93	1.81	1.93	2200.0
2011-08-25	AAON	Stock	4.8622	4.9511	4.6963	4.7111	181238.0
2011-08-25	AAP	Stock	59.2	60.11	57.83	57.98	1038700.0
2011-08-25	AAT	Stock	19.18	19.19	18.37	18.7	125400.0
2011-08-25	AATI-DELISTED	Stock	5.9	5.92	5.82	5.91	556936.0
2011-08-25	AAU-DELISTED	Stock	2.9	3.01	2.9	2.95	241264.0
2011-08-25	AAUAF-DELISTED	Stock	2.9	3.01	2.9	2.94	243364.0
2011-08-25	AAV-DELISTED	Stock	5.6	5.7	5.39	5.42	740823.0
2011-08-25	AAWW-DELISTED	Stock	44.97	45.767	42.55	43.09	231893.0
2011-08-25	AAXJ	Stock	53.93	54.08	52.74	52.8	801825.0
2011-08-25	AAXN-DELISTED	Stock	4.27	4.29	4.12	4.13	472517.0
2011-08-25	AB	Stock	15.35	15.8	14.94	15.17	238800.0
2011-08-25	ABAC-DELISTED	Stock	2.23	2.3	2.1	2.19	21980.0
2011-08-25	ABAX-DELISTED	Stock	24.68	24.68	23.62	23.73	155518.0
2011-08-25	ABB-DELISTED	Stock	20.42	20.56	19.8	19.96	2781324.0
2011-08-25	ABBC-DELISTED	Stock	8.52	8.68	7.93	7.96	51034.0
2011-08-25	ABBNY-DELISTED	Stock	20.42	20.56	19.8	19.96	2802751.0
2011-08-25	ABC-DELISTED	Stock	38.27	38.48	37.48	37.59	2663770.0
2011-08-25	ABCB	Stock	9.26	9.4	8.77	8.8	57400.0
2011-08-25	ABCD-DELISTED	Stock	2.91	2.93	2.8699	2.93	93894.0
2011-08-25	ABCO-DELISTED	Stock	30.45	30.53	29.11	29.16	111460.0
2011-08-25	ABCW-DELISTED	Stock	0.68	0.69	0.63	0.64	31740.0
2011-08-25	ABD-DELISTED	Stock	6.22	6.29	5.9198	5.97	189830.0
2011-08-25	ABE-DELISTED	Stock	18.24	18.27	17.96	17.96	4263.0
2011-08-25	ABEO	Stock	2562.5	2587.5	2312.5	2562.5	11.0
2011-08-25	ABFS-DELISTED	Stock	19.74	20.81	19.3	19.4	327892.0
2011-08-25	ABG	Stock	17.89	18.26	17.05	17.1	348100.0
2011-08-25	ABH-DELISTED	Stock	16.14	16.21	15.79	15.88	249418.0
2011-08-25	ABM	Stock	20.09	20.14	19.13	19.31	211600.0
2011-08-25	ABMD-DELISTED	Stock	12.23	12.33	11.22	11.3	127698.0
2011-08-25	ABR	Stock	4.01	4.01	3.76	3.8	85400.0
2011-08-25	ABT	Stock	24.585	24.585	23.8748	23.9612	13869737.0
2011-08-25	ABTL-DELISTED	Stock	4.4	4.42	4.2605	4.35	2560.0
2011-08-25	ABUS	Stock	1.97	1.97	1.8	1.89	3900.0
2011-08-25	ABV-DELISTED	Stock	33.57	33.78	33.33	33.5	2827325.0
2011-08-25	ABVA-DELISTED	Stock	4.8	4.88	4.8	4.84	7200.0
2011-08-25	ABVT-DELISTED	Stock	58.86	59.41	56.08	56.71	122206.0
2011-08-25	ABX-DELISTED	Stock	48.34	50.36	47.82	50.02	9099170.0

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

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