PREVIEW / stock_daily / 2011-10-06

all stock daily files

  file:    by_date/stock_daily/2011/2011-10-06.parquet
  size:    191 KB
  rows:    6,040
  symbols: 3,496

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-10-06	AAPL	Stock	13.3332	13.7421	13.2786	13.4775	812582400.0
2011-10-06	MSFT	Stock	25.9	26.4	25.7	26.34	55111400.0
2011-10-06	NVDA	Stock	0.3358	0.3482	0.3353	0.3473	773192000.0
2011-10-06	AMZN	Stock	11.014	11.181	10.8775	11.0755	136986000.0
2011-10-06	TSLA	Stock	1.6913	1.84	1.668	1.7973	26536500.0
2011-10-06	TLT	Stock	120.64	121.01	119.12	119.12	9682402.0
2011-10-06	ES	Stock	31.12	31.95	31.03	31.94	3378100.0
2011-10-06	CL	Stock	44.845	45.105	44.52	45.095	5129000.0
2011-10-06	A	Stock	22.8684	24.0057	22.4964	23.9914	7000066.0
2011-10-06	AABA-DELISTED	Stock	15.17	15.8	14.92	15.65	48945664.0
2011-10-06	AACC-DELISTED	Stock	3.05	3.16	3.05	3.06	32390.0
2011-10-06	AAIC-DELISTED	Stock	24.59	25.23	24.3529	25.18	43342.0
2011-10-06	AAME	Stock	1.8	1.82	1.69	1.8	2000.0
2011-10-06	AAON	Stock	4.9511	5.363	4.9511	5.357	246375.0
2011-10-06	AAP	Stock	58.39	59.6	58.25	59.39	601600.0
2011-10-06	AAT	Stock	17.57	17.94	17.38	17.8	199000.0
2011-10-06	AATI-DELISTED	Stock	4.445	4.445	4.37	4.44	215326.0
2011-10-06	AAU-DELISTED	Stock	2.56	2.7	2.48	2.61	167657.0
2011-10-06	AAUAF-DELISTED	Stock	2.56	2.7	2.48	2.61	168457.0
2011-10-06	AAV-DELISTED	Stock	4.06	4.3099	4.06	4.22	488658.0
2011-10-06	AAWW-DELISTED	Stock	32.99	35.09	32.81	35.04	239839.0
2011-10-06	AAXJ	Stock	47.18	48.3	46.97	48.22	211812.0
2011-10-06	AAXN-DELISTED	Stock	4.2	4.45	4.2	4.44	362418.0
2011-10-06	AB	Stock	14.1	14.12	13.65	13.96	358100.0
2011-10-06	ABAC-DELISTED	Stock	1.62	1.86	1.62	1.76	45200.0
2011-10-06	ABAX-DELISTED	Stock	23.38	23.63	22.95	23.58	140261.0
2011-10-06	ABB-DELISTED	Stock	17.12	17.77	17.05	17.75	3246232.0
2011-10-06	ABBNY-DELISTED	Stock	17.12	17.77	17.05	17.75	3248595.0
2011-10-06	ABC-DELISTED	Stock	36.65	36.66	34.71	36.06	5551443.0
2011-10-06	ABCB	Stock	9.25	9.37	9.2	9.34	87700.0
2011-10-06	ABCD-DELISTED	Stock	2.99	3.09	2.9408	3.04	67042.0
2011-10-06	ABCO-DELISTED	Stock	30.26	30.9	30.09	30.68	277108.0
2011-10-06	ABCW-DELISTED	Stock	0.49	0.53	0.485	0.5	15610.0
2011-10-06	ABD-DELISTED	Stock	4.8348	5.1952	4.7948	5.1652	249990.0
2011-10-06	ABE-DELISTED	Stock	16.88	17.3	16.88	17.2992	5986.0
2011-10-06	ABEO	Stock	2137.5	2187.5	2062.5	2187.5	15.0
2011-10-06	ABFS-DELISTED	Stock	16.1	16.69	15.77	16.65	493645.0
2011-10-06	ABG	Stock	17.66	18.39	17.52	18.38	321000.0
2011-10-06	ABH-DELISTED	Stock	14.99	15.85	14.9	15.61	449843.0
2011-10-06	ABM	Stock	19.18	19.75	19.08	19.72	256000.0
2011-10-06	ABMD-DELISTED	Stock	11.7	11.72	11.39	11.59	171270.0
2011-10-06	ABR	Stock	3.29	3.38	3.29	3.34	45000.0
2011-10-06	ABT	Stock	24.5562	24.6233	24.3067	24.5562	52921009.0
2011-10-06	ABTL-DELISTED	Stock	3.956	4.55	3.7592	4.55	27395.0
2011-10-06	ABUS	Stock	1.8	1.85	1.8	1.8	6000.0
2011-10-06	ABV-DELISTED	Stock	31.79	32.5301	31.59	32.0	4148664.0
2011-10-06	ABVA-DELISTED	Stock	4.88	4.9	4.8	4.8	4200.0
2011-10-06	ABVT-DELISTED	Stock	55.88	56.93	54.97	55.86	198793.0
2011-10-06	ABX-DELISTED	Stock	46.39	47.77	45.74	47.72	8382302.0
2011-10-06	ACAD	Stock	1.1	1.1	1.0	1.02	1176600.0

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

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