PREVIEW / stock_daily / 2017-09-13

all stock daily files

  file:    by_date/stock_daily/2017/2017-09-13.parquet
  size:    214 KB
  rows:    6,445
  symbols: 2,938

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
2017-09-13	AAPL	Stock	39.9675	39.99	39.4775	39.9125	179629600.0
2017-09-13	MSFT	Stock	74.93	75.23	74.55	75.21	13380800.0
2017-09-13	NVDA	Stock	4.2148	4.2885	4.182	4.2593	580960000.0
2017-09-13	AMZN	Stock	49.1985	50.0	48.971	49.98	67494000.0
2017-09-13	GOOGL	Stock	47.275	47.6425	47.237	47.522	21907640.0
2017-09-13	META	Stock	173.01	173.17	172.06	173.05	9119300.0
2017-09-13	TSLA	Stock	24.2547	24.538	23.9727	24.4153	62778000.0
2017-09-13	TLT	Stock	126.91	126.92	126.28	126.29	6740040.0
2017-09-13	ES	Stock	62.57	62.8	62.27	62.37	1104500.0
2017-09-13	CL	Stock	71.94	72.09	71.55	71.65	1806600.0
2017-09-13	A	Stock	65.91	66.22	65.41	65.44	2042600.0
2017-09-13	AA	Stock	44.61	45.07	44.36	44.91	3372200.0
2017-09-13	AAAP-DELISTED	Stock	52.48	55.4	50.82	54.3	216702.0
2017-09-13	AABA-DELISTED	Stock	65.4	66.71	65.4	66.61	9690365.0
2017-09-13	AAC-DELISTED	Stock	12.6	12.6	11.53	11.65	133811.0
2017-09-13	AACG	Stock	4.63	4.69	4.63	4.63	4200.0
2017-09-13	AAIC-DELISTED	Stock	13.08	13.145	13.07	13.11	210373.0
2017-09-13	AAL	Stock	46.35	47.58	46.1	47.0	7288200.0
2017-09-13	AAM.A-DELISTED	Stock	26.25	26.29	26.1	26.28	39552.0
2017-09-13	AAMC-DELISTED	Stock	30.3235	31.1765	28.2941	30.5147	32650.0
2017-09-13	AAME	Stock	3.3	3.3	3.2	3.3	2900.0
2017-09-13	AAMI	Stock	13.85	13.93	13.77	13.89	481900.0
2017-09-13	AAOI	Stock	57.25	60.553	56.31	59.69	2150900.0
2017-09-13	AAON	Stock	21.3	21.8667	21.2667	21.7333	193650.0
2017-09-13	AAP	Stock	97.07	100.32	97.07	100.1	2080200.0
2017-09-13	AAT	Stock	40.12	40.56	40.07	40.51	186000.0
2017-09-13	AAU-DELISTED	Stock	1.2	1.23	1.17	1.2066	257761.0
2017-09-13	AAUAF-DELISTED	Stock	1.2	1.23	1.17	1.2	283235.0
2017-09-13	AAV-DELISTED	Stock	6.3	6.55	6.3	6.475	48993.0
2017-09-13	AAWW-DELISTED	Stock	67.35	67.5	66.6	67.15	136431.0
2017-09-13	AAXJ	Stock	72.69	72.695	72.45	72.56	788854.0
2017-09-13	AAXN-DELISTED	Stock	22.34	22.56	22.21	22.41	404999.0
2017-09-13	AB	Stock	23.7	24.05	23.7	24.0	246700.0
2017-09-13	ABAC-DELISTED	Stock	2.16	2.19	2.13	2.19	2101.0
2017-09-13	ABAX-DELISTED	Stock	45.34	45.52	44.03	44.43	163349.0
2017-09-13	ABB-DELISTED	Stock	24.31	24.325	24.23	24.29	793780.0
2017-09-13	ABBNY-DELISTED	Stock	24.31	24.325	24.23	24.28	849659.0
2017-09-13	ABBV	Stock	87.58	88.84	87.42	88.47	9172200.0
2017-09-13	ABC-DELISTED	Stock	83.76	84.344	83.06	84.3	1111703.0
2017-09-13	ABCB	Stock	43.2	43.8	43.1	43.55	121300.0
2017-09-13	ABCD-DELISTED	Stock	6.22	6.305	5.98	6.05	72949.0
2017-09-13	ABCO-DELISTED	Stock	53.4	53.575	53.4	53.5	608716.0
2017-09-13	ABDC-DELISTED	Stock	10.63	10.813	10.55	10.6601	47082.0
2017-09-13	ABE-DELISTED	Stock	14.73	14.73	14.53	14.53	1136.0
2017-09-13	ABEO	Stock	341.25	357.5	340.0	350.0	36952.0
2017-09-13	ABEOW-DELISTED	Stock	9.51	9.51	9.5	9.5	350.0
2017-09-13	ABEV	Stock	6.67	6.75	6.63	6.69	20474900.0
2017-09-13	ABG	Stock	57.45	59.93	57.45	59.15	266500.0
2017-09-13	ABIL-DELISTED	Stock	0.7668	0.7694	0.7201	0.741	45606.0
2017-09-13	ABM	Stock	40.23	40.4	39.75	40.01	390300.0

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

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