PREVIEW / stock_daily / 2011-08-10

all stock daily files

  file:    by_date/stock_daily/2011/2011-08-10.parquet
  size:    196 KB
  rows:    6,119
  symbols: 3,553

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-08-10	AAPL	Stock	13.2554	13.3804	12.9464	12.9889	878656800.0
2011-08-10	MSFT	Stock	24.95	25.09	24.1	24.2	127819900.0
2011-08-10	NVDA	Stock	0.3138	0.3228	0.3068	0.3085	1140052000.0
2011-08-10	AMZN	Stock	10.038	10.12	9.68	9.7065	175152000.0
2011-08-10	TSLA	Stock	1.696	1.696	1.5753	1.588	23463000.0
2011-08-10	TLT	Stock	107.63	109.07	106.94	109.02	46221042.0
2011-08-10	ES	Stock	31.42	32.13	31.14	31.23	3625100.0
2011-08-10	CL	Stock	41.095	41.495	39.99	40.09	10443600.0
2011-08-10	A	Stock	23.834	24.1416	22.7325	22.7825	14205497.0
2011-08-10	AABA-DELISTED	Stock	11.76	12.14	11.62	11.77	46713673.0
2011-08-10	AACC-DELISTED	Stock	4.41	4.46	4.25	4.25	15531.0
2011-08-10	AACG	Stock	9.04	9.63	9.0	9.5	13100.0
2011-08-10	AAIC-DELISTED	Stock	24.5	24.59	23.1	23.15	85447.0
2011-08-10	AAME	Stock	1.85	1.89	1.67	1.85	7400.0
2011-08-10	AAON	Stock	5.6326	5.8726	5.4459	5.4815	399600.0
2011-08-10	AAP	Stock	50.3	51.42	49.5	50.1	1893500.0
2011-08-10	AAT	Stock	18.25	19.11	17.85	18.06	890400.0
2011-08-10	AATI-DELISTED	Stock	6.02	6.02	5.85	5.9	1600393.0
2011-08-10	AAU-DELISTED	Stock	2.95	3.32	2.95	3.22	298136.0
2011-08-10	AAUAF-DELISTED	Stock	2.95	3.32	2.95	3.21	295936.0
2011-08-10	AAV-DELISTED	Stock	5.56	5.74	5.2699	5.55	694089.0
2011-08-10	AAWW-DELISTED	Stock	43.01	43.95	40.5	40.63	294590.0
2011-08-10	AAXJ	Stock	54.27	54.47	52.9	52.96	660029.0
2011-08-10	AAXN-DELISTED	Stock	3.9	3.9	3.57	3.59	512010.0
2011-08-10	AB	Stock	13.99	14.42	13.5	13.63	672400.0
2011-08-10	ABAC-DELISTED	Stock	2.16	2.3	2.16	2.23	28150.0
2011-08-10	ABAX-DELISTED	Stock	21.84	22.51	21.28	21.39	271297.0
2011-08-10	ABB-DELISTED	Stock	21.82	21.85	20.57	20.59	7156249.0
2011-08-10	ABBC-DELISTED	Stock	8.3	8.31	7.72	7.8	164404.0
2011-08-10	ABBNY-DELISTED	Stock	21.82	21.85	20.57	20.59	7158904.0
2011-08-10	ABC-DELISTED	Stock	36.06	36.33	35.15	35.23	4777730.0
2011-08-10	ABCB	Stock	9.5	9.52	8.56	8.7	109900.0
2011-08-10	ABCD-DELISTED	Stock	2.68	3.12	2.68	2.76	49342.0
2011-08-10	ABCO-DELISTED	Stock	28.26	28.8	26.99	27.35	316047.0
2011-08-10	ABCW-DELISTED	Stock	0.61	0.62	0.6	0.61	111320.0
2011-08-10	ABD-DELISTED	Stock	7.02	7.2	6.46	6.49	484240.0
2011-08-10	ABE-DELISTED	Stock	17.09	17.19	16.8	17.06	25439.0
2011-08-10	ABEO	Stock	2500.0	2750.0	2450.0	2625.0	7.0
2011-08-10	ABFS-DELISTED	Stock	20.19	20.38	19.15	19.21	384868.0
2011-08-10	ABG	Stock	18.37	18.55	17.32	17.35	690800.0
2011-08-10	ABH-DELISTED	Stock	16.74	17.27	15.41	15.6	1617010.0
2011-08-10	ABM	Stock	18.9	19.26	18.4	18.44	576000.0
2011-08-10	ABMD-DELISTED	Stock	10.73	11.02	10.1	10.32	336069.0
2011-08-10	ABR	Stock	3.73	3.83	3.67	3.76	40800.0
2011-08-10	ABT	Stock	23.2847	23.3231	22.4306	22.4978	28365152.0
2011-08-10	ABTL-DELISTED	Stock	4.4003	4.4003	4.1502	4.1997	16223.0
2011-08-10	ABUS	Stock	2.37	2.37	2.11	2.31	3300.0
2011-08-10	ABV-DELISTED	Stock	28.8	29.38	28.38	28.41	4288470.0
2011-08-10	ABVA-DELISTED	Stock	4.55	4.57	4.511	4.511	20066.0
2011-08-10	ABVT-DELISTED	Stock	58.54	58.89	56.65	57.87	418610.0

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

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