PREVIEW / stock_daily / 2014-11-25

all stock daily files

  file:    by_date/stock_daily/2014/2014-11-25.parquet
  size:    222 KB
  rows:    6,657
  symbols: 3,568

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-25	AAPL	Stock	29.7675	29.9375	29.3625	29.4	275361600.0
2014-11-25	MSFT	Stock	47.66	47.97	47.45	47.47	28008000.0
2014-11-25	NVDA	Stock	0.5135	0.518	0.5125	0.5142	190240000.0
2014-11-25	AMZN	Stock	16.7635	16.8165	16.564	16.752	51300000.0
2014-11-25	GOOGL	Stock	27.3605	27.625	27.3455	27.4615	38071780.0
2014-11-25	META	Stock	74.21	75.74	74.13	75.63	32250200.0
2014-11-25	TSLA	Stock	16.49	16.648	16.406	16.5393	47397000.0
2014-11-25	TLT	Stock	120.37	121.27	120.31	121.2	6770006.0
2014-11-25	ES	Stock	49.98	49.98	49.34	49.51	2290500.0
2014-11-25	CL	Stock	67.97	68.45	67.82	68.33	2570600.0
2014-11-25	A	Stock	42.33	42.87	42.31	42.71	2713900.0
2014-11-25	AA.B-DELISTED	Stock	53.69	54.069	53.36	53.48	204948.0
2014-11-25	AABA-DELISTED	Stock	52.02	52.19	51.6	51.72	12131936.0
2014-11-25	AAC-DELISTED	Stock	26.76	29.4	26.65	28.5	60542.0
2014-11-25	AACG	Stock	3.88	3.95	3.86	3.9	4000.0
2014-11-25	AAIC-DELISTED	Stock	27.8	28.19	27.75	28.14	399832.0
2014-11-25	AAL	Stock	43.18	44.44	43.1	44.15	11563800.0
2014-11-25	AAMC-DELISTED	Stock	157.6441	161.7647	155.8824	161.4706	42286.0
2014-11-25	AAME	Stock	3.81	3.82	3.81	3.82	1600.0
2014-11-25	AAMI	Stock	15.5	15.83	15.28	15.5	189600.0
2014-11-25	AAOI	Stock	12.35	12.5	11.9	11.94	412500.0
2014-11-25	AAON	Stock	14.14	14.2133	14.0067	14.08	151800.0
2014-11-25	AAP	Stock	146.0	146.44	143.11	145.45	1001700.0
2014-11-25	AAT	Stock	38.54	38.76	38.45	38.67	87600.0
2014-11-25	AAU-DELISTED	Stock	1.07	1.08	1.04	1.06	94538.0
2014-11-25	AAUAF-DELISTED	Stock	1.06	1.07	1.03	1.06	95925.0
2014-11-25	AAV-DELISTED	Stock	4.97	5.11	4.9	4.98	268695.0
2014-11-25	AAVL-DELISTED	Stock	35.87	39.67	34.9	38.74	307961.0
2014-11-25	AAWW-DELISTED	Stock	44.48	45.3	44.4	45.062	175087.0
2014-11-25	AAXJ	Stock	62.86	62.98	62.54	62.58	1584567.0
2014-11-25	AAXN-DELISTED	Stock	20.1	20.83	19.7	20.59	3901469.0
2014-11-25	AB	Stock	27.13	27.34	26.93	27.24	195200.0
2014-11-25	ABAC-DELISTED	Stock	2.2399	2.25	2.05	2.08	51987.0
2014-11-25	ABAX-DELISTED	Stock	55.91	57.29	55.5518	56.92	259963.0
2014-11-25	ABB-DELISTED	Stock	22.94	23.055	22.92	23.01	695041.0
2014-11-25	ABBNY-DELISTED	Stock	22.94	23.055	22.92	23.02	758178.0
2014-11-25	ABBV	Stock	67.64	68.21	67.15	68.06	7550800.0
2014-11-25	ABC-DELISTED	Stock	90.04	90.45	89.51	90.31	1037396.0
2014-11-25	ABCB	Stock	25.73	25.94	25.34	25.8	205900.0
2014-11-25	ABCO-DELISTED	Stock	43.51	43.78	42.42	42.97	361909.0
2014-11-25	ABCW-DELISTED	Stock	30.09	30.1	29.95	30.0	39311.0
2014-11-25	ABDC-DELISTED	Stock	12.82	13.0399	12.8	13.01	51182.0
2014-11-25	ABE-DELISTED	Stock	14.19	14.26	14.1	14.16	54929.0
2014-11-25	ABEO	Stock	176.25	200.0	176.25	176.75	68.0
2014-11-25	ABEV	Stock	6.73	6.73	6.58	6.58	9928200.0
2014-11-25	ABG	Stock	75.28	76.58	75.07	75.53	212300.0
2014-11-25	ABGB-DELISTED	Stock	13.31	13.47	13.14	13.3	86085.0
2014-11-25	ABM	Stock	27.42	27.59	27.23	27.26	95800.0
2014-11-25	ABMD-DELISTED	Stock	35.68	35.72	35.2	35.48	272980.0
2014-11-25	ABR	Stock	6.8	6.84	6.77	6.77	46100.0

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

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