PREVIEW / stock_daily / 2014-11-03

all stock daily files

  file:    by_date/stock_daily/2014/2014-11-03.parquet
  size:    222 KB
  rows:    6,626
  symbols: 3,562

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-03	AAPL	Stock	27.055	27.575	27.0025	27.35	209130400.0
2014-11-03	MSFT	Stock	46.89	47.46	46.73	47.44	23130400.0
2014-11-03	NVDA	Stock	0.4998	0.5015	0.4942	0.4968	308732000.0
2014-11-03	AMZN	Stock	15.312	15.4005	15.162	15.286	64850000.0
2014-11-03	GOOGL	Stock	28.1765	28.3575	28.0815	28.1885	30886760.0
2014-11-03	META	Stock	75.47	75.52	73.7	73.88	40727000.0
2014-11-03	TSLA	Stock	16.2	16.504	16.088	16.1727	63057000.0
2014-11-03	TLT	Stock	118.9	119.16	118.211	118.96	9726839.0
2014-11-03	ES	Stock	49.48	49.67	49.34	49.58	1585400.0
2014-11-03	CL	Stock	66.8	67.46	66.71	67.41	2817400.0
2014-11-03	A	Stock	39.9	41.24	39.49	40.84	4559800.0
2014-11-03	AA.B-DELISTED	Stock	52.1	52.68	51.87	52.61	135796.0
2014-11-03	AABA-DELISTED	Stock	46.05	46.715	45.94	46.32	15801727.0
2014-11-03	AAC-DELISTED	Stock	22.04	22.4399	21.6337	22.03	42322.0
2014-11-03	AACG	Stock	3.98	4.22	3.98	4.0	5800.0
2014-11-03	AAIC-DELISTED	Stock	27.44	27.73	27.37	27.63	339222.0
2014-11-03	AAL	Stock	41.44	42.1	41.43	42.0	8441400.0
2014-11-03	AAMC-DELISTED	Stock	159.1471	159.4647	152.9412	158.2382	38481.0
2014-11-03	AAME	Stock	3.87	3.91	3.72	3.84	15000.0
2014-11-03	AAMI	Stock	14.94	15.04	14.51	14.74	58400.0
2014-11-03	AAOI	Stock	16.1	16.66	15.955	16.2	217600.0
2014-11-03	AAON	Stock	13.1	13.4467	12.9533	13.42	392550.0
2014-11-03	AAP	Stock	148.16	149.3	147.11	147.76	891500.0
2014-11-03	AAT	Stock	38.49	38.82	37.83	38.57	187400.0
2014-11-03	AAU-DELISTED	Stock	1.18	1.18	1.11	1.12	180709.0
2014-11-03	AAUAF-DELISTED	Stock	1.18	1.18	1.11	1.13	182209.0
2014-11-03	AAV-DELISTED	Stock	4.32	4.36	4.19	4.215	293740.0
2014-11-03	AAVL-DELISTED	Stock	35.88	36.44	34.91	35.96	77043.0
2014-11-03	AAWW-DELISTED	Stock	36.87	38.47	36.84	37.46	236552.0
2014-11-03	AAXJ	Stock	62.74	62.74	62.38	62.51	683633.0
2014-11-03	AAXN-DELISTED	Stock	18.51	19.45	18.37	19.15	4283268.0
2014-11-03	AB	Stock	26.64	26.99	25.61	25.97	399400.0
2014-11-03	ABAC-DELISTED	Stock	2.4	2.4	2.3	2.39	46348.0
2014-11-03	ABAX-DELISTED	Stock	52.92	53.48	51.98	52.99	235471.0
2014-11-03	ABB-DELISTED	Stock	21.9	21.92	21.67	21.81	745480.0
2014-11-03	ABBNY-DELISTED	Stock	21.9	21.92	21.67	21.81	791083.0
2014-11-03	ABBV	Stock	63.66	63.9	62.94	63.25	8250800.0
2014-11-03	ABC-DELISTED	Stock	85.81	86.96	85.58	86.9	2331082.0
2014-11-03	ABCB	Stock	24.89	25.16	24.67	24.75	101700.0
2014-11-03	ABCD-DELISTED	Stock	1.57	1.65	1.4905	1.5	3706.0
2014-11-03	ABCO-DELISTED	Stock	53.64	53.7	52.9	53.37	238248.0
2014-11-03	ABCW-DELISTED	Stock	29.5	29.99	28.31	29.99	11813.0
2014-11-03	ABDC-DELISTED	Stock	13.38	13.38	12.78	12.98	37282.0
2014-11-03	ABE-DELISTED	Stock	14.15	14.15	13.9606	14.0	13530.0
2014-11-03	ABEO	Stock	262.5	262.5	262.5	262.5	4.0
2014-11-03	ABEV	Stock	6.49	6.54	6.38	6.45	20448300.0
2014-11-03	ABG	Stock	70.39	71.09	70.1	70.53	345800.0
2014-11-03	ABGB-DELISTED	Stock	21.92	21.95	21.69	21.8	8182.0
2014-11-03	ABM	Stock	27.62	27.81	27.25	27.26	247800.0
2014-11-03	ABMD-DELISTED	Stock	30.86	32.77	29.95	32.52	822676.0

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

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