PREVIEW / stock_daily / 2012-10-23

all stock daily files

  file:    by_date/stock_daily/2012/2012-10-23.parquet
  size:    200 KB
  rows:    6,185
  symbols: 3,502

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-10-23	AAPL	Stock	22.5357	22.6393	21.8464	21.9057	707145600.0
2012-10-23	MSFT	Stock	27.77	28.2	27.76	28.05	64414800.0
2012-10-23	NVDA	Stock	0.2965	0.3103	0.2958	0.3083	573948000.0
2012-10-23	AMZN	Stock	11.5525	11.825	11.5005	11.7155	88616000.0
2012-10-23	META	Stock	19.25	19.8	19.1	19.5	78381200.0
2012-10-23	TSLA	Stock	1.8253	1.904	1.8247	1.8927	11235000.0
2012-10-23	TLT	Stock	122.1	122.73	122.0217	122.69	5760796.0
2012-10-23	ES	Stock	39.3	39.38	38.99	39.05	1474300.0
2012-10-23	CL	Stock	53.565	53.625	53.03	53.265	2678400.0
2012-10-23	A	Stock	25.3076	25.5579	25.3076	25.4006	4611303.0
2012-10-23	AABA-DELISTED	Stock	16.53	16.79	16.26	16.67	68684756.0
2012-10-23	AACC-DELISTED	Stock	7.04	7.22	6.94	6.98	6929.0
2012-10-23	AACG	Stock	5.13	5.13	5.13	5.13	500.0
2012-10-23	AAIC-DELISTED	Stock	21.78	21.85	21.38	21.63	127562.0
2012-10-23	AAME	Stock	2.88	2.89	2.88	2.89	900.0
2012-10-23	AAMRQ-DELISTED	Stock	0.364	0.37	0.362	0.366	687060.0
2012-10-23	AAON	Stock	5.8578	6.0681	5.843	6.0415	149513.0
2012-10-23	AAP	Stock	65.7	67.55	65.07	67.29	1296700.0
2012-10-23	AAT	Stock	27.28	27.7	27.11	27.59	104600.0
2012-10-23	AAU-DELISTED	Stock	2.61	2.61	2.555	2.57	64555.0
2012-10-23	AAUAF-DELISTED	Stock	2.62	2.62	2.56	2.56	64536.0
2012-10-23	AAV-DELISTED	Stock	3.63	3.63	3.54	3.59	351095.0
2012-10-23	AAWW-DELISTED	Stock	50.69	52.56	50.5201	52.32	129699.0
2012-10-23	AAXJ	Stock	56.05	56.1395	55.6	55.87	359372.0
2012-10-23	AAXN-DELISTED	Stock	6.38	6.52	6.31	6.52	569074.0
2012-10-23	AB	Stock	15.97	16.0	15.61	15.72	142100.0
2012-10-23	ABAC-DELISTED	Stock	1.54	1.54	1.42	1.42	2358.0
2012-10-23	ABAX-DELISTED	Stock	36.26	36.475	35.6	36.29	129448.0
2012-10-23	ABB-DELISTED	Stock	19.03	19.03	18.81	18.91	2355081.0
2012-10-23	ABBNY-DELISTED	Stock	19.03	19.03	18.81	18.91	2371657.0
2012-10-23	ABC-DELISTED	Stock	40.0	40.13	39.76	39.93	1692633.0
2012-10-23	ABCB	Stock	11.9	12.16	11.74	11.93	33800.0
2012-10-23	ABCD-DELISTED	Stock	0.97	1.03	0.94	0.94	10513.0
2012-10-23	ABCO-DELISTED	Stock	45.89	46.53	45.54	46.35	83274.0
2012-10-23	ABCW-DELISTED	Stock	0.37	0.38	0.37	0.38	10037.0
2012-10-23	ABE-DELISTED	Stock	20.38	20.48	20.34	20.4563	9977.0
2012-10-23	ABEO	Stock	337.5	337.5	337.5	337.5	22.0
2012-10-23	ABFS-DELISTED	Stock	7.68	7.82	7.54	7.8	196988.0
2012-10-23	ABG	Stock	30.0	31.09	29.07	30.89	578200.0
2012-10-23	ABM	Stock	18.31	18.31	18.02	18.23	137400.0
2012-10-23	ABMD-DELISTED	Stock	18.89	19.075	18.52	18.71	493506.0
2012-10-23	ABR	Stock	5.49	5.49	5.38	5.39	118700.0
2012-10-23	ABT	Stock	31.2446	31.5996	31.0575	31.3597	20737182.0
2012-10-23	ABTL-DELISTED	Stock	3.96	3.98	3.78	3.83	16749.0
2012-10-23	ABUS	Stock	4.02	4.02	3.92	3.99	14900.0
2012-10-23	ABV-DELISTED	Stock	41.02	41.1	40.685	40.72	1644320.0
2012-10-23	ABVA-DELISTED	Stock	4.47	4.47	4.445	4.445	2200.0
2012-10-23	ABX-DELISTED	Stock	38.67	39.085	38.37	38.92	6791983.0
2012-10-23	ACAD	Stock	2.22	2.34	2.16	2.29	934500.0
2012-10-23	ACAS-DELISTED	Stock	11.72	11.8	11.55	11.76	2017325.0

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

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