PREVIEW / stock_daily / 2014-11-28

all stock daily files

  file:    by_date/stock_daily/2014/2014-11-28.parquet
  size:    218 KB
  rows:    6,523
  symbols: 3,474

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-28	AAPL	Stock	29.8175	29.85	29.5125	29.7325	99257600.0
2014-11-28	MSFT	Stock	47.95	48.2	47.61	47.81	21534400.0
2014-11-28	NVDA	Stock	0.5247	0.5272	0.52	0.5242	124832000.0
2014-11-28	AMZN	Stock	16.8015	17.063	16.8015	16.932	61036000.0
2014-11-28	GOOGL	Stock	27.35	27.48	27.224	27.454	24201220.0
2014-11-28	META	Stock	77.67	78.27	77.23	77.7	15992000.0
2014-11-28	TSLA	Stock	16.3567	16.446	16.168	16.3013	31795500.0
2014-11-28	TLT	Stock	122.13	122.67	122.13	122.49	4562187.0
2014-11-28	ES	Stock	49.86	50.65	49.79	50.64	1362600.0
2014-11-28	CL	Stock	68.88	69.9	68.83	69.59	1876700.0
2014-11-28	A	Stock	42.74	42.99	42.59	42.74	1091800.0
2014-11-28	AA.B-DELISTED	Stock	53.95	53.95	53.16	53.16	35122.0
2014-11-28	AABA-DELISTED	Stock	51.87	52.0	51.642	51.73	7769905.0
2014-11-28	AAC-DELISTED	Stock	29.25	29.4	27.8074	28.86	56005.0
2014-11-28	AACG	Stock	3.85	3.89	3.85	3.88	14300.0
2014-11-28	AAIC-DELISTED	Stock	28.09	28.11	27.82	27.85	106604.0
2014-11-28	AAL	Stock	47.0	49.45	47.0	48.53	21638700.0
2014-11-28	AAMC-DELISTED	Stock	158.1824	158.1824	145.5882	145.5882	4495.0
2014-11-28	AAME	Stock	3.82	3.85	3.82	3.85	4000.0
2014-11-28	AAMI	Stock	15.58	15.722	15.19	15.5	74000.0
2014-11-28	AAOI	Stock	11.62	11.62	10.75	10.85	394500.0
2014-11-28	AAON	Stock	14.1133	14.1133	13.8	13.8133	176250.0
2014-11-28	AAP	Stock	146.0	148.06	145.67	147.08	683000.0
2014-11-28	AAT	Stock	39.08	39.57	38.82	39.3	168900.0
2014-11-28	AAU-DELISTED	Stock	1.06	1.0703	1.0288	1.06	154266.0
2014-11-28	AAUAF-DELISTED	Stock	1.02	1.06	0.99	1.06	163986.0
2014-11-28	AAV-DELISTED	Stock	4.41	4.54	4.35	4.48	281432.0
2014-11-28	AAVL-DELISTED	Stock	40.21	40.9899	39.06	39.491	30822.0
2014-11-28	AAWW-DELISTED	Stock	44.97	46.71	44.775	45.6445	135958.0
2014-11-28	AAXJ	Stock	63.05	63.08	62.8	62.89	1127507.0
2014-11-28	AAXN-DELISTED	Stock	22.0	22.12	20.93	21.48	2324781.0
2014-11-28	AB	Stock	27.13	27.22	26.81	26.84	51000.0
2014-11-28	ABAC-DELISTED	Stock	2.01	2.02	2.01	2.01	400.0
2014-11-28	ABAX-DELISTED	Stock	56.94	58.24	56.5	57.3931	101349.0
2014-11-28	ABB-DELISTED	Stock	22.48	22.505	22.42	22.42	675835.0
2014-11-28	ABBNY-DELISTED	Stock	22.48	22.505	22.42	22.42	703281.0
2014-11-28	ABBV	Stock	69.0	69.48	68.89	69.2	2953700.0
2014-11-28	ABC-DELISTED	Stock	90.49	91.59	90.46	91.07	649322.0
2014-11-28	ABCB	Stock	25.78	25.87	25.13	25.15	55500.0
2014-11-28	ABCO-DELISTED	Stock	42.55	43.27	42.5	42.6	187170.0
2014-11-28	ABCW-DELISTED	Stock	30.0	30.0	29.99	30.0	11326.0
2014-11-28	ABDC-DELISTED	Stock	12.94	13.03	12.94	13.01	2015.0
2014-11-28	ABE-DELISTED	Stock	14.27	14.28	14.27	14.28	428.0
2014-11-28	ABEO	Stock	175.25	175.25	175.0	175.25	120.0
2014-11-28	ABEV	Stock	6.56	6.58	6.49	6.55	7455400.0
2014-11-28	ABG	Stock	76.07	77.36	75.6	75.71	205900.0
2014-11-28	ABGB-DELISTED	Stock	13.08	13.15	12.6201	12.73	47110.0
2014-11-28	ABM	Stock	27.3	27.52	27.05	27.09	98900.0
2014-11-28	ABMD-DELISTED	Stock	35.77	36.09	35.41	35.53	125936.0
2014-11-28	ABR	Stock	6.88	6.93	6.88	6.91	50700.0

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

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