PREVIEW / stock_daily / 2012-11-02

all stock daily files

  file:    by_date/stock_daily/2012/2012-11-02.parquet
  size:    199 KB
  rows:    6,149
  symbols: 3,468

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
2012-11-02	AAPL	Stock	21.2818	21.3196	20.5268	20.6	599373600.0
2012-11-02	MSFT	Stock	29.59	29.77	29.33	29.5	57131600.0
2012-11-02	NVDA	Stock	0.317	0.3175	0.3103	0.3123	256700000.0
2012-11-02	AMZN	Stock	11.7005	11.87	11.6055	11.621	67494000.0
2012-11-02	META	Stock	21.26	21.69	21.07	21.18	38344400.0
2012-11-02	TSLA	Stock	1.9513	1.97	1.9033	1.928	15454500.0
2012-11-02	TLT	Stock	121.28	122.31	121.24	122.26	3527781.0
2012-11-02	ES	Stock	39.52	39.67	39.3	39.41	1305900.0
2012-11-02	CL	Stock	53.02	53.295	52.43	52.48	2789800.0
2012-11-02	A	Stock	26.731	26.731	26.2732	26.4664	4685537.0
2012-11-02	AABA-DELISTED	Stock	17.0	17.14	16.95	17.1109	27422303.0
2012-11-02	AACC-DELISTED	Stock	6.46	6.6	6.25	6.25	35820.0
2012-11-02	AACG	Stock	4.69	5.03	4.69	4.75	9500.0
2012-11-02	AAIC-DELISTED	Stock	22.32	22.47	22.14	22.15	84795.0
2012-11-02	AAME	Stock	2.9	2.93	2.86	2.93	1000.0
2012-11-02	AAMRQ-DELISTED	Stock	0.388	0.388	0.3711	0.38	787074.0
2012-11-02	AAON	Stock	6.237	6.237	6.0296	6.0296	85725.0
2012-11-02	AAP	Stock	80.83	81.23	79.38	79.97	2432800.0
2012-11-02	AAT	Stock	27.39	27.4	26.88	27.15	199400.0
2012-11-02	AAU-DELISTED	Stock	2.63	2.665	2.55	2.56	55840.0
2012-11-02	AAUAF-DELISTED	Stock	2.64	2.67	2.55	2.55	56237.0
2012-11-02	AAV-DELISTED	Stock	3.6	3.6231	3.53	3.57	119831.0
2012-11-02	AAWW-DELISTED	Stock	44.94	45.84	44.4	44.76	778941.0
2012-11-02	AAXJ	Stock	57.59	57.59	56.85	56.94	179198.0
2012-11-02	AAXN-DELISTED	Stock	8.05	8.1	7.87	7.915	584262.0
2012-11-02	AB	Stock	16.53	16.88	16.44	16.55	278900.0
2012-11-02	ABAC-DELISTED	Stock	1.2	1.22	1.18	1.22	17118.0
2012-11-02	ABAX-DELISTED	Stock	37.48	38.05	36.97	37.12	178948.0
2012-11-02	ABB-DELISTED	Stock	18.5	18.51	18.16	18.17	1261813.0
2012-11-02	ABBNY-DELISTED	Stock	18.5	18.51	18.16	18.18	1278386.0
2012-11-02	ABC-DELISTED	Stock	41.0	41.23	40.48	40.5	2052285.0
2012-11-02	ABCB	Stock	10.89	10.89	10.7	10.81	61700.0
2012-11-02	ABCD-DELISTED	Stock	0.81	0.85	0.81	0.82	9322.0
2012-11-02	ABCO-DELISTED	Stock	47.96	49.24	47.41	48.9	189806.0
2012-11-02	ABCW-DELISTED	Stock	0.38	0.395	0.37	0.395	63240.0
2012-11-02	ABE-DELISTED	Stock	20.77	20.7904	20.74	20.74	15420.0
2012-11-02	ABEO	Stock	437.5	437.5	412.5	412.5	9.0
2012-11-02	ABFS-DELISTED	Stock	8.38	8.4	8.12	8.27	301308.0
2012-11-02	ABG	Stock	32.58	32.64	30.99	31.0	427600.0
2012-11-02	ABM	Stock	19.24	19.9	19.16	19.71	651300.0
2012-11-02	ABMD-DELISTED	Stock	14.23	15.35	13.77	13.88	3184457.0
2012-11-02	ABR	Stock	5.57	5.57	5.32	5.46	224600.0
2012-11-02	ABT	Stock	31.6092	31.6476	31.139	31.1678	13617132.0
2012-11-02	ABTL-DELISTED	Stock	3.95	3.99	3.95	3.99	200.0
2012-11-02	ABUS	Stock	4.09	4.23	4.09	4.23	17400.0
2012-11-02	ABV-DELISTED	Stock	41.2	41.38	40.64	41.02	1420649.0
2012-11-02	ABVA-DELISTED	Stock	4.465	4.465	4.465	4.465	200.0
2012-11-02	ABX-DELISTED	Stock	36.34	36.34	35.35	35.38	14966002.0
2012-11-02	ACAD	Stock	2.33	2.33	2.18	2.18	1213700.0
2012-11-02	ACAS-DELISTED	Stock	11.76	11.89	11.68	11.79	2183005.0

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

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