PREVIEW / stock_daily / 2015-06-22

all stock daily files

  file:    by_date/stock_daily/2015/2015-06-22.parquet
  size:    225 KB
  rows:    6,691
  symbols: 3,525

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-06-22	AAPL	Stock	31.8725	32.015	31.77	31.9025	136157200.0
2015-06-22	MSFT	Stock	46.33	46.72	46.16	46.23	20318100.0
2015-06-22	NVDA	Stock	0.5478	0.5508	0.5362	0.5445	514236000.0
2015-06-22	AMZN	Stock	21.85	21.962	21.709	21.8145	36472000.0
2015-06-22	GOOGL	Stock	27.9705	28.2805	27.9455	27.984	34751380.0
2015-06-22	META	Stock	83.41	84.97	83.31	84.74	29383100.0
2015-06-22	TSLA	Stock	17.4767	17.6267	17.046	17.3193	68416500.0
2015-06-22	TLT	Stock	117.84	118.14	116.59	116.65	9768973.0
2015-06-22	ES	Stock	46.55	46.95	46.48	46.56	1230600.0
2015-06-22	CL	Stock	67.19	67.57	67.09	67.24	3128700.0
2015-06-22	A	Stock	39.81	40.01	39.73	39.81	3909300.0
2015-06-22	AA.B-DELISTED	Stock	42.4699	42.4699	41.54	41.6894	27672.0
2015-06-22	AABA-DELISTED	Stock	40.65	40.89	40.54	40.73	5765533.0
2015-06-22	AAC-DELISTED	Stock	44.39	44.89	43.87	44.2	125084.0
2015-06-22	AACG	Stock	5.79	5.79	5.15	5.38	47800.0
2015-06-22	AAIC-DELISTED	Stock	21.01	21.1605	20.94	20.95	372111.0
2015-06-22	AAL	Stock	42.92	43.25	42.24	43.03	15120200.0
2015-06-22	AAMC-DELISTED	Stock	45.5176	47.0559	45.3294	46.4353	9663.0
2015-06-22	AAME	Stock	3.59	3.71	3.55	3.71	1500.0
2015-06-22	AAMI	Stock	18.34	18.54	18.12	18.43	615300.0
2015-06-22	AAOI	Stock	18.41	18.79	17.52	18.01	251100.0
2015-06-22	AAON	Stock	15.7133	15.8133	15.54	15.58	173100.0
2015-06-22	AAP	Stock	161.02	163.51	160.33	163.26	879700.0
2015-06-22	AAT	Stock	41.26	41.37	40.45	40.46	515600.0
2015-06-22	AAU-DELISTED	Stock	0.89	0.89	0.8346	0.86	60880.0
2015-06-22	AAUAF-DELISTED	Stock	0.89	0.89	0.8346	0.86	61643.0
2015-06-22	AAV-DELISTED	Stock	6.32	6.47	6.22	6.44	71640.0
2015-06-22	AAVL-DELISTED	Stock	15.65	16.42	15.4	16.26	1700134.0
2015-06-22	AAWW-DELISTED	Stock	55.24	55.73	54.85	55.63	300740.0
2015-06-22	AAXJ	Stock	64.89	65.12	64.811	64.9	464810.0
2015-06-22	AAXN-DELISTED	Stock	34.72	34.88	33.79	33.99	1970287.0
2015-06-22	AB	Stock	31.0	31.0	30.36	30.42	170600.0
2015-06-22	ABAC-DELISTED	Stock	1.52	1.68	1.48	1.48	21442.0
2015-06-22	ABAX-DELISTED	Stock	52.25	53.37	52.005	53.16	369988.0
2015-06-22	ABB-DELISTED	Stock	22.61	22.62	22.41	22.415	1074860.0
2015-06-22	ABBNY-DELISTED	Stock	22.61	22.62	22.41	22.43	1152642.0
2015-06-22	ABBV	Stock	69.85	70.6	69.73	70.12	10124900.0
2015-06-22	ABC-DELISTED	Stock	112.58	113.19	111.65	111.8	768854.0
2015-06-22	ABCB	Stock	25.86	25.93	25.58	25.78	169300.0
2015-06-22	ABCD-DELISTED	Stock	4.16	4.22	4.15	4.18	19535.0
2015-06-22	ABCO-DELISTED	Stock	54.1	54.1	52.75	53.63	234604.0
2015-06-22	ABCW-DELISTED	Stock	37.25	37.255	34.67	36.91	38119.0
2015-06-22	ABDC-DELISTED	Stock	13.75	13.85	13.68	13.7	37702.0
2015-06-22	ABE-DELISTED	Stock	12.91	12.91	12.85	12.8501	6748.0
2015-06-22	ABEO	Stock	165.25	168.5	157.5	166.25	4876.0
2015-06-22	ABEV	Stock	6.19	6.21	6.13	6.15	9614600.0
2015-06-22	ABG	Stock	88.67	89.99	88.26	89.56	195100.0
2015-06-22	ABGB-DELISTED	Stock	17.45	17.5	17.26	17.26	29218.0
2015-06-22	ABIL-DELISTED	Stock	10.0	10.0	10.0	10.0	100.0
2015-06-22	ABM	Stock	33.5	33.69	33.34	33.42	123500.0

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

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