PREVIEW / stock_daily / 2011-05-02

all stock daily files

  file:    by_date/stock_daily/2011/2011-05-02.parquet
  size:    198 KB
  rows:    6,144
  symbols: 3,583

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-02	AAPL	Stock	12.4907	12.5168	12.3393	12.3671	442713600.0
2011-05-02	MSFT	Stock	25.94	26.0	25.48	25.66	89825600.0
2011-05-02	NVDA	Stock	0.5105	0.5108	0.4908	0.4932	613824000.0
2011-05-02	AMZN	Stock	9.8285	10.171	9.809	10.0595	187962000.0
2011-05-02	TSLA	Stock	1.84	1.8533	1.804	1.83	11769000.0
2011-05-02	TLT	Stock	93.32	93.68	93.17	93.64	5286363.0
2011-05-02	ES	Stock	35.83	35.89	35.59	35.67	810600.0
2011-05-02	CL	Stock	42.205	42.37	42.0	42.275	5176200.0
2011-05-02	A	Stock	35.9442	36.309	35.7797	36.0801	3657867.0
2011-05-02	AABA-DELISTED	Stock	17.76	18.345	17.57	18.14	43536055.0
2011-05-02	AACC-DELISTED	Stock	5.68	5.74	5.13	5.13	13184.0
2011-05-02	AACG	Stock	8.15	8.15	7.87	8.0	17800.0
2011-05-02	AAI-DELISTED	Stock	7.54	7.57	7.43	7.47	36318094.0
2011-05-02	AAIC-DELISTED	Stock	30.79	30.83	29.91	29.91	53707.0
2011-05-02	AAME	Stock	2.03	2.23	2.01	2.1	6300.0
2011-05-02	AAON	Stock	6.5067	6.5185	6.4415	6.4454	187312.0
2011-05-02	AAP	Stock	65.29	65.57	65.06	65.44	802400.0
2011-05-02	AAT	Stock	22.08	22.19	21.94	22.11	131000.0
2011-05-02	AATI-DELISTED	Stock	4.29	4.29	4.09	4.18	119981.0
2011-05-02	AAU-DELISTED	Stock	4.95	5.04	4.25	4.33	1405469.0
2011-05-02	AAUAF-DELISTED	Stock	4.95	5.04	4.25	4.34	1412884.0
2011-05-02	AAV-DELISTED	Stock	8.46	8.56	8.32	8.38	463451.0
2011-05-02	AAWW-DELISTED	Stock	69.42	69.66	66.96	68.88	193959.0
2011-05-02	AAXJ	Stock	65.0	65.307	64.81	64.96	206310.0
2011-05-02	AAXN-DELISTED	Stock	4.47	4.47	4.39	4.43	434842.0
2011-05-02	AB	Stock	22.34	22.7	21.8	21.9	604600.0
2011-05-02	ABAC-DELISTED	Stock	3.2	3.25	3.2	3.25	60599.0
2011-05-02	ABAX-DELISTED	Stock	29.13	29.31	28.45	28.58	125444.0
2011-05-02	ABB-DELISTED	Stock	27.28	27.47	26.94	26.95	2666060.0
2011-05-02	ABBC-DELISTED	Stock	12.18	12.18	11.85	11.95	43448.0
2011-05-02	ABBNY-DELISTED	Stock	27.28	27.47	26.94	26.94	2667270.0
2011-05-02	ABC-DELISTED	Stock	40.76	41.23	40.46	41.16	4348867.0
2011-05-02	ABCB	Stock	9.96	10.0	9.66	9.71	38000.0
2011-05-02	ABCD-DELISTED	Stock	3.45	3.45	3.28	3.35	27845.0
2011-05-02	ABCO-DELISTED	Stock	23.38	23.72	23.36	23.7	160655.0
2011-05-02	ABCW-DELISTED	Stock	0.7901	0.8391	0.7901	0.82	53420.0
2011-05-02	ABD-DELISTED	Stock	9.75	9.94	9.68	9.82	420350.0
2011-05-02	ABE-DELISTED	Stock	19.3	19.4199	19.29	19.29	10310.0
2011-05-02	ABEO	Stock	2750.0	2875.0	2662.5	2875.0	13.0
2011-05-02	ABFS-DELISTED	Stock	23.15	23.2	22.5	22.61	289104.0
2011-05-02	ABG	Stock	17.29	17.39	16.93	16.99	530700.0
2011-05-02	ABH-DELISTED	Stock	26.74	27.22	26.57	26.82	378817.0
2011-05-02	ABM	Stock	24.44	24.44	23.83	23.91	193000.0
2011-05-02	ABMD-DELISTED	Stock	17.42	17.58	17.03	17.16	227224.0
2011-05-02	ABR	Stock	5.26	5.28	5.1	5.14	31000.0
2011-05-02	ABT	Stock	25.0552	25.2999	24.9976	25.2327	15979158.0
2011-05-02	ABTL-DELISTED	Stock	7.403	7.504	6.997	7.2	56355.0
2011-05-02	ABUS	Stock	2.98	3.09	2.98	3.09	5500.0
2011-05-02	ABV-DELISTED	Stock	32.47	33.1	32.34	32.86	2658775.0
2011-05-02	ABVA-DELISTED	Stock	6.83	6.95	6.83	6.95	9639.0

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

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