PREVIEW / stock_daily / 2013-11-07

all stock daily files

  file:    by_date/stock_daily/2013/2013-11-07.parquet
  size:    214 KB
  rows:    6,394
  symbols: 3,531

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
2013-11-07	AAPL	Stock	18.5564	18.6854	18.2993	18.3032	262620400.0
2013-11-07	MSFT	Stock	37.96	38.01	37.43	37.5	60437400.0
2013-11-07	NVDA	Stock	0.3713	0.3723	0.363	0.3638	553076000.0
2013-11-07	AMZN	Stock	17.793	17.895	17.094	17.178	84926000.0
2013-11-07	META	Stock	49.24	49.87	47.3	47.56	97128000.0
2013-11-07	TSLA	Stock	9.6127	9.71	9.1747	9.318	334270500.0
2013-11-07	TLT	Stock	105.05	106.05	104.9701	105.96	7893771.0
2013-11-07	ES	Stock	43.04	43.18	42.29	42.4	1141000.0
2013-11-07	CL	Stock	65.97	65.97	64.62	64.8	4245600.0
2013-11-07	A	Stock	36.5379	36.6237	35.6509	35.8011	4961222.0
2013-11-07	AABA-DELISTED	Stock	32.99	33.05	32.0629	32.11	16636020.0
2013-11-07	AACG	Stock	4.11	4.4	4.11	4.35	1200.0
2013-11-07	AAIC-DELISTED	Stock	25.0	25.18	24.8	24.85	128276.0
2013-11-07	AAMC-DELISTED	Stock	188.2382	190.7662	188.2353	189.1176	11560.0
2013-11-07	AAME	Stock	3.94	4.04	3.94	4.02	3900.0
2013-11-07	AAMRQ-DELISTED	Stock	9.22	9.26	9.06	9.23	2382807.0
2013-11-07	AAOI	Stock	13.0	13.48	12.75	13.0	75100.0
2013-11-07	AAON	Stock	12.8444	12.8444	11.6133	11.6311	309825.0
2013-11-07	AAP	Stock	98.51	99.25	96.58	96.67	651100.0
2013-11-07	AAT	Stock	32.79	32.79	31.7	31.89	169900.0
2013-11-07	AAU-DELISTED	Stock	1.27	1.3	1.2451	1.28	53456.0
2013-11-07	AAUAF-DELISTED	Stock	1.27	1.31	1.25	1.28	53749.0
2013-11-07	AAV-DELISTED	Stock	3.81	3.89	3.715	3.77	159399.0
2013-11-07	AAWW-DELISTED	Stock	38.2	38.92	37.921	38.34	527461.0
2013-11-07	AAXJ	Stock	59.95	59.95	58.89	58.97	952673.0
2013-11-07	AAXN-DELISTED	Stock	17.2	17.42	15.9	16.01	2008993.0
2013-11-07	AB	Stock	22.24	22.46	21.8	21.84	351100.0
2013-11-07	ABAC-DELISTED	Stock	1.82	1.84	1.7	1.7	136088.0
2013-11-07	ABAX-DELISTED	Stock	35.07	35.47	34.8	34.97	96736.0
2013-11-07	ABB-DELISTED	Stock	25.33	25.3749	25.12	25.16	960358.0
2013-11-07	ABBNY-DELISTED	Stock	25.33	25.3749	25.12	25.15	989454.0
2013-11-07	ABBV	Stock	48.17	48.36	47.18	47.24	4444900.0
2013-11-07	ABC-DELISTED	Stock	67.41	67.48	66.59	66.75	1471359.0
2013-11-07	ABCB	Stock	18.87	18.87	18.54	18.54	55600.0
2013-11-07	ABCD-DELISTED	Stock	1.31	1.36	1.28	1.33	11952.0
2013-11-07	ABCO-DELISTED	Stock	60.41	61.8	59.75	60.3	402304.0
2013-11-07	ABE-DELISTED	Stock	19.89	20.05	19.86	19.972	5491.0
2013-11-07	ABEO	Stock	375.0	400.0	375.0	400.0	7.0
2013-11-07	ABFS-DELISTED	Stock	26.55	27.04	25.39	25.44	427055.0
2013-11-07	ABG	Stock	48.57	48.75	47.38	47.86	279800.0
2013-11-07	ABGB-DELISTED	Stock	11.65	11.6514	11.4	11.5	94459.0
2013-11-07	ABM	Stock	27.65	27.77	27.25	27.3	180500.0
2013-11-07	ABMD-DELISTED	Stock	25.99	26.32	25.12	26.15	795947.0
2013-11-07	ABR	Stock	6.56	6.57	6.46	6.55	246400.0
2013-11-07	ABR.A-DELISTED	Stock	25.02	25.0499	24.95	25.0499	4925.0
2013-11-07	ABR.B-DELISTED	Stock	23.48	23.5821	23.48	23.5	3872.0
2013-11-07	ABT	Stock	37.61	38.13	37.57	37.64	9474200.0
2013-11-07	ABTL-DELISTED	Stock	8.2	8.32	7.82	8.3	93078.0
2013-11-07	ABUS	Stock	8.44	8.48	7.65	7.73	304600.0
2013-11-07	ABV-DELISTED	Stock	36.74	37.005	36.5	36.8	4441749.0

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

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