PREVIEW / stock_daily / 2015-02-17

all stock daily files

  file:    by_date/stock_daily/2015/2015-02-17.parquet
  size:    223 KB
  rows:    6,646
  symbols: 3,535

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
2015-02-17	AAPL	Stock	31.8725	32.22	31.73	31.9575	252609600.0
2015-02-17	MSFT	Stock	43.97	44.0	43.19	43.58	33695700.0
2015-02-17	NVDA	Stock	0.5568	0.5622	0.5532	0.5595	203340000.0
2015-02-17	AMZN	Stock	18.886	18.9995	18.6335	18.7715	73464000.0
2015-02-17	GOOGL	Stock	27.558	27.65	27.163	27.2505	39173580.0
2015-02-17	META	Stock	75.3	76.91	75.08	75.6	25254400.0
2015-02-17	TSLA	Stock	13.7133	13.7133	13.4333	13.6233	59694000.0
2015-02-17	TLT	Stock	127.8	127.93	125.92	126.26	14968830.0
2015-02-17	ES	Stock	51.0	51.6	50.48	51.23	2602700.0
2015-02-17	CL	Stock	70.0	70.46	69.63	70.19	3342300.0
2015-02-17	A	Stock	40.01	40.53	39.76	40.52	2875800.0
2015-02-17	AA.B-DELISTED	Stock	50.58	50.8899	50.1799	50.48	11569.0
2015-02-17	AABA-DELISTED	Stock	44.37	44.54	43.35	43.53	12278777.0
2015-02-17	AAC-DELISTED	Stock	29.31	29.71	29.21	29.41	16663.0
2015-02-17	AACG	Stock	4.03	4.37	4.03	4.18	9300.0
2015-02-17	AAIC-DELISTED	Stock	25.18	25.3	25.05	25.12	213452.0
2015-02-17	AAL	Stock	48.77	49.45	47.86	48.01	7260500.0
2015-02-17	AAMC-DELISTED	Stock	52.6471	55.0735	52.6471	55.0735	8629.0
2015-02-17	AAME	Stock	3.97	4.01	3.86	3.91	5100.0
2015-02-17	AAMI	Stock	16.58	17.35	16.58	17.03	339100.0
2015-02-17	AAOI	Stock	10.15	10.375	10.08	10.25	215900.0
2015-02-17	AAON	Stock	15.56	15.6667	15.4	15.4267	139200.0
2015-02-17	AAP	Stock	149.91	151.38	148.86	150.23	1564300.0
2015-02-17	AAT	Stock	42.67	43.06	42.31	42.51	79300.0
2015-02-17	AAU-DELISTED	Stock	1.12	1.12	1.1	1.1	82954.0
2015-02-17	AAUAF-DELISTED	Stock	1.12	1.12	1.1	1.1	83541.0
2015-02-17	AAV-DELISTED	Stock	4.93	5.17	4.79	5.13	226460.0
2015-02-17	AAVL-DELISTED	Stock	36.13	36.9	35.76	36.84	166278.0
2015-02-17	AAWW-DELISTED	Stock	48.0	48.81	47.5	48.21	226229.0
2015-02-17	AAXJ	Stock	63.62	63.66	63.28	63.51	738314.0
2015-02-17	AAXN-DELISTED	Stock	27.05	27.32	26.6	26.87	704224.0
2015-02-17	AB	Stock	27.21	27.59	27.2	27.25	680200.0
2015-02-17	ABAC-DELISTED	Stock	1.62	1.73	1.62	1.73	200.0
2015-02-17	ABAX-DELISTED	Stock	61.19	61.325	60.79	61.16	113477.0
2015-02-17	ABB-DELISTED	Stock	21.34	21.36	21.15	21.24	1663736.0
2015-02-17	ABBNY-DELISTED	Stock	21.34	21.36	21.15	21.24	1842456.0
2015-02-17	ABBV	Stock	58.95	59.0	57.9	58.72	12789700.0
2015-02-17	ABC-DELISTED	Stock	100.21	100.85	99.68	100.64	1828259.0
2015-02-17	ABCB	Stock	25.7	26.05	25.53	25.99	57100.0
2015-02-17	ABCD-DELISTED	Stock	2.51	2.59	2.51	2.57	62458.0
2015-02-17	ABCO-DELISTED	Stock	53.4	54.54	52.9	53.74	336778.0
2015-02-17	ABCW-DELISTED	Stock	33.65	33.65	32.78	33.5	64953.0
2015-02-17	ABDC-DELISTED	Stock	13.4	13.71	13.3871	13.59	25374.0
2015-02-17	ABE-DELISTED	Stock	13.32	13.3699	13.2	13.2735	7989.0
2015-02-17	ABEO	Stock	73.0	77.5	73.0	77.5	184.0
2015-02-17	ABEOW-DELISTED	Stock	1.3	1.3	1.08	1.08	200.0
2015-02-17	ABEV	Stock	6.38	6.44	6.3	6.41	5858800.0
2015-02-17	ABG	Stock	79.92	79.99	78.11	78.19	329100.0
2015-02-17	ABGB-DELISTED	Stock	15.93	15.97	15.7249	15.79	64717.0
2015-02-17	ABM	Stock	29.59	30.27	29.52	30.12	174500.0

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

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