PREVIEW / stock_daily / 2011-09-20

all stock daily files

  file:    by_date/stock_daily/2011/2011-09-20.parquet
  size:    194 KB
  rows:    6,085
  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-09-20	AAPL	Stock	14.8304	15.1021	14.6854	14.7661	775754000.0
2011-09-20	MSFT	Stock	27.31	27.5	26.93	26.98	49211900.0
2011-09-20	NVDA	Stock	0.3833	0.3848	0.367	0.3688	792436000.0
2011-09-20	AMZN	Stock	12.04	12.0525	11.5515	11.6625	147710000.0
2011-09-20	TSLA	Stock	1.732	1.7733	1.7113	1.734	17706000.0
2011-09-20	TLT	Stock	114.37	114.8701	114.05	114.86	6360590.0
2011-09-20	ES	Stock	34.63	35.3	34.53	34.81	1426500.0
2011-09-20	CL	Stock	46.715	47.445	46.675	46.98	4885400.0
2011-09-20	A	Stock	25.2861	26.1016	25.0644	25.0715	6024262.0
2011-09-20	AABA-DELISTED	Stock	14.5	14.66	14.28	14.355	21640773.0
2011-09-20	AACC-DELISTED	Stock	3.89	3.89	3.51	3.8	3530.0
2011-09-20	AACG	Stock	9.79	9.88	9.51	9.62	7800.0
2011-09-20	AAIC-DELISTED	Stock	26.14	26.57	25.416	25.59	71760.0
2011-09-20	AAME	Stock	2.0	2.0	1.99	1.99	1000.0
2011-09-20	AAON	Stock	4.9156	5.0193	4.7052	4.7111	208575.0
2011-09-20	AAP	Stock	62.77	63.15	61.62	61.69	1051600.0
2011-09-20	AAT	Stock	19.0	19.27	18.77	18.79	134500.0
2011-09-20	AATI-DELISTED	Stock	3.99	4.11	3.89	4.11	1183117.0
2011-09-20	AAU-DELISTED	Stock	3.45	3.67	3.41	3.45	348852.0
2011-09-20	AAUAF-DELISTED	Stock	3.45	3.67	3.41	3.45	349052.0
2011-09-20	AAV-DELISTED	Stock	5.13	5.25	5.07	5.08	170539.0
2011-09-20	AAWW-DELISTED	Stock	45.9	46.28	43.44	43.44	466213.0
2011-09-20	AAXJ	Stock	52.23	52.66	51.77	51.79	247150.0
2011-09-20	AAXN-DELISTED	Stock	4.53	4.54	4.4	4.4	273011.0
2011-09-20	AB	Stock	15.41	15.79	15.41	15.57	594400.0
2011-09-20	ABAC-DELISTED	Stock	1.95	2.0	1.76	1.98	50202.0
2011-09-20	ABAX-DELISTED	Stock	25.11	25.82	24.64	24.735	102110.0
2011-09-20	ABB-DELISTED	Stock	18.15	18.38	17.97	18.05	2051180.0
2011-09-20	ABBC-DELISTED	Stock	8.08	8.27	7.93	7.95	31768.0
2011-09-20	ABBNY-DELISTED	Stock	18.15	18.38	17.97	18.06	2057987.0
2011-09-20	ABC-DELISTED	Stock	39.7	40.37	39.33	39.7	2088127.0
2011-09-20	ABCB	Stock	8.99	9.06	8.96	9.01	45600.0
2011-09-20	ABCD-DELISTED	Stock	3.06	3.06	2.99	2.99	25873.0
2011-09-20	ABCO-DELISTED	Stock	31.01	31.43	30.45	30.5	153196.0
2011-09-20	ABCW-DELISTED	Stock	0.5505	0.5784	0.5185	0.5195	37480.0
2011-09-20	ABD-DELISTED	Stock	5.85	5.97	5.58	5.58	253500.0
2011-09-20	ABE-DELISTED	Stock	17.56	18.0	17.56	17.8188	4430.0
2011-09-20	ABEO	Stock	2325.0	2562.5	2325.0	2562.5	17.0
2011-09-20	ABFS-DELISTED	Stock	20.38	20.85	19.79	19.85	195687.0
2011-09-20	ABG	Stock	18.48	18.67	17.79	17.81	386600.0
2011-09-20	ABH-DELISTED	Stock	16.01	16.23	15.72	15.74	129445.0
2011-09-20	ABM	Stock	18.78	19.12	18.41	18.41	282600.0
2011-09-20	ABMD-DELISTED	Stock	11.63	11.92	11.41	11.48	118098.0
2011-09-20	ABR	Stock	3.99	4.03	3.97	3.99	24100.0
2011-09-20	ABT	Stock	25.0648	25.5254	24.9976	25.319	15588162.0
2011-09-20	ABTL-DELISTED	Stock	4.3515	4.5016	4.3215	4.3485	5241.0
2011-09-20	ABUS	Stock	2.09	2.25	2.09	2.17	7100.0
2011-09-20	ABV-DELISTED	Stock	32.17	32.85	31.96	32.42	2797504.0
2011-09-20	ABVA-DELISTED	Stock	5.1	5.1	5.05	5.05	1460.0
2011-09-20	ABVT-DELISTED	Stock	56.1	56.1	53.92	53.93	194900.0

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

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