PREVIEW / stock_daily / 2015-06-17

all stock daily files

  file:    by_date/stock_daily/2015/2015-06-17.parquet
  size:    224 KB
  rows:    6,667
  symbols: 3,508

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-17	AAPL	Stock	31.93	31.97	31.685	31.825	131672400.0
2015-06-17	MSFT	Stock	45.73	46.07	45.36	45.97	28704100.0
2015-06-17	NVDA	Stock	0.533	0.5425	0.5318	0.5395	233544000.0
2015-06-17	AMZN	Stock	21.418	21.5675	21.2375	21.3905	43718000.0
2015-06-17	GOOGL	Stock	27.271	27.418	27.0905	27.33	24440980.0
2015-06-17	META	Stock	81.76	82.22	81.34	81.79	18350300.0
2015-06-17	TSLA	Stock	16.8113	17.624	16.8013	17.3607	82693500.0
2015-06-17	TLT	Stock	118.5	118.63	117.25	118.15	13626103.0
2015-06-17	ES	Stock	46.57	47.0	46.31	46.95	1111600.0
2015-06-17	CL	Stock	66.08	66.58	66.0	66.41	2356100.0
2015-06-17	A	Stock	39.76	39.8	39.32	39.6	1519400.0
2015-06-17	AA.B-DELISTED	Stock	43.0	43.0	42.6	42.7957	10644.0
2015-06-17	AABA-DELISTED	Stock	40.8	41.52	40.78	40.95	11343495.0
2015-06-17	AAC-DELISTED	Stock	43.65	43.9999	42.46	43.36	200958.0
2015-06-17	AACG	Stock	5.92	5.92	5.52	5.79	37400.0
2015-06-17	AAIC-DELISTED	Stock	20.68	20.83	20.6	20.83	279817.0
2015-06-17	AAL	Stock	39.27	40.09	38.91	39.88	9567400.0
2015-06-17	AAMC-DELISTED	Stock	45.0	46.9618	44.0559	44.5147	10421.0
2015-06-17	AAME	Stock	3.65	3.7	3.5	3.67	6800.0
2015-06-17	AAMI	Stock	17.9	18.05	17.5	17.64	6037500.0
2015-06-17	AAOI	Stock	18.98	19.18	18.42	18.66	150300.0
2015-06-17	AAON	Stock	15.8133	15.82	15.4533	15.56	161400.0
2015-06-17	AAP	Stock	159.12	160.67	157.65	158.99	688600.0
2015-06-17	AAT	Stock	39.67	40.3	39.34	40.21	300000.0
2015-06-17	AAU-DELISTED	Stock	0.91	0.92	0.8827	0.8872	70160.0
2015-06-17	AAUAF-DELISTED	Stock	0.91	0.92	0.88	0.89	70919.0
2015-06-17	AAV-DELISTED	Stock	6.28	6.39	6.11	6.29	62899.0
2015-06-17	AAVL-DELISTED	Stock	17.38	18.4	16.72	16.91	3495993.0
2015-06-17	AAWW-DELISTED	Stock	53.57	54.04	53.19	53.43	221566.0
2015-06-17	AAXJ	Stock	63.73	64.205	63.39	63.96	1106527.0
2015-06-17	AAXN-DELISTED	Stock	35.08	35.33	34.44	34.65	1468157.0
2015-06-17	AB	Stock	31.04	31.08	30.57	30.77	138600.0
2015-06-17	ABAC-DELISTED	Stock	1.3701	1.47	1.3701	1.4	8673.0
2015-06-17	ABAX-DELISTED	Stock	51.73	52.355	51.62	51.74	91056.0
2015-06-17	ABB-DELISTED	Stock	22.72	22.75	22.09	22.27	3836538.0
2015-06-17	ABBNY-DELISTED	Stock	22.71	22.75	22.09	22.28	3969302.0
2015-06-17	ABBV	Stock	66.97	67.99	66.88	67.77	7377100.0
2015-06-17	ABC-DELISTED	Stock	111.38	112.13	110.87	111.52	1360011.0
2015-06-17	ABCB	Stock	26.19	26.24	25.64	25.67	75400.0
2015-06-17	ABCD-DELISTED	Stock	4.24	4.25	4.13	4.19	41743.0
2015-06-17	ABCO-DELISTED	Stock	52.89	53.05	52.3	52.4	286980.0
2015-06-17	ABCW-DELISTED	Stock	37.15	37.15	36.89	36.99	24555.0
2015-06-17	ABDC-DELISTED	Stock	13.75	13.76	13.65	13.66	61332.0
2015-06-17	ABE-DELISTED	Stock	12.7	12.83	12.67	12.83	6760.0
2015-06-17	ABEO	Stock	175.5	179.0	172.0	172.75	28820.0
2015-06-17	ABEOW-DELISTED	Stock	2.75	2.86	2.4124	2.6	12330.0
2015-06-17	ABEV	Stock	6.0	6.11	5.96	6.1	11190400.0
2015-06-17	ABG	Stock	89.02	89.19	87.78	88.27	204600.0
2015-06-17	ABGB-DELISTED	Stock	16.33	16.43	16.29	16.36	5962.0
2015-06-17	ABIL-DELISTED	Stock	9.99	9.99	9.99	9.99	100.0

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

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