PREVIEW / stock_daily / 2012-09-28

all stock daily files

  file:    by_date/stock_daily/2012/2012-09-28.parquet
  size:    201 KB
  rows:    6,197
  symbols: 3,516

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-09-28	AAPL	Stock	24.2411	24.3254	23.8125	23.825	535110800.0
2012-09-28	MSFT	Stock	30.18	30.26	29.74	29.76	54229300.0
2012-09-28	NVDA	Stock	0.3305	0.3382	0.3263	0.3335	485508000.0
2012-09-28	AMZN	Stock	12.807	12.85	12.66	12.716	49132000.0
2012-09-28	META	Stock	20.57	21.95	20.5	21.66	65486000.0
2012-09-28	TSLA	Stock	1.9153	1.9927	1.9073	1.952	65151000.0
2012-09-28	TLT	Stock	124.75	125.2354	123.805	124.22	7173350.0
2012-09-28	ES	Stock	37.92	38.32	37.8	38.23	1184300.0
2012-09-28	CL	Stock	53.715	53.735	53.245	53.61	3019800.0
2012-09-28	A	Stock	27.525	27.6252	27.0386	27.5036	6803367.0
2012-09-28	AABA-DELISTED	Stock	16.01	16.0855	15.93	15.98	18688885.0
2012-09-28	AACC-DELISTED	Stock	7.56	7.57	7.37	7.48	14103.0
2012-09-28	AACG	Stock	4.9	5.5	4.9	5.45	14900.0
2012-09-28	AAIC-DELISTED	Stock	24.07	24.09	23.48	23.86	461512.0
2012-09-28	AAME	Stock	2.75	2.8	2.61	2.74	11800.0
2012-09-28	AAMRQ-DELISTED	Stock	0.4185	0.435	0.361	0.365	6666129.0
2012-09-28	AAON	Stock	5.8785	5.9111	5.8163	5.8341	204525.0
2012-09-28	AAP	Stock	67.93	68.6	67.62	68.44	963800.0
2012-09-28	AAT	Stock	26.85	27.53	26.71	26.79	421800.0
2012-09-28	AAU-DELISTED	Stock	2.62	2.74	2.55	2.73	360827.0
2012-09-28	AAUAF-DELISTED	Stock	2.62	2.73	2.55	2.73	364142.0
2012-09-28	AAV-DELISTED	Stock	3.71	3.75	3.6901	3.75	67062.0
2012-09-28	AAWW-DELISTED	Stock	52.93	53.48	51.4302	51.65	230554.0
2012-09-28	AAXJ	Stock	56.37	56.44	56.12	56.26	185501.0
2012-09-28	AAXN-DELISTED	Stock	6.01	6.11	5.94	6.04	383498.0
2012-09-28	AB	Stock	15.66	15.81	15.19	15.41	169200.0
2012-09-28	ABAC-DELISTED	Stock	1.4	1.48	1.4	1.48	21959.0
2012-09-28	ABAX-DELISTED	Stock	36.17	36.4	35.82	35.9	82148.0
2012-09-28	ABB-DELISTED	Stock	18.99	19.01	18.67	18.7	2091565.0
2012-09-28	ABBNY-DELISTED	Stock	18.99	19.01	18.67	18.7	2118821.0
2012-09-28	ABC-DELISTED	Stock	38.95	39.05	38.64	38.7	2934213.0
2012-09-28	ABCB	Stock	12.75	12.75	12.56	12.59	55200.0
2012-09-28	ABCD-DELISTED	Stock	0.99	1.0016	0.98	0.98	11085.0
2012-09-28	ABCO-DELISTED	Stock	47.13	48.0	47.0	47.83	188977.0
2012-09-28	ABCW-DELISTED	Stock	0.38	0.39	0.38	0.39	3970.0
2012-09-28	ABE-DELISTED	Stock	20.51	21.3	20.46	20.68	43106.0
2012-09-28	ABFS-DELISTED	Stock	8.0	8.1631	7.82	7.93	270779.0
2012-09-28	ABG	Stock	28.03	28.16	27.46	27.95	124000.0
2012-09-28	ABM	Stock	18.91	19.05	18.87	18.93	388100.0
2012-09-28	ABMD-DELISTED	Stock	21.32	21.44	20.9	21.0	527544.0
2012-09-28	ABR	Stock	6.09	6.12	5.95	5.97	53700.0
2012-09-28	ABT	Stock	33.2693	33.2693	32.8231	32.8951	25240725.0
2012-09-28	ABTL-DELISTED	Stock	3.78	3.86	3.78	3.78	7940.0
2012-09-28	ABUS	Stock	3.76	3.76	3.52	3.63	27300.0
2012-09-28	ABV-DELISTED	Stock	38.3	38.68	37.705	38.27	3125195.0
2012-09-28	ABVA-DELISTED	Stock	4.66	4.66	4.53	4.53	588.0
2012-09-28	ABX-DELISTED	Stock	41.65	41.91	41.23	41.76	8157464.0
2012-09-28	ACAD	Stock	2.52	2.57	2.51	2.53	392100.0
2012-09-28	ACAS-DELISTED	Stock	11.65	11.76	11.29	11.35	2970626.0
2012-09-28	ACAT-DELISTED	Stock	41.22	42.02	40.45	41.46	146872.0

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

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