PREVIEW / stock_daily / 2014-11-13

all stock daily files

  file:    by_date/stock_daily/2014/2014-11-13.parquet
  size:    222 KB
  rows:    6,621
  symbols: 3,543

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
2014-11-13	AAPL	Stock	27.95	28.3625	27.9	28.205	238091600.0
2014-11-13	MSFT	Stock	48.81	49.65	48.71	49.61	26210400.0
2014-11-13	NVDA	Stock	0.493	0.4938	0.4848	0.4888	225328000.0
2014-11-13	AMZN	Stock	15.6	15.8945	15.5755	15.824	73728000.0
2014-11-13	GOOGL	Stock	28.0405	28.041	27.7045	27.822	30219780.0
2014-11-13	META	Stock	74.74	75.24	73.64	74.25	26448500.0
2014-11-13	TSLA	Stock	16.708	17.05	16.6833	16.78	93540000.0
2014-11-13	TLT	Stock	118.7	119.18	118.435	118.91	4475902.0
2014-11-13	ES	Stock	49.6	49.8	49.11	49.27	1371300.0
2014-11-13	CL	Stock	68.94	68.99	68.26	68.29	2316700.0
2014-11-13	A	Stock	41.55	41.74	41.26	41.45	1805500.0
2014-11-13	AA.B-DELISTED	Stock	52.49	52.6	52.03	52.22	43658.0
2014-11-13	AABA-DELISTED	Stock	50.96	51.17	49.95	50.5	32725916.0
2014-11-13	AAC-DELISTED	Stock	24.84	27.15	24.84	26.76	101594.0
2014-11-13	AACG	Stock	3.87	3.87	3.87	3.87	100.0
2014-11-13	AAIC-DELISTED	Stock	27.38	27.47	27.11	27.23	173766.0
2014-11-13	AAL	Stock	43.54	44.46	43.49	44.12	11135000.0
2014-11-13	AAMC-DELISTED	Stock	152.9559	156.7618	141.0353	144.6588	50548.0
2014-11-13	AAME	Stock	3.86	3.89	3.85	3.89	6400.0
2014-11-13	AAMI	Stock	15.73	16.3	15.43	15.59	284900.0
2014-11-13	AAOI	Stock	12.4	12.58	12.06	12.1	655800.0
2014-11-13	AAON	Stock	14.3867	14.3867	14.02	14.08	239250.0
2014-11-13	AAP	Stock	146.45	147.27	145.41	146.0	519400.0
2014-11-13	AAT	Stock	39.04	39.44	38.81	39.2	169500.0
2014-11-13	AAU-DELISTED	Stock	1.13	1.13	1.04	1.06	86873.0
2014-11-13	AAUAF-DELISTED	Stock	1.13	1.13	1.04	1.06	87397.0
2014-11-13	AAV-DELISTED	Stock	4.75	4.75	4.52	4.6	183171.0
2014-11-13	AAVL-DELISTED	Stock	33.55	34.94	33.55	34.45	145403.0
2014-11-13	AAWW-DELISTED	Stock	42.0	42.09	40.8137	41.1	211390.0
2014-11-13	AAXJ	Stock	62.54	62.59	62.27	62.43	316612.0
2014-11-13	AAXN-DELISTED	Stock	19.8	20.3601	19.2	19.65	3369061.0
2014-11-13	AB	Stock	26.73	27.27	26.7	27.0	291300.0
2014-11-13	ABAC-DELISTED	Stock	2.2499	2.35	2.23	2.2699	51398.0
2014-11-13	ABAX-DELISTED	Stock	54.05	55.52	54.05	55.02	173475.0
2014-11-13	ABB-DELISTED	Stock	22.33	22.5	21.93	22.08	2633603.0
2014-11-13	ABBNY-DELISTED	Stock	22.33	22.5	21.93	22.07	2820670.0
2014-11-13	ABBV	Stock	64.25	64.79	63.4	63.63	4510200.0
2014-11-13	ABC-DELISTED	Stock	88.54	89.48	88.54	89.1	1327393.0
2014-11-13	ABCB	Stock	26.4	26.4	25.91	25.96	73200.0
2014-11-13	ABCD-DELISTED	Stock	1.85	1.96	1.75	1.75	54271.0
2014-11-13	ABCO-DELISTED	Stock	48.13	48.34	46.02	46.22	322977.0
2014-11-13	ABDC-DELISTED	Stock	13.09	13.1999	12.81	12.81	75695.0
2014-11-13	ABE-DELISTED	Stock	13.81	13.82	13.782	13.782	1087.0
2014-11-13	ABEO	Stock	180.0	187.5	180.0	187.25	116.0
2014-11-13	ABEV	Stock	6.41	6.45	6.17	6.24	19803800.0
2014-11-13	ABG	Stock	76.17	76.17	74.04	74.44	296100.0
2014-11-13	ABGB-DELISTED	Stock	15.5	15.5	14.3625	15.0	122717.0
2014-11-13	ABM	Stock	27.5	27.55	27.34	27.35	104800.0
2014-11-13	ABMD-DELISTED	Stock	33.74	33.74	32.95	33.46	313425.0
2014-11-13	ABR	Stock	7.0	7.08	6.92	7.05	99600.0

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

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