PREVIEW / stock_daily / 2011-11-04

all stock daily files

  file:    by_date/stock_daily/2011/2011-11-04.parquet
  size:    194 KB
  rows:    6,057
  symbols: 3,501

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-04	AAPL	Stock	14.3582	14.4086	14.2557	14.2943	302229200.0
2011-11-04	MSFT	Stock	26.38	26.4	26.0	26.25	36549200.0
2011-11-04	NVDA	Stock	0.363	0.3718	0.3572	0.3705	654840000.0
2011-11-04	AMZN	Stock	10.8825	10.9115	10.7165	10.824	81316000.0
2011-11-04	TSLA	Stock	2.0973	2.16	2.034	2.154	45493500.0
2011-11-04	TLT	Stock	115.72	117.0501	115.53	116.48	7583667.0
2011-11-04	ES	Stock	34.41	34.71	34.18	34.66	1340700.0
2011-11-04	CL	Stock	44.01	44.11	43.575	44.03	5767400.0
2011-11-04	A	Stock	26.1588	26.5093	25.6223	26.402	4422713.0
2011-11-04	AABA-DELISTED	Stock	15.39	15.54	14.946	15.24	39666981.0
2011-11-04	AACC-DELISTED	Stock	3.42	3.42	3.35	3.41	16806.0
2011-11-04	AACG	Stock	9.96	9.98	9.73	9.94	1700.0
2011-11-04	AAIC-DELISTED	Stock	22.26	22.38	21.78	21.94	44151.0
2011-11-04	AAON	Stock	6.5037	6.7022	6.2933	6.4089	164700.0
2011-11-04	AAP	Stock	65.65	66.02	64.79	66.02	623400.0
2011-11-04	AAT	Stock	19.79	20.31	19.56	20.15	75100.0
2011-11-04	AATI-DELISTED	Stock	3.82	3.87	3.62	3.84	275294.0
2011-11-04	AAU-DELISTED	Stock	2.75	2.82	2.67	2.77	110256.0
2011-11-04	AAUAF-DELISTED	Stock	2.75	2.82	2.67	2.77	111556.0
2011-11-04	AAV-DELISTED	Stock	5.32	5.35	5.12	5.19	220062.0
2011-11-04	AAWW-DELISTED	Stock	38.48	39.29	37.71	38.26	275632.0
2011-11-04	AAXJ	Stock	54.44	54.5	53.62	54.35	310131.0
2011-11-04	AAXN-DELISTED	Stock	5.4	5.5	5.3	5.43	458593.0
2011-11-04	AB	Stock	13.64	13.64	13.32	13.46	369500.0
2011-11-04	ABAC-DELISTED	Stock	1.86	2.1	1.84	2.05	11800.0
2011-11-04	ABAX-DELISTED	Stock	27.46	27.87	27.32	27.74	141581.0
2011-11-04	ABB-DELISTED	Stock	18.76	18.855	18.5	18.77	2273912.0
2011-11-04	ABBNY-DELISTED	Stock	18.76	18.855	18.5	18.78	2336524.0
2011-11-04	ABC-DELISTED	Stock	39.67	39.8	38.95	39.21	2541664.0
2011-11-04	ABCB	Stock	10.42	10.42	10.18	10.29	23700.0
2011-11-04	ABCD-DELISTED	Stock	3.34	3.34	3.25	3.3	31710.0
2011-11-04	ABCO-DELISTED	Stock	34.85	36.19	34.68	36.0	354146.0
2011-11-04	ABCW-DELISTED	Stock	0.5	0.53	0.49	0.52	61420.0
2011-11-04	ABD-DELISTED	Stock	7.125	7.255	7.008	7.115	161570.0
2011-11-04	ABE-DELISTED	Stock	18.04	18.25	17.12	18.25	22626.0
2011-11-04	ABEO	Stock	1700.0	1700.0	1650.0	1675.0	25.0
2011-11-04	ABFS-DELISTED	Stock	19.84	20.2	19.0	20.15	392148.0
2011-11-04	ABG	Stock	18.41	18.59	18.03	18.52	400400.0
2011-11-04	ABH-DELISTED	Stock	16.37	16.41	16.04	16.04	170792.0
2011-11-04	ABM	Stock	20.01	20.13	19.64	19.91	159900.0
2011-11-04	ABMD-DELISTED	Stock	17.44	20.0	17.44	18.73	1361012.0
2011-11-04	ABR	Stock	3.45	3.55	3.43	3.55	64700.0
2011-11-04	ABT	Stock	25.7077	25.7365	25.3574	25.5877	10694664.0
2011-11-04	ABTL-DELISTED	Stock	4.453	4.5969	4.3576	4.547	746.0
2011-11-04	ABUS	Stock	1.7	1.7	1.68	1.7	12200.0
2011-11-04	ABV-DELISTED	Stock	33.56	33.71	33.255	33.31	1802793.0
2011-11-04	ABVA-DELISTED	Stock	5.15	5.2	5.1	5.1	13752.0
2011-11-04	ABVT-DELISTED	Stock	59.39	60.56	58.95	60.06	258193.0
2011-11-04	ABX-DELISTED	Stock	51.33	51.88	50.49	51.4	4448937.0
2011-11-04	ACAD	Stock	1.15	1.18	1.15	1.16	86700.0

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

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