PREVIEW / stock_daily / 2011-10-12

all stock daily files

  file:    by_date/stock_daily/2011/2011-10-12.parquet
  size:    195 KB
  rows:    6,104
  symbols: 3,535

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-12	AAPL	Stock	14.5479	14.6161	14.2907	14.3639	622286000.0
2011-10-12	MSFT	Stock	27.18	27.31	26.9	26.96	52489800.0
2011-10-12	NVDA	Stock	0.3725	0.3728	0.365	0.3652	612064000.0
2011-10-12	AMZN	Stock	11.832	12.092	11.7165	11.8405	130216000.0
2011-10-12	TSLA	Stock	1.8167	1.8667	1.8133	1.8533	16851000.0
2011-10-12	TLT	Stock	114.7	115.12	113.48	114.49	14033398.0
2011-10-12	ES	Stock	32.34	32.8	32.13	32.55	2058800.0
2011-10-12	CL	Stock	45.245	46.04	45.245	45.61	3683000.0
2011-10-12	A	Stock	24.4707	24.7353	23.8913	24.1631	10626757.0
2011-10-12	AABA-DELISTED	Stock	15.93	15.95	15.67	15.75	20398415.0
2011-10-12	AACC-DELISTED	Stock	2.97	3.26	2.97	3.09	2990.0
2011-10-12	AACG	Stock	8.61	8.74	8.53	8.55	4600.0
2011-10-12	AAIC-DELISTED	Stock	24.67	25.0	24.44	24.83	25819.0
2011-10-12	AAME	Stock	1.8	1.8	1.8	1.8	200.0
2011-10-12	AAON	Stock	5.277	5.603	5.2474	5.5644	203513.0
2011-10-12	AAP	Stock	61.36	61.55	59.9	60.04	798800.0
2011-10-12	AAT	Stock	17.51	18.78	17.51	18.69	101800.0
2011-10-12	AATI-DELISTED	Stock	4.47	4.49	4.44	4.44	195154.0
2011-10-12	AAU-DELISTED	Stock	2.82	2.84	2.6	2.6	241155.0
2011-10-12	AAUAF-DELISTED	Stock	2.82	2.84	2.6	2.6	243255.0
2011-10-12	AAV-DELISTED	Stock	4.55	4.78	4.461	4.53	502513.0
2011-10-12	AAWW-DELISTED	Stock	35.5	36.82	35.35	35.97	294452.0
2011-10-12	AAXJ	Stock	51.15	52.24	51.15	51.66	236196.0
2011-10-12	AAXN-DELISTED	Stock	4.64	4.67	4.54	4.59	363125.0
2011-10-12	AB	Stock	13.88	14.56	13.85	14.32	469400.0
2011-10-12	ABAC-DELISTED	Stock	1.76	1.84	1.65	1.76	19884.0
2011-10-12	ABAX-DELISTED	Stock	23.74	24.22	23.61	24.1	175753.0
2011-10-12	ABB-DELISTED	Stock	19.2	19.74	19.14	19.55	4808058.0
2011-10-12	ABBNY-DELISTED	Stock	19.2	19.74	19.14	19.54	4808853.0
2011-10-12	ABC-DELISTED	Stock	37.23	37.9	36.91	37.61	3256546.0
2011-10-12	ABCB	Stock	9.51	9.63	9.41	9.57	62900.0
2011-10-12	ABCD-DELISTED	Stock	3.05	3.12	3.04	3.1	53079.0
2011-10-12	ABCO-DELISTED	Stock	31.7	31.82	30.9	31.54	261968.0
2011-10-12	ABCW-DELISTED	Stock	0.52	0.55	0.4871	0.51	15000.0
2011-10-12	ABD-DELISTED	Stock	5.4149	5.5951	5.3449	5.5751	379090.0
2011-10-12	ABE-DELISTED	Stock	17.3001	17.61	17.3	17.32	6264.0
2011-10-12	ABEO	Stock	2062.5	2287.5	1750.0	2287.5	83.0
2011-10-12	ABFS-DELISTED	Stock	16.86	17.72	16.72	17.45	699966.0
2011-10-12	ABG	Stock	19.19	19.75	18.85	19.54	337200.0
2011-10-12	ABH-DELISTED	Stock	15.95	16.25	15.94	16.16	207206.0
2011-10-12	ABM	Stock	20.08	20.27	19.9	20.09	231800.0
2011-10-12	ABMD-DELISTED	Stock	11.87	12.48	11.77	12.38	127110.0
2011-10-12	ABR	Stock	3.29	3.35	3.25	3.3	52500.0
2011-10-12	ABT	Stock	25.0791	25.3622	25.036	25.1079	13444352.0
2011-10-12	ABTL-DELISTED	Stock	4.4995	4.5	4.1461	4.5	11973.0
2011-10-12	ABUS	Stock	1.96	1.96	1.66	1.8	35100.0
2011-10-12	ABV-DELISTED	Stock	32.91	33.15	32.13	32.8	2765774.0
2011-10-12	ABVA-DELISTED	Stock	4.95	5.0	4.9	4.98	18556.0
2011-10-12	ABVT-DELISTED	Stock	58.06	59.55	58.06	58.88	159823.0
2011-10-12	ABX-DELISTED	Stock	48.61	48.73	47.82	48.17	5648975.0

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

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