PREVIEW / stock_daily / 2011-11-09

all stock daily files

  file:    by_date/stock_daily/2011/2011-11-09.parquet
  size:    195 KB
  rows:    6,084
  symbols: 3,519

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-11-09	AAPL	Stock	14.1775	14.3175	14.0796	14.1171	558684000.0
2011-11-09	MSFT	Stock	26.59	26.75	26.06	26.2	62950900.0
2011-11-09	NVDA	Stock	0.3682	0.373	0.3565	0.358	532244000.0
2011-11-09	AMZN	Stock	10.7475	10.785	10.53	10.561	93612000.0
2011-11-09	TSLA	Stock	2.058	2.0993	2.02	2.0587	14305500.0
2011-11-09	TLT	Stock	118.26	119.13	117.07	118.12	13004493.0
2011-11-09	ES	Stock	33.89	33.98	33.54	33.71	3169000.0
2011-11-09	CL	Stock	44.05	44.245	43.575	43.725	5402800.0
2011-11-09	A	Stock	26.7597	26.9242	25.5293	25.8011	9209744.0
2011-11-09	AABA-DELISTED	Stock	16.2	16.5	15.87	15.93	43942657.0
2011-11-09	AACC-DELISTED	Stock	3.14	3.3	3.0	3.23	25354.0
2011-11-09	AACG	Stock	9.73	10.15	9.73	9.76	13300.0
2011-11-09	AAIC-DELISTED	Stock	21.57	22.0125	21.27	21.46	89853.0
2011-11-09	AAME	Stock	1.8	1.81	1.75	1.8	11900.0
2011-11-09	AAON	Stock	6.5363	6.5363	6.3763	6.3881	327375.0
2011-11-09	AAP	Stock	66.7	68.03	65.89	66.37	1329100.0
2011-11-09	AAT	Stock	20.0	20.21	19.54	19.64	174800.0
2011-11-09	AATI-DELISTED	Stock	3.82	3.82	3.69	3.78	256051.0
2011-11-09	AAU-DELISTED	Stock	2.93	3.039	2.81	2.81	267548.0
2011-11-09	AAUAF-DELISTED	Stock	2.93	3.039	2.81	2.81	268148.0
2011-11-09	AAV-DELISTED	Stock	5.22	5.3	4.99	5.03	311267.0
2011-11-09	AAWW-DELISTED	Stock	37.48	37.96	35.27	35.82	371283.0
2011-11-09	AAXJ	Stock	53.1	53.36	51.96	52.11	563941.0
2011-11-09	AAXN-DELISTED	Stock	5.45	5.5	5.3829	5.42	478258.0
2011-11-09	AB	Stock	13.0	13.32	12.87	12.93	434500.0
2011-11-09	ABAC-DELISTED	Stock	2.11	2.3	2.01	2.28	20734.0
2011-11-09	ABAX-DELISTED	Stock	27.15	27.5	26.67	26.73	117809.0
2011-11-09	ABB-DELISTED	Stock	18.17	18.24	17.69	17.79	3702856.0
2011-11-09	ABBNY-DELISTED	Stock	18.17	18.24	17.69	17.79	3703406.0
2011-11-09	ABC-DELISTED	Stock	38.53	38.97	37.98	38.23	3241017.0
2011-11-09	ABCB	Stock	10.37	10.53	10.0	10.03	73000.0
2011-11-09	ABCD-DELISTED	Stock	3.2	3.4	3.19	3.24	102214.0
2011-11-09	ABCO-DELISTED	Stock	35.15	35.83	34.51	34.59	143534.0
2011-11-09	ABCW-DELISTED	Stock	0.486	0.5057	0.4785	0.48	84240.0
2011-11-09	ABD-DELISTED	Stock	6.95	7.1	6.95	7.01	285950.0
2011-11-09	ABE-DELISTED	Stock	17.85	18.2	17.52	17.85	6570.0
2011-11-09	ABEO	Stock	1612.5	1675.0	1600.0	1675.0	20.0
2011-11-09	ABFS-DELISTED	Stock	19.77	20.46	19.56	19.63	430639.0
2011-11-09	ABG	Stock	17.78	18.34	17.64	17.8	388000.0
2011-11-09	ABH-DELISTED	Stock	15.61	15.76	15.28	15.41	223004.0
2011-11-09	ABM	Stock	20.13	20.36	19.51	19.56	296900.0
2011-11-09	ABMD-DELISTED	Stock	18.55	19.08	18.33	18.46	308192.0
2011-11-09	ABR	Stock	3.8	3.85	3.65	3.69	34400.0
2011-11-09	ABT	Stock	25.7461	25.794	25.2615	25.4006	14403501.0
2011-11-09	ABTL-DELISTED	Stock	4.5869	4.5869	4.4233	4.5	1874.0
2011-11-09	ABUS	Stock	1.62	1.69	1.62	1.65	7100.0
2011-11-09	ABV-DELISTED	Stock	33.01	33.445	32.91	33.11	3516158.0
2011-11-09	ABVA-DELISTED	Stock	5.04	5.16	4.88	4.88	37154.0
2011-11-09	ABVT-DELISTED	Stock	59.48	60.03	59.0	59.13	113099.0
2011-11-09	ABX-DELISTED	Stock	51.71	52.98	51.1	51.14	13104305.0

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

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