PREVIEW / stock_daily / 2017-08-30

all stock daily files

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

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-30	AAPL	Stock	40.95	40.9725	40.6525	40.8375	109078400.0
2017-08-30	MSFT	Stock	73.01	74.21	72.83	74.01	16897800.0
2017-08-30	NVDA	Stock	4.1375	4.1532	4.1068	4.142	384400000.0
2017-08-30	AMZN	Stock	47.922	48.4705	47.8455	48.3795	58092000.0
2017-08-30	GOOGL	Stock	46.7835	47.293	46.7025	47.1815	22406840.0
2017-08-30	META	Stock	168.17	170.18	167.63	169.92	11138300.0
2017-08-30	TSLA	Stock	23.3113	23.5647	23.1333	23.5453	51193500.0
2017-08-30	TLT	Stock	127.46	127.74	127.34	127.61	4735194.0
2017-08-30	ES	Stock	63.33	63.44	63.0	63.24	883100.0
2017-08-30	CL	Stock	71.1	71.26	70.78	70.95	2076800.0
2017-08-30	A	Stock	63.4	63.93	63.39	63.9	1072500.0
2017-08-30	AA	Stock	43.23	44.1	42.991	43.09	5537900.0
2017-08-30	AAAP-DELISTED	Stock	48.55	48.785	48.07	48.39	19063.0
2017-08-30	AABA-DELISTED	Stock	63.65	64.58	63.63	64.17	4586028.0
2017-08-30	AAC-DELISTED	Stock	9.0	9.29	8.87	9.23	37729.0
2017-08-30	AACG	Stock	5.1	5.24	4.72	4.76	95400.0
2017-08-30	AAIC-DELISTED	Stock	12.85	12.88	12.74	12.81	265983.0
2017-08-30	AAL	Stock	44.54	44.77	43.89	44.32	5472600.0
2017-08-30	AAM.A-DELISTED	Stock	26.08	26.18	25.8849	26.09	31625.0
2017-08-30	AAMC-DELISTED	Stock	23.9706	25.5882	23.9706	25.5147	11421.0
2017-08-30	AAME	Stock	3.36	3.4	3.3	3.3	1500.0
2017-08-30	AAMI	Stock	13.48	13.56	13.44	13.46	654100.0
2017-08-30	AAOI	Stock	63.1	64.0	61.46	61.5	1939600.0
2017-08-30	AAON	Stock	21.3	21.6	21.3	21.5333	160350.0
2017-08-30	AAP	Stock	95.12	98.08	95.12	96.81	1441200.0
2017-08-30	AAT	Stock	40.2	40.34	39.89	40.31	147700.0
2017-08-30	AAU-DELISTED	Stock	1.19	1.19	1.12	1.1854	98698.0
2017-08-30	AAUAF-DELISTED	Stock	1.19	1.19	1.12	1.19	102778.0
2017-08-30	AAV-DELISTED	Stock	6.35	6.35	6.25	6.3	20821.0
2017-08-30	AAWW-DELISTED	Stock	64.85	66.3	64.6	66.2	247312.0
2017-08-30	AAXJ	Stock	71.83	71.94	71.72	71.83	893575.0
2017-08-30	AAXN-DELISTED	Stock	21.6	21.69	21.44	21.61	330748.0
2017-08-30	AB	Stock	23.1	23.4	22.9	23.25	124700.0
2017-08-30	ABAC-DELISTED	Stock	2.25	2.25	2.12	2.16	5251.0
2017-08-30	ABAX-DELISTED	Stock	45.61	45.92	45.08	45.65	71759.0
2017-08-30	ABB-DELISTED	Stock	22.86	22.91	22.81	22.85	1233364.0
2017-08-30	ABBNY-DELISTED	Stock	22.86	22.91	22.81	22.84	1269565.0
2017-08-30	ABBV	Stock	73.62	74.18	73.58	73.92	3189100.0
2017-08-30	ABC-DELISTED	Stock	78.43	78.53	77.79	78.33	1091461.0
2017-08-30	ABCB	Stock	43.75	44.1	43.5	43.65	94300.0
2017-08-30	ABCD-DELISTED	Stock	5.37	5.505	5.3	5.47	29819.0
2017-08-30	ABCO-DELISTED	Stock	53.05	53.25	53.0	53.15	2701584.0
2017-08-30	ABDC-DELISTED	Stock	10.54	10.68	10.45	10.6	56832.0
2017-08-30	ABE-DELISTED	Stock	13.9347	14.28	13.9347	14.2	6358.0
2017-08-30	ABEO	Stock	286.25	355.0	268.0	341.25	139212.0
2017-08-30	ABEOW-DELISTED	Stock	6.45	9.0	6.4	9.0	11365.0
2017-08-30	ABEV	Stock	6.24	6.26	6.18	6.24	16365400.0
2017-08-30	ABG	Stock	51.0	52.25	50.65	52.15	109900.0
2017-08-30	ABIL-DELISTED	Stock	0.8529	1.21	0.8529	0.9198	4382289.0
2017-08-30	ABM	Stock	43.83	43.98	43.58	43.96	183400.0

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

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