PREVIEW / stock_daily / 2011-05-17

all stock daily files

  file:    by_date/stock_daily/2011/2011-05-17.parquet
  size:    199 KB
  rows:    6,144
  symbols: 3,584

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-05-17	AAPL	Stock	11.8571	12.005	11.8118	12.005	452334400.0
2011-05-17	MSFT	Stock	24.4	24.7	24.27	24.52	82882100.0
2011-05-17	NVDA	Stock	0.441	0.4412	0.428	0.4408	1420364000.0
2011-05-17	AMZN	Stock	9.591	9.799	9.588	9.7405	141466000.0
2011-05-17	TSLA	Stock	1.8	1.8	1.7147	1.7307	18513000.0
2011-05-17	TLT	Stock	96.03	96.6	95.98	96.59	9828200.0
2011-05-17	ES	Stock	35.86	36.31	35.75	36.26	1685500.0
2011-05-17	CL	Stock	42.85	43.26	42.85	43.135	4063400.0
2011-05-17	A	Stock	36.9814	37.1316	36.3448	36.6023	6319100.0
2011-05-17	AABA-DELISTED	Stock	15.88	16.07	15.725	16.0	30932671.0
2011-05-17	AACC-DELISTED	Stock	4.15	4.25	4.15	4.25	26439.0
2011-05-17	AACG	Stock	10.05	10.71	9.89	10.5	36200.0
2011-05-17	AAIC-DELISTED	Stock	27.13	27.13	26.04	26.6	197579.0
2011-05-17	AAME	Stock	2.05	2.05	2.05	2.05	100.0
2011-05-17	AAON	Stock	6.3941	6.4711	6.3941	6.4257	99225.0
2011-05-17	AAP	Stock	69.84	69.93	68.56	69.72	1389400.0
2011-05-17	AAT	Stock	21.64	22.14	21.54	21.79	113700.0
2011-05-17	AATI-DELISTED	Stock	3.83	3.88	3.625	3.72	262259.0
2011-05-17	AAU-DELISTED	Stock	3.83	3.83	3.15	3.51	2838866.0
2011-05-17	AAUAF-DELISTED	Stock	3.83	3.83	3.15	3.45	2839166.0
2011-05-17	AAV-DELISTED	Stock	7.81	7.91	7.77	7.87	435121.0
2011-05-17	AAWW-DELISTED	Stock	62.63	62.63	60.73	61.5	184623.0
2011-05-17	AAXJ	Stock	62.02	62.36	61.81	62.2	371696.0
2011-05-17	AAXN-DELISTED	Stock	4.49	4.56	4.36	4.4	609181.0
2011-05-17	AB	Stock	21.49	21.73	21.26	21.43	419000.0
2011-05-17	ABAC-DELISTED	Stock	2.97	3.0671	2.95	2.95	14200.0
2011-05-17	ABAX-DELISTED	Stock	27.48	27.83	27.39	27.73	72505.0
2011-05-17	ABB-DELISTED	Stock	25.96	26.24	25.82	26.2	4683971.0
2011-05-17	ABBC-DELISTED	Stock	11.17	11.44	11.13	11.37	80173.0
2011-05-17	ABBNY-DELISTED	Stock	25.96	26.24	25.82	26.22	7370751.0
2011-05-17	ABC-DELISTED	Stock	42.07	42.09	41.35	42.01	2482867.0
2011-05-17	ABCB	Stock	8.85	9.14	8.84	8.9	43300.0
2011-05-17	ABCD-DELISTED	Stock	2.97	3.05	2.97	3.04	15910.0
2011-05-17	ABCO-DELISTED	Stock	24.76	25.2	24.76	25.12	102623.0
2011-05-17	ABCW-DELISTED	Stock	0.85	0.88	0.81	0.84	52430.0
2011-05-17	ABD-DELISTED	Stock	9.17	9.28	8.92	8.98	234000.0
2011-05-17	ABE-DELISTED	Stock	18.69	18.69	18.43	18.59	9912.0
2011-05-17	ABEO	Stock	2750.0	2812.5	2562.5	2812.5	21.0
2011-05-17	ABFS-DELISTED	Stock	24.06	24.29	23.77	23.88	299112.0
2011-05-17	ABG	Stock	16.28	16.34	15.92	16.22	530600.0
2011-05-17	ABH-DELISTED	Stock	25.72	26.0	24.3	24.58	3026886.0
2011-05-17	ABM	Stock	23.56	23.82	23.54	23.59	184100.0
2011-05-17	ABMD-DELISTED	Stock	17.14	17.9	16.8334	17.87	326267.0
2011-05-17	ABR	Stock	5.05	5.08	4.96	4.97	73700.0
2011-05-17	ABT	Stock	25.8612	25.8612	25.4822	25.6693	14245727.0
2011-05-17	ABTL-DELISTED	Stock	6.05	6.15	5.6	5.7	71361.0
2011-05-17	ABUS	Stock	2.9	2.9	2.77	2.77	10600.0
2011-05-17	ABV-DELISTED	Stock	30.78	31.6	30.69	31.57	2825629.0
2011-05-17	ABVA-DELISTED	Stock	6.68	6.68	6.3	6.3	46177.0
2011-05-17	ABVT-DELISTED	Stock	63.56	64.86	63.21	64.22	139461.0

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

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