PREVIEW / stock_daily / 2017-08-10

all stock daily files

  file:    by_date/stock_daily/2017/2017-08-10.parquet
  size:    214 KB
  rows:    6,444
  symbols: 2,955

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-08-10	AAPL	Stock	39.975	40.0	38.6575	38.83	163217200.0
2017-08-10	MSFT	Stock	71.9	72.19	71.35	71.41	24734500.0
2017-08-10	NVDA	Stock	4.304	4.3165	4.1083	4.1185	1328088000.0
2017-08-10	AMZN	Stock	48.815	48.993	47.734	47.846	113682000.0
2017-08-10	GOOGL	Stock	46.75	46.815	46.0888	46.1795	54147860.0
2017-08-10	META	Stock	170.06	170.59	166.85	167.4	20832700.0
2017-08-10	TSLA	Stock	24.1067	24.4433	23.644	23.6933	106393500.0
2017-08-10	TLT	Stock	125.62	126.44	125.52	126.37	10378215.0
2017-08-10	ES	Stock	61.75	62.33	61.49	62.22	2116600.0
2017-08-10	CL	Stock	71.4	71.84	71.21	71.55	2567900.0
2017-08-10	A	Stock	59.35	59.5	58.22	58.57	2471500.0
2017-08-10	AA	Stock	38.12	38.78	37.715	37.78	3515600.0
2017-08-10	AAAP-DELISTED	Stock	50.0	50.0	48.58	49.0	42515.0
2017-08-10	AABA-DELISTED	Stock	59.17	59.51	57.87	58.0	3816294.0
2017-08-10	AAC-DELISTED	Stock	8.35	8.75	8.155	8.43	201263.0
2017-08-10	AACG	Stock	4.68	4.79	4.68	4.79	12900.0
2017-08-10	AAIC-DELISTED	Stock	13.15	13.2	12.9653	13.01	250580.0
2017-08-10	AAL	Stock	49.03	49.34	48.19	48.55	5441400.0
2017-08-10	AAM.A-DELISTED	Stock	26.15	26.15	25.85	25.95	25551.0
2017-08-10	AAMC-DELISTED	Stock	22.9706	22.9706	21.9853	21.9853	6820.0
2017-08-10	AAME	Stock	3.55	3.55	3.35	3.4	1500.0
2017-08-10	AAMI	Stock	13.88	13.91	13.57	13.65	605800.0
2017-08-10	AAOI	Stock	66.67	66.77	63.0	63.55	3461400.0
2017-08-10	AAON	Stock	22.4	22.4333	22.0333	22.2667	176400.0
2017-08-10	AAP	Stock	108.44	108.82	105.25	106.13	1844500.0
2017-08-10	AAT	Stock	40.09	40.28	39.99	40.05	218400.0
2017-08-10	AAU-DELISTED	Stock	1.1	1.15	1.08	1.085	167606.0
2017-08-10	AAUAF-DELISTED	Stock	1.1	1.15	1.08	1.085	192597.0
2017-08-10	AAV-DELISTED	Stock	6.65	6.65	6.4	6.45	97695.0
2017-08-10	AAWW-DELISTED	Stock	63.0	63.0	61.45	61.6	279381.0
2017-08-10	AAXJ	Stock	70.27	70.34	69.12	69.16	1470314.0
2017-08-10	AAXN-DELISTED	Stock	23.0	23.05	22.24	22.46	1304687.0
2017-08-10	AB	Stock	24.45	24.45	23.4	23.8	433000.0
2017-08-10	ABAC-DELISTED	Stock	2.221	2.3212	2.17	2.2	10863.0
2017-08-10	ABAX-DELISTED	Stock	46.26	46.34	45.24	45.81	71390.0
2017-08-10	ABB-DELISTED	Stock	23.08	23.1	22.8	22.81	1414980.0
2017-08-10	ABBNY-DELISTED	Stock	23.08	23.1	22.8	22.82	1610265.0
2017-08-10	ABBV	Stock	72.01	72.19	70.39	70.44	5940300.0
2017-08-10	ABC-DELISTED	Stock	79.43	80.025	78.13	78.87	2068166.0
2017-08-10	ABCB	Stock	44.4	44.6	43.6	43.65	105200.0
2017-08-10	ABCD-DELISTED	Stock	4.9	5.25	4.9	5.15	85234.0
2017-08-10	ABCO-DELISTED	Stock	50.95	51.3	50.0	50.75	1361140.0
2017-08-10	ABDC-DELISTED	Stock	10.56	11.12	10.24	10.246	139953.0
2017-08-10	ABE-DELISTED	Stock	13.6	13.7938	13.6	13.68	6389.0
2017-08-10	ABEO	Stock	195.0	200.0	186.25	191.25	10468.0
2017-08-10	ABEOW-DELISTED	Stock	4.25	4.3	4.25	4.3	300.0
2017-08-10	ABEV	Stock	6.07	6.12	6.05	6.05	15543300.0
2017-08-10	ABG	Stock	52.85	53.4	51.75	51.95	163100.0
2017-08-10	ABIL-DELISTED	Stock	0.6913	0.6913	0.6283	0.6413	34239.0
2017-08-10	ABM	Stock	44.14	44.18	43.68	43.68	263100.0

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

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