PREVIEW / stock_daily / 2011-09-13

all stock daily files

  file:    by_date/stock_daily/2011/2011-09-13.parquet
  size:    193 KB
  rows:    6,037
  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-09-13	AAPL	Stock	13.6479	13.7932	13.5804	13.7364	440560400.0
2011-09-13	MSFT	Stock	25.92	26.19	25.81	26.04	48792300.0
2011-09-13	NVDA	Stock	0.3582	0.365	0.3528	0.3632	853836000.0
2011-09-13	AMZN	Stock	10.8895	10.9975	10.7505	10.9765	96718000.0
2011-09-13	TSLA	Stock	1.534	1.6067	1.5167	1.6053	10897500.0
2011-09-13	TLT	Stock	113.4	113.59	112.11	112.21	9282360.0
2011-09-13	ES	Stock	33.4	33.75	33.15	33.69	1208100.0
2011-09-13	CL	Stock	43.975	44.89	43.55	44.73	5570200.0
2011-09-13	A	Stock	23.9771	25.0358	23.8841	24.8784	7681451.0
2011-09-13	AABA-DELISTED	Stock	14.3	14.34	14.12	14.26	19922217.0
2011-09-13	AACC-DELISTED	Stock	3.98	4.04	3.81	3.92	4735.0
2011-09-13	AACG	Stock	9.27	9.27	9.13	9.27	4800.0
2011-09-13	AAIC-DELISTED	Stock	24.37	24.67	24.25	24.61	19528.0
2011-09-13	AAME	Stock	2.0	2.04	1.89	2.04	8400.0
2011-09-13	AAON	Stock	4.8089	4.9215	4.72	4.8948	133988.0
2011-09-13	AAP	Stock	60.72	61.31	60.26	60.65	854000.0
2011-09-13	AAT	Stock	18.46	18.93	18.38	18.83	113600.0
2011-09-13	AATI-DELISTED	Stock	4.62	4.66	4.41	4.48	1596802.0
2011-09-13	AAU-DELISTED	Stock	3.33	3.43	3.29	3.34	193932.0
2011-09-13	AAUAF-DELISTED	Stock	3.33	3.43	3.29	3.34	194380.0
2011-09-13	AAV-DELISTED	Stock	5.1	5.18	5.03	5.15	308211.0
2011-09-13	AAWW-DELISTED	Stock	44.1	45.215	43.4912	44.8	221495.0
2011-09-13	AAXJ	Stock	52.76	53.12	52.38	53.03	270744.0
2011-09-13	AAXN-DELISTED	Stock	4.33	4.47	4.33	4.45	326847.0
2011-09-13	AB	Stock	16.65	16.74	16.48	16.61	345500.0
2011-09-13	ABAC-DELISTED	Stock	2.17	2.1899	2.01	2.06	10679.0
2011-09-13	ABAX-DELISTED	Stock	24.06	24.69	23.87	24.53	84064.0
2011-09-13	ABB-DELISTED	Stock	17.86	18.19	17.71	18.05	2990030.0
2011-09-13	ABBC-DELISTED	Stock	8.11	8.19	7.98	8.14	16548.0
2011-09-13	ABBNY-DELISTED	Stock	17.86	18.19	17.71	18.03	3008880.0
2011-09-13	ABC-DELISTED	Stock	38.08	38.64	37.88	38.53	1929828.0
2011-09-13	ABCB	Stock	8.67	9.01	8.61	8.87	42400.0
2011-09-13	ABCD-DELISTED	Stock	2.94	3.0	2.9	3.0	46966.0
2011-09-13	ABCO-DELISTED	Stock	29.38	29.84	28.99	29.66	188324.0
2011-09-13	ABCW-DELISTED	Stock	0.5511	0.5711	0.5411	0.5689	21330.0
2011-09-13	ABD-DELISTED	Stock	5.58	5.7201	5.42	5.63	329790.0
2011-09-13	ABE-DELISTED	Stock	17.76	17.85	17.47	17.66	8689.0
2011-09-13	ABEO	Stock	2600.0	2600.0	2375.0	2600.0	5.0
2011-09-13	ABFS-DELISTED	Stock	19.28	19.96	19.19	19.77	665194.0
2011-09-13	ABG	Stock	18.37	19.43	18.19	19.31	662300.0
2011-09-13	ABH-DELISTED	Stock	15.97	16.38	15.88	16.16	128078.0
2011-09-13	ABM	Stock	18.96	19.16	18.63	19.09	548700.0
2011-09-13	ABMD-DELISTED	Stock	10.78	10.99	10.71	10.9	170812.0
2011-09-13	ABR	Stock	4.12	4.18	4.05	4.17	16900.0
2011-09-13	ABT	Stock	24.2779	24.3738	24.1243	24.2683	12012505.0
2011-09-13	ABTL-DELISTED	Stock	4.4116	4.4914	4.2923	4.4884	1383.0
2011-09-13	ABUS	Stock	2.06	2.06	2.06	2.06	500.0
2011-09-13	ABV-DELISTED	Stock	32.41	32.47	31.78	32.32	1937326.0
2011-09-13	ABVT-DELISTED	Stock	55.99	56.49	55.15	56.22	102937.0
2011-09-13	ABX-DELISTED	Stock	53.53	53.89	52.5	53.63	6720566.0

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

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