PREVIEW / stock_daily / 2011-12-06

all stock daily files

  file:    by_date/stock_daily/2011/2011-12-06.parquet
  size:    196 KB
  rows:    6,134
  symbols: 3,544

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-12-06	AAPL	Stock	14.0182	14.0939	13.9064	13.9625	283598000.0
2011-12-06	MSFT	Stock	25.81	25.87	25.61	25.66	46175300.0
2011-12-06	NVDA	Stock	0.3893	0.39	0.3775	0.3815	573832000.0
2011-12-06	AMZN	Stock	9.799	9.916	9.5055	9.5995	104040000.0
2011-12-06	TSLA	Stock	2.28	2.332	2.2687	2.3247	14277000.0
2011-12-06	TLT	Stock	117.81	118.29	116.77	117.27	8506263.0
2011-12-06	ES	Stock	34.56	34.66	34.29	34.38	1615100.0
2011-12-06	CL	Stock	45.335	45.425	45.03	45.27	3442200.0
2011-12-06	A	Stock	26.5594	26.7167	26.0944	26.4521	3471793.0
2011-12-06	AABA-DELISTED	Stock	15.9	16.05	15.85	15.85	16903529.0
2011-12-06	AACC-DELISTED	Stock	3.42	3.46	3.4	3.45	28307.0
2011-12-06	AACG	Stock	9.59	9.6	9.55	9.59	800.0
2011-12-06	AAIC-DELISTED	Stock	20.23	20.62	20.0	20.5	69377.0
2011-12-06	AAME	Stock	1.99	1.99	1.9	1.98	1900.0
2011-12-06	AAON	Stock	6.4563	6.5659	6.2222	6.4652	206213.0
2011-12-06	AAP	Stock	70.23	70.54	69.75	70.09	760300.0
2011-12-06	AAT	Stock	20.42	20.56	20.27	20.42	243400.0
2011-12-06	AATI-DELISTED	Stock	5.76	5.76	5.74	5.75	631614.0
2011-12-06	AAU-DELISTED	Stock	2.55	2.61	2.48	2.59	114573.0
2011-12-06	AAUAF-DELISTED	Stock	2.55	2.61	2.48	2.59	114873.0
2011-12-06	AAV-DELISTED	Stock	4.59	4.74	4.53	4.67	295809.0
2011-12-06	AAWW-DELISTED	Stock	40.41	40.5456	38.43	39.91	118394.0
2011-12-06	AAXJ	Stock	52.36	52.56	51.9525	52.29	232918.0
2011-12-06	AAXN-DELISTED	Stock	6.18	6.49	6.08	6.38	709979.0
2011-12-06	AB	Stock	13.4	13.67	13.36	13.47	404100.0
2011-12-06	ABAC-DELISTED	Stock	1.6	1.6	1.47	1.5	7560.0
2011-12-06	ABAX-DELISTED	Stock	28.16	28.54	28.04	28.44	87184.0
2011-12-06	ABB-DELISTED	Stock	18.82	18.93	18.69	18.8	1903898.0
2011-12-06	ABBNY-DELISTED	Stock	18.82	18.93	18.69	18.81	1908098.0
2011-12-06	ABC-DELISTED	Stock	36.75	36.93	36.44	36.45	2306456.0
2011-12-06	ABCB	Stock	10.24	10.49	10.14	10.29	38400.0
2011-12-06	ABCD-DELISTED	Stock	3.06	3.06	2.89	2.95	42961.0
2011-12-06	ABCO-DELISTED	Stock	36.65	37.04	36.54	36.93	162083.0
2011-12-06	ABCW-DELISTED	Stock	0.4317	0.4317	0.3916	0.4217	28900.0
2011-12-06	ABD-DELISTED	Stock	9.31	9.75	9.27	9.61	582480.0
2011-12-06	ABE-DELISTED	Stock	18.01	18.01	17.88	17.89	2200.0
2011-12-06	ABEO	Stock	1787.5	1787.5	1750.0	1787.5	3.0
2011-12-06	ABFS-DELISTED	Stock	19.37	19.42	18.93	19.33	246002.0
2011-12-06	ABG	Stock	20.54	20.72	20.45	20.57	319300.0
2011-12-06	ABH-DELISTED	Stock	15.08	15.33	14.98	15.24	145580.0
2011-12-06	ABM	Stock	22.03	22.03	21.15	21.38	655000.0
2011-12-06	ABMD-DELISTED	Stock	20.32	20.6	20.07	20.6	259964.0
2011-12-06	ABR	Stock	3.34	3.35	3.3	3.33	15400.0
2011-12-06	ABT	Stock	26.1443	26.293	25.9524	26.1683	11286161.0
2011-12-06	ABTL-DELISTED	Stock	3.8	3.8	3.6625	3.8	11622.0
2011-12-06	ABUS	Stock	1.69	1.7	1.64	1.64	3400.0
2011-12-06	ABV-DELISTED	Stock	34.89	35.2308	34.78	35.08	1192929.0
2011-12-06	ABVA-DELISTED	Stock	3.82	3.82	3.82	3.82	4100.0
2011-12-06	ABVT-DELISTED	Stock	62.75	63.09	62.105	62.97	176895.0
2011-12-06	ABX-DELISTED	Stock	49.95	51.81	49.76	51.22	5801732.0

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

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