PREVIEW / stock_daily / 2011-04-15

all stock daily files

  file:    by_date/stock_daily/2011/2011-04-15.parquet
  size:    198 KB
  rows:    6,084
  symbols: 3,544

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-04-15	AAPL	Stock	11.9036	11.9157	11.6714	11.695	453605600.0
2011-04-15	MSFT	Stock	25.46	25.56	25.18	25.37	65080400.0
2011-04-15	NVDA	Stock	0.4593	0.4735	0.457	0.4678	969720000.0
2011-04-15	AMZN	Stock	9.05	9.089	8.951	9.0005	85448000.0
2011-04-15	TSLA	Stock	1.71	1.7453	1.694	1.7053	14152500.0
2011-04-15	TLT	Stock	92.26	92.71	92.07	92.67	10223053.0
2011-04-15	ES	Stock	33.74	34.08	33.74	33.96	2052400.0
2011-04-15	CL	Stock	40.9	40.985	40.775	40.905	6609200.0
2011-04-15	A	Stock	33.3405	34.3205	33.1402	33.9771	6851598.0
2011-04-15	AABA-DELISTED	Stock	16.66	16.78	16.54	16.61	13295367.0
2011-04-15	AACC-DELISTED	Stock	5.21	5.42	5.21	5.4	52598.0
2011-04-15	AACG	Stock	8.0	8.1	7.8	7.87	25400.0
2011-04-15	AAI-DELISTED	Stock	7.38	7.4	7.35	7.38	3765530.0
2011-04-15	AAIC-DELISTED	Stock	29.05	29.54	28.7	29.49	46611.0
2011-04-15	AAME	Stock	2.03	2.04	2.03	2.04	600.0
2011-04-15	AAON	Stock	6.1689	6.1886	6.0899	6.1728	242494.0
2011-04-15	AAP	Stock	63.96	64.4	63.73	63.84	1184600.0
2011-04-15	AAT	Stock	21.34	21.55	21.2	21.5	160400.0
2011-04-15	AATI-DELISTED	Stock	4.07	4.23	4.05	4.2	287947.0
2011-04-15	AAU-DELISTED	Stock	4.35	4.54	4.3	4.53	384194.0
2011-04-15	AAUAF-DELISTED	Stock	4.35	4.54	4.3	4.53	384494.0
2011-04-15	AAV-DELISTED	Stock	8.39	8.65	8.28	8.55	480215.0
2011-04-15	AAWW-DELISTED	Stock	63.97	65.205	63.85	65.18	204061.0
2011-04-15	AAXJ	Stock	63.98	64.02	63.63	63.91	566896.0
2011-04-15	AAXN-DELISTED	Stock	3.88	3.92	3.84	3.89	188689.0
2011-04-15	AB	Stock	21.88	22.2	21.59	21.89	309100.0
2011-04-15	ABAC-DELISTED	Stock	3.53	3.63	3.39	3.4	78606.0
2011-04-15	ABAX-DELISTED	Stock	29.16	29.54	28.83	29.17	133575.0
2011-04-15	ABB-DELISTED	Stock	24.24	24.51	24.19	24.49	2469990.0
2011-04-15	ABBC-DELISTED	Stock	12.01	12.28	11.99	12.26	49991.0
2011-04-15	ABBNY-DELISTED	Stock	24.24	24.51	24.19	24.5	2475531.0
2011-04-15	ABC-DELISTED	Stock	39.81	39.925	39.5	39.6	2642833.0
2011-04-15	ABCB	Stock	9.72	9.73	9.61	9.68	75200.0
2011-04-15	ABCD-DELISTED	Stock	3.25	3.3	3.25	3.27	25118.0
2011-04-15	ABCO-DELISTED	Stock	24.16	24.26	24.05	24.23	97449.0
2011-04-15	ABCW-DELISTED	Stock	0.9294	0.9304	0.9204	0.9206	56590.0
2011-04-15	ABD-DELISTED	Stock	9.39	9.54	9.14	9.51	265600.0
2011-04-15	ABE-DELISTED	Stock	18.81	18.84	18.81	18.8388	2516.0
2011-04-15	ABEO	Stock	2687.5	2812.5	2687.5	2812.5	28.0
2011-04-15	ABFS-DELISTED	Stock	25.06	25.5	25.06	25.46	186589.0
2011-04-15	ABG	Stock	17.24	17.57	16.89	16.97	298700.0
2011-04-15	ABH-DELISTED	Stock	26.18	26.57	25.83	25.9	179945.0
2011-04-15	ABM	Stock	24.34	24.75	24.24	24.65	166400.0
2011-04-15	ABMD-DELISTED	Stock	16.0	17.38	15.63	16.94	2309245.0
2011-04-15	ABR	Stock	5.32	5.33	5.29	5.32	10400.0
2011-04-15	ABT	Stock	24.6713	24.9352	24.5226	24.9016	27354106.0
2011-04-15	ABTL-DELISTED	Stock	6.7	7.0	6.25	6.75	42759.0
2011-04-15	ABUS	Stock	2.93	2.99	2.93	2.96	21500.0
2011-04-15	ABV-DELISTED	Stock	29.83	30.08	29.74	30.03	2196676.0
2011-04-15	ABVA-DELISTED	Stock	5.5	6.48	5.5	6.25	69843.0

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

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